Excel tutorials

Learn essential Microsoft Excel skills through clear, simple tutorials designed to help you organize data, build spreadsheets, and work more confidently with numbers.

Excel basics

• Excel Basics Part 1 – Understanding the Excel Interface, Worksheets + Cells

  • Learn the difference between workbook sand worksheets, how cells are organized, how to navigate a sheet and what the name box and formula bar do

• Excel Basics Part 2 – How Excel Displays Text, Numbers + Formatting

  • Understand how what you see isn’t always what you get, use Wrap Text, resize rows and columns, control alignment and indentation and choose number formats

• Excel Basics Part 3 – Formatting Worksheets, Borders + Visual Tools

  • Learn how to merge and centre cells, preview printed pages, apply borders, use styles, apply conditional formatting, insert rows or columns and freeze panes

page setup + printing

• How to Print in Landscape

  • Switch your worksheet orientation to landscape for wide tables or long rows

• How to Edit Page Headers

  • Add or change headers so your printed worksheets include titles, dates or custom text

• Formatting and Printing Worksheets in Excel – Page Setup, Tabs + Print Areas

  • Learn the key settings that make printed spreadsheets clean and professional

formatting data

• Format Numbers as Currency or Accounting

  • Apply currency and accounting formats to make financial data clear and readable

• Formatting Addresses in Excel Worksheets – Line Breaks Inside a Cell

  • Format names and addresses neatly so they line up correctly in your worksheet

• Add Borders

  • Add borders to cells or ranges to organize data visually

formulas + data entry

• How to Use AutoSum and AutoFill

  • Quickly add up numbers and fill repeating patterns using Excel’s smart tools

• Introduction to Formulas and Functions in Excel – How Calculations Actually Work

  • Learn how to write simple formulas and use basic functions to calculate values

• Rename Worksheet Tabs

  • Change tab names so your workbook is easier to navigate

charts + visuals

• Creating Charts and Graphs in Excel – Visualize Your Data the Right Way

  • Learn the basics of inserting and customizing different types of charts

• Manipulating Charts and Graphs in Excel – Make Your Data Easier to Read

  • Modify chart elements to make your visuals clearer and more accurate

• How to Insert a Line Chart

  • Create a simple line chart to show trends in your data

• Format Lines in an Excel Line Chart

  • Adjust the style, thickness and colour of lines in your charts

Sorting, Filtering + data tools

• Using Sort + Filter in Excel – Show the Right Data Without Losing Anything

  • Sort your data and apply filters to quickly find what you need