Microsoft Office

Excel - Introduction

Course Prerequisites

  • Required: Knowledge of Windows Introduction topics and ability to use keyboard and mouse.

Section 1: Getting Started With Excel

Lesson 1.1: Introduction

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

Lesson 1.2: Help With Excel

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

Lesson 1.3: Beginning Excel

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

Lesson 1.4: The Basics Of File Management

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

Lesson 1.5: Explore Your Workbook

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

Section 1: Review Questions

back to top

Section 2: Excel Basics

Lesson 2.1: Working With Excel

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

Lesson 2.2: Basic Excel Features

  • What Is Autofill?
  • What Is Autosum?
  • What Is Autocomplete?
  • Working With Basic Formulas
  • Practice Exercise

Lesson 2.3: Editing Tools

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

Lesson 2.4: 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
  • Practice Exercise

Lesson 2.5: Using Smart Tags And Option Buttons

  • What Are Smart Tags?
  • The Error Option Button
  • The Autofill Option Button
  • The Paste Option Button
  • Practice Exercise

Section 2: Review Questions

back to top

Section 3: Working With Excel

Lesson 3.1: 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
  • Practice Exercise

Lesson 3.2: Cell Formatting

  • Conditional Formatting
  • What Is The Format Painter
  • What Is Autoformat
  • Cell Merging And Autofit
  • Find And Replace Formatting
  • Practice Exercise

Lesson 3.3: Enhancing A Worksheet's Appearance

  • Adding Patterns And Colours
  • Adding Borders
  • Adding Fill Effects
  • Working With Styles
  • Practice Exercise

Lesson 3.4: Modifying Excel's Toolbars

  • Hiding Toolbars
  • Showing Toolbars
  • Moving Toolbars
  • Customizing Toolbars
  • Practice Exercise

Lesson 3.5: 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
  • Practice Exercise

Lesson 3.6: 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
  • Practice Exercise

Section 3: Review Questions

back to top

Section 4: Workbook Management

Lesson 4.1: Organizing Your Workbook

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

Lesson 4.2: Formatting Your Workbook

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

Lesson 4.3: Printing A Workbook

  • Microsoft Office Document Imaging
  • Choosing A Print Area
  • Setting Up Page Breaks
  • Choosing Paper Size And Changing Print Scale
  • Adding Print Titles And Gridlines
  • Practice Exercise

Lesson 4.4: More Workbook Features

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

Section 4: Review Questions

back to top