EXCEL

Lesson Description

 

Exploring Excel

Working with the Office Assistant

Using Basic Workbook Skills

Working with Ranges

Creating Simple Formulas

Copying and Moving Data

Printing

Using Page Setup

Formatting Numbers

Formatting Text

Working with Columns and Rows

Formatting Cells

Using Automatic Formatting and Styles

Using Online Help

Using Large Worksheets

Working with Multiple Worksheets

Managing Worksheets

Working with Outlines

Using HTML Files

Using Paste Special

Using Range Names

Working with Labels in Formulas

Using Other Functions

Creating Charts

Editing Charts

Drawing an Object

Using Additional Effects and Objects

Using AutoShapes

Managing Data

Customizing Excel Preferences

Managing Files

Working with Databases

Working with the Data Form

Using AutoFilter

Working with Advanced Filters

Importing and Exporting Data

Creating/Revising PivotTables

Using Multiple Workbooks

Using Conditional and Custom Formats

Using Templates

Working with Comments

Using Worksheet Protection

Sharing Workbooks

Working with Data Series

Using Advanced Functions

Using Scenarios and Goal Seeking

Using Data Tables

Using Auditing Tools

Consolidating Worksheets

Solving Problems

Working with Views

Using the Report Manager

Using Macros

Recording Macros

Editing Macros

Using Custom Toolbars and Buttons

Creating a Macro Button

Modifying Charts

Working with the Data Map

Index