|
 |
 |
 |
 |
 |
 |
|
|
|
 |
|
|
Microsoft Excel - Level 3 |
|
|
 |
|
|
|
 |
 |
 |
|
 |
 |
|
|
 |
 |
|
 |
 |
 |
 |
|
 |
 |
|
|
 |
|
This course covers aspects of Microsoft Excel beyond building basic workbooks and deals with workbook automation and productivity features. It includes areas such as workbook and worksheet consolidation and linking, data analysis tools, and automating workbook operations using macros.
Learning Outcomes:
At the completion of this courseware participants will be able to:
• nest functions to create complex formulas
• use advanced filters to analyse data in a list
• use a variety of data validation techniques
• use goal seeking to determine the values required to reach a desired result
• create, use and modify data tables
• create, modify and work with PivotTables and the Scenario Manager
• use linking to create more efficient workbooks
• combine data in separate worksheets or workbooks using consolidation
• publish workbooks and worksheets for the web
• summarise data using subtotals and relative range naming
• open workbooks that contain macros and create recorded macros in Excel
Course Content:
• Nesting Functions Workshop
• Advanced Filters
• Validations and Goal Seeking
• Scenarios
• PivotTables and Data Tables
• Linking Workbooks
• Consolidation
• Excel On The Web
• Summarising Data
• Macro Virus Control
• Recorded Macros
• Recorder Workshop
Target Audience:
This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks.
Duration:
1 Day
Courseware:
High quality learning materials are available for purchase by participants. Participants will also be presented with a certificate of achievement upon completion of the course.
|
|
|
|
|
|
 |
 |
|
 |
 |
 |
 |
|
 |
 |
|
|
|
|
