Advanced Microsoft Excel: PivotTables, Macros and Power Query

Level: Advanced

Master the full power of Microsoft Excel with this advanced Excel training course built for professionals who are ready to go beyond the basics and intermediate techniques. This seminar delivers a concentrated, high-impact day of learning focused on the complex capabilities that separate proficient users from true Excel experts. You'll build on what you already know, diving deep into nested functions, PivotTable analysis, macro editing, Power Query and more. 

If you're comfortable in Excel but know there are layers of capability you haven't yet unlocked, this course gives you the tools, strategies and confidence to work at an expert level. 

Why Take Advanced Microsoft Excel Training? 

Excel's most powerful features are also its most underused, because they're rarely self-taught. Advanced Excel skills give professionals the ability to: 

• Build complex, layered formulas that handle real business problems 
• Automate and edit macros using the Visual Basic Editor 
• Analyze large datasets faster with advanced PivotTable techniques 
• Streamline data preparation and transformation with Power Query 

This advanced Excel seminar is built around the tools and techniques that experienced users need to work more accurately, efficiently and confidently. 

Who Should Attend This Advanced Excel Training Course? 

This seminar is designed for professionals who are already comfortable working in Excel. You will get the most from this course if you already have hands-on experience with: 

• Organizing and cleaning data on a worksheet 
• Using Excel tables and conditional formatting 
• Working with XLOOKUP 
• Building basic PivotTables 
• Recording and using basic macros 

If these skills are in place, this course will build on that foundation and take your Excel proficiency to an expert level.

Advanced Functions and Formula Techniques  

Go beyond standard formulas and build calculations that handle complex, real-world data: 

• Build a summary sheet using 3D references across multiple worksheets 
• Make data smarter with logical functions including AND and OR 
• Harness the full power of IF functions by learning to nest them and ask layered questions of your data 
• Learn more efficient ways to split columns beyond the basic Text to Columns tool 
• Format and perform calculations directly within PivotTables 
• Use Excel's built-in error checking tools to keep your calculations accurate 
• Track down formula errors using Excel's formula auditing features 
• Learn tips and techniques for building complicated formulas using nested functions 
• Discover two ways to filter out duplicate records from your datasets 

PivotTable Mastery  

Get more out of your data with advanced PivotTable analysis and presentation techniques: 

• Extract exactly the analysis you need from any PivotTable 
• Control how and where your PivotTable data is displayed 
• Style and format PivotTables for polished, at-a-glance reporting 
• Sort and group PivotTable results for a clearer picture of your data 
• Take PivotTables further with Calculated Fields 

Macros and the Visual Basic Editor  

Move beyond recording basic macros and start editing and troubleshooting them with confidence: 

• Get started with the Visual Basic Editor 
• Understand the basic structure of macro programs so you can edit them effectively 
• Apply easy debugging techniques that resolve issues quickly 

Power Query for Data Automation  

Simplify complex, time-consuming data tasks using one of Excel's most powerful tools: 

• Use Power Query to work with large datasets, perform complex text splits, combine data from multiple sources and unpivot data for analysis 

Course Format: Lecture-Style for Faster Learning 

This is a lecture-style Excel seminar, not a hands-on workshop. All concepts are demonstrated by an expert instructor so you can stay focused on learning without delays from in-class data entry. You'll receive a detailed workbook with step-by-step examples to practice after the course. 

This course is applicable to Excel 2019 and all versions forward.

Who is the Advanced Microsoft Excel course designed for?  

This course is designedfor users who are already comfortable with intermediate Excel skills, including tables, XLOOKUP, basic PivotTables, conditional formatting and basic macros. If those skills are in place, this course will push your proficiency significantly further. 

What topics are covered in Advanced Microsoft Excel? 

This one-day advanced Excel course covers nested logical functions, 3D references, formula auditing and error checking, advanced PivotTable techniques including Calculated Fields, macro editing using the Visual Basic Editor, debugging techniques and Power Query for data automation and transformation. 

Is this course hands-on or lecture-based?  

This is a lecture-style seminar, not a hands-on workshop. The expert-led format ensures fast-paced, high-impact learning without the delays of in-class data entry. You'll receive a comprehensive workbook so you can practice and apply everything you've learned at your own pace after the course.