BeginnerFree
Excel Essentials
Excel appears in more African job adverts than any other software. This course takes you from a blank sheet to confident daily use: entering data properly, writing formulas that do not break, using lookups, and building a clean summary report you can hand to a manager.
2h 30m 11 lessons 4.8 15k learners
Course content
Module 1: Getting Comfortable
Cells, sheets and clean data entry
- The Grid: Cells, Rows and Columns6 min
- Entering Data the Right Way7 min
- Formatting Without Ruining Your Data6 min
Module 2: Formulas That Do the Work
From SUM to logical tests
- Your First Formulas7 min
- Copying Formulas and Absolute References7 min
- Making Decisions with IF7 min
Module 3: Finding and Summarising Data
Lookups and pivot tables
- VLOOKUP and XLOOKUP8 min
- Sorting, Filtering and Cleaning7 min
- Pivot Tables in Ten Minutes8 min
Module 4: Presenting Your Numbers
Charts, printing and sharing
- Charts That Communicate6 min
- Printing, Sharing and Next Steps6 min