(10:07) Creating a report from the pivot table
(10:14) Inserting a pivot table
(11:11) Formatting the pivot table
(12:18) Creating an interactive chart from a pivot table
(15:11) Disable autofit column widths on update
(17:18) Linking data to a new table without pivot table formula
(18:06) Flexibility of charts and linking values out of the pivot table
(20:53) Creating a report on a page layout
(21:13) Preparing the data: Transferring the pivot table to a page layout
(21:52) Linking the labels and inserting the charts
(24:09) Inserting borders
(25:26) Creating a column marker
(26:40) Aligning the labels
(27:10) Linking the pivot table to the report
(27:59) Inserting a Slicer
(30:15) Designing a Slicer
(30:21) Adjusting columns and rows
(32:20) Creating your own Slicer style
(34:11) Setting format – whole Slicer: Fonts, borders, fill
(34:53) Editing Header: Fonts, borders, fill
(35:30) Editing selected item with data: Fonts, borders, fill
(36:29) Editing unselected item with data: Fonts, borders, fill
(37:19) Editing hovered selected item with data: Fonts, borders, fill
(40:28) Editing and viewing the reports
(41:37) Publishing reports to SharePoint
(44:30) Creating a static chart from a pivot table
(45:29) Copying the worksheet
(46:00) Refreshing the tables
(46:13) Exporting your worksheets to PDF
(47:11) Exporting your worksheets to Excel Workbook
(48:51) Synchronized Slicer: Changed pivot table
(50:38) Adjusting Slicer navigation: Synchronizing Slicer with the filter
(52:59) Q & A
(1:03:22) Zebra BI resources and social media presence
Share this
Ready to start uncovering actionable insights from your data?
Explore Zebra BI for Office and Power BI, or start a trial instantly and test our tools on your data. You can also contact us to help you build your first test report and create a custom package for your business.
Your reports are ready. Decisions aren't. Learn how to close the Last Mile - live Power BI build, real client case, actionable framework. Free, 60 min.
Your reports are ready. Decisions aren't. Learn how to close the Last Mile - live Power BI build, real client case, actionable framework. Free, 60 min.
Join our live webinar to learn how to use Zebra AI to turn raw finance and business data into executive-ready dashboards that help Controlling & FP&A teams explain performance.
Discover how to build a sales dashboard that shows real results in context — spotlighting top performers, uncovering gaps, and driving action with clear, trusted data.
September 8th
February 22nd
