Training Course on Creating Dynamic Dashboards with Excel for Management Reporting.

Event: Training Course on Creating Dynamic Dashboards with Excel for Management Reporting.

Venue: Indepth Research Services Centre Kenya.

Event Date: 19th -23rdJune 2017.

INTRODUCTION:

Microsoft Excel Dashboards are a reporting mechanism than can deliver Business Intelligence (BI) in graphical form. Dashboards take raw data; allow it to be analyzed and presented in a form that is of most benefit to the end user.

The idea of information dashboards is to have the most important information such as KPIs presented within a single page that allows people to understand what is going on and make decisions.

DURATION:

5 days.

WHO SHOULD ATTEND:

This training course is ideal for individuals working in Monitoring and Evaluation officers, Statistician, Programmes and Project managers, Project officers, Managing Directors, General Managers, Sales &Marketing analysts, Financial Analysts, IT Executives, Engineers, Directors, and Data Warriors who dabble with data and want to learn advanced techniques to convert Data into actionable Information.

COURSE OBJECTIVES:

Upon completion of this training course, participants are expected to be able to:

• Differentiate between Reports and dashboards
• Discuss the benefits of an Excel dashboard
• Assemble all data needed for a dashboard
• Identify ground rules for creating effective dashboards
• Show how to enable the Developer tab in Excel
• Understand the Data Model
• Create dynamic charts
• Create Pivot tables
• Create Pivot Charts
• Modify Pivot tables and charts
• Apply conditional formatting to a dashboard
• Identify and apply Excel functions (IF, CHOOSE and VLOOKUP)
• Design and build a dashboard from raw data to the finished product

Tailor-Made Training

This training can also be customized for your institution upon request to a minimum of 4 participants. You can have it delivered in our training centre or at a convenient location.

How to participate

• Tailors make your course.
• Register individual.
• Register as a group.

View related courses

• Training Course on Introduction to Occupational Health and Safety.
• Training Course on Nutrition Assessment and Survey using ENA/ EPIINFO.
• Training Course on Introduction to Health Systems Management.
• Training Course on ICT for HIV/AIDS Surveillance and Reporting

The most popular courses.

• Training Course on Mapping Nutrition Preparedness in Emergency.
• Training Course on Qualitative Data Management and Analysis with NVIvo (Concept & Approaches).
• Training course on Participatory M&E for Rural Development and Community Managed Programmes.
• Training Course on Microsoft Excel for Health Care Professionals.
• Training Course on Mainstreaming Disaster Risk Reduction into National Development Process.
• Training Course on GIS and remote sensing in multi hazard early warning systems.
• Training Course on Procurement and Supply Chain Management.

View course catalogue on ICT4D and mobile technologies Institute. 

For further inquiries, please contact us on Tel: +254 715 077 817, +254 (020) 211 3814, +254 731240802, +254 735331020.

Email: [email protected]

Others Details

Accommodation is arranged upon request. For reservations contact the Training Officer.