Microsoft Excel Data Analysis: Formulas & Pivot Tables

Microsoft Excel Data Analysis: Formulas & Pivot Tables, available at $79.99, has an average rating of 4.4, with 58 lectures, 13 quizzes, based on 983 reviews, and has 10630 subscribers.

You will learn about 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 is ideal for individuals who are Job seekers who want to add "Microsoft Excel" as a skill on their resume or Linkedin Profile or Aspiring Data Analysts, Managers, or employees that anticipate using MORE data in the future or Anyone already in a job/career that involves data who wants to level up their skills in Excel or Anyone who wants to learn how to cut hours off of their weekly reporting tasks or Anyone who wants to learn how to learn excel for budgeting, side projects, or as an additional skill It is particularly useful for Job seekers who want to add "Microsoft Excel" as a skill on their resume or Linkedin Profile or Aspiring Data Analysts, Managers, or employees that anticipate using MORE data in the future or Anyone already in a job/career that involves data who wants to level up their skills in Excel or Anyone who wants to learn how to cut hours off of their weekly reporting tasks or Anyone who wants to learn how to learn excel for budgeting, side projects, or as an additional skill.

Enroll now: Microsoft Excel Data Analysis: Formulas & Pivot Tables

Summary

Title: Microsoft Excel Data Analysis: Formulas & Pivot Tables

Price: $79.99

Average Rating: 4.4

Number of Lectures: 58

Number of Quizzes: 13

Number of Published Lectures: 58

Number of Published Quizzes: 13

Number of Curriculum Items: 71

Number of Published Curriculum Objects: 71

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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
Creating Named Ranges
Using dates in Excel like a pro
Handling errors
Intermediate functions like VLOOKUP, COUNTIF, INDEX & MATCH, Nested 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!

See why people love this course on Udemy:

“This course in particular gave me an indept knowledge of simple tools that can be used by a typical data analyst. It is a really good course to improve your skills and usage of spreadsheets.”

-Oladipupo J.

“This is a great course! I have learned alot of information so far. It is taking me longer to pick up, as I am a beginner, but since we are able to reverse, I am still learning so much!”

-Katrina C.

“It was a great experience, being a first-timer. First, i thought the course would be a tough one. But the way the course is designed and explained is amazing! Worth it!”

-Subhajit S.

NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Lectures should be compatible with Excel 2007- 2016.

Course Curriculum

Chapter 1: Welcome!

Lecture 1: Welcome to this Data Analysis Course!

Chapter 2: The Data Set for this Course

Lecture 1: Download the Powerpoint file for this Course (Optional)

Lecture 2: Understanding our Data Set – Part 1

Lecture 3: Metrics and Dimensions

Lecture 4: Understanding our Data Set – Part 2

Chapter 3: Foundational Principles

Lecture 1: Foundations Lesson #1 – Sorting Data

Lecture 2: Foundations Lesson #2 – Filtering Data

Lecture 3: Foundations Lesson #3 – Autofilling Patterns and Formulas

Lecture 4: Foundations Lesson #4 – Named Ranges

Lecture 5: Keyboard Shortcuts Lesson 1: Moving around your workbook

Lecture 6: Keyboard Shortcuts Lesson 2: CTRL + 1

Lecture 7: Keyboard Shortcuts Lesson 3: Cut, Copy, Paste, Undo, Find

Chapter 4: Functions and Formulas: Part 1

Lecture 1: Introduction to Formulas: Part 1

Lecture 2: Introduction to Formulas: Part 2

Lecture 3: Dates: Part 1 – Introduction

Lecture 4: Dates: Part 2 – Finding the difference between days

Lecture 5: Dates: Part 3 – DATEDIF

Lecture 6: Dates: Part 4 – DAY, MONTH, YEAR, and WEEKDAY

Lecture 7: Dates: Part 5 – Using the TEXT function to ReFormat Cells

Chapter 5: Functions and Formulas: Part 2

Lecture 1: Math Functions: Part 1 – SUM

Lecture 2: Math Functions: Part 2 – SUMIF

Lecture 3: Math Functions: Part 3 – SUMIFS

Lecture 4: Statistical Functions: Part 1 – COUNT and AVERAGE

Lecture 5: Statistical Functions: Part 2 – COUNTIF

Lecture 6: Statistical Functions: Part 3 – COUNTIFS

Lecture 7: Statistical Functions: Part 4 – AVERAGEIFS

Lecture 8: Project #1 – Intro and Project Files

Lecture 9: Project #1 – Answers and Walk Through

Chapter 6: Functions and Formulas: Part 3

Lecture 1: Lookup Functions: VLOOKUP – Part 1

Lecture 2: Lookup Functions: VLOOKUP – Part 2

Lecture 3: Lookup Functions: VLOOKUP – Part 3

Lecture 4: Lookup Functions: INDEX

Lecture 5: Lookup Functions: MATCH

Lecture 6: Lookup Functions: INDEX & MATCH – Part 1

Lecture 7: Lookup Functions: INDEX & MATCH – Part 2

Lecture 8: Logical Functions: Part 1

Lecture 9: Logical Functions: Part 2

Lecture 10: Logical Functions: Part 3

Lecture 11: Errors in Excel: Part 1 – #N/A and the IFERROR Functiton

Lecture 12: Errors in Excel: Part 2 – #NAME and #VALUE

Lecture 13: Errors in Excel: Part 3 – #REF Errors

Lecture 14: Project #2 – Intro and Project Files

Lecture 15: Project #2 – Answers and Walk Through Video

Chapter 7: Pivot Tables: Part 1

Lecture 1: Pivot Tables 101: Creating our first Pivot Table

Lecture 2: Pivot Tables 101: Rows

Lecture 3: Pivot Tables 101: Columns

Lecture 4: Pivot Tables 101: Values – Part 1

Lecture 5: Pivot Tables 101: Values – Part 2

Lecture 6: Pivot Tables 101: Filters

Lecture 7: Pivot Tables 101: Refreshing Pivot Tables

Lecture 8: Pivot Tables 101: Using Tables to Refresh Pivot Tables

Chapter 8: Pivot Tables: Part 2

Lecture 1: Pivot Tables 201: Calculated Fields

Lecture 2: Pivot Tables 201: Calculated Items

Lecture 3: Pivot Tables 201: Working with Dates

Lecture 4: Pivot Tables 201: Clean up and Organization

Lecture 5: Project #3 – Introduction and Project Files

Lecture 6: Project #3 – Answers and Walk Through

Chapter 9: Bonus Lecture: Survey

Lecture 1: Help Decide Which Courses we Make Next!

Instructors

James Nissen
Data Analyst

Rating Distribution

1 stars: 5 votes
2 stars: 18 votes
3 stars: 104 votes
4 stars: 373 votes
5 stars: 483 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu