Data Visualization in Excel – Techways

Current Status

Not Enrolled

Price

R500

Get Started

This course is currently closed

Data visualisation with Excel

Course Content

Expand All

Guide To Completing the Course 3 Topics Sample Lesson

Expand

Lesson Content

0% Complete 0/3 Steps

Course Learning Outcome

What is Microsoft Excel?

Excel Navigation 6 Topics Sample Lesson

Expand

Lesson Content

0% Complete 0/6 Steps

EXERCISE: Create a Workbook

EXERCISE: Create/Rename/Delete a sheet

Formula Bar and Name Box

The Fill handle

TASK: Your Workbook

Worksheet Formatting 9 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/9 Steps

Columns/Rows/Cells

EXERCISE: Cell merging and sizing

EXERCISE: Fonts and Colors

EXERCISE: Alignment

EXERCISE: Orientation

EXERCISE: Number Formats

TASK: Entering Data

Operations and Calculations 9 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/9 Steps

EXERCISE: Functions

Count Functions

EXERCISE: Referencing

EXERCISE: Cell/Cell range naming

Conditional formatting

TASK: Calculations

Charts 5 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/5 Steps

EXERCISE: Create Charts

EXERCISE: Combo charts

Tables 6 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/6 Steps

EXERCISE: Tables

EXERCISE: Pivot Table

TASK : Pivot Table

Manage Data 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

EXCERCISE: Import data

EXERCISE: Filtering

EXERCISE: Sorting

TASK: Manage Data