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.