Excel 365: Free Beginner to Advanced Course

About this course

Develop Excel skills through a three-stage learning path from the workbook interface to more demanding analysis. This free Simon Sez IT course includes the complete beginner, intermediate and advanced Excel 365 classes, giving you time to practise each stage before moving to the next.

Course at a glance

What you’ll learn

• Build a foundation for creating, navigating and maintaining Excel workbooks before attempting more complex tasks.
• Progress through the intermediate class with a clearer understanding of how spreadsheet tools support everyday work.
• Follow advanced demonstrations and relate the chosen technique to the structure and purpose of the data.
• Develop a practice routine that includes checking results and explaining how the workbook should be used.

Skills you’ll gain

• Excel 365
• Workbook management
• Spreadsheet calculations
• Data organisation
• Advanced Excel practice
• Workbook review

Course Overview

The course is organised around three extended training classes rather than a collection of unrelated tips. Begin with the four-hour introductory class, continue with the intermediate training and finish with the advanced class. The progression makes it possible to build confidence before taking on more complex work. Use the beginner section to establish reliable navigation and data-entry habits, then use later demonstrations to improve the way you calculate, organise and interpret spreadsheet information. Excel 365 changes over time, so match the instructor’s purpose to the tools available in your installed version.

How to study the course

• Complete the beginner class in manageable sections and reproduce a small example. Confident navigation reduces the friction of learning later techniques.
• Use the intermediate class to improve an existing practice workbook. Keep its data structure clear enough that someone else could understand it.
• Treat the advanced class as a practical extension of the earlier skills. Verify the output and note where a technique depends on the software version.

Use the searchable classroom lesson list to revisit a specific explanation. Pause after a useful demonstration, reproduce a small example and explain the result in your own words. Keep a short note of what worked, what changed and what you still need to understand before moving on.

Who is this for?

The course suits office professionals, students and self-taught Excel users seeking an ordered path. Beginners can start at the opening class, while experienced users can revisit a stage without losing access to the rest of the curriculum.

Before you start

A computer with a suitable Excel 365 installation is useful for practice. Viewing the public videos is free; Microsoft 365 access and any separate provider membership benefits are not included.

Put the lessons into practice

Create a workbook for a small community project using invented tasks, dates and costs. After the beginner class, make the workbook readable and easy to navigate. During the intermediate class, improve how you organise and calculate its information. After the advanced class, add one more demanding analysis that answers a clear question. Check the result against a small manual example and write brief instructions for another user. Keep the earlier version so you can explain what changed and why the change helped.

This optional activity is provided by WikiFree for independent practice. It is not a graded assignment from the instructor. Keep your working notes, check the result against the task you defined and return to the relevant lesson when an assumption or technique is unclear.

Certificate / Assessment

Watching the public videos and using WikiFree progress tracking does not award a certificate, exam voucher, academic credit or instructor assessment.

Use your practice output to review what you can now explain and repeat independently. Completion tracking records your study progress; it does not replace an assessed qualification or professional experience.

Frequently asked questions

Provider: Simon Sez IT. Videos play from the Simon Sez IT channel on YouTube.