Microsoft Excel for Beginners - Live Online 1 Day Course

Mark Baglow Training Limited

Understanding the Excel Interface & Navigation

Get comfortable with Excel’s layout and tools so you can work faster and with more confidence.

• What Excel is and how it’s used in the workplace

• Opening, saving, and navigating between worksheets and workbooks

• Understanding the Ribbon, formula bar, and worksheet layout

• Zooming and adjusting your view for comfortable working

• Adding and removing rows and columns

• Customising the Quick Access Toolbar for commonly used commands

Entering and Managing Data

Learn efficient ways to input, edit, and manage data accurately.

• Typing, editing, and clearing data in cells

• Selecting cells, rows, and columns quickly

• Speeding up data entry using Autofill and the Fill Handle

• Using Flash Fill to split or combine data automatically

• Cut, Copy, and Paste – including Excel’s different paste options

Performing Essential Calculations

Understand the basics of formulas and start using Excel’s real power.

• Writing simple formulas to add, subtract, multiply, and divide

• Using cell references to create flexible 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, readable, and professional.

• Applying number formats (currency, dates, percentages, etc.)

• Clearing formatting, data, and hyperlinks efficiently

• Using the Format Painter to reuse formatting quickly

• Adjusting column widths, row heights, and alignment

• Applying basic Conditional Formatting to highlight key information

Managing Data with Lists & Tables

Work more effectively with larger sets of data.

• Sorting data, including custom sorts

• Filtering data to focus on what matters

• Creating and working with Excel Tables

• Creating subtotals to analyse data quickly

Data Visualisation Fundamentals

Turn your data into clear, meaningful visuals.

• When and why to use charts

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

• Creating more advanced charts (stacked and combo charts)

• Choosing the right chart type for your message

• Editing chart titles, labels, legends, and colours

Finalising Worksheets & Printing

Finish your work confidently and share it professionally.

• Working with multiple Excel files at once

• Viewing different areas of a worksheet at the same time

• Using Find & Replace and spell check

• Adding comments and notes for collaboration

• Saving Excel files as PDFs

• Setting page layout, print areas, headers, and footers

• Printing clean, well-formatted spreadsheets without stress

-

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

-

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

• Individuals who are new to Microsoft Excel

• People who use Excel regularly but have never had formal training

• Professionals who need Excel for basic data entry, calculations, and reports

• Anyone who wants to improve their core Excel skills and work more efficiently

• Learners looking to build confidence with spreadsheets in a supportive environment

No previous Excel knowledge is required.

You’ll need a computer with Microsoft Excel installed and an internet connection to join the live online session. A microphone and webcam are helpful if you wish to ask questions, but are not essential. You will still be able to interact via the Teams chat if you wish.

Excel skills are in demand across almost every industry and role.

Building confidence with Excel can significantly improve your productivity, help you work more efficiently, and support your long-term career development.