Excel Advanced 2007
Description
This course will expand upon the skills you learned in the Excel 2007 Level 1 and Level 2 courses and give you an opportunity to work with some more advanced features of Excel, including templates; sorting and filtering; importing and exporting; advanced formulas; analysis tools; and collaboration.
Entrance Requirements
Participants should have completed MS Excel Basic & Intermediate.
Who Should Attend
This course is designed for students desiring to prepare to be a certified Microsoft Office Specialist (MOS) in Excel or for those needing to work within spreadsheets.
Course Outline
Working with Advanced Formulas
- Using Names
- Using Decision-Making functions
- Creating Nested Functions
- Using Financial Functions
Lookups & Data Tables
- Working with Lookup Functions
- Using MATCH & INDEX
- Creating Data Tables
Advanced List Management
- Creating Sub-Totals
- Validating Cell Entries
- Exploring Database Functions
- Working with Database Forms
Working with PivotTables & PivotCharts
- Working with PivotTables
- Re-Arranging PivotTables
- Formatting PivotTables
- Working with PivotCharts
Exporting & Importing
- Exporting & Importing Text Files
- Exporting & Importing XML Files
- Querying External Databases
Using Analytical Options
- Working with Goal Seeker and Solver
- Working with the Analysis Toolpak
- Working with Scenarios
- Working with Views
Working with Macros
- Running and Recording a Macro
- Working with VBA Code
Interactive Web Pages
- Creating Interactive Web Sheets
- Publishing pivotTables on the Web
Using SharePoint Services
- Document Workspaces
Examinations and Assessments
Learners write the CCS IT examination, the pass mark for which is 70%. Learners may elect to write the International Microsoft examinations at CCS’s Authorized Prometric Testing Centre. The costs for International exams are not included in the course fees.
Learning Materials
All standard learning materials are included in the course fee.
Links and Further Information
Duration and Times
We run this course as both full time (1 day) and part time (2 evenings) course. Contact us for current starting dates and times.