-
Duration: 1 day
Price: £195 (exc. VAT)
Search
Contact
Apprenticeship Vacancies
Make an enquiry
Search
Contact
Apprenticeship Vacancies
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.
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.
Learn how to:
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.