Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Advanced Excel Dashboards Course

By: Foscore Development Center

Kenya

05 - 09 Sep, 2022  5 days

Follow Event

  

USD 1,000

Venue: Foscore Development Center, Nairobi Kenya

Other Dates

Venue Date Fee  
Foscore Development Center, Nairobi Kenya, Kenya 28 Nov - 02 Dec, 2022 USD1000

This course teaches participant on how to create interactive Excel dashboards that update with the click of the Refresh button, or with a simple copy and paste of your new data into your spreadsheet. Excel Dashboards provide insight, analysis and even alerts. They are interactive and dynamic, and have a wide range of applications, providing help with project management, customer service, KPI management, forecasting and so on. They usually fit on one page, displaying key trends, comparisons and data in small graphs or tables. This makes them easy to read and digest the information

Who Should Attend?

Anyone with an advanced knowledge of Excel who wants to learn how to create dashboard which will enhance their spreadsheets with easily understood and interactive data displays.

Course Objective:

  • Creating Professional Dashboards
  • Pivot Tables and Pivot Charts, Conditional Formatting, Functions, Formulas and Macros
  • Create visualizations charts

Course Content

Module 1:  Introduction to Dashboards

Module2:  Inserting Graphics for a Dashboard

  • Inserting a Chart
  • Sparkline’s with Dashboards
  • Tables to Dynamically Link Charts and Lists
  • Linking Charts Across Worksheets

Module 3: Functions and Formulas

  • The OFFSET Function
  • Nested IF Statements Using the AND and OR Operators
  • VLOOKUPs
  • The MATCH Function

Module 4:  Dashboard Navigation

  • Creating Bespoke Navigation Bars
  • Creating Dashboard Links
  • Using Named Objects

Module 5: Workbook’s Layout and Structure

  • Organizing Data in Data Tables using IFs
  • Table Formulas to Make Dynamic Charts
  • Table Formulas with Conditional Formatting
  • OFFSETs, VLOOKUPs and Name Range Lists

Module 6:  Using Excel Objects for Specialist Dashboard Views

  • Adding a Data Bar into your Dashboard
  • Creating a Window Chart
  • Creating an Advanced Comparison Chart
  • Creating a Timeline Chart

Module 7: Using Macros and VBA with Dashboards

  • Macros and the Visual Basic Interface
  • Configuring Controls using Macros
  • Ironing out Minor Issues in your Dashboard with VBA
  • The Select Case

Note

  • All our courses can be Tailor-made to participants needs
  • Presentations are well guided, practical exercise, web-based tutorials and group work. Our facilitators are expert with more than 10years of experience.
  • Upon completion of training the participant will be issued with Foscore development center certificate (FDC-K)
  • One-year free Consultation and Coaching provided after the course
Foscore Development Center, Nairobi Kenya Sep 05 - 09 Sep, 2022
Foscore Development Center, Nairobi Kenya, Kenya 28 Nov - 02 Dec, 2022

Registration: 09:00:am - 04:30:am

USD 1,000.00
(Convert Currency)

Jackson Munene +254712260031

A discount of 20% for 5 or more participants
Foscore Development Center

Related Courses

Quantitative Data Management and Analysis with SPSS Course Quantitative Data Management and Analysis with SPSS Course

5 days, 12 - 16 Sep, 2022 

2022-09-12 12:09:00 2022-09-12 12:09:00
Kenya

Foscore Development Center

Introduction The training is essential in the development of better understanding of the concepts of statistics. It will provide the participants with a general idea of computer assisted data ...

Impact Evaluation for Evidence-Based Policy in Development Course Impact Evaluation for Evidence-Based Policy in Development Course

12 days, 27 Jun - 08 Jul, 2022 

2022-06-27 12:06:00 2022-06-27 12:06:00
Kenya

Foscore Development Center

The course aimed to address an important prerequisite for incorporating impact evaluation (IE) into programme design: a theoretical and practical understanding of IE approaches to enable selection of ...

Trauma Support and Counselling Course Trauma Support and Counselling Course

5 days, 11 - 15 Jul, 2022 

2022-07-11 12:07:00 2022-07-11 12:07:00
Kenya

Foscore Development Center

The course equips you with the relevant knowledge, skills and values to identify clients exposed to traumatic events and provide trauma support services in the immediate aftermath of traumatic ...

Gender Mainstreaming, Analysis and Planning Course Gender Mainstreaming, Analysis and Planning Course

5 days, 18 - 22 Jul, 2022 

2022-07-18 12:07:00 2022-07-18 12:07:00
Kenya

Foscore Development Center

Gender equality and empowerment is considered a critical element for development. This course is designed to prepare participants for a variety of careers where specialized knowledge is required ...