www.OntarioConstruction.com Training with Microsoft Project 2000 (Scheduling) & Excel for Ontario Construction & Engineering

Software Training
Excel Advanced

Once you have mastered basic MS Excel, there are many advanced features that can give you more detailed information. You can set up pivot tables and IF Function to target your specific needs. They enable you to carry out in depth analysis and export data to other applications.

MMS Excel Course Content
Advanced Excel

Call 905-271-1119 or email info@actionebiz.com

Single-level sorting
Multiple-level sorting
Sorting options
Design considerations
Filtering a list
Custom criteria
Multiple-condition criteria
Managing a filtered list
Working with Built-in Toolbars
Using Custom Toolbars
Creating and Using Styles
Using Templates
Using Names
Using the IF Function
Using the VLOOKUP Function
Using IS Functions and the Auditing
Creating Pivot Tables
Modifying Pivot Tables
Grouping and Summarizing Data in a Pivot Table
Creating Interactive Pivot Tables for the Web
Working with Workbooks
Linking Cells in Different Workbooks
Workbook Versus Links and Workspaces
Sharing and Merging Workbooks
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
Using Comments
Protecting Workbooks
Using Custom Views
Running Macros
Recording a Macro
Viewing and Editing VBA Code
Web Documents
Saving Excel Worksheets as Web Documents
Spreadsheet Web Components