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.

( 92 Reviews )

Created by: Michael Olafusi

Produced in 2021

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
Learn Power BI and other new interesting

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 84 / 100

Course Description

**** Important Notice *********************************
Still building the Power BI section. Expect lots of new content as the business data analysis world is now a fast changing one. Microsoft is constantly updating and expanding the features of Microsoft Excel and Power BI.
*************************************************************
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.Who this course is for:

This course is designed mainly for business professionals who use Excel a lot at work. It is built entirely out of my experience teaching over 500 business professionals over the course of two years on Excel, business data analysis and VBA. It focuses on giving you business productivity improving Excel skill and tips using practice files I built to mirror Excel consulting jobs I have done for companies. The course is best suited for people who currently used Excel at work and will benefit from improved Excel skills for reporting, presentation and analysis.
However, if you seldom use Excel and just want a certificate in Excel for CV purpose, you will find it hard to put in the commitment required to finish this training. You should consider the Microsoft MOS training as it is more ideal for CV building.
This course is also not for people who want to learn business data analysis but not with Excel and/or Power BI. The entire course is Excel and Power BI based.

Time: 12h

Instructor Details

Michael Olafusi

4.2 Rating
92 Reviews

Michael is a Microsoft Excel MVP (Most Valuable Professional), Microsoft Certified Trainer and founder of UrBizEdge, a Microsoft Excel and business data analysis consulting 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 is addicted to Microsoft Excel, Power BI, VBA programming and web app development. He loves blogging daily and loves helping people with their Microsoft Excel issues.

Excel Basics (2017)

4.9 (15 Reviews)

Provider: YouTube
Time: 12h

Free

Microsoft Excel - Online Tutorial for Beginners (2010)

0.0 (0 Reviews)

Provider: Chandoo.org
Time: 1h 30m

Free

Excel Power Pivot and Power Query For Dummies

Excel Power Pivot and Power Query For Dummies (2016)

0.0 (0 Reviews)

Provider: Amazon

$14.53

More Courses

Reviews

4.2

92 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Lokanadh Naveen Deevi

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.

By Shubham Kene

Excellent course, great learnings, but the sound could have been clearer and louder. Thank you. Mr. Olafusi

By Alfredo NarvÃ¡ez Docimo

This course has given me great insights about how to understand and make sense of data. It goes even further than Excel and it's extremely useful for those who want to get into BI. Totally recommended!
Thank you so much for this!

By NOCM9T .

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 Maya Brandl

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 Bharat Kumar Sharma

Great course. The course gives overall uses of various business analysis related Microsoft Excel features. It also touches use of Microsoft's Power BI. This is very cool part of the course. Thanks Michael.

By Emmanuel Adebayo

This was a great Course. Thank you very much Michael!

By Ken Tan

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

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.

By Monica Sanchez

Poor english and contents
Difficult to follow because the substitles are not good

By Almaz Meharenna

Great Job Mr. Alafusi, this is the kind of course I was looking for. I need to brush up on my data analysis skills and I enjoyed it every step of the way. I have learned much more than I thought I would. He is amazing!!!!

By Arthur Wang

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!