Excel for Business Analysts

Microsoft Excel remains one of the best tools for Data Analysis. In this course, we focus on the specific functions, formulas, and tools that Excel has to help conduct business or data analysis.

We start by looking at how to take raw data and clean it so it’s in a usable format. After that, we look at a number of tools and functions that can be used to conduct analysis before moving onto how to display data in the most meaningful way. 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

Course Format

This is a video-led, Advanced Microsoft Excel training course. You can preview some videos in the pane above. This course includes practice exercises so you can practice as you learn. This course is designed for PC users and does require a working knowledge of Microsoft Excel.

This course is also suitable for Office 365 users.

30-Day Guarantee

We offer an unconditional, 30-day, full money-back guarantee, no questions asked. It’s our way of ensuring you have complete confidence in your membership to Simon Sez IT. With 30 days of risk-free membership, you can test-drive all of our courses and feel entirely sure you’re getting just what you need. If you don’t learn, you don’t pay.

Why Trust Us?

Simon Sez IT has been in business for 10+ years and has taught over 500,000 students. We’ve created over 100 software training courses, 5,900+ video tutorials, and we’ve helped thousands of people around the world learn how to use Microsoft Office and developed multiple Microsoft Excel training courses.

How Do I Start?

Simon Sez IT makes complicated software simple at a fantastic price. To access this course and over 100 others, select a membership option on the right-hand side >>>

All Simon Sez IT memberships are entirely flexible (cancel anytime), and all include our no questions asked 30-day money-back guarantee.