Microsoft Excel 2000 Intermediate:

This course is intended for participants who have previous experience with spreadsheet programs. This is one of the two PBTSystem books covering problem-solving skills for Microsoft Excel 2000. This full-day performance-based training course covers skills using Excel 2000, including linking workbooks, formatting worksheets, creating charts, and using PivotTables.

Course Prerequisites: Excel 2000 Fundamentals

Course Length: 1 day

Performance Objectives:  Set up multiple worksheets to use information from other sources.  Consolidate data to combine information into one worksheet.  Create and modify charts to present data effectively.  Customize charts to enhance their appearance.  Create PivotTables to reorganize summary data in an easy-to-read format.  Use PivotCharts to present the data from PivotTables in a graphical format.  Create and apply styles to format worksheets consistently and quickly.  Use conditional formatting, comments, and text boxes to highlight and explain your data.

Course Content:

Module 1:
Using Multiple Worksheets; Building Your Skills; Setting Up Multiple Worksheets; Importing Data; Creating Links with Formulas; Changing and Restoring Links; Consolidating Data; Using 3-D References to Consolidate Data; Using the Consolidate Feature to Consolidate Data; Applying Your Skills.

Module 2:
Working with Charts; Building Your Skills; Creating Charts; Creating Column and Pie Charts; Publishing Charts on the Web; Changing Chart Data; Modifying Chart Elements; Creating Exploded Pie Charts; Showing Data with Graphics Adding Trendlines and Data Tables; Creating Custom Charts; Creating Custom Chart Types; Setting a Default Chart; Applying Your Skills.

Module 3:
Using PivotTables; Building Your Skills; Creating PivotTables; Organizing PivotTables; Editing PivotTables; Using Pivot Charts.

Module 4:
Applying Formatting; Building Your Skills; Creating Styles; Working with Styles Using Conditional Formatting; Annotating Worksheets; Adding Cell Comments; Adding Text Boxes; Applying Your Skills.