Microsoft Excel Master Class
Microsoft Excel Master Class
All courses should be registered through the following link to receive final confirmation on registration and attendance-
http://entrepreneurslb.academy/trainingregistration.html
Delegates will need some basic knowledge of Excel but not of professional modeling or programming. Some of the topics that will be discussed include:
· The 40 Excel functions that financial modelers use the most
· Best practice in modeling forecasted financial statements (Balance Sheet, Income Statement, and Cash Flow Statement)
· The powerful combination of arrays, the offset function, the match function and drop down menus
· The danger of using IRR in isolation and possible solutions
· Modeling and automating ratio analysis in Excel
· Various Optimization solutions using Excel Solver (cash and inventory management, capacity planning and capital budgeting)