MBA in Excel- Master Business Analytics in Excel

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

What you'll 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

Requirements
Basic knowledge of Excel
Be passionate to learn Excel and other tools

Description
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.

Who this course is for
Working professionals, Students, Managers, Data Analysts, anyone wishing to improve their Excel skills
Basics to Intermediate Excel users will quickly gain indepth analysis throughout the course.