Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

Lynda - Creating Interactive Dashboards in Excel 2013

Posted By: U.N.Owen
Lynda - Creating Interactive Dashboards in Excel 2013

Lynda - Creating Interactive Dashboards in Excel 2013
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 principles of visual design to guide you in developing an easy-to-use and visually appealing report.

* 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


Lynda - Creating Interactive Dashboards in Excel 2013

No mirrors below please.