Creating Interactive Dashboards in Excel 2013

[Alexandr 3]

 

Creating Interactive Dashboards in Excel 2013

English | 2h 34m | AVC (.mp4) 1280x720 15&30fps | AAC 48KHz 2ch

Genre: eLearning

 

 

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 prin[beeep]les 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

DOWNLOAD

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.