Description

This book is a comprehensive & authentic book on ‘Spreadsheet skills for finance professionals’. The Present Publication is the 2nd Edition with the following noteworthy features:

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

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