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 feel intimidating.
My Excel Beginner Course gives you a clear, practical introduction to Microsoft Excel.
You'll learn how to build spreadsheets, perform simple calculations, manage data effectively and present information clearly.
Whether you’re completely new to Excel or just want to fill in the gaps from being self-taught, this session focuses on hands-on learning rather than heavy theory.
You’ll work through real examples designed to show you how Excel works in the real world - helping you save time, avoid mistakes and feel confident handling data in your role.
By the end of the Excel Beginner Course, you’ll be able to:
-
Create and format professional-looking spreadsheets.
-
Enter data accurately and quickly using time-saving tricks.
-
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 a strong foundation before moving on to the Intermediate and Advanced levels. View all Excel courses.
Excel Beginner Course Content
For in-house training the course can be tailored to your specific requirements
Every participant receives:
-
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.
-
Certificate of Completion after the course.
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 me. Delivered in-person at your site or another location of your choice. Training can also take place online via Teams.
In-house sessions allow me 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 my regular public courses below. My online Excel courses are delivered as live instructor-led training via Microsoft Teams.
Looking for Microsoft Excel in-person or remote training for your team?
Please contact me to discuss our in-house training options.
- Excel Beginner - 12/01/2612 Jan 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
- Excel Beginner - 08/07/2608 Jul 2026, 09:30 – 16:30 BSTLive Online Training
- Excel Beginner - 23/09/2623 Sept 2026, 09:30 – 16:30 BSTLive Online Training
Who Is This Excel Beginner Course For?
This Excel training course is ideal for anyone who wants to build practical spreadsheet skills and feel confident using Excel in their daily 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 want to improve your accuracy, speed and confidence - or finally learn Excel “the right way” - this 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
Frequently Asked Questions
For more general questions about booking, pricing, delivery and more, please visit the main FAQ Page
Build on the foundations from the Beginner course. Learn logical functions, lookups, data validation, advanced charts and much more.
Become a power user with advanced logic and lookups, dynamic array functions, Pivot Tables, Power Query, data cleaning and auditing.
Learn the latest AI tools to increase your productivity and grow your skills with ChatGPT and Microsoft Copilot courses.
Improve your skills in other Microsoft Office applications - including Power BI, Word, PowerPoint, Outlook and more.
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. View all Excel courses.
Not sure which level is right for you? I'd be more than happy to advise.
Just fill in the form to get the conversation started.
You can also book a free 30 minute no-obligation consultation call here
