![]() ![]() a good command in using worksheet functions such as SUM, MAX, MIN, VLOOKUP and especially the IF functions, and conversant in writing worksheet formulae for a given problem. ![]() High-level users who need expert skills in using Excel to build simple financial models. Growth of investment in different assets.Allowance for changing interest rates or repayment period.Object-based concept: Objects, methods and properties.Part 1 Excel VBA fundamentals and its application in Finance Upon completion of this course, participants would have learned the fundamentals of Excel 2007 VBA and how to apply it to build simple yet commonly used spreadsheet models for financial data analysis. It can be used to overcome the limitations of Excel and automate spreadsheet procedures. VBA (Visual BasicĀ® for Applications) is the built-in macro programming language in Microsoft Office applications. Financial Modeling with Microsoft Excel 2007 VBA
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |