Spreadsheet Skills forFinance Professionals
Author(s)
Publisher
ISBN
9789390128228
Edition
2nd Edition 2020
Pages | Format
388 | Paperback
Approx. Product Size
0.46
Note : The book "Spreadsheet Skills for Finance Professionals" consists of 10 chapters.This is a comprehensive and authentic book “Spreadsheet Skills for Finance Professionals” for PGDM/MBA/CA/CWA and other professional courses. The book tries to fill the gap by identifying and explaining all the spreadsheet features that one needs to have to build robust financial models.
Description
A Comprehensive and Authentic Book on “Spreadsheet Skills for Finance Profession-als”for PGDM/MBA/CA/CWA and other professional courses
- Spreadsheet skills to build powerful financial models
- Techniques of good/bad practices to be followed/avoided to build financial models
- Enough examples to understand use of functions in excel to build financial models using formulas
- Simple and powerful VBA macros to build powerful financial models
- Discussion about typical errors and their identification in auditing of financial models
| Chapter No | Chapter name |
|---|---|
| Chapter: 1 | Introduction |
| Chapter: 2 | Functions used in Financial Models |
| Chapter: 3 | Keyboard Shortcuts in Excel |
| Chapter: 4 | Writing Correct Formulas in Excel |
| Chapter: 5 | Using Controls in Excel |
| Chapter: 6 | Creating Useful Charts in Finance |
| Chapter: 7 | Understanding Macros |
| Chapter: 8 | Formatting Numbers |
| Chapter: 9 | Sensitivity Analysis in Excel |
| Chapter: 10 | Miscellaneous Topics |
Will update soon
Will update soon
Will update soon
Will update soon
Will update soon
Will update soon
Will update soon
Will update soon
Will update soon
Will update soon
