Excel tutorials

Learn essential Microsoft Excel skills for beginners through clear, simple tutorials. These step-by-step lessons explain how to organize spreadsheet data, format worksheets, create charts, use formulas, sort information and print Excel documents.

Excel basics

Learn the core parts of Microsoft Excel before working with real data. These tutorials explain the Excel interface, worksheets, cells, and basic formatting so you can understand how spreadsheets are organized and how to navigate them confidently.

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

  • Learn how the Excel interface works, including the difference between workbooks and worksheets, how cells are organized, how to navigate a worksheet and what the name box and formula bar do.

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

  • Understand why what you see in Excel isn’t always what you get. Learn how to use wrap text, resize rows and columns, control alignment and indentation and apply number formatting.

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

  • Learn how to merge and centre cells, apply borders and styles, use conditional formatting, insert rows or columns and freeze panes to organize worksheet data more clearly.

page setup + printing

Learn how to prepare Excel worksheets for printing. These tutorials show how to adjust page orientation, add headers, define print areas, and control page layout so your spreadsheets print cleanly and professionally.

• 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

Formatting makes spreadsheet data easier to read and understand. These tutorials show how to apply number formats, organize information visually with borders, and format text inside cells so worksheets look clean and professional.

• 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

Excel becomes powerful when you start entering data and performing calculations. These tutorials introduce formulas, functions, and Excel tools like AutoSum and AutoFill so you can calculate values, fill patterns quickly, and manage worksheet tabs more efficiently.

• 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

Charts help turn spreadsheet numbers into clear visual information. These tutorials show how to create charts and graphs in Excel, adjust chart elements, and format visuals so trends and patterns in your data are easier to understand.

• 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

Sorting and filtering tools help you find and organize information inside large spreadsheets. These tutorials show how to sort data, apply filters, and quickly display the rows that matter without changing the structure of your worksheet.

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

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