Creating Interactive Dashboards in Excel 2013 With Nate Makdad

[xidau123 14]

Creating Interactive Dashboards in Excel 2013 With Nate Makdad

Size: 669MB | Duration: 2h 34m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch

Genre: eLearning | Level: Intermediate | Language: English

 

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

 

 

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.