Course not currently available
Microsoft Excel Advanced
Short course
In Harpenden ()
Description
-
Type
Short course
-
Level
Advanced
-
Duration
1 Day
On completion of this course, attendees will be able to create a variety of functions, present their data using PivotTables, analyse workbooks and data and record macros. Suitable for: This course is designed for those who wish to understand how to analyse and present their data more efficiently as well as automate common tasks.
Important information
Documents
- Excel Advanced
About this course
Attendees should have attended our Excel Intermediate course or have equivalent knowledge.
Reviews
Course programme
Microsoft Excel Advanced Course Outline
Review of Excel Skills
- Constructing formulae
- Using functions
- Absolute and relative cell referencing
- Naming ranges
Automating Worksheets
- Creating and editing templates
- Using data validation
- Applying workbook & cell protection
Further Functions
- Nested IF functions
- Using AND OR operators
- Lookup functions
- Text functions
Summarising Worksheets
- Group and outline a worksheet
- Hiding and displaying outlines
Pivot Tables
- Creating and modifying Pivot Tables
- Refreshing the data
- Grouping data within a Pivot Table
Data Management
- Using worksheet auditing tools
- Tracing dependent and precedent cells
- Checking for errors & highlighting invalid data
Macros
- Recording simple Macros
- Running and editing Macros
- Assigning Macros to the keyboard, toolbar buttons and menus
Microsoft Excel Advanced