Excel – Data Analysis for Business

Excel – Data Analysis for Business

Unlock your BI Mind

What you’ll learn

Excel – Data Analysis for Business

• Data analytics in excel
• data cleaning and management
• solving examples from real-world problems
• data matching and lookups
• business scenario analysis through conditional formulas

Requirements

• Be familiar with Excel

Description

Do you deal with data at work? Do you aspire to be a Data or Business Analyst? Then this course can help you. This course will cover not only the technical skills to improve your analysis in Excel but also insights and examples based on real-world scenarios that will help unlock your hidden BI Mind.

First, we will look at principles of Data management, cleaning, and preparation as well as the mindset and work process that will allow you to make an impact in your job. Using these skills, you will be able to effectively manage large data sets in Excel.

After this, we will slowly build up technical skills. We will begin by learning how to link data sets in Excel.

Then we will build up abilities in dealing with conditional scenarios, layering techniques upon each other to tackle any problem. For example, if conditions A, B, and C meet then x, if D and E then y, etc.

Finally, we will use all the skills learned to tackle a challenge question derived from the real world.

After completing this course, you will both be ready to tackle more challenging problems at your own work and have a good foundation to build upon for any future up-skilling.

I have tried to include the skills, scenarios, and useful tips and tricks that have helped me in my own career as a Data Analyst. Thus, this course is not purely Excel, but I do include some discussion about the business context that I hope you will find useful.

Who this course is for

• Beginner to Intermediate Excel Users, for those who want to set the foundations to become Analyst or upskill for work.