Autoplay
Autocomplete
Previous Lesson
Complete and Continue
MS Excel for Non-Techies
Excel Charts (Graphs)
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
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
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
Make it easy for people to fill data - Create your own drop down lists (6:02)
Teach online with
Finding duplicate values (or unique values) with Conditional Formatting
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock