-
Duration: 1 day
Price: £195 (exc. VAT)
Course overview
Training participants will learn the essential skills needed to confidently navigate Excel, manage data, perform basic calculations, and format workbooks effectively for professional use. Higher level courses are ideal for individuals who use Excel as a powerful analysis tool, working with advanced functions, automation tools, and data validation techniques, all designed to improve data handling and analysis.
Further Information
-
Course Modules
-
Module 1: Formula Auditing
• What is it?
• Trace Precedents
• Trace Dependents
• Show Formulas
• Error Checking
• Evaluate Formula
• Watch Window.Module 2: Analysis Tools
• Advanced Filter
• Subtotal
• What – If Analysis: Goal Seek
• What – If Analysis: Data Tables
• What – If Analysis: Scenario Manager
• Analyze Data.Module 3: Macros
• Overview
• VBA macros.Module 4: Get Data
• Overview
• From Microsoft Access Database
• From Web.Module 5: Data Integrity
• Data Validation
• Password Protection.Module 6: Data Types
• Linked Data Types.Module 7: Dashboard
• PivotTables
• PivotCharts
• Slicers & Timelines. -
Course Objectives
-
Learn how to:
- Validate Data
- Use Advanced Formulas
- Use Auditing Tools
- Create and manipulate PivotTables and PivotCharts
- Work with Templates
- Insert Illustrations.
-
Prerequisites
-
This course is ideal for delegates who are very familiar with Microsoft Excel and can use intermediate functions. The course is designed to enhance efficiency with advanced functions, automation tools, and data validation techniques, ensuring users can confidently manipulate and interpret large datasets.