->
Lynda - Creating Interactive Dashboards in Excel 2013 - 374773
Lynda - Creating Interactive Dashboards in Excel 2013
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.


Table of Contents

  • Introduction
  • 1. Introduction to Dynamic Dashboards
  • 2. Preparing Your Data
  • 3. Designing Your Visual Layout
  • 4. Designing the Report
  • 5. Improving User Experience
  • Conclusion
  • Lynda - Creating Interactive Dashboards in Excel 2013


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss