Microsoft Excel Data Analysis: Formulas & Pivot Tables

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

Created by: James Nissen
Data Analyst

What Will I 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.

Target audience

• 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