|
Microsoft Excel Advanced Outline
Aims of the One-Day Course
This course is suitable for experienced users who wish to learn how
to use the advanced features of Microsoft Excel. The course is 100% hands-on,
with exercises to help the trainees practice the new skills they learn.
Course Content
- Working with Multiple Worksheets
- Inserting, moving, renaming, copying & deleting worksheets
- Making changes to multiple worksheets
- Creating formulae linking data on multiple worksheets
- Working with Multiple Workbooks
- Copying and moving data between workbooks
- Creating formulae linking data in separate workbooks
- Working with workspace files
- Excel Templates
- Creating a new template
- Changing the default template style
- Creating a new workbook based on a template
|
- Scenarios
- Create a Scenario
- Display a Scenario
- Create a Scenario Summary Report
- Advanced Excel Functions
- Using the VLOOKUP, IF and ISERROR functions
- Customising Excel
- Creating and displaying Views
- Creating and using a Custom AutoFill
- Outlining a worksheet
- PivotTables and PivotCharts
- Creating PivotTables & PivotCharts
- Changing the layout of a PivotTable or PivotChart
- Macros
- Record a simple Macro
- Assign a Macro to a Button
|
Prerequisites
Trainees should have attended the Intermediate, or equivalent level,
Excel course or have an in-depth knowledge of Microsoft Excel.
Course Duration
Six hours (9.30am to 12.30pm and 1.30pm to 4.30pm).
Next Course
Microsoft Excel VBA and Microsoft
Excel Programming
Prices
|
