|
|
|
|
Search using the drop down list, or further refine your search using keywords.
|
|
|
|
|
 |
|
|
Microsoft Excel: Advanced
Business Skills Courses |
|
|
|
This course is designed for those who require a greater knowledge of the more advanced features of Excel including Goal Seek, What-if scenarios and pivot tables.
This is a ‘power-user’ course and you will leave able to create and customise your own macros and utilise Excel’s auditing tools.
This outline is based on Microsoft Excel 2007 (or Excel 2008 if you are a Mac user). If you are using a different version, please give us a call on 020 7359 9855.
|
|
Introduction
• Problem solving
• Using Goal Seek
• Using Solver
• Using Scenario Manager
• Merging scenarios
Advanced features
• Lookup functions
• Nesting functions
• Data functions
• Financial functions
Advanced data management
• Advanced filters
• Using formulas as filters
• Creating Pivot tables
• Using analysis tools
• Smart documents
• Creating histograms |
Forms
• Understanding how forms work
• Text boxes and list boxes
• Combo boxes
• Check and option boxes
• Command buttons
Macros
• Understanding macros
• Recording a macro
• Customising a macro
Auditing
• Excel’s auditing tools
• Data entry validation
• Error checking
• Watch window
Questions and answers |
|
If you'd like to book by phone, or discuss your requirements;
 Courses provided by partners Media Training.
|
|
|
|
|
|
|
