Business Data Analysis with Microsoft Excel and Power BI (Udemy.com)
An in-depth training on Excel and Power BI for busy professionals who use Excel a lot at work.
Created by: Michael Olafusi
Last updated November 2020
What you will learn
- Constantly being updated with new content and covering more areas of business data analysis.
- Be more productive and creative in their use of Microsoft Excel and Power BI for business and reporting
- Become proficient in using PivotTables for analyzing a large data
- Become proficient in the use of VLOOKUP, HLOOK, LOOKUP to get last item, INDEX and MATCH to make automated dynamic dashboarts/reports.
- Learn how to use Sorting in more advanced ways: multi-level sorting, sorting left to right.
- Learn how to create professional and great looking charts in Excel and understand when to use a particular chart type.
- Learn creative uses of Excel and a lot of keyboard shortcuts that saves analysis time
- Be introduced to Excel VBA, shown how to create a macro by clicking a particular button twice.
- Make a sample Excel VBA userform that gets data from user and input into a table in Excel
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.3 out of 5higher than 13% of them
- Reviews2,418#100 of 356 by number of reviews
- Length12.6 hourslonger than 80% of them
- Last updatedNovember 2020earlier than 72% of them
Course Description
**** Important Notice *********************************
We do regular live support sessions to give a more enriching experience and help you align what you are learning with career growth. Enroll now to get this benefit for life!
*************************************************************
Microsoft Excel is the world's most used and versatile business analysis, reporting and strategy software. Having a deep practical knowledge of Excel will turn you almost superhuman at work and increase your productivity. You will be seen as a very efficient, highly competent and indispensable partner in the organization's progress. And, hopefully, it will lead to a much greater career role and opportunity for you.
Power BI is Microsoft's business intelligence and dashboarding tool that enables organizations to have a wholesome understanding of what is happening at all operational levels of the company. With it you can create reports with drill down features, access-level restrictions, auto-refresh, alerts/triggers and interactivity.
This training is going to focus on making you highly proficient in the use of Excel and Power BI for business data analysis, dashboard creation and reporting the professional way. And most of this would be achieved through lots of samples that will be similar to what you'll need at work.
Instructor Details
- 4.3 Rating
2,418 Reviews
Michael Olafusi
Michael is a 9x Microsoft MVP (Most Valuable Professional), certified Advanced Financial Modeler (AFM), Chartered Stockbroker (NG), UK CISI member, Microsoft Certified Trainer and founder of UrBizEdge, a business data analysis solutions firm. He began his professional career as a Radio Access (RA) Engineer for Nokia Siemens Networks, then as a Business Analyst and MIS Analyst for Comviva -- Airtel Africa CRBT operations in 10 countries, and finally as a Service Delivery Lead and Performance Analyst for 21st Century Technologies before resigning to build his own company.
He has done several financial modeling, business intelligence and data analysis projects/training for Telecommunications companies, FMCG companies, FinTech companies and other industries across the globe.
He is addicted to Microsoft Excel, Power BI, Python, business intelligence and Financial Modeling.
More courses by Michael Olafusi
Financial Modelling, Financial Planning and DCF Valuation (2020)
4.3 (569 Reviews)
Provider: Udemy
Time: 6.5h
$64.99
Reviews
By Joyce Tamor on 12/29/2025
It would be great to obtain a revised, updated version of all the lessons laid out properly and delivered with clarity (verbally and in writing). It's nice to learn content, but it's hard to understand at times; one would have to repeat it over and over. The examples are sometimes far-fetched and out of nowhere. I finished the course, but will have to keep repeating multiple sections in order to finally get some degree of understanding.
By Sulaimon ronke on 4/2/2020
This is a very good course. Very interesting. I am a business developer for a small company in Lagos. I gather lots of data from people every day. Raw data. I started this course in expanding my knowledge in excel and now I am so interested in data analysis. I would implement the VBA form in getting the data now. I am really interested in ways to further with data analysis. I have a little bit of knowledge in SQL.
By Maya Brandl on 7/20/2018
Mehr zu Excel als zu PowerBI, ruhig vorgetragen, ausführliche Erklärungen, viele Beispiele, an den Akzent kann man sich schnell gewöhnen, nur die Untertitel enthalten zu viele Fehler und sind daher nicht gut zu gebrauchen, insgesamt überzeugend als erster Kurs bei Udemy
By Caplain Marie on 6/26/2018
Good course overall with presentation of all basic (and more complex) functions of excel, and possibility to practice each with provided material. 2 videos are not working. Pace of the course is a bit slow if you are already using excel regularly. Also, there hasn't been updates (as said in the presentation of the course) in over a year in which I was signed up to the course. I'm satisfied with the course overall.
By Ken Tan on 10/27/2017
it's really great where the instructor compares the different platform and definition of analysis and tools. however, most of the definition is from the website where it was being read out word by word. hope there is a more in-depth explanation or linkage to real-life applications examples which can enhance our understanding. great content and thank you...
By Heena desai on 10/25/2017
I wish the instructor had spend more time on Power BI demos. Overall, Michael did good in explaining the different options available in MS Excel. I got to learn about various options available in MS Excel that I did not know about. I now feel more confident being able to build better business dashboards. Thank you Michael.
By Arthur Wang on 10/1/2017
This course is a very systematic and comprehensive course about data analysis and advanced excel formula. It includes very practical examples. Other course providers may offer courses that cover very similar contents. However, I think Michael's covers a wider and more comprehensive range of data and business analysis skills. Highly recommended!
By Puneet Shah on 5/9/2017
The context and content is one of its kind. Mr, Michael presentation and the knowledge of Excel including Analysis tool and Business tools are great. I would like to pay my thanks to Mr,Michael for presenting such a nice videos. I request to Mr, Michael kindly improve the sound quality of some videos its create complex while we studied but yes! great thanks to Mr,Michael Thought:- "If someone gives us a single idea for life we should always respect his/her here Mr,Michael gave a suitcase of knowledge i don't know how i am going to pay to him. Love from India.
By J S on 3/23/2017
Michael's course is wonderful. I thought I was an advanced excel user, it turns out I was a novice all along. I have been glued to this course and am about half way towards completion. The fact that he has offered it for free is completely outside of my understanding, but appreciated nonetheless. I can't help but wonder how he obtained all this information/experience and would love to perhaps get some personal advice from him.
By Goh Weili Jeremy on 12/17/2016
Good introduction on new analysis tools such as goal seek, scenario manager, power pivot and also introducing new charts such as sparkline chart , forecast charts . I alao learned nee excel functions such as v lookup and hlookup which are useful tools to build dashboards
This is a great course, all the topics are adequately covered. Learnt a lot excel to start working comfortably with excel. But the trainer has a native language effect on English, other than that everything is great.
Excellent course, great learnings, but the sound could have been clearer and louder. Thank you. Mr. Olafusi
Quality Score
Overall Score : 86 / 100




