MS Excel for Non-Techies

Right course for:-

Course Curriculum

Excel Charts (Graphs)

Available in days

days after you enroll

Creating a new chart (Graph) (1:07)
Adding titles in graph (2:00)
Understand the use of legend in graph (2:01)
Make your graph more useful with data labels (2:01)
Rescaling the Y- axis (2:51)
Formatting the chart (Colors, Background, etc.) (7:53)

Conditional Formatting

Available in days

days after you enroll

The basics of Conditional Formatting (2:02)
Practice on Conditional Formatting with few Examples (4:11)
Removing (Clearing) the Conditional Formatting (1:22)
Removing only one rule of Conditional Formatting (3:13)
Copy Conditional Formatting (2:29)
Highlight the highest and lowest values with Conditional Formatting (2:13)
Finding duplicate values (or unique values) with Conditional Formatting (1:37)
Higlighting a whole row based upon a cell value (4:25)

Pivot Table

Available in days

days after you enroll

Get familiar with Pivot Table Environment (1:41)
First simple steps with pivot tables (7:34)
Magic of Pivot Table features (2:19)
Getting advanced: Intersecting More Than One Field (1:41)
Improving the Appearance of the pivot table, Making it More Comprehensive (2:34)

Prevent Wrong Data from Entering

Available in days

days after you enroll