by Tony Kau | Released May 2013 | ISBN: 9781849696388

Create stunning and fully interactive data visualizations in Excel 2013About This VideoUtilize your existing data and turn it into valuable business intelligencePresent key information with straightforward, eye-catching reportsBuild highly interactive reports using some of the best new features in Excel 2013Implementation of these techniques is made simple with this easy to follow, step by step guideIn DetailAs businesses collect increasing amounts of vital data, the need for an effective and intuitive interface increases every day. Excel 2013 is a natural tool to handle these business intelligence projects because you’re working in a familiar environment and harnessing Microsoft’s powerful enterprise-level software. This video course provides you with all the information you need to know to create a fully interactive dashboard, making you invaluable to your organization.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. Show and hide more

1. Section 1: Dashboard Outputs and Inputs
   • Beginning with the End in Mind 00:03:51
   • Empowering your Audience 00:05:11
   • Connecting to MS Access 00:03:10
   • Connecting to MS SQL Server 00:02:33
   • Using data in your Excel Sheet 00:02:14
2. Chapter 2: Implementing PowerPivot
   • Importing Data into PowerPivot 00:03:20
   • Adding Data from Excel to PowerPivot 00:02:27
   • PowerPivot Relationships and Hierarchy 00:02:49
   • Creating Calculated Fields 00:04:15
   • Implementing KPIs 00:03:17
3. Chapter 3: Working with PivotTables
   • Constructing PivotTables (part 1) 00:05:07
   • Constructing PivotTables (part 2) 00:04:36
   • PivotTable Formatting and Options 00:04:15
   • PivotTable Design and Layout 00:04:08
   • Adding a Calculated Field and KPI 00:04:02
4. Chapter 4: Constructing Your Framework
   • Creating a PivotChart 00:03:33
   • Customizing a PivotChart 00:03:05
   • Creating a Combo Chart 00:04:56
   • Customizing a Combo Chart 00:05:42
   • Creating Text-highlight Cells 00:03:44
5. Chapter 5: Stylizing Your Data
   • Formatting the Dashboard Sheet 00:05:18
   • Referencing a PivotTable 00:04:47
   • Conditional Formatting 00:04:07
   • Implementing Sparklines 00:02:52
   • Enhancing Sparklines using Named Ranges 00:08:01
6. Chapter 6: Adding Interactivity
   • Implementing Slicers 00:03:42
   • Customizing Slicers 00:04:42
   • Employing Timelines 00:05:16
   • Utilizing Hyperlinks 00:03:08
7. Chapter 7: Utilizing Power View
   • Creating a Power View 00:03:47
   • Creating Drill-downs in Power View 00:02:49
   • Using Filters in Power View 00:03:37
   • Implementing Tiles in Power View 00:02:35
   • Visualizing Multiples in Power View 00:03:02
8. Chapter 8: Publishing Your Dashboard
   • Cleaning Up and Locking Down 00:06:33
   • Backwards Compatibility and SharePoint Distribution 00:03:08
   • Sharing on Microsoft SkyDrive 00:04:57
   • Publishing on Office 365 SharePoint 00:03:48
   • Printing and Exporting to PDF 00:04:33
Show and hide more