Course Details

Reporting effectively and in a meaningful way is a skill. Excel Dash Boards are most commonly used reporting standards in the corporate world. Excel provides an excellent platform with desired tools and equipment to present meaningful and attractive Dash Board expressing KPIs and other financial and non-financial indicators through the use of pictorial and graphical presentation.

Key Deliverables 1. Learn the use of Advance Excel for DashBoard Reporting 2. Understand conditional formatting and sparklines for Dash Boards 3. Get acquaintance of advanced Excel Techniques 4. Apply knowledge to summarize and consolidate data for Reporting Purpose 5. Understand pivot tables & slicers to be used in Dash Boards 6. Take insight of Macros for Reporting  7. Calculate important ratios using Excel  8. Master commonly used formulas in Financial Modelling 9. Identify Key finance indicators and organization’s financial dashboard using Excel 10. Evaluate Organization’s financial strategy and capital structures using Excel 11. Command Financial Modelling Skills

Who Should Attend a. Departmental Heads   b. Supply Chain Managers   c. Legal Department Managers   d. Project professionals   e. Customer Service Department   f. Sales & Marketing Professionals g. Procurement Department Staff h. Staff of Technical Department i. Internal Auditors j. Customer Support Department