Microsoft Excel Data Analysis: Formulas & Pivot Tables (Udemy.com)
Learn Data Analysis, Formulas, and Pivot Tables. Data Analysis in Microsoft Excel for Beginners and Intermediate users
Created by: James Nissen
Last updated October 2023
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
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.5 out of 5higher than 39% of them
- Reviews1,117#162 of 356 by number of reviews
- Length2.2 hoursshorter than 84% of them
- Last updatedOctober 2023earlier than 51% of them
Course 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.
Instructor Details
- 4.5 Rating
1,117 Reviews
James Nissen
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 :)
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
By Vladimir Rakic on 4/20/2026
This course was a very good refresher. I have found the most value out of Pivot Table section. James presents the course in a calm manner, with clear explanations in byte size pieces that are easy to review a few times if required. I will definitely look out for more of his courses.
By Prasanth Daniel Joseph on 6/7/2025
Great. This is helpful in hand as it offers basic knowledge on excel. One should keep practising the notes learned from this presentation to avail its benefits to the fullest. However there is an issue to be noted, the tasks given are complicate a bit and zoomed out in smaller size. Also at certain instances, there is speedy typing of formula. Please watch out particularly when you come across topic on "Iferror" statement.
By Paul Flood on 7/25/2023
The presenter obviously knows Excel very well, but presented at the pace of someone who knows it very well. I often kept having to rewatch and pause videos just to keep up. By the time I'd finished doing what I was doing, looking back to the video screen, he was 3 steps ahead. Very informative though, and I got there in the end!
By Anonymized User on 1/10/2023
Just finished the course in span of 2 weeks. I consider myself as a beginner in Excel. As an aspiring Product Manager, I took this course in order to learn and understand more of data analytics method using Excel. For me personally, this course is phenomenal!. I learn a lot of things that I wouldn't normally be able to understand myself, especially the Formulas and common Errors in Excel. I love how the way he explain things in concise manner, the course is pretty challenging for me. But I managed to complete it. As for my recommendations for next Excel content. I would like to learn how to gather, clean and visualize my data trough Excel. Along with practice material and project. Thank you very much for the lessons!
By John Pacioni on 7/7/2021
This is exactly what I am looking for. The instructor is eloquent and the presentation is excellent for learning. I like that I can pause the video and examine more closely what was done in the tutorial so that I can better learn as opposed to a typical class packed into a specific time frame. Thanks.
By Oladipupo Jaji on 3/11/2020
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.
By Amanda Howes on 1/8/2020
I loved this course! It was a great refresher for me. There were a few times I had to research outside of the course due to having an older version of excel and using a mac as well. The Mac shortcuts are different and the version of excel is quite different.
By Mohamed ali amen on 10/25/2019
it was a great experience for me i was imagine that i knew a lot but i realized that i missed a lot of details thank you very much it was great simple teaching i am looking for more advanced in excel
By Laura Skipper on 10/22/2019
spreadsheet had mentioned one thing and instructor mentioned different, however I was following intently, and knew what he was talking about. Excellent intermediate/advanced functions I was looking for and was explained very well. Slow down a bit with each example. Pause works wonders in this case, but maybe slow down slightly during explaining/showing steps. Best course found so far for what I needed to refresh/learn proper techniques to use versus manually formatting options.
By Ireoluwatomi Oloke on 10/9/2019
It was a really great course. The instructor's 'fast' pace was just right, and it helped me think on my feet (had to pause the video sometimes though =D). He didn't drag out his explanations or talk down to us as if we've never used a computer before. Thanks James, I wish I could pay you for this course. Please do some more in the future and make them paid!
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 90 / 100






