|
|
|
Email: Address: Computer Support 860 South 5th Ave Clarion, PA 16214 Page best viewed with Internet Explorer 4.0 or higher and 1024x768 or higher screen resolution.
|
Advanced Microsoft Excel Day or Evening Class
Overview Students will learn how to use the many advanced features of Excel. Topics include pivot tables, analysis tools, filters, and databases.
Prerequisite Students should have successfully completed the Introduction to Microsoft Excel class or possess equivalent knowledge.
Outline
1. Review of Introduction to Excel
2. Review of Basic Charting
3. Working with Databases
A. Creating and using a database B. Sorting records
4. Data Form
A. View and edit Data Form Records
5. Filters
A. Using AutoFilter B. Create and use a criteria range C. Advanced AND/OR condition D. Database functions
6. Pivot Table Features
A. Create a Pivot Table report B. Interactive Pivot Tables
7. Using Views
A. Normal and customizing Views
8. Working with Report Manager
A. Using sheets in a report B. Using scenarios and views in a Report
9. Analysis Tools
A. Using Goal Seek and Scenario Manager B. Using Excel Solver C. Create and save Scenarios
10. Auditing Cells
11. Protecting a Workbook
12. Linking Embedded Objects |
