About Workshop
Microsoft Excel is the most commonly used spreadsheet application in the world. Excel can play a crucial part in your business, and is essential for producing accurate numeric data. The vast majority of businesses use Microsoft Excel every day to produce accounting and financial reports, budgets, and many more crucial numeric data tasks, but few appreciate the extent of the features and functions within the software. This course will enable you to maximize the potential of the powerful Microsoft Excel software to produce more professional business information. This course is designed to equip participants with the technical knowledge of building financial models in Excel. The aim is to bridge the gap between financial theory and practice. Modeling skills acquired to develop sample applications in this course will provide participants with the tools and confidence to build their own finance applications.
Workshop topics to be covered:
- Formula Auditing
- Goal Seeking
- Solver Tool
- Working with Scenarios
- What-IF Analysis
- Ratio Analysis
- Break-Even Analysis
- Data Tables
- Charts in Financial Modeling
- Loan Repayment Schedule
- Calculating Interests
- Discount Cash Flow Analysis
- Forecasting and regression analysis
- Pivot Table Report
- Pivot Table Chart
- Functions: PV, NPV, XNPV, IRR, MIRR, XIRR, RATE, NPER, FV, FVSCHEDULE, PMT, PPMT, etc.
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
