Microsoft Excel Data Analysis: Pivot Tables and Formulas

Name: Microsoft Excel Data Analysis: Pivot Tables and Formulas
Rating: 4.8 (799 reviews)

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

Highest rated

(799 ratings)

10,133 students

Created by James Nissen

Last updated 6/2022

English

English [Auto]

What you'll 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...
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

Requirements

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.

Description

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!

Who this course is for:

Job seekers who want to add "Microsoft Excel" as a skill on their resume or Linkedin Profile
Aspiring Data Analysts, Managers, or employees that anticipate using MORE data in the future
Anyone already in a job/career that involves data who wants to level up their skills in Excel
Anyone who wants to learn how to cut hours off of their weekly reporting tasks
Anyone who wants to learn how to learn excel for budgeting, side projects, or as an additional skill

Featured review

Soji A.

17739 courses

58 reviews

2 years ago

Great course. Instructor was very knowledgeable & clear. However, he is too fast with the clicks and typing. Had to rewind several times to see what was being clicked or typed. Overall, very satisfied.

James Nissen

Data Analyst

4.8 Instructor Rating
799 Reviews
10,133 Students
1 Course

James Nissen is a Data Analyst with experience in the B2B, E-Commerce, and Social Media industries. He specializes in cleaning & organizing messy data sets, advanced text/lookup functions, and data visualization.

He founded Excel Nerds in 2017 to help others accelerate their careers, improve their data analysis skills, and most importantly learn to make Pivot Tables :)