Morewide Academy Home Courses About Us Become a Creator Contact
Data entry

MICROSOFT EXCEL FOR BEGINNERS

A complete, practical beginner course that takes you from your first cell to building a working sales and expense tracker, using real Malawian business examples.

30 lessons Beginner English 12h total Lifetime access
Offered by Ernest Kampira  ·  Last updated November 2026

What You'll Learn

  • Navigate the Excel screen and manage workbooks and worksheets with confidence
  • Enter, edit, copy, fill and format data including Malawi Kwacha amounts and dates
  • Write formulas and use SUM, AVERAGE, IF, COUNTIF, SUMIF, text, date and lookup functions
  • Sort, filter, validate and highlight data using tables and conditional formatting
  • Summarise data with PivotTables and present it with clear charts
  • Print, share and protect workbooks and build a complete monthly sales and expense tracker

Requirements

  • Computer or smartphone with Microsoft Excel (any version from 2016 onwards) or the free Excel for the web
  • Basic ability to use a keyboard and mouse
  • No previous Excel experience needed

About This Course

This course teaches Microsoft Excel from the very beginning, with no previous experience required. Rather than showing features in isolation, each section builds toward practical skills that people use every day in shops, schools, offices, NGOs and savings groups in Malawi: recording sales, tracking stock, preparing budgets, calculating marks and loans, and presenting results clearly.

You will learn the Excel screen, workbooks and worksheets, entering and formatting data (including Malawi Kwacha), formulas and cell references, essential functions such as SUM, AVERAGE, IF, VLOOKUP and XLOOKUP, sorting and filtering, tables, data validation, conditional formatting, PivotTables and charts, then printing, sharing and protecting your work. The course ends with a hands-on project and an end of course exam.

Course Curriculum

7 sections · 30 lessons
Section 1: Getting Started with Microsoft Excel (7 lessons · 65 min )
Section 2: Entering and Formatting Data (4 lessons · 85 min )
Section 3: Formulas and Basic Functions (4 lessons · 95 min )
Section 4: Useful Functions for Everyday Work (4 lessons · 85 min )
Section 5: Organising and Analysing Data (6 lessons · 100 min )
Section 6: Charts, Printing and Real-World Projects (4 lessons · 110 min )
End of Course Exam (1 lesson · 30 min )

About the Instructor

E

Ernest Kampira

Course Instructor · Morewide Academy

5 courses 28 students Malawi
MICROSOFT EXCEL FOR BEGINNERS
K10,000

Lifetime access on enrollment

Sign Up to Enroll Already have an account? Sign In

Free to enroll · No credit card needed

This course includes:
  • On-demand video lessons
  • Downloadable templates & resources
  • Lifetime access
  • Access on mobile & desktop
  • Certificate of completion
  • Community access