Microsoft Excel Data Analysis: Formulas & Pivot Tables
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
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.
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
Instructor
- 4.5 Instructor Rating
- 1,079 Reviews
- 11,386 Students
- 2 Courses
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 :)