Spreadsheet Skills for Finance Professionals (2nd Edition 2020) 

Taxmann’s Spreadsheet Skills for Finance Professionals (2nd Edition 2020) 

by Pitabas Mohanty

Buy Online Rs 500 Click here

• Item Weight : 460 g
• Paperback : 388 pages
• Publisher : Taxmann (27 July 2020)

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 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