Excel for Business Analysts

advanced project

In short

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.

£49.00

You can also subscribe to Toppa for unlimited access to all of our courses for just £9.99 per month.

Further info

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

Toppa courses: Set your business up for success

Wide range of content

Wide range of content

A huge range of the best video, audio and animated courses specifically created to develop your skills and help you succeed in business.

Expert instructors

Expert instructors

A vibrant community of proven expert instructors, meaning you can learn from the very best in the business.

Unlimited access

Unlimited access

Once you are a Toppa member there are no limits to how many courses you can start, or how often you learn.

Mapped to global MBA Syllabuses

Mapped to global MBA Syllabuses

Toppa and our instructors use the best MBA syllabuses from around the globe to help structure our courses

Toppa perks

Toppa perks

With Toppa, you get more than just unlimited learning. We've partnered with some amazing brands to give you access to optional learner perk add ons.

Just £9.99 per month

Just £9.99 per month

It is just £9.99 a month for a Toppa membership. Full access to all courses. No hidden costs.