Hotlines: +234-8035786640, 8127708077 | Email: info@walktalkblogsystems.org

Creating Dashboards In Excel

12,000.00 8,500.00

Rating: SKU: Unit. Category:

Learn The Principles And Steps  Create interactive Dashboards In Excel. This is a virtual program that you can take right from the comfort of your home.

Product Description

This course teaches you about the concept of dashboards and how to build user-friendly dashboards in Excel. You can take this training right from the comfort of your home.

FROM THE VIRTUAL OFFICE OF EMMANUEL DANIELS

3-5 Day Courses in Excel are good but you cannot learn everything in 3 -5 days. In fact, I Started learning Excel 17 years ago and I am still learning because the program is so deep.
To Help you enhance your skills outside those 3-day programs, I have created this Dashboard tutorial  which is now officially launched on 24/7/2017, apart from the advanced Excel and VBA for Excel Courses I created in 2014.

THIS COURSE TEACHES YOU…” ALL ABOUT DASHBOARDS IN EXCEL”

FOR WHOM?

    1. Those who prepare business intelligence reports
    2. Managers, accountant, HR Specialists, Production managers, marketing managers etc

WHY SUBSCRIBE FOR MY VIRTUAL TRAINING?

You cannot learn Excel in 3 days – Use this program to build you skill set over time If you cannot pay N50,000 to N100,000 to take your Excel Skills to an Advanced Level, this program is for you; If you have no time to attend those 3-days crash courses, this program is for you

CONTENTS OF THE DASHBOARD TUTORIAL

    1. What Is A Dashboard ?

 

    1. Data Source For Your Dashboard Presentation

 

 

    1. Excel Functions For Dashboard Presentation

 

    1. Starting With Excel Charts For Dashboard

 

    1. Creating A Bar chart

 

    1. Creating A Column chart

 

    1. Creating A Line chart

 

    1. Creating A Combo chart

 

    1. Creating A Pie chart

 

    1. Creating An Area chart

 

    1. Creating A Scattered chart

 

    1. Creating A Stock chart

 

    1. Creating A Surface chart

 

    1. Creating A Radar chart

 

    1. Creating A Two-Axis Chart

 

    1. Adding A Series To An Existing Chart

 

    1. Handling Missing Data

 

    1. Introduction To Chart Formatting

 

    1. Formatting Chart Axes, Titles & Legends

 

    1. Introduction To Pivot Table

 

    1. Understanding Pivot Table Field List

 

    1. Working Through The Pivot Table Contextual Tab

 

    1. Working With Date Field

 

    1. Grouping By Other Factors on A Pivot Table

 

    1. Introduction To Slicers

 

    1. Creating A Pivot Chart

 

    1. Extracting Information From A Pivot Table/Pivot Chart

 

    1. Starting With Excel Charts For Dashboard

 

    1. Creating A Histogram From A Pivot Table

 

    1. Charting A Survey Result From A Pivot Table

 

    1. Creating Sparklines

 

    1. Creating Dynamic Labels

 

    1. Using Excel Camera Tool

 

    1. Creating Formula Driven Labels

 

    1. Using Fancy Fonts For Visualization

 

    1. Introducing Macros For Dashboard

 

    1. Creating Navigation Buttons With Macros

 

    1. Changing Chart Types With Macros

 

    1. Showing Trends On Our Dashboard

 

    1. Grouping Data On Dashboard

 

    1. Measuring Performance Against Target

 

    1. Adding Interactive Controls – Checkbox, Combo box, List Box, Option Button

 

Reviews

There are no reviews yet.

Be the first to review “Creating Dashboards In Excel”

Your email address will not be published. Required fields are marked *