Microsoft Excel Advanced - Live Online 1 Day Course

Mark Baglow Training Limited

Advanced Logical Functions

Build intelligent spreadsheets that respond automatically to different conditions.

• Using AND and OR to combine multiple criteria

• Creating nested IF and IFS formulas

• Summarising data with COUNTIFS, SUMIFS, and related functions

Advanced Lookups & Data Retrieval

Retrieve exactly the data you need, even from complex, multi-sheet workbooks.

• Using XLOOKUP and XMATCH for flexible searching

• Combining INDEX and MATCH for dynamic lookups

• Using wildcards and multi-criteria lookups

• Handling duplicates and missing values confidently

Importing & Cleaning Data

Prepare data efficiently before analysis.

• Removing blank rows and duplicates

• Adjusting text formatting with UPPER, LOWER, and PROPER

• Cleaning data using TRIM

• Reformatting data with Text to Columns and Flash Fill

Advanced Data Cleaning with Power Query

Automate data preparation and transformation without complex formulas.

• Importing data from spreadsheets and external sources

• Cleaning and transforming data using Power Query steps

• Combining tables, removing errors, and automating repetitive tasks

Dynamic Arrays

Use Excel’s modern formulas to analyse data more flexibly and efficiently.

• Extracting unique values with UNIQUE

• Sorting data using SORT and SORTBY

• Generating lists with SEQUENCE and RANDARRAY

• Filtering data dynamically using FILTER

• Combining dynamic arrays with traditional functions

Data Validation & Control

Maintain clean, accurate, and consistent data entry.

• Applying validation rules

• Creating custom input messages and alerts

• Building drop-down and dependent drop-down lists

PivotTables & PivotCharts

Analyse large datasets and create professional reports quickly.

• Building and structuring PivotTables

• Grouping, filtering, and summarising data

• Creating interactive PivotCharts

• Using slicers for dashboard-style interactivity

Macros & Automation

Save time and reduce errors by automating repetitive tasks.

• Understanding what macros can do

• Recording macros using the Macro Recorder

• Saving and reusing macros across workbooks

• Creating custom ribbons for quick access

-

Some of the feedback received for my Excel training:

"We recently had Excel training with Mark Baglow Training, and it was excellent. Mark’s delivery was clear, engaging, and very informative. His knowledge and practical examples have given us valuable skills that will make our daily work more efficient.

Every section of the training can be adapted to use in our work. We have already spoken to other colleagues about how well our day went. Highly recommended Mark and will certainly be in touch again for any future training needs! Thank you Mark."

-

"Mark's Excel intermediate course was well structured, informative. I really enjoyed the course and came out feeling more confident using Excel in the future."

-

"I was a complete newcomer to Excel. The course content was comprehensive, detailed and extensive and the course provider excellent. I was able to ask questions throughout and felt totally supported. By the end of the day, Excel had been demystified for me and I am now able to set up and operate worksheets and workbooks, including using basic formulae, with complete confidence."

-

"Thank you for today’s Excel training - it was engaging, well-paced, and full of practical tips I can use right away.​ I especially appreciated how interactive the session was. Your clear explanation of formulas helped me finally understand how they work, boosting my confidence and accuracy. Thanks again for such a valuable and enjoyable session!"

-

"Great course delivered by Mark with an excellent workbook. Good instructions and learning about spreadsheets made the day enjoyable. Mark explained each task and made it simple. I learnt such a lot in a few hours."

-

"He was very interesting to listen to and follow which made it easier to learn. I did come away from the course with lots more knowledge of Excel and now it doesn't feel like this big ogre that I kept running away from! I will try and keep practising, and can now confidently say on my CV that I know Excel! Thank you Mark :)"

-

"Mark teaches at a steady pace and everything is explained perfectly. With the use of the workbook that is sent prior to the course and Mark's live examples there was a great mix of practical exercises and listening with examples, which I find is always the best mix for something like this."

• Experienced Excel users looking to advance their skills

• Professionals working with large datasets and complex spreadsheets

• Analysts creating reports, dashboards, and models

• Excel users who want to automate tasks and improve efficiency

• Anyone aiming to master Excel’s advanced analysis and automation tools

You should have completed an Excel Intermediate (Level 2) course or already be comfortable with intermediate Excel features such as logical formulas, lookups, and structured data.

You’ll need a computer with Microsoft Excel installed and an internet connection to join the live online session.

A microphone and webcam are helpful if you wish to ask questions, but are not essential. You will still be able to interact via the Teams chat if you wish.

Advanced Excel skills are highly valued across industries and roles.

Mastering data analysis, automation, and reporting tools can significantly improve productivity, support better decision-making, and open up advanced career opportunities.