Home»2022»December»12»Lynda Creating Interactive Dashboards in Excel 2013
19:39:10
Lynda Creating Interactive Dashboards in Excel 2013
Included Exercise Files
Skill Level : Intermediate
Duration : 2h 34m
Language : English
Released : 7/3/2015
Size : 402,35 Mb
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
