Skip to content

Microsoft Excel Introduction for Beginners - Level 1 Live Online

Live online small group interactive course with detailed notes and materials. Private courses also available.

Provided by Mark Baglow Training Limited

Summary

Price
£200 inc VAT
Study method
Online + live classes
Duration
1 day · Part-time or full-time
Qualification
No formal qualification
Certificates
  • Certificate of Completion - Free
Additional info
  • Tutor is available to students

8 students enquired about this course

Add to basket or enquire

Dates

Start date
End date
12/05/2025
12/05/2025
07/06/2025
07/06/2025
17/06/2025
17/06/2025
14/07/2025
14/07/2025

Overview

New to Microsoft Excel or never had any training? Nervous about formulas? No problem!

Our friendly Microsoft Excel Level 1 beginner training will help you master the Excel basics build a strong foundation in spreadsheets, formulas, and data management.

Whether you're brand new to Excel, or have been muddling along with it for years, our training will demystify Excel and teach you to become a confident and efficient Microsoft Excel user.

Courses are delivered live online with a maximum of 8 attendees so you can get all the support you may need.

Learn how to navigate Excel, enter and format data, perform calculations, and create charts with confidence in this hands-on, practical course.

Microsoft Excel is one of the most powerful tools for data management, reporting, and calculations, but getting started can feel overwhelming.

Learn the secrets of being a great Excel user, banish your nerves and complete tasks more quickly and efficiently.

All attendees are provided with a course file containing comprehensive notes and exercises.

The course is designed to be extremely practical. You will be guided to do everything the trainer does.

By the end of the day you will have a course file filled with notes and working examples of everything we cover.

There are also extra exercises for you to practice your skills after the course.

The course is live online instructor-led training in a small group with a maximum of 8 attendees. Courses run from 9:30am - 4:30pm with breaks.

Private in-person courses are also available upon request.

If you would like a private course just for your organisation, or 1-2-1 tuition, please get in touch and we will be happy to help.

Certificates

Certificate of Completion

Digital certificate - Included

Course media

Description

Understanding the Excel Interface & Navigation

  • What is Excel?

  • Opening, saving and navigating between worksheets and workbooks

  • Zooming in to the right distance every time - no more squinting at tiny numbers!

  • Ribbon, formula bar, adding and removing columns and rows

  • Customising the Quick Access Toolbar

Entering and Managing Data

  • Typing, editing and clearing data in cells

  • Selecting multiple cells, entire rows and entire columns

  • Speed up data entry and creating formulas with Autofill and the Fill Handle

  • Separate, join and edit data quickly using Flash Fill (one of the most powerful features in Excel!)

  • Using Cut, Copy, and the different options for Pasting data

Performing Essential Calculations

  • Writing simple formulas using basic mathematical operators (plus, minus, divide, multiply)

  • Using cell references to make your formulas easy, dynamic and error-free

  • Essential formulas - SUM, AVERAGE, MIN, MAX, and counting functions

  • Percentage calculations in Excel (increase, decrease, finding percentages)

  • Understanding common formula errors and how to fix them

Formatting & Organising Data

  • Applying number formatting (currency, percentages, dates, etc.) and why it's important

  • How to quickly and easily clear formatting, data and hyperlinks

  • Adjusting column widths, row heights, and cell alignment

  • Using conditional formatting to highlight important data

Working with Lists & Tables

  • Sorting and filtering data effectively

  • Creating Excel Tables for better data management

  • Applying custom sorts and using subtotals

Data Visualisation Fundamentals

  • Creating and customising basic charts (column, bar, line, pie)

  • When to use different charts depending on your data

  • Modifying chart elements (titles, labels, legends, colours)

Finalising Worksheets & Printing

  • Spell check and Find & Replace to polish your worksheets

  • Adjusting page layout and print settings for professional-looking spreadsheets

  • Setting print areas and using headers & footers

  • Print Excel worksheets without the headaches and stress!

Some of the feedback received for our Excel training:

“Mark was excellent!!!”

"The trainer was full of knowledge and made the course run very smoothly and had plenty of time to go over anything."

"All of the course content was valuable & I particularly found the demonstrations and each of the breakdowns for each step on how to do it very useful and beneficial."

"I'll be referring to the training material on a regular basis to keep learning and getting used to everything we learned today."

"I will continue to grow my excel knowledge and being able to refer back to the notes taken will help massively."

"I won't be be so nervous of Excel!"

"I will put all I have learnt into practice going forwards, found the course very helpful & useful."

“I really enjoyed the course and refreshing some lost knowledge.”

Who is this course for?

  • Individuals who are new to Microsoft Excel and want to learn the fundamentals.
  • Regular Excel users who have never received training and are often frustrated when trying to use it.
  • Professionals who need to use Excel for basic data entry, calculations, and reporting.

  • Anyone wanting to improve their core Excel skills and gain confidence in using spreadsheets.

  • Teams and individuals who require foundational Excel training to enhance their everyday productivity.

Requirements

No previous Excel knowledge required. Computer with Excel installed is needed. Internet access for joining the course.

Career path

Proficiency in Microsoft Excel is one of the most in-demand skills across all industries.

Being able to work with Excel confidently and efficiently can massively boost your productivity, speed up tasks and open new doors.

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Provider

Mark Baglow Training Limited

I’m Mark Baglow - the founder and lead trainer of Mark Baglow Training. I'm an experienced trainer with a passion for helping professionals build confidence, improve communication, and lead effectively. With a background in corporate training and education, I bring a practical, results-driven approach to developing managers and teams.

I am a strong believer that training is one of the most valuable investments that an organisation can make. That’s why I work with you to ensure that the training I deliver fits your needs to help upskill your teams and retain top talent.

I am a PGCE-qualified educator and I am DISC-certified, giving me a strong foundation in both instructional design and behavioural analysis. This allows me to tailor training to different learning styles and personality types, ensuring sessions are engaging, interactive, and impactful.

I specialise in leadership, management, project management, Microsoft 365 and other business skills such as communication and time management. I work with organisations across the UK and internationally. My training is designed to be practical and immediately applicable, whether you’re a new manager navigating leadership challenges, a business owner scaling your team, or an organisation looking to give your employees new skills.

With experience across industries including education, technology, financial services and the public sector, I understand the diverse challenges professionals face. My goal is to equip people with the tools, strategies, and confidence to perform at their best - while reducing stress and improving work-life balance.

I offer both online and in-house training, adapting sessions to suit organisations of all sizes.

View Mark Baglow Training Limited profile

FAQs