Look Who it Was Random video

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

3,478 views · Published 12 June 2014 · 4:49 · Indexed 1 November 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

If the default slicer settings and color scheme is not acceptable for the dashboard, we can customize them. 
• Setup any column and row headers in your dashboard 
• Use a formula that can handle blank cells to reference the cells in your PivotTable; for example, =if(D4=0,"",D4) 
• Select every other row and change the fill color to simulate banded rows; you can alternatively format the cells as a table 

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

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