Microsoft Excel

Introduction

Intermediate

Advanced

Getting started

Spreadsheet terminology

The Excel environment

Navigating a worksheet

Using a template

 

Entering and editing data

Entering and editing text and values

Entering and editing formulas

Saving and updating workbooks

 

Modifying a worksheet

Moving and copying data

Moving, copying, and viewing formulas

Absolute and relative references

Inserting and deleting ranges, rows, and columns

 

Functions

Entering functions

AutoSum

Other common functions

 

Formatting

Text formatting

Row and column formatting

Number formatting

Conditional formatting

Additional formatting options

 

Charts

Chart basics

Formatting charts

 

Graphics

Working with pictures

Conditional formatting with graphics

SmartArt graphics

 

Printing

Preparing to print

Page Setup options

Printing worksheets

Managing workbooks and worksheets

Viewing large worksheets

Printing large worksheets

Working with multiple worksheets

Linking worksheets with 3-D formulas

Using multiple workbooks

Linking workbooks

 

Advanced formatting

Using special number formats

Working with themes

Other advanced formatting

 

Outlining and subtotals

Outlining and consolidating data

Creating subtotals

 

Cell and range names

Creating and using names

Managing names

 

Data structure and tables

Sorting and filtering data

Working with tables

 

Web and sharing features

Saving workbooks as Web pages

Using hyperlinks

Sharing workbooks

 

Documenting and auditing

Auditing features

Comments in cells and workbooks

Protection

Workgroup collaboration

 

Application settings and templates

Application settings

Working with templates

 

Advanced functions and formulas

Logical functions

Conditional functions

Financial functions

Text functions

Date functions

Array formulas

 

Lookups and data tables

Using lookup functions

Using MATCH and INDEX

Creating data tables

 

Advanced data management

Validating cell entries

Advanced filtering

 

Advanced charting

Chart formatting options

Combination charts

Graphical objects

 

PivotTables and PivotCharts

Working with PivotTables

Rearranging PivotTables

Formatting PivotTables

PivotCharts

 

Exporting and importing data

Exporting and importing text files

Getting external data

 

Analytical tools

Goal Seek

Scenarios

 

Macros and Visual Basic

Running and recording a macro

Working with VBA code

 

Computer Training of America, Inc.

Telephone: (413) 283-7740

Toll Free: (877) 283-7740

Fax: (413) 283-7730

Web Site: www.computertrainingofamerica.com