Description
Reporting effectively and in a meaningful way is a skill. Excel Dash Boards are most commonly used reporting standards in corporate world. Excel provides an excellent platform with desired tools and equipments to present meaningful and attractive Dash Board expressing KPIs and other financial and non financial indicators through use of pictorial and graphical presentation.
Key Deliverables
1. Learn use of Advance Excel for Dash Board Reporting
2. Understand conditional formatting and spark lines 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
Details
- Location / Region United Arab Emirates (UAE)/ Dubai
- Course Location: Learn with us at: CYBERMODO TRAINING CENTER Office 507, Rania Business Center, Al Barsha-1, Dubai, UAE (2 min of walk from Mall of Emirates-MOE, Opp. Citimax Hotel) Tel: +971 04-4579128 Mobile: +971 551136109 Email Add:info at cybermodo dot com Website: www.cybermodo.com
Features
Education Type
Education level
Beginner, Intermediate, Professional
Education Subject
Duration
18
Accredited by
KHDA
Payment Option
Study Material
Yes - Provided by Institute
Post New Review