Microsoft Access

Course Outline
Microsoft Excel (Advanced)

 
|   Home     |     Training     |     TNAs  |    Courseware    |   Course Outlines   |   About   |    Contact    |    Index    |
   
 
    Application:  Microsoft Excel
Level:  Advanced
Duration:  1 Day
Target:  Existing users of Excel who have experience of building spreadsheets and want to take their skills to a higher level.
Objectives:  This course is designed to give an insight into some of the more advanced features in Excel and will be of particular
 interest to those who want to build or work with financial models, carry out detailed data analysis and automate tasks
 by recording macros.
Content:  
         
1. What-if Analysis
    Using the Scenario Manager
    Creating and editing scenarios
    Creating a Scenario Report
    Using Goal Seek

2. Data Tables
    The single-variable data table
    The two-variable data table
    Adding conditional formatting

3. Working with Outlines
    Applying an outline
    Automatic outlining
    Displaying and collapsing levels
    Modifying outline settings
    Creating subtotals

 

     4. Analysing Data with Pivot Tables
    Creating a pivot table
    Defining the source range
    Inserting. moving and deleting fields
    Showing and hiding fields
    Grouping and ungrouping fields
    Renaming fields
    Defining field properties
    Formatting a pivot table
    Refreshing a pivot table
    Drilling down

 

     5. Excel Macros
    About macros and VBA
    Macro security
    Recording macros
    Running a Macro
    Absolute and relative references
    Saving and distributing macros
    Assigning a macro to a button
    Editing macro code
    Automatic macros
         
Download a printable copy of this course outline as a PDF file [30KB].
  2011 Martin Green. All rights reserved. Contact: training@fontstuff.com