Advanced Dashboard Management in Excel

Microsoft Excel offers lots of dashboard creation tools and techniques, making it easier than ever to gather data and use the data to create Powerful Reports, Scorecards, and Dashboards.

You probably know that to create awesome Excel Dashboard reports requires a thorough knowledge of many Microsoft Excel techniques, but also principles of good Visual Design, and learning this practical knowledge takes a significant investment of time.

If you have been looking for a course to teach you how to create your very own awesome dashboards in Excel, then this is the perfect course for you. This course will teach you how to create amazing interactive Dashboards in Microsoft Excel. They’ll wow your boss and take your career to the next level.

This comprehensive course that covering Dashboard Design Principles, Basic and Advance Charting techniques, Interactive Excel Form Controls, Data Analysis and Publishing and much more.

Key Takeaways
  • Power Packed Knowledge

    Participants will get Power Packed knowledge to create an Awesome and award winning Dashboards in Excel. The workshop will focus on the detailed Tips and tricks to work with Basic and Advance Dashboard development. Creating dynamic dashboard within a minute to impress your Management.

  • Programme Completion Certificate

    The Participants will get the Programme Completion Certificate from Future in Hands.

  • Full of Freebies

    All the Participants will get full of Freebies in their Laptop or Pen Drive. It will contains:

    • Theoretical concepts required to Build Dashboards
    • Sample Files covered during the Programme
    • A comprehensive Guide to Create Awesome Dashboards in Excel
    • 10 Tips for Building a Dashboard in Excel
    • 5 Tips for Compelling Dashboards
    • Premium reusable KPI Dashboards
    • Bulk Files and Assignments for Practice
    • Premium eBooks for becoming Dashboard Ninja
    • Much More
  • Premium Access to iLearn

    All the candidates will get the life Premium Access to iLearn – Your Learning Management System. This is our Learning Portal where you can get the access to the world of Learning that includes:

    • Knowledge Bank
    • Brilliant Tips & Tricks related to difference technologies and industries
    • Library with great collection
    • Career Planners
    • Interview Questions
    • Assessments and Mock Tests
    • Job Opening Information
    • Lounge to meet our Alumni s
    • Much more
  • Premium Access to Future in Hands club

    All the candidates will get the lifetime Premium Access to Future in Hands club. It is our Discussion Forum specially designed for our learners across different location. The club is meant for our learners to help each other in any point of time. There are lots of idea sharing and helping each other on their work. You can get the best solutions by other experts. It will help you to solve your queries even after the Training.

Coverage

Initial Warmups

  • Introduction to Advanced Dashboard Management
  • Importance of Dashboard
  • Use of Dashboard in Corporate Environment
  • Dashboard capabilities in Microsoft Excel
  • Dashboard Components

Overview of BASICS

  • Important Functions used in Dashboard Development
  • Excel Name Management using Name Manager
  • Dynamic Report using Excel Table

Working with Basic Charting

  • Introduction to Basic Charting
  • Elements of Charts and its importance
  • Columns Chart & Types
  • Bar Chart & Types
  • Line Chart & Types
  • Pie Chart & Types
  • Donought Chart & Types
  • Radar Chart
  • Combination Charts or Combo Charts

Pivot Table based Dashboard Development

  • Introduction to Pivot Charts
  • Working of Slicer
  • Working with Timeline
  • Development of Basic Dashboard using Pivot Table
  • Working on Advance Dynamic Dashboard using Pivot Table

Working of Form Controls

  • Introduction to Form Controls
  • Preparing Basic Dashboard using Form Controls
  • Working with Advance Dashboard using Form Controls
  • Controlling Conditional Formatting using Form Controls

Filter Based Dashboard Development

  • Introduction to Custom Views
  • Dashboard Development using Excel table & Slicer – A Filter Approach
  • Advance Dashboard using Custom Views – The Macro Automation Approach

Customizing Chart Elements

  • Creation of Scrollable Chart
  • Customizing Charts to create Interactive Chart using Form Controls
  • Controlling Visibility option of Chart Elements using Form Controls
  • Controlling Data Points using Form Controls
  • Controlling Trendline using Form Controls
  • Preparing Dynamic MAX-MIN Terminals using Form Controls and Smart Calculations

Working with Advance Charting

  • Creating Dynamic Charts using Excel Tables
  • Creating Dial Charts
  • Creating Speedometer or Gauge Charts
  • Creating Thermometer Charts
  • Creating Battery Charts
  • Creating Traffic Charts
  • Working with Tiny Charts – Sparklines
  • Using Conditional Formatting in Charts
  • Dynamic Charts using OFFSET
  • Creating Interactive Dashboards using Hyperlink
  • Creating Interactive Dashboard using Range Selection – The Macro Approach
  • Creating Picture LOOKUPS using Camera Tool
  • Create Inline Charting using REPT
  • Creating Customer Rating Chart using REPT and Special Fonts

Knowledge Sharing

  • Dashboard Do’s & Don’ts
  • A Guide to Create Awesome Dashboards
  • 10 Tips for Building a Dashboard in Excel
  • 5 Tips for Compelling Dashboards
  • Bunch of out of Syllabus Tips & Tricks for Advance Dashboard Management.
Who should attend?
  • Executives
  • Managers
  • General Managers
  • Vice Presidents
  • Senior Management
  • MIS Personal
  • BPO Professionals
  • KPO Professionals
  • Finance & Accounts Personal
  • Human Resources
  • Quality Analyst
  • Analyst
  • Data Analyst
  • Reporting Analyst
  • Project Managers
  • Software Engineers
  • Research Professionals
  • Business Analyst
  • Business Development Professionals
  • Software Testing Engineers
  • Banking Professionals
  • Entrepreneur
  • Businessman
  • Freelancers
  • Students