Microsoft Excel for Beginners: Learn Excel Step by Step

Categories: Digital Skills
Wishlist Share

About Course

Learn Microsoft Excel from scratch with simple, step-by-step lessons designed for complete beginners. Learn how to create spreadsheets, enter and format information, use formulas and common functions, organise data, sort and filter lists, create tables and charts, and build practical worksheets.

Through hands-on examples and real-world activities, you will practise using Excel for budgets, task tracking, student records, sales, and other everyday tasks.

No previous Excel experience is required.

What Will You Learn?

  • Understand the Excel interface and basic spreadsheet concepts
  • Create, save, and organise Excel workbooks and worksheets
  • Understand rows, columns, cells, and ranges
  • Enter, edit, and organise information
  • Format text, numbers, dates, currency, and percentages
  • Adjust column widths and row heights
  • Use borders, alignment, and basic formatting
  • Create basic Excel formulas
  • Perform addition, subtraction, multiplication, and division
  • Use common functions such as SUM, AVERAGE, MIN, MAX, and COUNT
  • Sort and filter data
  • Create and use Excel tables
  • Identify and fix common data-entry problems
  • Understand relative and absolute cell references
  • Create simple charts
  • Choose an appropriate chart for basic data
  • Prepare spreadsheets for printing and sharing
  • Build practical spreadsheets independently

Course Content

Module 1 – Getting Started with Excel
Purpose: Understand the Excel interface and basic spreadsheet concepts.

  • Lesson 1: What Is Microsoft Excel?
  • Quick Check
  • Lesson 2: Understanding Workbooks and Worksheets
  • Quick Check
  • Lesson 3: Rows, Columns, Cells, and Ranges
  • Quick Check
  • Lesson 4: Entering and Editing Data
  • Quick Check
  • Module 1 Review
  • Module 1 Quiz

Module 2 – Formatting and Organising Your Spreadsheet
Purpose: Make spreadsheets easier to read and use.

Module 3 – Excel Formulas and Functions
Purpose: Learn how Excel performs calculations.

Module 4 – Working with Data
Purpose: Learn how to organise and find information.

Module 5 – Cell References, Charts, and Useful Features

Module 6 – Real-World Excel Practice

Final Course Assessment

FINAL PROJECT

COURSE COMPLETION

Student Ratings & Reviews

No Review Yet
No Review Yet