Mon premier blog

Financial Analysis and Modeling Using Excel and VBA Chandan Sengupta
Publisher: Wiley

May 3, 2010 - The end result was a detailed Excel workbook with a number of financial calculations, all extracted from an extensive series of pivot tables. Aug 15, 2011 - Based on the authors extensive experience of building models in business and finance, and of training others how to do so this book starts with a review of Excel functions that are generally most relevant for building accurate and readily understandable models (including the use of sensitivity analysis techniques) before covering key application areas, such as the modelling of financial statements, of cash flow valuation, risk analysis, options and real options. Oct 29, 2013 - We would have traditional BI pros on staff, but their mission would be to support the Excel pros – providing them with data and infrastructure, and occasionally “taking over” a Power Pivot model that had grown too large. While he wasn't actively using R in his work at that point, he continued to experiment in his free time by building trading tools and models in R. Aug 8, 2012 - Execute data studies and analysis to determine if data provided by an external vendor is able to improve our current underwriting models. But had never used it as a development platform, to handle complex data analysis. So, not only did I gain a ton of experience building complex, automated models in Excel, I produced a deliverable that could be reused on future IBM projects, as well as a tool that the client was able to make use of going forward, as well. As you may be aware that financial modelling can be performed in various platforms such as R, MATLAB, most widely used Microsoft Excel, Python , C++, Java etc. 7 days ago - In this stage, more complex functions of Excel are covered and it guides one on how to use the tool to do a complex financial analysis or an advanced model building. This advanced tutorials offer the user with skills about using Excel's high level features such as the advanced filtering and sorting, using pivot tables and automation of the spreadsheets using the VBA and pivot tables. Mar 9, 2014 - I would try to answer this in the same generic way. BI Pros would If you “gifted” me an army of BI consultants and stipulated that they could only be employed to build reports, analyses, and models, I would decline the free gift. So, here we are in Excel and VBA building from scratch. Jul 25, 2011 - In addition to his efforts on the R/Finance organizing committee (of which Dirk Eddelbuettel, whom we profiled here earlier this year, is also a member), he has also developed a number of popular R packages for financial analysis -- most notably quantmod "At that point, I did most of my work in perl and Excel/VBA," he says.