• BBA in Finance
    Co-created with Jain University
    4.3 out of 5 by 211 learners
    2x
  • 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
  • Post Graduate Program in Business Management with NMIMS
    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
  • Post Graduate Program In Finance And Accounting
    Co-created with Grant Thornton
    4.9 out of 5 by 238 learners
    14 X industry demand
  • Professional Certification in FinTech
    Co-created with SP Jain School of Global Management
    4.6 out of 5 by 1421 learners
    6X industry demand
  • Credit Risk and Underwriting Prodegree
    Co-created with Moody’s Analytics
    4.6 out of 5 by 1139 learners
    4X industry demand
  • Banking And Wealth Management Bootcamp
    4.6 out of 5 by 1429 learners
    3X industry demand
  • Post Graduate Program In Capital Markets
    4.7 out of 5 by 807 learners
    3X 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
  • Placement Assistance
    BBA in Finance
    Co-created with Jain University
    Course duration(Months)
    4
    Upcoming batches
    1
    Organizations enrolled
    20
    4.3 out of 5 by 211 learners
    2x
    Upcoming Batches
    Date Location Schedule
    ONLINE 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
    nil 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
    nil ONLINE Online
    Date Location Schedule
  • Placement Program
    Post Graduate Program in Business Management with NMIMS
    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
    ONLINE 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
    Not Available MUMBAI Online
    Date Location Schedule
  • Post Graduate
    Post Graduate Program In Finance And Accounting
    Co-created with Grant Thornton
    Course duration(months)
    4
    Upcoming batches
    1
    Organizations enrolled
    20
    4.9 out of 5 by 238 learners
    14 X industry demand
    Upcoming Batches
    Date Location Schedule
    None DELHI Online
    Date Location Schedule
  • Certification
    Professional Certification in FinTech
    Co-created with SP Jain School of Global Management
    Course duration(Months)
    3
    Upcoming batches
    1
    Organizations enrolled
    20
    4.6 out of 5 by 1421 learners
    6X industry demand
    Upcoming Batches
    Date Location Schedule
    ONLINE Online
    Date Location Schedule
  • PRODEGREE
    Credit Risk and Underwriting Prodegree
    Co-created with Moody’s Analytics
    Course duration(Months)
    3
    Upcoming batches
    2
    Organizations enrolled
    20
    4.6 out of 5 by 1139 learners
    4X industry demand
    Upcoming Batches
    Date Location Schedule
    13th February ONLINE Weekend
    Date Location Schedule
    29th May ONLINE Weekend
  • Certification
    Banking And Wealth Management Bootcamp
    Course duration(Months)
    2-3
    Upcoming batches
    1
    Organizations enrolled
    20
    4.6 out of 5 by 1429 learners
    3X industry demand
    Upcoming Batches
    Date Location Schedule
    30th January LUCKNOW Weekend
    Date Location Schedule
  • Post Graduation
    Post Graduate Program In Capital Markets
    Course duration(months)
    4
    Upcoming batches
    1
    Organizations enrolled
    20
    4.7 out of 5 by 807 learners
    3X industry demand
    Upcoming Batches
    Date Location Schedule
    Not Available ONLINE Online
    Date Location Schedule