Skip to content
UdemyExcelPaid courseAll LevelsCertificate

Microsoft Excel DATA ANALYSIS Using my Proven 4-Step System (Udemy.com)

Excel Data Analysis w/Pivot Tables. Learn my valuable 4-step system to IMPORT, CLEAN, ENHANCE, & ANALYZE data in Excel.

Created by: Steve McDonald

Last updated October 2021

icon
What you will learn

  • Learn my effective 4-step process for importing, cleaning, enhancing and analysing your data.
  • Learn how to use Pivot Tables to do lightning fast data analysis.

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.4 out of 5higher than 25% of them
  • Reviews388#244 of 356 by number of reviews
  • Length2.4 hoursshorter than 82% of them
  • Last updatedOctober 2021earlier than 64% of them

icon
Course Description

  1. Import

  2. Clean

  3. Enhance

  4. Analyze

These are the 4 simple steps you should be using every time that you analyze data. In this course you'll learn how to do each of the steps so that your data, your tables, and your pivot tables with work smoothly and efficiently every time.

Data analysis is one of the biggest needs for businesses today. And so much data is going to waste because many businesses don't have someone to analyze it. You could be that person. Imagine how valuable you would be to your boss if you knew how to discover trends, needs or deficiencies in your companies workflow.

This course is designed to teach you a simple 4-step process for importing data into Excel, cleaning up that data to make it easy to work with, enhancing that data with formulas and tools to make it more powerful, and finally, analyzing that data quickly and easily with pivot tables. This process makes it easier and gives you more powerful results from you data, results that you can actually use to make better decisions for your company.

Your instructor, Lucas, created this system to help him analyze market data at his job. He used this process over and over again to find the answers that his company was missing and to transform the way they did business. In this course, he's going to teach you that same process that he uses.

This course includes video lectures that walk you through all of the steps, and access to instructors if you ever get stuck along the way.

You also have a 30-day money back guarantee. We know that you'll love the course and be amazed at what you can do when you are finished. But if for any reason you're not, you can watch the whole course, keep everything that you've learned, and get 100% of your money back within 30 days. That's how sure we are that you'll love it.

We're glad that you're checking out this course. We've designed it to help you change the game for yourself and your business. If you're ready to learn how to crunch data at lightning speeds, this is the course for you. Jump in and start learning with the first video, and we'll see you in there.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Steve McDonald

Learning is easier with the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals. 

My talent is taking complex subjects (like Excel, Access and Photoshop) and making them simple to learn. I wasn't always good at technology. There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated myself to mastering technology. Now I'm proud to call myself a self-taught tech geek. 

I'm a geek who still speaks the language of normal human beings. I don't use a lot of jargon and fancy words that the average person doesn't understand.

I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery.

I am here to guide you on your way to success. You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction.

I'm always happy to help.  I believe in you, and I'm here to support you in your learning process.

icon
More courses by Steve McDonald

$24.99

$12.99

$79.99

Free

Free

$10.99

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.4

388 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Abraham Martinez on 4/17/2022

The information presented is clear and easy to understand. I wanted to learn specific topics I need to use in my day to day job. This is what I expected.

By Saurav Rana on 7/16/2021

The note pad method used by instructor is really helpful. I had struggled with INDEX and MATCH function earlier, now I understand them thanks to this course.

By Kerry Benjamin on 2/15/2021

This course was easy to follow along with and got you using importnant functions like Vlookup, INDEX-MATCH, and PIVOT TABLES pretty quickly. Good for beginners and people who need a refresher.

By Timothy Macqueen on 2/3/2021

Very informative. Learnt many new things about Excel. How to run data analysis faster. Useful Pivot table techniques.

By Maarten van den Berg on 11/16/2020

The last column formatting to dollars does not work with me. Furthermore this is really basis excel, but always good to have a look at it.

By Bamidele Temitope Oluwafemi on 11/2/2020

This course helps me to put to use all my Microsoft Excel knowledge. really practical, Great course..... Thanks to the instructor

By Tawheed Mohammad Sayyid on 10/25/2020

The course is overall good. It would have been better if you included HLOOKUP and some more exercise files for us to work on. Or share with us some websites to plug and play with Excel for Data Analysis. This will keep the student well focused.

By Rumil Kothari on 9/25/2020

This was really a good course for someone who wants to analyse and present data. The presenter was really good in the way he explained and was very easy to grasp. Personally I already knew maximum content of the course. Good work.

By Sascha Hollingsworth on 8/29/2020

The only change I would make to this course is how you have the files saved or at least specify which file you are using because there are times when you dont need to change the actual file even though the resource folder shows a new file.

By Gulshan Kumar on 8/22/2020

Course helped me a lot. Content was very simple and well explained. Pivot table concept is clear now. Only problem was needed to watch on bigger screen to see the data and command clearly.

Showing all 10 reviews on CourseDuck

Read all 388 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 88 / 100