#FREE Creating Interactive Dashboards in Excel 2013 #IT #Access

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.

LEVEL –  Intermediate

COURSE TOPICS:

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

READ MORE

LEARN THIS COURSE FOR FREE *10 days of free unlimited access to “Creating Interactive Dashboards in Excel 2013”

Instructor’s Welcome Note:

– Hi, I’m Nate Makdad and welcome to Creating Interactive Dashboards in Excel. In this course we’ll look at creating a template that can be used for dynamic chart displays and customized filtering to allow your stakeholders to get to the level of data they need with only a few clicks. I’ll start by showing you how to work with your data by applying some data management techniques to improve our production time in data quality. Then show you how to bring your data into Excel to start building your template with pivot tables. We’ll also see how to add slicers, create macros, and add action buttons to bring our template to life and make it an interactive experience.
We’ll be discussing all these features, plus discussing visual design concepts to build a robust and effective Excel dashboard. Now, let’s get started with Creating Interactive Dashboards in Excel.

 

 

Get 10 days of FREE unlimited access to Lynda.com.

Creating Interactive Dashboards in Excel 2013
Business Intelligence T
Nate Makdad tutorials
Lynda review

from Course reviews, freebies, coupons http://www.coursetag.com/free-creating-interactive-dashboards-in-excel-2013-it-access/