Introduction to Data Analysis & Excel Tools

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Course Content
PART 1: EXCEL FOR DATA ANALYSIS
0/4
Introduction to Data Analysis & Excel Tools
07:46
Overview of the Excel interface
01:53
Key Excel shortcuts
07:58
Importing Data into Excel
08:29
PART 2: FUNCTIONS
0/8
Functions Intro
01:22
Sum, Sumif, Sumifs
08:24
Average, Min, Max
04:60
Count, CountA, CountIF
11:02
IF
04:57
IFS
07:53
IF Error
02:56
IF inside VLOOKUP
04:16
PART 3: FUNCTIONS
0/2
Date and Function Intro
00:27
Day Month Year
01:37
PART4: FUNCTION
0/8
Vlookup pt1
04:00
Vlookup pt 2
03:47
Today & Now
00:45
Text to Date
02:27
Pivot Tables 1
01:10
Pivot Tables 2
08:10
Pivot Tables 3
10:46
Functions Conclusion
01:00
Excel for Data Analytics
Previous
Next