Financial Reporting with Microsoft Excel
7-8 May May 2018, Kuala Lumpur
About NASH Training:
Our courses are designed with the aim of providing our clients the latest practical tools and techniques crucial to solve business challenges within the organization. We also create a platform for our clients to gain invaluable experience through benchmarking and networking with their peers on a global scale. For all of our training courses, we target to equip our clients with the latest emerging trends, innovation practices and future opportunities for their respective industries, both locally and internationally.
Financial Reporting with Microsoft Excel:
Tired of the number crunching game & endless nights of preparing for reports manually? Wished that you could spend more time analysing your numbers instead of trouble shooting your report? This course will help you in learning useful tips & skills in generating your financial reports & to also analyse your data efficiently & effectively.
The objective of this course is to equip you with useful techniques in constructing your workbook in a manner that requires very minimal manual interventions in preparing your monthly reporting & to analyse your data efficiently
The objective of this course is to equip you with useful techniques in constructing your workbook in a manner that requires very minimal manual interventions in preparing your monthly reporting & to analyse your data efficiently.
At the end of this course, you will learn on useful functions & formulas to use in your financial reports, generate reports from trial balance to financial statements, create monthly and yearly financial reports, analyzing your top line & also analyzing your department OPEX with Microsoft Excel
- Day 1: Module 1: Financial Report Preparation
- Module 2: Useful Function & Formulas in Financial Report
- Module 3: Trial Balance to Financial Statements
- Module 4: Financial Ratios Analysis
- Day 2: Module 5: Creating MTD and YTD reporting with Variance Analysis
- Module 6: Department OPEX Analysis
- Module 7: Sales to Gross Margin Analysis
- Module 8: Case Study Application
Who Should Attend?
Accounting professionals that would like to further enhance their productivity at work through Microsoft Excel