Microsoft Excel Data Analysis: Pivot Tables and Formulas Course

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

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
  • Learn 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
  • Learn 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
  • 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

Last updated: 3/2020 | Size: 1.4 GB
Click to get:
Source: https://www.udemy.com/course/microsoft-excel-for-data-analysis/


Microsoft Excel - Excel, Pivot Tables & Power Pivot (Bundle)
Microsoft Excel - Excel, Pivot Tables & Power Pivot (Bundle)
04.21.2020
EXCEL at Work - Complete MS Excel Mastery Beginner to Pro
EXCEL at Work - Complete MS Excel Mastery Beginner to Pro
04.12.2020
Zero to Hero in Microsoft Excel: Complete Excel guide 2020
Zero to Hero in Microsoft Excel: Complete Excel guide 2020
05.16.2020
Excel Basics: Helpful Tips & Formulas for Excel
Excel Basics: Helpful Tips & Formulas for Excel
08.06.2020

No comments.

Add Commenent
reload, if the code cannot be seen

or
Registration
Lostpassword