Digital Productivity
Excel Basics: From First Cell to Confident Workbook
Build practical Excel confidence through guided lessons, videos, quizzes and two workplace-style spreadsheet projects.
By Janine Van Rooi · Beginner · Self-study
A complete beginner course based on the Excel Basics learner guide. Learners tour the modern Excel interface, enter and organise data, manage worksheets, build formulas, use essential functions, format professional workbooks, create charts, prepare worksheets for printing and complete two practical assessments. Designed for self-study or facilitated delivery.
Curriculum
1. Getting Started with Excel
- 🔒 Welcome, outcomes and learning resources
- 🔒 Workbook, worksheet, row, column and cell
- 🔒 Touring the Ribbon and key screen areas
2. Entering, Selecting and Editing Data
- 🔒 Navigation and selecting cells and ranges
- 🔒 Entering text, numbers, dates and time
- 🔒 Edit, clear, move, copy and AutoFill
3. Structuring Workbooks and Worksheets
- 🔒 Rows, columns, widths, heights and AutoFit
- 🔒 Manage worksheet tabs and files
4. Formulas and Cell References
- 🔒 Formula foundations and operators
- 🔒 Relative, absolute and mixed references
- 🔒 Copy formulas and troubleshoot common errors
5. Professional Cell Formatting
- 🔒 Fonts, borders, fills and Format Painter
- 🔒 Number formats and custom formats
- 🔒 Alignment, wrapping, merging and conditional formatting
6. Essential Excel Functions
- 🔒 SUM and AutoSum
- 🔒 AVERAGE, MAX, MIN and COUNT
- 🔒 Function selection and formula quality
7. Charts, Printing and Productivity
- 🔒 Choose and create an effective chart
- 🔒 Edit, move and review charts
- 🔒 Print preview, page setup and productivity shortcuts
8. Practical Assessments and Final Check
- 🔒 Practical assessment 1: weighted grade sheet
- 🔒 Practical assessment 2: Toy Sales chart
- 🔒 Final knowledge assessment and next steps