Dalia tried to use the Excel Interactive View to show data on the web, but she needs toShow/Hide Columns instead of Rows. Today, in Episode #1796 Bill shows us a way to Filter by Column using two Pivot Tables and a Slicer. To try out the Web App visit: Microsoft Excel Web App Example from MrExcel.
“Pivot Table Data Crunching Excel 2013“, by Bill Jelen. Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control!
Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power.
And if you need to know more about Microsoft Excel 2013 in depth…
“Microsoft 2013 InDepth” – by Bill Jelen has that information. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013.
“The Learn Excel from MrExcel Podcast Series”
Visit us: MrExcel.com for all of your Microsoft Excel Needs!