Microsoft Excel Advanced in-house team training in person

Mark Baglow Training Limited

Below is the typical content for a one-day course. This can be tailored to suit your organisation's requirements.

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."

• Teams who already use Excel at an intermediate level or above

• Employees responsible for reporting, analysis, or data-heavy tasks

• Analysts and professionals working with large or complex datasets

• Departments looking to standardise advanced Excel practices

• Organisations seeking to reduce manual work and improve data accuracy

Participants should already be comfortable with intermediate Excel features such as logical formulas, lookups, and working with structured data.

Each participant will need access to a computer with Microsoft Excel installed. Delivery format (on-site or live online) can be agreed in advance.

Advanced Excel training helps organisations build deep internal capability and reduce reliance on manual processes.

Strong Excel automation and analysis skills support productivity, improve reporting quality, and enable teams to take on more advanced analytical and decision-making responsibilities.