• EXECUTIVE PROGRAMME IN INVESTMENT BANKING AND CAPITAL MARKETS
  • ADVANCED MANAGEMENT PROGRAM IN FINANCIAL SERVICES AND CAPITAL MARKETS
  • IIM Indore Postgraduate Certificate Programme for Emerging CFOs
  • POSTGRADUATE PROGRAM IN BANKING AND FINANCE
  • PGP in New Age Banking
    Co-created with Imarticus Learning
    4.8 out of 5 by 669 learners
    4x Industry Demand
  • POST GRADUATE DIPLOMA IN MANAGEMENT
    Co-created with BIMTECH
    4.8 out of 6071 learners
    2x industry demand
  • MBA in Investment Banking
    Co-created with Jain University
    4.5 out of 5 by467 learners
    2x industry demand
  • MBA in Fintech
    Co-created with Jain University
    4.4 out of 5 by 349 learners
    2x industry demand
  • MBA (Distance) in Banking and Finance with NGASCE
    Co-created with NMIMS
    4.7 out of 5 by 669 learners
    4x Industry Demand
  • Post Graduate Program in Banking and Credit Underwriting
    4.7 out of 5 by 1376 learners
    12 X industry demand

Financial modeling can be best learned through practice.  If you are just starting to learn financial modeling, reading up on the different financial models will help you clear the fundamentals. Microsoft Excel is one of the most-used programs which are used for financial modeling.

The following books are helpful to clear the basics of financial modeling and planning, and also discusses how to analyze data sets. They also show how Excel can be used for the same models.

Mastering Financial Modelling in Microsoft Excel: This book by Alastair Day will help you master the concept of financial modeling and how they can be generated through Excel. Complex issues are discussed with ease, with solutions to practical problems. Some of the major topics covered by the book are spreadsheet designs, processes, and methodologies.

Various techniques which can be used to check and improve existing models are also given in the book. Tests for every scenario are also given along with different Excel formulas and functions.

Financial Modeling in Practice: A Concise Guide for Intermediate and Advanced Levels: It is an engaging, easily readable book authored by Michael Rees. This is a great book for students as different Excel functions and tools for financial modeling are easily explained with scenarios, explanations, and illustrations.

It also teaches the basics of how to design a model, detail out its structure, and make them accurate, relevant and easily understandable. The book also explores different add-ins such as @RISK and Precision Tree, which are very useful for risk assessment. Different examples of how these models have been used in practical solutions are explained in great detail in the book.

Best Practices for Equity Research Analysis: The book by James Valentine is aimed at equity research, and is useful for anyone who wants a career in this field. The book explains concepts from the business’ point of view. The book explains ideas on valuation, behavioral finance, and due diligence.

The author’s own experiences are clearly stated in the book as well. It focuses on the importance of clear communication through the different models which are generated. Tips and tricks which can be used in Excel are explained in detail in the book.

Financial Analysis and Modeling using Excel and VBA: The book discusses the world of Visual Basic for Applications (VBA), as used in different Excel models. It is written by Chandan Sengupta and is relevant for both students and financial modelers who want to include VBA in their analysis.

It goes into the detailed features in Excel which are necessary for financial analysis course and modeling. Examples of these models are statistical analysis, Ribbon, data analysis, and PivotTables. This book also teaches financial analysis and modeling through different features of VBA and Excel.

You can learn by the different examples that are given as assignments in the book. Iterative solutions to different problem scenarios are also explained in great detail in the book.

For Online Course Enquiries
About Imarticus
Imarticus Learning is India’s leading professional education institute that offers training in Financial Services, Data Analytics & Technology. We’ve successfully transformed careers of over 35,000+ individuals globally through our Certification, Prodegree, and Post Graduate programs offered in association with leading and renowned global organisations in the Financial Services, Data Analytics & Technology domain.
Related course
  • Certification
    EXECUTIVE PROGRAMME IN INVESTMENT BANKING AND CAPITAL MARKETS
    Course duration(year)
    1
    Upcoming batches
    1
    Organizations enrolled
    20
    Upcoming Batches
    Date Location Schedule
    Date Location Schedule
  • Advanced Management Program
    ADVANCED MANAGEMENT PROGRAM IN FINANCIAL SERVICES AND CAPITAL MARKETS
    Course duration(hours)
    126
    Upcoming batches
    1
    Organizations enrolled
    20
    Upcoming Batches
    Date Location Schedule
    Date Location Schedule
  • Postgraduate Program
    IIM Indore Postgraduate Certificate Programme for Emerging CFOs
    Course duration(Months)
    12
    Upcoming batches
    1
    Organizations enrolled
    20
    Upcoming Batches
    Date Location Schedule
    Date Location Schedule
  • Postgraduate
    POSTGRADUATE PROGRAM IN BANKING AND FINANCE
    Course duration(months)
    4
    Upcoming batches
    1
    Organizations enrolled
    20
    Upcoming Batches
    Date Location Schedule
    Date Location Schedule
  • Placement Program
    PGP in New Age Banking
    Co-created with Imarticus Learning
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.8 out of 5 by 669 learners
    4x Industry Demand
    Upcoming Batches
    Date Location Schedule
    8th Jan 2022 Live Instructor - Led Training Online
    Date Location Schedule
  • Finance
    POST GRADUATE DIPLOMA IN MANAGEMENT
    Co-created with BIMTECH
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.8 out of 6071 learners
    2x industry demand
    Upcoming Batches
    Date Location Schedule
    3rd August Live Instructor - Led Training Online
    Date Location Schedule
  • Recent Graduates
    MBA in Investment Banking
    Co-created with Jain University
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.5 out of 5 by467 learners
    2x industry demand
    Upcoming Batches
    Date Location Schedule
    31st July ONLINE Online
    Date Location Schedule
  • Recent Graduates
    MBA in Fintech
    Co-created with Jain University
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.4 out of 5 by 349 learners
    2x industry demand
    Upcoming Batches
    Date Location Schedule
    31st July ONLINE Online
    Date Location Schedule
  • Placement Program
    MBA (Distance) in Banking and Finance with NGASCE
    Co-created with NMIMS
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.7 out of 5 by 669 learners
    4x Industry Demand
    Upcoming Batches
    Date Location Schedule
    8th Jan 2022 Live Instructor - Led Training Online
    Date Location Schedule
  • Post Graduate
    Post Graduate Program in Banking and Credit Underwriting
    Course duration(6)
    Upcoming batches
    1
    Organizations enrolled
    20
    4.7 out of 5 by 1376 learners
    12 X industry demand
    Upcoming Batches
    Date Location Schedule
    3rd August MUMBAI Online
    Date Location Schedule