» » » Creating Interactive Dashboards in Excel 2013

Information of news
  • Author: Solid
  • Date: 16-06-2015, 01:01
16-06-2015, 01:01

Creating Interactive Dashboards in Excel 2013

Category: Tutorials » Other

Creating Interactive Dashboards in Excel 2013
Creating Interactive Dashboards in Excel 2013
Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch
(2h 34m Intermediate Jun 15, 2015)

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.
Topics include:
*Defining your requirements
*Setting up data
*Adding reference tables
*Creating hierarchy in the layout
*Choosing color and typography
*Importing data
*Inserting slicers
*Recording a macro
*Editing VBA code
*Improving the user experience

Always check out my other posts, you find interchangable mirror if you want!
but Don't report my post, Enjoy!


Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.