·       Specific focus on application of MS Excel in corporate finance

·       Enhances the readers skills to build powerful financial models

·       Discusses techniques of good/bad practices to be followed/avoided & VBA macros to build financial models

·       Usage of multiple examples to under the use of functions in excel to build financial models using formulas

·       Discusses newer applications such as the following:

o   Google Sheets

o   Office 365

·       Coverage:

o   Functions used in Financial Models

o   Keyboard Shortcuts in Spreadsheets

o   Writing Correct Formulas in Excel

o   Using Controls in Excel

o   Creating Useful Charts in Finance

o   Understanding Macros

o   Formatting Numbers

o   Sensitivity Analysis in Excel

o   Miscellaneous Topics

·       Newer features such as dynamic array (that applies to many existing features in Excel) & XLOOKUP have also been discussed