This course teaches excel basics to intermediate skills, covering navigation, formulas, functions, and data management.
This course contains the use of artificial intelligence.
What you’ll learn
- Confidently navigate Microsoft Excel and understand how worksheets, cells, rows, and columns work together..
- Use essential keyboard shortcuts to work faster and more efficiently..
- Enter, organise, and format data in a clear and professional way..
- Use formulas and operators to perform accurate calculations..
- Apply core functions to analyse data..
- Use logical functions like IF to automate decisions within your spreadsheets..
- Identify and fix common formula errors with confidence..
- Build structured spreadsheets that are easy to understand and maintain..
Course Content
- Introduction –> 1 lecture • 1min.
- Enabling Macros (The Interactive Workbook) –> 1 lecture • 1min.
- Section 1 –> 9 lectures • 1hr 39min.
- Section 2 –> 8 lectures • 1hr 48min.
Requirements
This course contains the use of artificial intelligence.
This Excel Mini Course is designed to take you from the basics to an intermediate level with clear, practical lessons that build your confidence and understanding step by step. You will begin by exploring Excel’s interface, learning how to navigate the ribbon, quick access toolbar, formula bar, and status bar. You will also discover useful keyboard shortcuts that help you work faster and more efficiently, giving you a strong foundation before moving on to more advanced features.
As you progress through the course, you will learn how to enter, organise, and format data effectively. This includes understanding cells, rows, and columns, applying different formatting options to make your spreadsheets clear and professional, and using autofill to save time. You will then explore formulas and functions, including sums, averages, logical tests, counts, and text functions. These tools will allow you to perform calculations, analyse information, and manipulate datasets to gain meaningful insights from your data.
Each lesson includes practical examples and exercises so you can practise as you learn, reinforcing your understanding and building confidence. By the end of the course, you will have the skills to create, manage, and analyse spreadsheets confidently in Microsoft Excel. You will be able to handle real-world tasks, make data-driven decisions, and use Excel efficiently for personal, academic, or professional projects.