Microsoft Excel

Microsoft Excel is a practical, hands-on course designed to introduce learners to the fundamentals of spreadsheet creation, data management, and basic data analysis using Microsoft Excel. Whether you are a complete beginner or looking to improve your computer skills, this course will help you build confidence in using one of the world's most popular productivity applications.

What you will learn:

  • Navigate Excel and enter data across workbooks and worksheets

  • Format cells with number styles, dates, currencies and borders

  • Write formulas using relative and absolute cell references

  • Use essential functions: SUM, AVERAGE, IF, COUNT, VLOOKUP and more

  • Create charts and graphs to visualise your data clearly

  • Organise data with Tables, Sort and Filter tools

  • Summarise large datasets instantly using Pivot Tables and Slicers

Course curriculum

    1. Welcome to Microsoft Excel Foundations

    2. Setting Expectations: What We'll Cover

    3. Who This Course Is For & What You'll Need

    4. What You'll Be Able to Do

    5. How to Succeed & Get Help

    1. Introduction

    2. Workbooks, Worksheets & Cells

    3. Tour of the Excel Window

    4. Getting to Know the Ribbon

    5. Navigation Shortcuts

    6. Structuring Data the Right Way

    7. Creating Excel Tables

    8. Understanding Data Types

    9. Why Dates Are Really Numbers

    10. Fixing Data Type Problems

    11. Number Formats

    12. The Format Cells Dialog

    13. Formatting for Readability

    14. Conditional Formatting

    15. Sorting Data

    16. Filtering Data

    17. Chapter Recap

    18. Excel Fundamentals Quiz

    19. Excel Fundamentals Assignment

    1. Introduction & Section Overview

    2. Anatomy of a Formula

    3. Operators & Order of Operations

    4. Entering & Copying Formulas

    5. Relative, Absolute & Mixed References

    6. Absolute References in Action

    7. Structured References in Tables

    8. Understanding Formula Errors

    9. Finding & Fixing Errors with IFERROR

    10. SUM, AVERAGE, MIN, MAX & COUNT

    11. COUNTIFS, SUMIFS & AVERAGEIFS

    12. Making Decisions with IF

    13. AND, OR & IFS

    14. Cleaning & Reshaping Text

    15. Working with Dates

    16. Joining Data Across Tables

    17. VLOOKUP

    18. XLOOKUP

    19. Chapter Recap

    20. Formulas & Functions Quiz

    21. Formulas & Functions Assignment

    1. Introduction & Section Overview

    2. What Is a PivotTable?

    3. Preparing Your Data

    4. Creating Your First PivotTable

    5. The PivotTable Fields Pane

    6. Building a Cross-Tab with Rows & Columns

    7. Changing the Calculation

    8. Show Values As

    9. Sorting & Filtering PivotTables

    10. Slicers & Timelines

    11. Grouping Dates & Numbers

    12. Calculated Fields

    13. Refreshing & Updating the Source Data

    14. Layout & Design Options

    15. Common PivotTable Pitfalls

    16. Chapter Recap

    17. PivotTables Quiz

    18. PivotTables Assignment

    1. Introduction & Section Overview

    2. Why Visualize Data?

    3. Five Design Principles

    4. Choosing the Right Chart

    5. Inserting & Editing Charts

    6. Bar & Column Charts

    7. Line Charts

    8. Pie & Donut Charts

    9. Scatter Plots

    10. Histograms

    11. Filled Maps & Sparklines

    12. Decluttering Your Charts

    13. Telling a Story with Data

    14. Common Chart Mistakes

    15. Chapter Recap

    16. Data Visualization & Storytelling Quiz

    17. Data Visualization & Storytelling Assignment

    1. Introduction & Section Overview

    2. What AI Can and Can't Do

    3. Your AI Options: Copilot, Claude & AI Chat

    4. Getting Started with Copilot in Excel

    5. Getting Started with Claude for Excel

    6. Writing Prompts That Work

    7. Writing & Explaining Formulas with AI

    8. Cleaning, Analysing & Summarising Data with AI

    9. Building Charts with AI

    10. Debugging Errors with AI

    11. Always Verify AI Results

    12. Data Privacy & Safety

    13. Chapter Recap

    14. Using AI with Excel

About this course

  • £120.00
  • 95 lessons
  • 10.5 hours of video content

Discover your potential, starting today

Enroll today