Microsoft Excel Data Analysis: Pivot Tables and Formulas

Microsoft Excel Data Analysis: Pivot Tables and Formulas

This course will teach you to go from level up from beginner to intermediate in Excel in around 2 hours. You'll learn a wide variety of important Excel features, including Pivot Tables, sorting and filtering, keyboard shortcuts, as well as intermediate functions like VLOOKUP, INDEX & MATCH, IF statements, and many more (2016 PC Version used in course).

Sample data sets provided for you to follow along and learn as you watch!

Learn Data Analysis, Formulas, and Pivot Tables. Data Analysis in Microsoft Excel for Beginners and Intermediate users

Url: View Details

What you will learn

• How to create Pivot Tables to quickly summarize data
• How to use VLOOKUP and INDEX/MATCH to pull out specific info from large data sets
• How to use basic math/statistical functions like SUM, AVERAGE, COUNTIFS, and more...

Rating: 4.5

Level: Beginner Level

Duration: 2 hours

Instructor: James Nissen