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
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
