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
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
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
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
Switch your worksheet orientation to landscape for wide tables or long rows
Add or change headers so your printed worksheets include titles, dates or custom text
Formatting and Printing Worksheets
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
Format names and addresses neatly so they line up correctly in your worksheet
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
Learn how to write simple formulas and use basic functions to calculate values
Change tab names so your workbook is easier to navigate
charts + visuals
Learn the basics of inserting and customizing different types of charts
Manipulating Charts and Graphs
Modify chart elements to make your visuals clearer and more accurate
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 the Sort and Filter Commands
Sort your data and apply filters to quickly find what you need