 |
|
|
|
|
PC Training - Course Outlines - Microsoft Excel 2003 Level 3 |
|
|
|
Course Name - Microsoft Excel 2003 Level 3
Course Number - Com 532
Prerequisites - Microsoft Windows (2000 or XP) Level 1, Microsoft Excel '97 or 2003 Level 1 and Level 2
Course Length - 1 Day
Lesson 1:
Lesson 2:
Lesson 3:
Lesson 4:
Lesson 5:
Lesson 6:
Lesson 7:
Lesson 8:
|
Working with Databases
Sorting Database Data
Using Database Functions
Using Advanced Filters and Automatic Subtotals
Creating PivotTables and PivotCharts
Formatting and Adjusting PivotTables
Auditing Worksheets and Performing What-If Analyses
Working with Scenarios
|
|
|
|
|
|
NC DOT
NC DOH
NC GOV
