Taxmann’s Spreadsheet Skills for Finance Professionals by Pitabas Mohanty – 2nd Edition August 2020.

Taxmann’s Spreadsheet Skills for Finance Professionals by Pitabas Mohanty – 2nd Edition August 2020.

Description

This book is a comprehensive & authentic book on ‘Spreadsheet skills for finance professionals’. The Present Publication is the 2^nd 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 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

Details