|
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
Styles and Templates
Cell styles
Format as a table
Using the Sort and Filter Editing option
(to remove filters)
Creating a style by example
Defining and applying a style
Creating spreadsheet templates
Creating worksheet templates
Opening and editing the original template
Customising Excel
The Quick Access toolbar
Adding commands
Customising the keyboard
Creating custom views
|
Data Analysis
Using Scenarios
Using Goal Seek
Using Solver*
Data tables
Remove duplicates
Simple Macros
The Office toolbar
Adding Developer tab
Trust Centre settings
Recording a macro
Understand the Personal Macro Workbook
Assigning a macro to Quick Access toolbar
Editing the icon
Running a macro
Editing and deleting macros
Exchanging Data with Other
Applications
Using Clipboard
Linking and embedding data buttons
*Optional items available on request
|
