Microsoft Excel - Advanced
Short course
In London, Sutton, Surrey, Nottingham
Description
-
Type
Short course
-
Location
London, sutton, surrey, ...
-
Duration
1 Day
You will learn various advanced techniques for analyzing and manipulating data in Excel. This course meets the Microsoft Proficiency Guidelines for Excel at the Expert level. Suitable for: This course is intended for businesses and home users of Microsoft Excel that need advanced skills in Microsoft Excel.
Facilities
Location
Start date
Start date
Reviews
Course programme
- Course book
- Lunch
- 3 Months post training support
- Certificate of attendence
Customising the Work Area
- Working with built-in toolbars
- Using custom toolbars
- Creating and using Styles
- Using Templates
- Using Names
- Using the IF function
- Using the VLOOKUP function
- Using IS functions and the Auditing features
- Creating Pivot Tables
- Modifying Pivot Tables
- Grouping and summarizing data in a Pivot Table
- Creating interactive Pivot Tables for the Web
- Working with Workbooks
- Linking cells in different Workbooks
- Workbook versus links and Workspaces
- Sharing and merging Workbooks
- Consolidating and analyzing data
- Consolidating data from more than one Worksheet
- Using the Goal Seek and Solver utilities
- Using Scenario Manager to view a Worksheet with different input values
- Using Comments
- Protecting Workbooks
- Using custom views
- Running Macros
- Recording a Macro
- Viewing and editing VBA code
- Saving Excel Worksheets as Web documents
- Spreadsheet Web components
Microsoft Excel - Advanced