Chart Facility Overview :

- Entering Chart data, views of the data block;

- Creating Charts Using the Chart Wizard;

- Chart Types Line vs X-Y charts, bar etc.

- Rotating Charts, Viewing;

- Changing the Data ranges,

- Formatting Axes, grid lines etc

- Saving & Printing Charts;

- Saving Charts with Documents, Linking Sheets with Charts

- Updating Links, etc

Lists/Database Facility Overview:

- database terms & concepts, records, fields, defining etc

- entering records via the sheet vs the Form;

- Using Auto Filters vs Advanced filter

- selecting using the Auto-filter options

- sorting records, nested sorts etc.

- using the subtotal facility

- using the group and outline facility

-     finding & deleting records

-     overview of pivots, strategic usage;

- Overview of Database functions

Macro Facility Overview

- Defining/recording a Macro;

- Macro sheets, Global macros;

- Editing & modifying Macros;

- Naming macros, assigning quick keys;

- Assigning Buttons to Macros;

- Autoexecute Macro, automating tasks and functions

Overview of Linking & Embedding

- uses & purposes of links

-     linking objects & word documents

-     strategic use of OLE etc.

Overview of Templates :

- uses/purposes of templates

- things that should be entered

- saving AsA template, using the template

- protecting sheets, passwords etc.

Other Topics (Optional )

- Using the Data Analysis Tools

- Regression facility overview

- Statistical Testing

- Random Number Generation

- Describing Data

- Goal Seek etc

Workbook Facility:

-     Why workbooks, uses & purposes

-     Creating, Modifying, Deleting Workbooks;

-     Adding & Removing from a Workbook.