Home > Courses > Microsoft Excel Data Analysis: Pivot Tables and Formulas
   4.3  694 reviews on Udemy

Microsoft Excel Data Analysis: Pivot Tables and Formulas

Learn Data Analysis, Formulas, and Pivot Tables. Data Analysis in Microsoft Excel for Beginners and Intermediate users
Course from Udemy
 9846 students enrolled
 en
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...
How to build conditional statements using the IF() function
How to organize data to be scalable and easily used other data analysts
How to move around Excel quickly and efficiently
How to sort and filter data based on specific criteria
How to streamline your data analysis workflow in Excel

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!

Microsoft Excel Data Analysis: Pivot Tables and Formulas
$ 19.99
per course
Also check at

FAQs About "Microsoft Excel Data Analysis: Pivot Tables and Formulas"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

CONTACT

[email protected]

SOCIAL NETWORK

Copyright © Elektev
Privacy Policy