Data Visualization in Excel (free form) – Techways

Current Status

Not Enrolled

Price

R500

Get Started

This course is currently closed

Data visualisation with Excel

Course Content

Guide To Completing the Course V2 3 Topics Sample Chapter

Chapter Content

0% Complete 0/3 Steps

Course Learning Outcome V2

What is Microsoft Excel? V2

Excel Navigation V2 7 Topics | 1 Quiz Sample Chapter

Chapter Content

0% Complete 0/7 Steps

EXERCISE: Create a Workbook V2

EXERCISE: Create/Rename/Delete a sheet V2

Formula Bar and Name Box V2

The Fill handle V2

Excel Navigation V2

TASK: Your Workbook V2

Worksheet Formatting V2 9 Topics | 1 Quiz

Chapter Content

0% Complete 0/9 Steps

Columns/Rows/Cells V2

EXERCISE: Cell merging and sizing V2

EXERCISE: Fonts and Colors V2

EXERCISE: Alignment V2

EXERCISE: Orientation V2

Number Formats V2

EXERCISE: Number Formats V2

Number formats V2

TASK: Entering Data V2

Operations and Calculations V2 9 Topics | 1 Quiz

Chapter Content

0% Complete 0/9 Steps

EXERCISE: Functions V2

Count Functions V2

EXERCISE: Referencing V2

EXERCISE: Cell/Cell range naming V2

Conditional formatting V2

Functions Quiz V2

TASK: Calculations V2

Charts V2 5 Topics | 1 Quiz

Chapter Content

0% Complete 0/5 Steps

EXERCISE: Create Charts V2

Format charts V2

EXERCISE: Combo charts V2

TASK: Charts V2

Tables V2 6 Topics | 1 Quiz

Chapter Content

0% Complete 0/6 Steps

EXERCISE: Tables V2

EXERCISE: Pivot Table V2

QUIZ: Tables V2

TASK : Pivot Table V2

Manage Data V2 6 Topics

Chapter Content

0% Complete 0/6 Steps

EXCERCISE: Import data V2

EXERCISE: Filtering V2

EXERCISE: Sorting V2

Format views V2

TASK: Manage Data V2