Microsoft Excel - Creating Dynamic Dashboards
By Erin Olsen
Publisher: Infinite Skills
Final Release Date: November 2014
Run time: 4 hours 59 minutes

In this Microsoft Excel - Creating Dynamic Dashboards training course, expert author Erin Olsen teaches you how to use Excel features and techniques to create dynamic dashboards in order to present complex data. This course is designed for users that already have a basic working knowledge of Excel.
You will start by learning how to prepare the data, then jump into building the dashboard. Throughout the course, you will be working to create a dashboard that provides a summary of a person's health information. Erin will teach you how to optimize Excel data for use in dashboards, create visual dashboard components, and add interactivity to customize them for each user. This video tutorial also covers how to create a distribution histogram, use a waffle chart to show progress, and add actions to buttons. Finally, you will learn how to generate dashboards as output, produce them as a PDF, and present them with PowerPoint or share via OneDrive.
Once you have completed this computer based training course, you will have gained the knowledge and skills necessary to create your own dynamic dashboards in Excel. Working files are included, allowing you to follow along with the author throughout the lessons.

Table of Contents
Product Details
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyMicrosoft Excel - Creating Dynamic Dashboards
 
3.3

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (1)

67%

of respondents would recommend this to a friend.

Pros

  • Easy to understand (3)

Cons

No Cons

Best Uses

No Best Uses

Reviewed by 3 customers

Displaying reviews 1-3

Back to top

 
4.0

Helpful and easy to follow

By Grey Um

from UK

About Me Sys Admin

Verified Buyer

Pros

  • Easy to understand
  • Helpful examples

Cons

  • Too basic

Best Uses

  • Intermediate

Comments about oreilly Microsoft Excel - Creating Dynamic Dashboards:

Very good at its topic so can't fairly criticise this, however it left me wanting more.. not of the topic but the other subjects it touches on
In summary I would recommend this product

 
1.0

OK'ish

By SimonC

from London, England

About Me Senior Management Da

Verified Buyer

Pros

  • Concise
  • Easy to understand

Cons

  • Not comprehensive enough
  • Too basic

Best Uses

    Comments about oreilly Microsoft Excel - Creating Dynamic Dashboards:

    Video Course which is split out into self explanatory chapters. If I were beginning building dashboards with Excel it would be fine... but, unfortunately, I've been using excel for sometime and this was just way too basic for my needs... didn't find anything that I wasn't already doing several steps better than in the examples.

     
    5.0

    I would buy this product again and again

    By CapedPlayto

    from Cape Town, South Africa

    About Me Designer

    Verified Reviewer

    Pros

    • Accurate
    • Concise
    • Easy to understand
    • Helpful examples
    • Well-written

    Cons

      Best Uses

      • Expert
      • Intermediate

      Comments about oreilly Microsoft Excel - Creating Dynamic Dashboards:

      Thank you Erin!

      You are a natural Teacher. Not too much info, but certainly enough!

      Already Listed our other videos on my Wishlist for later download!

      Displaying reviews 1-3

      Back to top

       
      Buy 2 Get 1 Free Free Shipping Guarantee
      Buying Options
      Immediate Access - Go Digital what's this?
      Video:  $49.95
      (Streaming, Downloadable)