Microsoft Excel Intermediate In-house training Level 2

Mark Baglow Training Limited

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

Formula Fundamentals

Develop a deeper understanding of how Excel formulas work and how to build them correctly.

• Quick recap of key beginner formulas

• How Excel functions work and what arguments mean

• Using absolute and mixed cell references for reliable calculations

Statistical Functions & Analysis Tools

Use Excel’s built-in functions to analyse data more effectively and confidently.

• Calculating averages with MEAN, MEDIAN, and MODE

• Rounding numbers with ROUND, ROUNDUP, and ROUNDDOWN

• Advanced rounding using MROUND, CEILING.MATH, and FLOOR.MATH

• Ranking data with RANK.EQ and RANK.AVG

• Identifying top and bottom values using LARGE and SMALL

• Summarising filtered lists efficiently with SUBTOTAL

Excel Logic Fundamentals

Learn how to make Excel perform automatic decisions based on your data.

• Understanding and applying IF statements

• Creating logical tests using comparison operators

• Building smarter conditional logic to automate calculations and reporting

Linking & Managing Data

Manage and summarise data across multiple worksheets with confidence.

• Linking data across worksheets and workbooks

• Using Subtotals and Grouping for clearer summaries

• Keeping multi-sheet reports consistent and dynamic

Lookups & Search Functions

Automatically retrieve information from tables and worksheets.

• Performing classic lookups with VLOOKUP

• Using XLOOKUP for more flexible and powerful data retrieval

• Working with exact and approximate matches

• Returning multiple values from a single lookup

• Handling missing data using built-in error options

Conditional Formatting & Data Visualisation

Highlight important information automatically and make patterns easy to spot.

• Reviewing cell styles and formatting options

• Applying highlight cell rules and top/bottom comparisons

• Using data bars, colour scales, and icon sets

Working with Date & Time Functions

Handle dates and deadlines accurately and efficiently.

• Performing date calculations and date arithmetic

• Using EDATE and EOMONTH for reporting

• Extracting date elements using DAY, MONTH, YEAR, and TEXT

• Calculating deadlines with WORKDAY and NETWORKDAYS

Auditing & Troubleshooting Spreadsheets

Understand how your formulas work and fix issues with confidence.

• Tracing precedents and dependents

• Displaying formulas to review calculations

• Using Evaluate Formula and Error Checking tools

Collaboration & Data Control

Finish the course by learning how to make spreadsheets secure and team-friendly.

• Adding and managing comments and notes

• Using data validation to restrict input

• Creating drop-down lists for efficient data entry

• Protecting worksheets and workbooks to maintain accuracy

-

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 and want to develop more advanced working practices

• Employees responsible for reporting, tracking, or analysing data

• Departments that rely on Excel and want to reduce errors and manual work

• Organisations looking to improve data accuracy and spreadsheet consistency

• Staff progressing beyond basic Excel usage

Participants should already be comfortable with Excel basics, such as entering data, using simple formulas, and applying basic formatting.

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

Developing intermediate Excel skills helps organisations build stronger internal capability and support staff development.

Improving how teams analyse data and automate calculations can increase productivity, reduce errors, and support progression into more analytical or management roles.