Microsoft Excel Data Analysis: Formulas & Pivot Tables

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

• Creating Named Ranges

• Using dates in Excel like a pro

• Handling errors

• Intermediate functions like VLOOKUP, COUNTIF, INDEX & MATCH, Nested 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!

See why people love this course on Udemy:

“This course in particular gave me an indept knowledge of simple tools that can be used by a typical data analyst. It is a really good course to improve your skills and usage of spreadsheets.”

-Oladipupo J.

“This is a great course! I have learned alot of information so far. It is taking me longer to pick up, as I am a beginner, but since we are able to reverse, I am still learning so much!”

-Katrina C.

“It was a great experience, being a first-timer. First, i thought the course would be a tough one. But the way the course is designed and explained is amazing! Worth it!”

-Subhajit S.

NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Lectures should be compatible with Excel 2007- 2016.