|
Learning outcomes
Delegates will be equipped to use Microsoft Excel for numerical analysis
of management information and to develop applications and automate frequently
used tasks.
Who should attend?
Delegates should first attend the Microsoft Excel Introduction and Intermediate
courses or have gained a similar level of expertise.
Training style
Informal and participative using a combination of trainer input, discussion
and practical exercises. This approach ensures the training meets the
needs of both the group and individual participants.
|
Course Contents
Data Validation & Pivot Tables
Data validation
Pivot tables
Creating a chart from a Pivot Table
Sharing Workbooks*
Setting up a shared workbook
Limitations of a shared workbook
Distributing a shared workbook
Tracking changes
Review and incorporate changes Removing a workbook from being shared Merging
workbooks
Data Analysis
Scenarios, Goal Seek
Solver*
Data Tables
Styles and Templates
Creating a style by example
Defining and applying a style
Creating Spreadsheet Templates
Creating Worksheet Templates
Opening and editing the original template
|
Customising Excel
Customising toolbars and menus
Moving toolbars
Customising the keyboard
Simple Macros
Recording a macro
Assigning a macro to a menu, tool bar or icon
Editing the icon
Running a macro
Exchanging Data with Other
Applications
Clipboard
Linking and embedding data buttons
*Optional items available on request
|
