Excel
Excel Reporting Guides
Pivot tables, dashboards, recurring report packs, change history, survey summaries, and chart workflows for business reporting.
9 guides.
reporting, dashboards
Pivot Tables: Automatically Update & Refresh When Source Data Changes
Learn how to pivot Tables: Automatically Update & Refresh When Source Data Changes using PivotTables. Follow clear steps, test the result, and know when the spreadsheet method needs automation.
workbooks, reporting
Show Changes and History of Edits from Multiple Users in Excel
Learn how to show Changes and History of Edits from Multiple Users in Excel using Excel. Follow clear steps, test the result, and know when the spreadsheet method needs automation.
dashboards, reporting
Build an Interactive Excel HR Dashboard with PivotTables & Slicers
Learn how to build an Interactive Excel HR Dashboard with PivotTables & Slicers using PivotTables. Follow clear steps, test the result, and know when the spreadsheet method needs automation.
dashboards, reporting
Introduction to Pivot Tables, Charts, and Dashboards in Excel
Learn how to introduction to Pivot Tables, Charts, and Dashboards in Excel using PivotTables. Follow clear steps, test the result, and know when the spreadsheet method needs automation.
dashboards, reporting
How to Create a Dashboard Using Pivot Tables and Charts in Excel
Learn how to create a Dashboard Using Pivot Tables and Charts in Excel using PivotTables. Follow clear steps, test the result, and know when the spreadsheet method needs automation.
reporting, dashboards
How to Analyze Survey Data: Summarize with Pivot Tables and Charts
Learn how to analyze Survey Data: Summarize with Pivot Tables and Charts using PivotTables. Follow clear steps, test the result, and know when the spreadsheet method needs automation.
reporting
How To Quickly Calculate Total Daily Averages With Pivot Tables
Learn how to quickly Calculate Total Daily Averages With Pivot Tables using PivotTables. Follow clear steps, test the result, and know when the spreadsheet method needs automation.
reporting, dashboards
How To Create An Actual Vs Target Chart In Excel
Learn how to create An Actual Vs Target Chart In Excel using Excel. Follow clear steps, test the result, and know when the spreadsheet method needs automation.
reporting, exports
Create Multiple Pivot Table Reports with Show Report Filter Pages
Learn how to create Multiple Pivot Table Reports with Show Report Filter Pages using PivotTables. Follow clear steps, test the result, and know when the spreadsheet method needs automation.