Bang Ti Lenydoor

Microsoft Excel Essentials

Categories: Digital Skills, Technology
Wishlist Share

About Course

Microsoft Excel is one of the most valuable skills for study, work, and managing everyday data — from budgets to grade trackers. This course teaches Excel from the ground up: entering and organising data, using formulas and functions, and creating charts to present information clearly.

No prior spreadsheet experience is required. By the end, you will be able to build and use simple, functional spreadsheets confidently.

The first four weeks build the fundamentals; the applied modules that follow, advanced formulas, larger datasets, and real-world spreadsheet projects, are self-paced and typically carry most learners into their second and third month.

What Will You Learn?

  • Enter, organise, and format data in Excel confidently
  • Use formulas and common functions like SUM and AVERAGE
  • Sort and filter data to find what you need quickly
  • Create simple charts to visually present data
  • Build practical spreadsheets for budgets, schedules, and trackers

Course Content

Week 1: Getting Started with Excel
This week covers the Excel interface, entering data, and saving your work. Estimated time: 60-75 minutes.

  • Understanding the Excel Grid
    00:00
  • Entering and Editing Data
  • Workbooks, Worksheets, and Saving
  • Week 1 Knowledge Check: Getting Started
  • Week 1 Assignment: Your First Workbook

Week 2: Formulas and Functions
This week covers writing formulas, using common functions, and understanding cell references. Estimated time: 75-90 minutes.

Week 3: Formatting and Organising Data
This week covers formatting cells, sorting, and filtering data. Estimated time: 60-75 minutes.

Week 4: Charts and Practical Use
This week covers creating charts, printing, and exporting your work. Estimated time: 60-75 minutes.

Advanced Formulas and Lookups
This week covers looking up data across a spreadsheet and using conditional logic in formulas. Estimated time: 60-75 minutes.

Working with Larger Datasets
This week covers sorting, filtering, validating, and summarising larger amounts of data. Estimated time: 60-75 minutes.

Real-World Spreadsheet Projects
This week applies everything so far to spreadsheets you will actually use. Estimated time: 60-75 minutes.

Scroll to Top