Look Who it Was Random video

Excel 2013 Dashboard Design Tutorial: Implementing Slicers | packtpub.com

3,352 views · Published 19 September 2014 · 3:50 · Indexed 28 October 2026

Channel: Packt · 2014 · Science & Technology

Watch on YouTube

Part of 'Excel 2013 Dashboard Design' video series. For the full Course visit:
http://www.packtpub.com/excel-2013-dashboard-design/video?utm_source=youtube&utm_medium=video-description&utm_campaign=yt-excel2013dashboard

To make an interactive experience with a dashboard based on PivotTables, we can use slicers to let the end user focus as wide or as narrow as they would like, at the click of a button. 
• Click on the intersection of the row and column labels to select all the cells in the worksheet, and choose a fill color from the paint bucket button 
• Set charts to move independently of cells by clicking on Format Chart Area and selecting Don't move or size with cells 
• Move PivotTables between sheets by clicking on any cell in a PivotTable; click on Analyze, and Move PivotTable and then select the destination cell 

------------------------------------------------------------------------------------------------

For the latest in   video tutorials, please visit:
http://www.packtpub.com/books/video?utm_source=youtube&utm_medium=video-description&utm_campaign=yt-excel2013dashboard

Find us on Facebook -- http://www.facebook.com/Packtvideo
Follow us on Twitter - http://www.twitter.com/packtvideo

More from this channel