The following topics 1 to 4 will be covered across the two sessions of this course:
🟢 1. Getting Started
What Excel is and what it’s used for
Understanding the interface (ribbon, tabs, worksheet, cells)
Opening, saving, and creating workbooks
Basic navigation (rows, columns, cell addresses)
🟢 2. Entering and Editing Data
Typing text, numbers, and dates
Editing cell content
Copying and pasting
Using Autofill and Flash Fill
🟢 3. Basic Formatting
Formatting text
Cell formatting
Number formats (currency, percentage, dates)
Adjusting column width and row height
🟢 4. Basic Formulas and Functions
What formulas are and how they work
Simple calculations (+, −, ×, ÷)
Using common functions:
SUM
AVERAGE
COUNT
Understanding cell references (relative vs absolute)
These further topics below may be covered, depending upon the requirements of those taking the course:
🟢 5. Working with Data
Sorting data (A–Z, smallest–largest)
Filtering data
Creating simple tables
Removing duplicates
🟢 6. Charts (Graphs) and Visuals
Creating basic charts (column, line, pie)
Choosing the right chart type
Customizing charts (titles, labels, colors)
🟢 7. Page Layout and Printing
Page setup and margins
Print preview
Printing worksheets properly
🟢 8. Basic Data Analysis Tools
Conditional formatting (highlighting values)
Using simple data validation (drop-down lists)
🟢 9. Productivity Tips
Keyboard shortcuts (copy, paste, undo)
Freezing panes
Hiding/unhiding rows and columns
🟢 10. Real-World Practice
Creating a simple budget spreadsheet
Tracking expenses
Basic data entry project