Course Outline

Duration
3 Half Days

Prerequisite
Experience with Windows and completed an Excel Interemdiate course.

Objectives
To provide a thorough understanding of the comprehensive concepts and skills that will enable the participant to effectively use Microsoft Excel.

Methodology
Group and individual instruction, hands on practical exercises, visual aids, comprehensive course documentation.

Confirmation of Assessment Plan
This will be issued to the trainee at commencement of training session.

Expected Outcome
By the end of the course the participant should be able to use the following functions and features of Microsoft Excel.

CONTENT

Nesting Functions
• Nesting overview
• Scoping the formula
• Creating a nested function
• Editing a nested function
• Nesting more functions
• Copying nested functions
• Using concatenation
• Nesting functions quick reference

Advanced Filters
• Advanced filers overview
• Using an advanced filter
• Extracting records with advanced filter
• Using formulas in the criteria
• Using database functions
• Advanced filters quick reference

Goal Seeking
• Goal seeking overview
• Using goal seek
• Goal seeking quick reference

Data Tables
• Data table overview
• Understanding the case study
• Creating a one-variable data table
• Updating table values
• Creating a two-variable data table
• Some data table tips
• Data tables quick reference

Scenarios
• Scenario overview
• Creating default values
• Creating additional scenarios
• Using names in scenarios
• Displaying scenarios
• Producing a summary report
• Merging scenarios
• Scenarios quick reference

Pivot Table Reports

• Overview of pivot table reports
• Using the pivot table wizard
• Working with the pivot tale report
• Auto formatting the pivot table report
• Creating a pivot chart
• Working with a pivot chart
• Pivot tables quick reference

Consolidation
• Consolidation overview
• Consolidating worksheet data
• Consolidating data using different layouts
• Consolidating data using a pivot table
• Consolidation quick reference

Linking Workbooks
• Linking overview
• Linking within a workbook
• Linking between workbooks
• Updating links between workbooks
• Linking workbooks quick reference

Excel on the Web
• Overview of web page publishing
• Previewing web pages
• Publishing to the web
• Adding to an existing web page
• Publishing an interactive web page
• Excel on the web quick reference

Recorded Macros
• Macro recorder overview
• Recording a simple macro
• Running a recorded macro
• Relative recording
• Running a relative recording
• Viewing the module
• Modifying a recorded macro
• Recorded macros quick reference

Recorder Workshop
• Creating a recorded application
• Examining the data
• Recording a summation macro
• Recording an averaging macro
• Recording the maximum macro
• Recording the minimum macro
• Recording divisional macros
• Testing macros
• Creating objects to run macros
• Assigning a macro to an object
• Recorder workshop quick reference

Conclusion
_________________