Course Content WordPress Logo
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

No Attachment Found
No Attachment Found
← Previous Next →
0% Complete