Current Status
Not Enrolled
Price
R500
Get Started
This course is currently closed
Data visualisation with Excel
Start Course
Course Content
Expand All
Guide To Completing the Course
3 Topics
Sample Chapter
Expand
Chapter Content
0% Complete
0/3 Steps
The Plot
Course Learning Outcomes
What is Microsoft Excel?
Excel Navigation
6 Topics
Sample Chapter
Expand
Chapter Content
0% Complete
0/6 Steps
EXERCISE: Create a Workbook
EXERCISE: Create/Rename/Delete a sheet
The Ribbon
Formula Bar and Name Box
The Fill handle
TASK: Your Workbook
Worksheet Formatting
9 Topics
|
1 Quiz
Expand
Chapter Content
0% Complete
0/9 Steps
Columns/Rows/Cells
EXERCISE: Cell merging and sizing
EXERCISE: Fonts and Colors
EXERCISE: Alignment
EXERCISE: Orientation
Number Formats
EXERCISE: Number Formats
TASK: Entering Data
QUIZ 2
Number formats
Operations and Calculations
9 Topics
|
1 Quiz
Expand
Chapter Content
0% Complete
0/9 Steps
Formulas
Functions
EXERCISE: Functions
Count Functions
EXERCISE: Referencing
EXERCISE: Cell/Cell range naming
Conditional formatting
TASK: Calculations
Lesson Quiz
Functions Quiz
Charts
5 Topics
|
1 Quiz
Expand
Chapter Content
0% Complete
0/5 Steps
EXERCISE: Create Charts
Format charts
EXERCISE: Combo charts
TASK: Charts
Charts Quiz
Charts Quiz
Tables
6 Topics
|
1 Quiz
Expand
Chapter Content
0% Complete
0/6 Steps
Tables
EXERCISE: Tables
Pivot Table
EXERCISE: Pivot Table
TASK : Pivot Table
Tables Quiz
QUIZ: Tables
Manage Data
6 Topics
Expand
Chapter Content
0% Complete
0/6 Steps
EXCERCISE: Import data
EXERCISE: Filtering
EXERCISE: Sorting
Format views
Printing
TASK: Manage Data
Recap
Login
Accessing this course requires a login. Please enter your credentials below!
Username or Email Address
Password
Remember Me
Lost Your Password?