Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,151,601 members, 7,812,967 topics. Date: Tuesday, 30 April 2024 at 12:14 AM |
Nairaland Forum / Entertainment / Events / Microsoft Excel Dynamic Dashboards For Management Reporting (379 Views)
Microsoft Excel Dynamic Dashboards For Management Reporting / Microsoft Excel Dynamic Dashboards For Management Reporting / Creating Dynamic Dashboards With Excel For Management Reporting Course (2) (3) (4)
(1) (Reply)
Microsoft Excel Dynamic Dashboards For Management Reporting by FINERESULTS(m): 7:20pm On Oct 01, 2019 |
Dear all, RE: Microsoft Excel Dynamic Dashboards for Management Reporting FineResults Research Services would like to invite you to high impact training on [b]Microsoft Excel Dynamic Dashboards for Management Reporting [/b]to be held in Nairobi from 18th-22nd November 2019 Event information Course Name: Microsoft Excel Dynamic Dashboards for Management Reporting Venue: FineResults Research, Nairobi, Kenya Event Date: 18th-22nd November 2019 Course Fee: KES 65000 or USD 800 Online Registration: REGISTER HERE INTRODUCTION Microsoft Excel Dashboards are reporting mechanisms that can deliver Business Intelligence (BI) in graphical form. Dashboards take raw data; allow it to be analysed 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 COURSE OBJECTIVES At the end of this training course , participants will 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 TOPICS TO BE COVERED Module 1: Introduction Understanding Management Dashboards • What is a Dashboard? • Principles of Great Dashboard Design • Dashboard Do’s and Don’t’s Working with your Data • Understanding Data Quality issues • Gathering data from different sources • Linking Data • Merging and Consolidating Data • Excel Hints and Tips when working with data Module 2: Using Advanced Formulas & Functions in Excel 2010/2013 • Referencing & Ranges • Advanced Lookup • Advanced Formatting Analysing Data with Advanced Pivot Table Techniques in Excel 2010 • Percentage • Computed Columns • Grouping & Sorting • Top Views • Multiple data sources • Using the dashboards with Excel Pivot Tables • Pivot Charts & Visual Dashboarding Techniques • Using external data sources such as The Web Module 3: Advanced Power Charting Techniques • Thermometer Chart • Doughnut Chart • Pareto chart • Using Shapes to make Charts more attractive • Using Alerts to draw attention to dashboards Creating Dynamic Dashboards with Excel 2010 / Excel 2013 for Management Reporting • Complete Management Dashboard for project KPIs • Complete Management Dashboard for Sales & Services • Best Practices in Dashboard Design • Versatile management dashboards • Dashboards Publishing Excel Dashboards to the Web Module 4: Dashboard Macros • Simple & Complex Macros • Dynamic Dashboards using Macros Module 5: Building Your Own Dashboard • This last session will be used to build some relevant Dashboards. Delegates are encouraged to bring examples of the dashboarding they would like to create during the training. TRAINING CUSTOMIZATION This training can also be customized for your institution upon request. You can also have it delivered your preferred location. For further inquiries, please contact us through Mobile: +254 732 776 700 / +254 759 285 295 or Email: training@fineresultsresearch.org REQUIREMENTS Participants should be reasonably proficient in English. During the trainings, participants should come with their own laptops. TRAINING FEE The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits. ACCOMMODATION Accommodation is arranged upon request. For reservations contact us through Mobile: +254 732 776 700 / +254 759 285 295 or Email: training@fineresultsresearch.org PAYMENT Payment should be transferred to FineResults Research Services Limited bank before commencement of training. Send proof of payment through the email: training@fineresultsresearch.org Visit our website for more details How to participate Individual Registration Contact information Email:training@fineresultsresearch.org TEL: +254 732 776 700 / +254 759 285 295 Website: fineresultsresearch.org/training/ Visit our face book page
|
(1) (Reply)
Shrink Your Belly In Less Than A Week / Nigeria Property Expo / Oloja Ekun Obaship Impasse: Court Okays Prince Toyin Akinde To Contest Stool
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 15 |