Skip to content
UdemyData AnalysisPaid courseIntermediate levelCertificate

Excel for Business Analysts Online Course (Udemy.com)

Learn the Functions and Formulas you need to perform detailed Data Analysis in Excel from Excel experts Simon Sez IT

Created by: Simon Sez IT

Last updated March 2023

icon
What you will learn

  • How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP
  • How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis
  • How to split data using text functions SEARCH, LEFT, RIGHT, MID
  • How to standardize and clean data ready for analysis in Excel
  • About using the PivotTable function to perform data analysis
  • How to display your analysis using Pivot Charts in Excel
  • Conducting a Linear Forecast and Forecast Smoothing in Excel
  • All about Histograms and Regression in Excel
  • How to use Goal Seek, Scenario Manager, and Solver to fill data gaps in Excel

icon
Course Description

In this course, we focus on the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. We take you on a no-nonsense journey to teach you how to use them.

We start by looking at how to take raw data and prepare it for analysis. After that, we look at a number of tools and functions that can be used to conduct analysis such as Pivot Tables, before moving onto how to display data in the most meaningful way using charts, Pivot Charts, Slicers and so much more. Finally, we move onto some more advanced techniques designed to aid forecasting and using existing data to predict future trends.

This course also includes practice exercises so you can immediately put into practice the new data analysis techniques that you learn.


In this course you will learn:

  • How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP

  • How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis

  • How to split data using text functions SEARCH, LEFT, RIGHT, MID

  • How to standardize and clean data ready for analysis

  • About using the PivotTable function to perform data analysis

  • How to use slicers to draw out information

  • How to display your analysis using Pivot Charts

  • All about forecasting and using the Forecast Sheets

  • Conducting a Linear Forecast and Forecast Smoothing

  • How to use Conditional Formatting to highlight areas of your data

  • All about Histograms and Regression

  • How to use Goal Seek, Scenario Manager, and Solver to fill data gaps


This course includes:

  1. 7+ hours of video tutorials

  2. 55 individual video lectures

  3. Exercise files to practice what you learned

  4. Certificate of completion

This course was recorded using Excel from Office 365. It's also relevant to those using other, recent versions of Microsoft Excel including Excel 2013, 2016, and 2019.


Here’s what our students are saying…


"Yes, I learned so much and its applicable to what I needed to learn for my career in less than a week. I wish I had taken this course much sooner."

- Matt

"This course is relative to my role as a Business Analyst and has already taught me something new to use in my role."

- Kara

"Lots of stuff I've never used in here despite using Excel every day."

- Jonathan

"Great match for me as an engineer!"

- Glen

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

Simon Sez IT

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 12,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 1 million Udemy students in over 190 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. 

icon
More courses by Simon Sez IT

$19.99

$14.99

$109.99

$174.99

$84.99

$84.99

icon
More Data Analysis courses

Free

$12.99

$69.99

Free

$19.99

$19.99

icon
Reviews

4.8

636 ratings on Udemy

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

By John S. Harris on 9/27/2026

I appreciate the easy to follow steps and redundancies to help reinforce previous things learned. I recommend this as fundamental course for excel modeling or structuring your data spreadsheets for analysis.

By Amy A on 2/10/2024

This was such an enjoyable course and Deb Ashby was amazing. She explained different functions of excel clearly and concisely and the exercises at the end of each topic helped to give practice. Thank you.

By Stephanie Hilders on 2/10/2024

The course is well-structured and has a clear instructor. I think the course could be improved by adding additional exercise material. These skills are easiest to learn through practise, but the exercises were only very brief and straight-forward.

By Erik Okushko on 6/29/2023

Instructor's done an amazing job. Would love to buy some other courses taught by her. The only issue is that there aren't any business cases to practice your business analysis skills. It's mostly about improving your excel skills with a bit of a business context. Can you consider adding some? I'd also appreciate a whole separate course focused specifically on solving business problem & doing sales and pricing analysis

By Koshika Verma on 10/18/2022

I am really enjoying learning Excel through this course. The tutor is really amazing and polite she made each and every concept easy to understand. I would happily recommend this course to others.

By Kashish Mittal on 7/24/2022

Great course! Please note that this is pretty basic level but covers almost everything you need to start your journey on everything excel. For Dashboards and Forecasting you may need to take higher level courses but apart from that this course teaches you all the basics of excel in 7-8 hours!!

By Jacobus J N Maritz on 5/16/2022

I thoroughly enjoyed the course, the material covered and the pace thereof. My only issue is that the quizzes need to be reviewed. One of the questions referred to an equation which was not displayed, and two of the answers given were incorrect if you refer back to the theory presented in the respective session. Apart from these minor inconveniences, very good indeed, thanks!

By Aydan Hasanova on 10/10/2021

I've tried hard to find flaws in this course and to see if any details have been missed, and I've failed to do so. The instructor is incredibly attentive to details, explains ideas really well and the course flows incrementally which makes it very easy to follow and understand. One of the best courses I've ever taken. Thank you!

By Christine Wieseler on 5/31/2021

I took a previous course but this one is much better. The other person was from London the accent made her hard to follow. She is more understandable and I understand her well. VERY happy. Thank you!!

By Krishna on 1/19/2021

Course started with basics, now I feel like I started understanding the way Excel behaves. Only one feed back is, Please include few more exercises. So that we can practice a little better.

Showing all 10 reviews on CourseDuck

Read all 636 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 : 96 / 100