Introduction to Data Analysis & Excel Tools - Syno

Introduction to Data Analysis & Excel Tools - Syno

About WordPress
Log In
Register

Search

Excel for Data Analytics Introduction to Data Analysis & Excel Tools

Excel for Data Analytics

0% Completed

PART 1: EXCEL FOR DATA ANALYSIS

Introduction to Data Analysis & Excel Tools

Video - 7:47 mins

Overview of the Excel interface

Video - 1:52 mins

Key Excel shortcuts

Video - 2:17 mins

Importing Data into Excel

Video - 8:29 mins

PART 2: FUNCTIONS (Calculations Formula and Conditions)

Functions Intro

Video - 1:22 mins

Sum, Sumif, Sumifs

Video - 00:08:24 mins

Average, Min, Max

Video - 00:04:60 mins

Count, CountA, CountIF

Video - 00:11:02 mins

Video - 00:04:057 mins

Video - 00:07:053 mins

Video - 00:02:056 mins

IF inside VLOOKUP

Video - 00:04:016 mins

PART 3: FUNCTIONS (Date and Time)

Date and Function Intro

Video - 0:28 mins

Video - 00:01:037 mins

PART4: FUNCTION (Vlookup and Pivot Tables)

Video - 4:01 mins

Video - 00:03:047 mins

Video - 00:00:045 mins

Video - 00:02:027 mins

Video - 00:01:10 mins

Video - 00:08:10 mins

Video - 10:46 mins

Functions Conclusion

Video - 1:01 mins

Announcements Reviews Live Classes Gradebook Certificate Course Info

Sign inSign up

Sign in

Don’t have an account? Sign up

Remember meLost your password?

Sign up

Already have an account? Sign in