lynda

Creating Interactive Dashboards in Excel 2013


  • flag Lynda
  • student Intermediate
  • database eLearning
  • earth English
  • clock 2h 34m

About

Learn how to explore and analyze your data by creating an interactive dashboard in Excel using pivot tables and a little Visual Basic. Using these lessons^ you can create a dynamic template to generate reports for customers and to better understand your own data. Along the way^ you ll learn how to import external data^ design a template using pivot tables^ and add slicers^ macros^ and action buttons to make the template more interactive. Author Nate Makdad also shares some basic principles of visual design to guide you in developing an easy-to-use and visually appealing report.

Covered topics:

  • Business
  • Business Intelligence
  • IT
  • Access
  • Excel