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
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
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:
7+ hours of video tutorials
55 individual video lectures
Exercise files to practice what you learned
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
Instructor Details
- 4.8 Rating
636 Reviews
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.
More courses by Simon Sez IT
Microsoft Excel 2016 for Beginners: Master the Essentials
4.7 (30,769 Reviews)
Provider: Udemy
Time: 15.7h
$14.99
Jira for Beginners - Detailed Course to Get Started in Jira (2025)
4.5 (30,730 Reviews)
Provider: Udemy
Time: 4.8h
$109.99
Ultimate Microsoft Office; Excel, Word, PowerPoint & Access (2024)
4.5 (17,065 Reviews)
Provider: Udemy
Time: 70.7h
$174.99
Mastering Microsoft 365 SharePoint Online: Essential Guide (2026)
4.5 (12,189 Reviews)
Provider: Udemy
Time: 9.2h
$84.99
Learn Microsoft Windows 11: Comprehensive Windows 11 Course (2025)
4.4 (6,330 Reviews)
Provider: Udemy
Time: 6h
$84.99
More Data Analysis courses
Complete neural signal processing and analysis: Zero to hero (2026)
4.8 (2,013 Reviews)
Provider: Udemy
Time: 46.9h
$12.99
Alteryx Designer Advanced Certification Mega Bundle (2023)
4.8 (468 Reviews)
Provider: Udemy
Time: 16.9h
$69.99
The Complete SQL Bootcamp : From Beginner to Advanced (2026)
4.8 (130 Reviews)
Provider: Udemy
Time: 14.2h
$19.99
Reviews
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.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 96 / 100











![Data Analysis with Pandas and Python [2026]](/programming/data-analysis/images/932344_e14a_2.jpg?v=1789153473)
