MBA in Excel- Master Business Analytics in Excel

Categories: All Courses
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Master Excel with Formulas, Functions, Excel Dashboards, Pivot tables, Power Query, Macros & VBA and Power BI

Course reviews:

“Best course of MS excel. covered everything”

Abhishek Batham

” This course really worth more than others.

Sandeep K.H – India

” Thank you for this amazing course and for all the Information you shared in this course. For me your course is in top 10 excel courses here on Udemy and believe me I have seen a lot. Your course have everything. If you will do in the future others courses I will buy then instantly. 

Copaci Florin-Romania

Thank you so much for the course. I am loving it. You present challenge after challenge in each exercise, and its been fun following, along as well as figuring out multiple ways to answer your questions. I hope you make more courses. You are a good teacher.

N.Sanchez – USA

I am lucky I took this course. Amazing

Ijlal hasnain – Pakistan

I must confess, course really helped me in doing my work. I highly recommend the course to the who like to learn and master in data analysis. Funny thing, I did this course while based in Switzerland. Most importantly, I was able to reach out with my customized questions to the course Instructor and he was always reachable and supportive to answer my queries.

Rizwan Safdar – Switzerland

All in One Excel Course – Enhance your Excel experience with MBA in Excel. Start with formulas, move onto Pivot tables, macro and VBA, manipulate data and consolidate with Power Query and visualize with Power BI. All in One course, from basics to Advanced level.  Recommended for any Excel user to level up their skills and insights of different tools provided. Excel is a must anywhere you go in the world. Uplift your Excel confidence and step out an Excel hero. With more than 18 hours of content, I hope you will be able to learn many new tips and at the end of the course be able to quickly analyze and debug formulas with ease. From data analysis, to visualization, the course walks you through the steps required to become a superior data analyst. All you need is basic Excel skills and a passion to put in hard work to master key concepts.

More videos to be added on student feedback and request.

Formulas covered are Xlookup, Vlookup, Counta, Index & Match, Sumif, Sumifs, Countif, Countifs, Array nested formulas, Filter, Xmatch, Sumproduct, Text functions, Date functions, VBA coding, DAX functions, Pivot tables, Named Ranges, Offset, Conditional Formatting, Dashboard creation, Animation in Excel, Getpivotdata, Slicers, Indirect function, Textjoin, IFS, Maxifs, Sort, Sortby, Unique, Switch, Let, Sequence, much more and  Super Excel shortcuts.

Course is updated with Microsoft 365 version.

Show More

What Will You Learn?

  • The course builds slowly with intermediate concepts to Advanced level Excel skills, using formulas, pivot tables and VBA
  • You will learn data analysis using nested formulas, pivot tables, VBA magic to animate Charts, Power Query and Power BI
  • Course is designed in Excel 2019 and also covers new formulas of Microsoft Office 365
  • Recommended for any Excel enthusiast to master key Excel concepts
  • After completing the course, you will have the confidence and knowledge towards becoming an Excel Expert
  • I will be updating the course on new materials and videos as and when needed on student feedback

Course Content

Understanding the data & Resources

Introduction

Analyzing Data in Excel

Student Ratings & Reviews

No Review Yet
No Review Yet
× Chat