RMD Training - Hull

 

RMD Business Excel 2003 Foundation Syllabus

 

This course is designed for delegates who have little or no experience of using Microsoft Excel 2003.

 

If the course syllabus does not entirely match your requirements, please contact us as we are able to customise it to your needs.

 

This course has a duration of 1 day.

 

Getting Started With Excel

 

Introduction

  • What Is Excel?
  • New Features In Excel 2003
  • Opening Excel
  • Exiting Excel

     

    Help With Excel

  • Finding Help
  • The Office Assistant
  • The Help Task Pane

     

    Beginning Excel

  • The Standard Toolbar
  • The Formatting Toolbar
  • Working With Excel Menus
  • Exploring Task Panes
  • Excel Short-Cut Keys

     

    The Basics Of File Management

  • New Workbooks
  • How To Open Existing Workbooks
  • How To Save Workbooks
  • How To Close Workbooks
  • Excel File Types

     

    Explore Your Workbook

  • Switching Worksheets
  • The Active Cell
  • Selecting Cells
  • Exploring A Worksheet
  • The Zoom Feature

     

    Excel Basics

     

    Working With Excel

  • Columns, Rows, Cells And Ranges
  • Creating Worksheet Labels
  • Entering And Deleting Data
  • Printing Your Worksheet

     

    Basic Excel Features

  • What Is AutoFill?
  • What Is AutoSum?
  • What Is AutoComplete?
  • Working With Basic Formulas

     

    Editing Tools

  • Using Autocorrect
  • Using Spell Check
  • Using Find And Replace
  • Documenting A Worksheet With Comments

     

    Moving Your Data

  • Dragging And Dropping Cells
  • How To Cut, Copy And Paste Cells
  • How To Cut, Copy And Paste Multiple Cells And Items
  • How To Use Paste Special
  • How To Insert And Delete Cells, Rows And Columns
  • Using Undo, Redo And Repeat

     

    Using Smart Tags And Option Buttons

  • What Are Smart Tags?
  • The Error Option Button
  • The AutoFill Option Button
  • The Paste Option Button

     

    Working With Excel

     

    Modifying Cells And Data

  • Changing The Size Of Rows Or Columns
  • Working With The Formatting Toolbar
  • Adjusting Cell Alignment
  • Rotating Text
  • Creating Custom Number And Date Formats

     

    Cell Formatting

  • Conditional Formatting
  • What Is The Format Painter?
  • What Is AutoFormat?
  • Cell Merging And AutoFit
  • Find And Replace Formatting

     

    Enhancing A Worksheet Appearance

  • Adding Patterns And Colors
  • Adding Borders
  • Adding Fill Effects
  • Working With Styles

     

    Modifying Excel Toolbars

  • Hiding Toolbars
  • Showing Toolbars
  • Moving Toolbars
  • Customizing Toolbars

     

    Working With Charts

  • Creating A Chart
  • Formatting A Chart
  • Manipulating A Chart
  • Enhancing A Chart With Drawing Tools
  • Enhancing Your Chart With Titles And Tables

     

    Working With Charts And Data

  • Changing The Type Of Chart
  • Changing The Source Data
  • Creating 3-D Charts
  • Working With The Chart Axes And Data Series
  • Making Custom Charts

     

    Workbook Management

     

    Organising Your Workbook

  • Inserting And Removing Worksheets
  • Renaming, Moving And Color-Coding Worksheets
  • How To Split And Freeze A Window
  • Using Multiple Workbooks And Windows
  • Using A Watch Window
  • Creating A Custom View

     

    Formatting Your Workbook

  • Using Headers And Footers
  • Inserting Page Numbers
  • Changing Margins And Orientation
  • Hiding Rows, Columns And Worksheets

     

    Printing A Workbook

  • Choosing A Print Area
  • Setting Up Page Breaks
  • Choosing Paper Size And Changing Print Scale
  • Adding Print Titles And Gridlines

     

    More Workbook Features

  • Linking Workbooks
  • Consolidating Workbooks
  • Combining Worksheets
  • Protecting Worksheets
  • Using Templates

     

     

    •