Learn Basic Excel Skills and Build Confidence
Excel is one of the most valuable workplace skills you can have – and learning it doesn’t need to be intimidating.
Our Beginner Excel Course gives you a clear, practical introduction to Microsoft Excel, helping you build spreadsheets, perform simple calculations, and present your data clearly.
Whether you’re completely new to Excel or just want to fill in the gaps, this session focuses on hands-on learning rather than heavy theory.
You’ll be guided through hands-on exercises designed to show you how Excel really works – so you can save time, reduce mistakes, and feel confident managing data in your role.
By the end of our Beginner Excel Class, you’ll be able to:
-
Create and format professional-looking spreadsheets.
-
Use simple formulas and functions to perform calculations.
-
Organise data using sorting and filtering tools.
-
Create clear charts and graphs to present your data visually.
-
Save and print your work with confidence.
This course is perfect for anyone who uses Excel in day-to-day tasks and wants to build a strong foundation for future learning.
Looking to go beyond the basics?
We also have Intermediate and Advanced Excel courses available.
Excel Beginner Course Content
For in-house training the course can be tailored to your specific requirements
All learners on our Beginner Excel Course receive:
-
A detailed course workbook with step-by-step explanations for all topics.
-
Hands-on examples for everything to make learning practical and engaging.
-
Post-course exercises to help you keep practising what you’ve learned.
Understanding the Excel Interface & Navigation
Get comfortable with Excel’s layout and tools so you can work faster and smarter.
-
What Excel is and how it’s used in business.
-
Opening, saving, and navigating between worksheets and workbooks.
-
Zooming and adjusting your view for comfortable working.
-
Understanding the Ribbon, formula bar, and layout.
-
Adding or removing columns and rows.
-
Customising the Quick Access Toolbar for your most-used commands.
Entering and Managing Data
Learn the easiest and quickest ways to input, edit, and manage data efficiently.
-
Typing, editing, and clearing data in cells.
-
Selecting multiple cells, rows, and columns.
-
Speeding up data entry with Autofill and the Fill Handle.
-
Using Flash Fill to quickly separate or join data (a powerful time-saver!).
-
Using Cut, Copy, and Paste effectively with Excel’s different paste options.
Performing Essential Calculations
Master the formulas that make Excel so powerful.
-
Writing basic formulas to add, subtract, divide and multiply numbers.
-
Using cell references to create flexible, dynamic, and reliable calculations.
-
Essential functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK
-
Performing percentage calculations, including increases and decreases.
-
Understanding and fixing common formula errors.
Formatting & Organising Data
Make your spreadsheets clear, professional, and easy to read.
-
Applying number formats (currency, percentage, date, etc.).
-
Clearing formatting, data, and hyperlinks without a lot of manual work.
-
Reuse formatting quicker and easily with the Format Painter.
-
Adjusting column widths, row heights, and alignment.
-
Using basic Conditional Formatting to highlight key information automatically.
Managing data with Lists & Tables
Bring structure and control to larger sets of data.
-
Sorting data by a single column or with a Custom Sort.
-
Filtering your information effectively.
-
Creating Excel Tables to manage data more easily.
-
Create subtotals to quickly analyse data.
Data Visualisation Fundamentals
Turn numbers into visuals that tell a story.
-
How charts help you understand data better.
-
Creating and customising charts (column, bar, line, pie).
-
Choosing the right chart type for your message.
-
Editing chart elements like titles, labels, legends, and colours.
Finalising Worksheets & Printing
Finish your Excel files with confidence and share your work professionally.
-
How to manage multiple Excel files at once.
-
Viewing multiple places in an Excel file at the same time (big time saver!).
-
Checking spelling and using Find & Replace.
-
Collaborating with others using Comments and Notes.
-
Saving Excel files as a PDF to share with others.
-
Adjusting page layout and print settings.
-
Setting print areas, headers, and footers.
-
The step-by-step process to printing neatly formatted spreadsheets without stress.
Course Delivery
In-House Training
Private in-house courses are available by contacting us. Delivered in-person at your site or another location of your choice. Training can also take place online via Teams.
In-house sessions allow us to tailor the content to your organisation’s specific goals, culture, and challenges.
Public Courses
Regular public courses available to everyone. Live, online training classes delivered via Microsoft Teams.
Perfect for individuals or a small number of attendees. Interactive and engaging to give you the classroom experience while building your skills and confidence.
Public Course Dates
Book instantly onto one of our regular public courses below. Our online Excel courses are delivered as live instructor-led training via Microsoft Teams.
Looking for in-person or remote training for your team?
Please contact us to discuss our in-house training options.
- Excel Beginner - 10/12/2510 Dec 2025, 09:30 – 16:30 GMTLive Online Training
- Excel Beginner - 13/01/2613 Jan 2026, 09:30 – 16:30 GMTLive Online Training
- Excel Beginner - 06/02/2606 Feb 2026, 09:30 – 16:30 GMTLive Online Training
- Excel Beginner- 04/03/2604 Mar 2026, 09:30 – 16:30 GMTLive Online Training
- Excel Beginner- 02/04/2602 Apr 2026, 09:30 – 16:30 BSTLive Online Training
- Excel Beginner - 16/06/2616 Jun 2026, 09:30 – 16:30 BSTLive Online Training
Who Is This Beginners Excel Course For?
This Excel training for beginners is ideal for anyone who wants to develop practical spreadsheet skills and feel confident using Excel in their day-to-day work.
Excel skills are needed in almost every job. Millions of people use Excel every day, but few have ever received proper training.
If you find yourself unsure of what Excel can do, need to improve your skills for a future role, or just want to brush up on the basics - our beginner Excel course is the perfect place to start.
This course is ideal for:
-
Office and administrative staff who regularly handle data, reports, or budgets.
-
Professionals in any role or industry who want to build or refresh their Excel skills to do their work more quickly and easily.
-
Small business owners who manage their own records, invoicing, or project data.
-
Students or jobseekers looking to boost their employability with a valuable, in-demand skill.
-
Regular Excel users who have never had training and want to improve their skills and confidence.
-
Anyone new to Excel who wants to learn in a friendly, supportive environment.
Whether you’re working with spreadsheets for the first time or simply want to learn the right way to use Excel, this course gives you a strong foundation to build on.
Why Choose Mark Baglow Training
If you’re ready to take control of your data and stop feeling daunted by spreadsheets, this is the perfect place to begin.
Join one of my upcoming Excel Beginner classes online or contact me to discuss tailored in-house options.
I also have Intermediate and Advanced Excel courses available to cater to all abilities.
Just fill in the form to get the conversation started.
You can also book a free 30 minute no-obligation consultation call here
