Be familiar with Excel
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, preparation as well as the mindset and work process that will allow you 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 are 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 busniess 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.