Microsoft Excel Basics: The Complete 365 Beginner Course

Learn how to create, rename, colour and organise worksheets to keep your workbooks neat and easy to navigate. Good organisation from the very beginning makes every Excel project easier to manage.

Discover the quickest ways to resize rows and columns, use AutoFit, and keep your worksheets looking clean and professional. Small formatting improvements can make a huge difference to readability.

Master the essential techniques for inserting, deleting, hiding and unhiding rows and columns. These everyday skills will help you edit worksheets confidently without disrupting your data.

Explore the new Microsoft 365 checkboxes and see how they can turn ordinary worksheets into interactive task lists and dashboards. You'll learn how to insert, use and remove checkboxes with confidence.

Save time by learning Excel's smartest productivity tools. Discover how to copy and move data correctly, then use the Fill Handle to create lists and patterns automatically instead of typing everything manually.

Discover one of Excel's greatest productivity features. Learn how the Fill Handle can automatically continue lists, copy values and formulas, and eliminate repetitive typing, helping you work faster and more efficiently from day one.

Learn the fastest ways to select cells, rows, columns and large datasets in Excel. Master essential navigation techniques and keyboard shortcuts that will save you time when working with real-world spreadsheets.

Create clean, professional-looking worksheets using Excel's alignment tools, then discover how the Format Painter lets you copy formatting instantly, saving time while keeping your work consistent.

Give your spreadsheets a polished Microsoft 365 look by using the modern Aptos font, professional colour themes and consistent formatting techniques that make your work easier to read and more visually appealing.

Discover how Excel performs calculations using formulas and cell references. Learn why referencing cells instead of typing numbers directly makes your spreadsheets more accurate, flexible and easier to maintain.

Put your new formula skills into practice by creating a simple invoice. Calculate totals, copy formulas efficiently and see how Excel can automate everyday business calculations in just a few clicks.

Learn when Excel automatically adjusts cell references and when they need to stay fixed. Master relative and absolute references so your formulas continue to work correctly when copied across large worksheets.

Meet the five functions every Excel user should know: SUM, AVERAGE, COUNT, MAX and MIN. These powerful built-in tools allow you to analyse data quickly without writing complicated formulas.

Make your formulas easier to read and maintain by replacing cell references with meaningful names. Named Ranges improve clarity, reduce errors and make even complex worksheets much easier to understand.

Transform ordinary ranges into intelligent Excel Tables that automatically expand, apply formatting and unlock powerful features. Discover why Tables are considered one of the most valuable tools in modern Excel.

The invoice exercise is one for you to complete yourself, but this walkthrough can be useful to check your results.

Quickly focus on the information that matters by using Excel's powerful filtering tools. Learn how to display only the records you need, helping you answer questions and analyse data without deleting or rearranging anything.

Turn your data into clear, professional charts using Excel's modern charting tools. Learn how to create attractive visuals, apply clean formatting and present information that is easy to understand at a glance.

Add compact charts directly into your worksheets using Sparklines. Learn how these miniature charts highlight trends and patterns without taking up valuable worksheet space.

Prepare your worksheets for printing by setting print areas, adjusting page layouts and creating professional PDF documents. Learn the finishing touches that make your work ready to share with colleagues and clients.

Bring everything together by creating an interactive project tracker using modern Excel checkboxes, formulas and conditional formatting. This practical exercise demonstrates how the skills you've learned throughout the course combine to solve a real business problem.

I have included a "cheat sheet" of the Excel shortcuts used throughout the course. Just download the PDF and print it if you wish.