Brief Introduction
Create stunning and fully interactive data visualizations in Excel 2013Description
Excel 2013 Dashboard Design will show you how to turn your organization’s data into a powerful and interactive dashboard. By learning these easy-to-implement, advanced techniques, you can impress and empower the decision-makers in your organization, making you an irreplaceable asset.
Excel 2013 Dashboard Design begins by creating a vision for the dashboard with the help of stakeholders, and then moves on to gathering the data and building each element of the dashboard. The course ends with comparing distribution strategies appropriate for every size and type of organization.
The first section, Outputs and Inputs, covers the strategic aspects of planning your finished product and bringing in all of the necessary data from your database or Excel workbook. We then explore PowerPivot, a powerful bridge between your raw data and Excel. PivotTables will help us slice our data in a flexible manner, and Charts give us at-a-glance comprehension of important metrics and trends. Stylizing and Interactivity enhance the user experience and present the information in a manageable format. Publication can be problematic without proper planning, but we’ll cover the most effective ways to distribute your dashboard to any type or size of audience.
Excel 2013 Dashboard Design will guide you through your entire project, start to finish, covering every part of the process in depth. Since you’ll not only learn how to do each task, but also why it would be beneficial for you, you’ll be able to easily translate your learning into your own dashboard design project.
About the Author
Tony Kau is a Tableau Desktop 8 Qualified Associate, and he is putting its power to use in his role as a reporting analyst for a Fortune 500 company. His analytical background spans a decade, during which he has used a variety of business intelligence software, though none were better than Tableau. His passion is efficiently leveraging data to inform strategic business decisions.
He holds a degree in Business Administration from the University of Oregon, and his background includes web design, programming, and financial analysis.
Requirements
- Requirements
- This course has in-depth coverage of Excel Dashboards for a duration of 4 hours. Our course is focused on Dashboard designing only.
The Complete Business Plan Course (Includes 50 Templates)
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Everything You Need to Make a Great Business Plan by an Award Winning Business School Prof, VC & Successful Entrepreneur ...
Create Database Applications Using MS Access 2013
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Create real world database applications. Easy to Follow Lectures. Boost Your Resume and Earning Potentials!. What's in it for you? In this course, you will learn how to:...
The Complete Personal Finance Course: Save,Protect,Make More
- 4.6
-
![]()
![]()
![]()
![]()
![]()
3 Courses in 1! Save,Protect & Make More! By an Award Winning MBA Professor, VC & Best Selling Online Business Teacher....
Increasing Real Estate Management Profits: Harnessing Data Analytics
- 4.7
-
![]()
![]()
![]()
![]()
![]()
In this final course you will complete a Capstone Project using data analysis to recommend a method for improving profits for your company, Watershed Property Management, Inc....
