With the BIWS Premium (Excel & VBA + Financial Modeling Mastery + PowerPoint Pro) you will have access to lessons on setup and navigation, learning how to improve the system and Excel setup as well as how to utilize the ribbon menu. The step-by-step guidelines are combined along with video instructions.
The main shortcuts of formatting and printing are openly shared, which can help you speed up the process of formatting financial models as well as master the conditional formatting.
You will learn about financial formulas and lookup functional lessons. Besides, the knowledge about lookup functions, Index, Match, and Indirect, array functions, Offset, sensitivity tables, goal seek and solver, and so on.
Instructions on data manipulation and analysis lessons are provided along with the knowledge about the graph setups in Excel and how to gain the best insights out of such charts.
Guidelines on VBA, Macro, and User-Defined Function are shared so that you can learn how to automate processes and create custom functions.