YOUR CART
- No products in the cart.
Subtotal:
€0
Overview
In this Excel Advanced Course we assume the knowledge from our Microsoft Excel Essentials course. This course covers data analysis using Tables and Pivot Tables. It will use functions used frequently when analysing data such as IFS, Lookups and the M365 #SPILL functions of Sort and Filter. This Excel Advanced Course will also give you an introduction to Excel feature called Power Query.
Perfect for those that have completed our Excel Essentials course and need to extend their Excel knowledge of Microsoft's Excel product.
Course Objectives
In this Excel Advanced course, participants will learn how to efficiently convert data ranges into tables, facilitating organized data management. They will also gain the skills to perform in-depth data analysis by harnessing the power of Pivot Tables. Additionally, students will explore advanced functions using LOOKUPS and IFS as well as the new M365 #SPILL formula.
How We Stand Out
IACT’s Excel Advanced Course – Data Analysis is part of a modular pathway that also includes Excel Essentials and Excel Master Diploma options.
With CPD/CV‑worthy certification and flexible delivery modes (remote or in‑person), learners can tailor their journey to fit their schedule and goals.
Participants have the option to join only this advanced module or combine it with Essentials and Master levels at a bundled rate, making it ideal for teams or individuals scaling up their Excel capability.
Course Benefits
- A significant boost in productivity by shifting from manual operations to automated, formula-driven solutions
- Clean data and standardised processes to reduce costly mistakes
- Interactive dashboards deliver insights that can support key business decisions
- Hands-on learning with real‑life case studies — practice while you learn
- Suitable for both classroom-based and blended learning: attend in-person or via live online classes run by expert Microsoft-certified trainers
Content
Formatting
- Tips and Tricks
- Custom Formatting Options
- Splitting Data Options
Calculations
- Revision of Cell Ref and Basic Daily
Functions
- Auditing Tools
- CleanUp Functions such as TRIM, UPPER & LOWER
Dynamic Ranges
- Revision of Tables
- Table Style Options incl. Total Row
- Use of Table Names in Functions
- Referring To Tables In Other Sheets
Functions
- Countif
- Countifs
- Sumif
- Sumifs
Advanced Functions
- IF Statements
- Nested IF and IFS (365)
- VLOOKUP & HLOOKUP Functions
- XLOOKUP Function
Working with Lists
- UNIQUE, SORT and FILTER #SPILL formulas
- Advanced Conditional Formatting
- Subtotal Command & Aggregate Function
Data Tools
- Data Validation
- Lists (dropdowns)
Pivot Tables
- Creating and Formatting Pivot Tables
- Calculations in a Pivot Tables
- Slicers and Timelines
- Working with Dates
Charts
- Creating different types of Charts
- Primary and Secondary Axis
Power Query
- GET & TRANSFORM
- Getting started with the Power Query Editor interface
- Split Columns
- Format & TRIM
- Unpivot Columns
- Append multiple sheets
What you’ll learn
Cleaning and normalising raw data: handling duplicates, missing values, formatting and text errors efficiently with tools like Flash Fill and Text-to-Columns
Advanced formulas and functions: nested IFs, INDEX–MATCH, SUMIFS, array formulas and conditional mapping to solve real-world problems
Data validation and error handling: drop‑down lists, dependent validation, and error trapping to enforce data quality
PivotTables and PivotCharts: summarise hundreds of thousands of rows instantly, slice by dimensions like time or category, and share automated visual reports
What‑If Analysis tools: data tables, Goal Seek and Solver for modelling scenarios and forecasting
Dashboards and interactive reporting: combining charts, slicers, conditional formatting and form controls to create dynamic visual displays
Introduction to automation: record macros and learn basic VBA to reduce repetitive tasks — preparing you for our deeper Excel Macros with VBA course
Audience
Essential to have a good understanding of Excel before attending this course. Please ensure you are familiar with all the topics on our Excel Essentials Course. If you are using Excel everyday to a good level and would like to be better and know more about formula and data manipulation, this course if perfect for you.
Ideal for:
Professionals already comfortable with Excel’s intermediate features
Analysts, managers, accountants, marketers, HR staff and project coordinators who work with data regularly
Users looking to speed up reporting, minimize errors, and replace manual workflows
Duration
2 Day or 4 x 3 Hour Sessions
More Courses...
Contact us...
Relevant, industry-focused learning and development
Our expert trainers have a wealth of experience in providing corporate training. Whether you pick off-the-shelf professional diplomas or a customised online L&D Program, we provide relevant, engaging content for all employees.
