Watch our
FREE Online Excel Training Course for Absolute Beginners.

Learn Excel from Scratch by Building Eight  Practical Spreadsheets for UK Office World.

Beginners Excel Course.  If you’re completely new to Microsoft Excel, or you’ve used Excel a little before this free beginners Excel tutorial is designed for you.

Introductory Excel Training Course.

Rather than learning Excel through a long list of commands and formulas in Excel basics for beginners  you’ll learn by actually building eight practical spreadsheets from scratch. Throughout the course, we build practical Excel spreadsheets for the UK office world , introducing new skills step by step  and then using those skills again in realistic real life  work examples .

So at the end, you will get one of the most useful workplace skills you can have — but ALSO maybe , you will have  changed the way you see and understand Excel.( maybe even love it)

For the first 20 minutes, we’ll learn the practical fundamentals. Enough so we can start building the spreadsheets.

BUT  and here is the KEY POINT most Excel training videos miss. 

Excel uses the same functions & techniques over and over again but it also use the Same Spreadsheet Types over and over again. The spreadsheet types are as UNIVERSAL as the Main functions.

The industry changes.The headings change. The data changes. But underneath, both the Excel and the spreadsheets are remarkably similar. Knowledge of them help unlock Excel and your proficiency with it.

And that’s what we’re going to unlock. We don’t just want you to learn a SUM or an IF function, we also want you to recognise the spreadsheet type in front of you.

To look at it and think: “I know what this is trying to do.”

Then: “I can see how Excel is doing it.”

And eventually: “I could build this myself.”

That’s when Excel stops being difficult but interesting. You begin to read Excel. You understand the patterns. And any fear of Excel is replaced by something completely different — the feeling that you understand it and you’re in control of it. That’s a powerful skill to take into any workplace.

Learn Excel fundamentals:

We start with the absolute basics and then we gradually introduce more powerful Excel functions and techniques as they’re needed.

During the course you’ll learn how to:

• Enter, edit, copy, move and format Excel data

Excel formulas for beginners:

• Use essential functions including SUM, AVERAGE, MIN and MAX
• Understand relative and absolute cell references
• Create and work with Excel Tables
• Use IF to make decisions
• Use COUNTIF and SUMIF to analyse information
• Work with dates, TODAY and time calculations
• Apply Conditional Formatting
• Link information between worksheets
• Understand how Microsoft Copilot and AI can help you work with Excel

Examples use UK date settings.

Learn how to Build  and Adapt  Practical Universal Excel Spreadsheets..

 

Expense Tracker :       “Number / transaction tracker” — record and summarise amounts.
Sales Database: –        “Transaction database” — record many events and analyse them.
Inventory Tracker: –  “Stock /quantity tracker” What we have, what changed, what needs action.
Jobs & Tasks:              ” Status / workflow tracker” — what needs doing, by whom, by when.
Job Cost & Price: –      “Calculator / model”— inputs go in, calculated answer comes out.
Invoice & Payments: –“Balances tracker”-What should happen versus what has happened.
Timesheet: –                 “Time-based record” — dates, times, durations and values.

Free Online Excel Training for Beginners ..

Practical Excel Skills for Work, Business and Everyday Life..

 

Individual spreadsheet may change, but the underlying Excel skills are often exactly the same.That’s why learning those skills through different practical examples is so useful.

Learn Excel by Actually Using Excel.

The idea behind this beginner Excel course is simple. You don’t learn Excel just by watching someone explain what the buttons do. You learn by using Excel to solve problems. As the course progresses, you’ll see individual Excel features begin to work together:
You’ll also regularly change information in the spreadsheets and see how the calculations, results, warnings and summaries respond. That’s an important part of understanding the real power of Excel.
By the end of the course, you won’t simply have watched an Excel tutorial.You’ll have seen how to build practical spreadsheets and understand the Excel skills that make them work.

Want to Take Your Excel Skills Further?

This free course gives you a strong foundation in practical Excel.    Free beginner Excel certificate:

When you’re ready to progress further, Online Excel Training provides structured online Excel courses covering beginner through to more advanced skills, including formulas and functions, PivotTables, data analysis, advanced Excel and using Excel with AI.
The free course is your starting point.Then you can continue developing the Excel skills you need for work, business and the AI era.

OnlineExcelTraining.co.uk  — Excel Training for the AI Era in the UK.