Microsoft Excel Data Analysis: Pivot Tables and Formulas

Online Course

Udemy

Go to Udemy

Start Learning

What is the course about?
Prerequisites & Facts
Cost, Certificate & Degree
Reviews & Experiences

What is the course about?

Microsoft Excel Data Analysis: Pivot Tables and Formulas

The course Microsoft Excel Data Analysis: Pivot Tables and Formulas is an online class provided by Udemy. It may be possible to receive a verified certification or use the course to prepare for a degree.

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

Course description

Microsoft Excel Data Analysis: Pivot Tables and Formulas

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

Microsoft Excel for PC (2013 or later recommended. Some features may not be available in earlier versions)
Some prior knowledge of Excel will be helpful.

2 hours on-demand video
1 article
16 downloadable resources
Full lifetime access
Access on mobile and TV
Certificate of Completion
James Nissen

Start Learning

Prerequisites & Facts

Microsoft Excel Data Analysis: Pivot Tables and Formulas

Course Topic

Business, Data Analytics, Excel

University, College, Institution

Udemy

Course Skill Level

see course summary

Course Language

English

Place of class

Online, self-paced (see curriculum for more information)

Degree

Certificate

Start Learning

Degree & Cost

Microsoft Excel Data Analysis: Pivot Tables and Formulas

To obtain a verified certificate from Udemy you have to finish this course or the latest version of it, if there is a new edition. The class may be free of charge, but there could be some cost to receive a verified certificate or to access the learning materials. The specifics of the course may have been changed, please consult the provider to get the latest quotes and news.

Udemy

Microsoft Excel Data Analysis: Pivot Tables and Formulas

provided by Udemy

Start Learning