Microsoft Excel Data Analysis: Pivot Tables and Formulas
Description
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
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
Course content
- Welcome!
- The Data Set for this Course
- Foundational Principles
- Functions and Formulas: Part 1
- Functions and Formulas: Part 2
- Functions and Formulas: Part 3
- Pivot Tables: Part 1
- Pivot Tables: Part 2
Price
: 14.99 EUR
Brand
James Nissen
12 reviews for Microsoft Excel Data Analysis: Pivot Tables and Formulas James Nissen, Cheap
There are no reviews yet.