Course Content
Module 1: Basic Excel Functions To Analyze Large Data
0/18
Meet Your Instructor
01:07
Introduction to this course
03:45
Download the Excel spreadsheet for this module
00:00
Let us look at the data for this illustration
02:56
Extraction of data: understanding the SUMIF function
08:14
Extraction of data: calculating growth rates
03:58
Extraction of data: understanding the VLOOKUP function
11:41
Extraction of data: understanding the HLOOKUP function
09:31
Extraction of data: understanding the INDEX and MATCH function
13:56
Extraction of data: understanding the IF, COUNTIF and COUNTIFS function
09:10
Presentation of data: understanding the LINE chart
12:34
Presentation of data: understanding the PIE chart
11:45
Presentation of data: understanding the COLUMN chart
13:04
Presentation of data: understanding the STACKED COLUMN chart
10:57
Presentation of data: understanding the CONDITIONAL FORMATTING function
06:58
Practice Assignment #1 – Difficulty level: MEDIUM
00:00
Solution to Practice Assignment #1
00:00
Recap
01:03
Go to Course Home
Introduction to this course
Complete Lesson
Pause
Play
% buffered
00:00
00:00
Unmute
Mute
Disable captions
Enable captions
Settings
Captions
Disabled
Quality
0
Speed
Normal
Captions
Go back to previous menu
Quality
Go back to previous menu
Speed
Go back to previous menu
0.5×
0.75×
Normal
1.25×
1.5×
1.75×
2×
4×
PIP
Exit fullscreen
Enter fullscreen
Play
No Attachment Found
← Previous
Next →
0%
Complete
Complete Lesson
Insert/edit link
Close
Enter the destination URL
URL
Link Text
Open link in a new tab
Or link to existing content
Search
No search term specified. Showing recent items.
Search or use up and down arrow keys to select an item.
Cancel
Notifications
