(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.
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.
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.
Join our live webinar to learn how to build a self-service BI environment that combines flexibility with a single source of truth. Discover how to balance freedom and governance, ensure data accuracy, and scale trusted, decision-ready analytics across your organization.
Discover how to speed up your Power BI reports and dashboards using proven best practices. In this free webinar, Zebra BI’s experts will show you how to optimize your data model, streamline visuals, and cut report load time from 15 seconds to under 1. Join us and learn how to build faster, smarter reports that scale.
September 8th
February 22nd
16 Dec 2025 
