Microsoft Excel Advanced

Course Outline:
More on Formulae & Functions:

Date & Time Functions
Maths & Trig Functions
Logical Functions
Statistical Functions
Lookup & Reference Functions
Text Functions
Financial Functions
Information Functions
Working with Scenarios
Formula Auditing
Using the Error Checking Tools
Using Data Validation
Goal Seeker & Solver
Linking Multiple Workbooks
Entering Formula Across Workbooks
More on Data Lists
Advanced Filters
Database Functions
Grouping & Outlining
Working With Pivot Tables
Modifying & Enhancing Pivot Tables
Extracting Pivot Data
Pivot Calculations
Creating Pivot ChartsSetting Defaults
Cell Comments
Go To & Paste Special
OLE Linking Designing & Working With Templates
Creating & Using Custom Views
Creating Custom Charts & Displaying Trend Lines
Combination Charts
Using the Drawing Tools
An Introduction to Macros
Attaching Macros to Shortcut Keys &Toolbar Buttons
Editing Macros
Macro Virus Protection