 |
Training |
Excel Level 3
Course Description
Students
will learn various advanced techniques for analyzing and manipulating data in
Excel . This course meets the Microsoft Proficiency Guidelines for Excel
at the Expert level.
Prerequisites
Excel Level
2 or equivalent knowledge.
Study Method:
Flexible
Learning: Group
Training
What Next?
The
European Computer Driving Licence (ECDL)
Course Content
Lesson 1: Customizing the Work Area
Working
with Built-in Toolbars
Using
Custom Toolbars
Creating
and Using Styles
Using
Templates
Lesson
2: Advanced Formula Construction
Using
Names
Using
the IF Function
Using
the VLOOKUP Function
Using
IS Functions and the Auditing Features
Lesson
3: Using Pivot Tables
Creating
Pivot Tables
Modifying
Pivot Tables
Grouping
and Summarizing Data in a Pivot Table
Creating
Interactive Pivot Tables for the Web
Lesson
4: Working with Multiple Worksheets
Working
with Workbooks
Linking
Cells in Different Workbooks
Workbook
Versus Links and Workspaces
Sharing
and Merging Workbooks
Lesson
5: Consolidating and Analyzing Data
Consolidating
Data from More Than One Worksheet
Using
the Goal Seek and Solver Utilities
Using
Scenario Manager to View a Worksheet with Different Input Values
Lesson
6: Using Protection and Display Options
Using
Comments
Protecting
Workbooks
Using
Custom Views
Lesson
7: Introduction to Macros
Running
Macros
Recording
a Macro
Viewing
and Editing VBA Code
Lesson
8: Working with Interactive Excel Web Documents
Saving
Excel Worksheets as Web Documents
Spreadsheet Web Components