ConferenzaConferenza.in

Spreadsheet Skills for Finance Professionals by Pitabas Mohanty is a MBA book on General on Conferenza, priced at ₹517 (10% off MRP ₹575). Published by Taxmann. Order online with fast delivery across India.

Price
₹517 · 10% off
Course
MBA
Subject
General
Edition
2nd
Spreadsheet Skills for Finance Professionals

Spreadsheet Skills for Finance Professionals

by Pitabas Mohanty

Taxmann

₹517₹57510% off
100% Secure PaymentsPowered by Cashfree
UPIVISARuPayNet BankingWallets

Book details

Edition
2nd
Author
Pitabas Mohanty
Course
MBA

About this book

Learn MS Excel and spreadsheet tools for finance work. Build financial models using formulas, macros, and advanced functions. Covers Excel, Google Sheets, and Office 365 with practical examples.

At a glance

Edition2nd
AuthorPitabas Mohanty
CourseMBA

What's inside

  • Functions for financial models and keyboard shortcuts
  • Writing correct formulas, controls, and chart creation
  • Macros, VBA, and sensitivity analysis techniques
  • Good and bad practices to follow and avoid
  • Dynamic arrays and XLOOKUP functions
  • Number formatting and miscellaneous topics

Who should buy this

  • Finance professionals building or learning financial models
  • MBA students needing hands-on spreadsheet competency
  • Anyone seeking Excel mastery beyond basics for corporate finance
Publisher's 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 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

Frequently asked questions

What is Spreadsheet Skills for Finance Professionals?+

Learn MS Excel and spreadsheet tools for finance work. Build financial models using formulas, macros, and advanced functions. Covers Excel, Google Sheets, and Office 365 with practical examples. At a glance Edition 2nd Author Pitabas Mohanty Course MBA What's inside Functions for

Who is the author of Spreadsheet Skills for Finance Professionals?+

Pitabas Mohanty (Taxmann).

How much does Spreadsheet Skills for Finance Professionals cost?+

Spreadsheet Skills for Finance Professionals is available for ₹517 (MRP ₹575) on Conferenza, with fast delivery.

Which exam is Spreadsheet Skills for Finance Professionals for?+

MBA — General.

Is Spreadsheet Skills for Finance Professionals available as a free PDF download?+

Spreadsheet Skills for Finance Professionals is a paid book on Conferenza, delivered fast across India. For free PDFs — study material, RTPs, MTPs and suggested answers — visit https://conferenza.in/downloads.