Video Tutorial: Excel Modules 5 & 6

Two modules in one video. Work through them in order.

Quick Answer

What Do Excel Modules 5 and 6 Cover?

Excel Modules 5 and 6 explain how to format financial spreadsheets clearly and organise large sets of data efficiently. They cover number and currency formatting, consistent presentation, Excel tables, multi-column sorting and customised filters. These skills make financial information easier to read, analyse and present professionally.

Module 5: Clean Formatting for Finance Module 6: Tables, Sorting and Filters
Excel Modules 5 & 6: Complete
Module 5

Clean Formatting for Finance

  • Number and currency formatting
  • Consistent fonts, colours, and spacing
  • Making spreadsheets readable at a glance
  • Professional presentation standards
Module 6

Tables, Sorting and Filters

  • Converting data ranges into tables
  • Sorting data by one or multiple columns
  • Applying and customising filters
  • Using tables to organise financial data

💡 Tips for This Video

  • Have Excel open and follow along as you watch
  • Pause after each concept and try it yourself before moving on
  • In Module 6, practise sorting and filtering a dataset of your own
AI Robot

Ask Our AI Stock
Learning Assistant

Get instant educational answers about
stocks, investing, and StockEducation.com.

Instant Answers Built With Learners

Educational support only. Not personal financial advice. AI responses may contain errors.

Powered by AI ●

The Ultimate Investing Starter Guide

Free Stock Market
Investing Guide

A beginner friendly guide that covers the essential lessons and concepts every new investor should understand.

Subscription Form

Inside You'll Learn

Stocks & How They Work
Valuation Basics
Compound Interest
Index Funds & Diversification
Warren Buffett Principles
AI Stock Research & More
20+ Pages
of Value
Instant
Download
100% Free
No Strings