Get ahead before the holidays. Individual webinars are $149 throughout October. *Pricing automatically applied in cart.

Building a Reporting Tool with Pivot Tables in Excel

Access this expert-led webinar instantly, available anytime on-demand.

4.7
Included in All-Access Membership
Live Webinar - no upcoming date
Customer Satisfaction Guarantee Learn with confidence. If you're not happy, we'll make it right. That's our guarantee.

Purchase Options

Select an attendee quantity to add to cart.

Recorded Webinar Only

$219.00 $149.00
or

All Access Membership

The Aurora All Access Membership is designed to provide you with the training that you want when you want it. You will have 100% access to every live webinar, on demand webinar, professional alert, and podcast that Aurora Training Advantage offers with no additional cost.

Learn More About Our All Access Membership
$599.00
All Access Membership

Unlock the power of Excel's data analysis and Business Intelligence (BI) toolkit with Pivot Tables. Whether you're aiming to construct dynamic dashboards, conduct in-depth data analysis, or streamline data summaries for personal or business purposes, Pivot Tables are your key to success.

In just a few clicks, without the need for complex formulas, you can effortlessly generate insightful reports, dynamic dashboards, and informative charts. These tools empower you to summarize, analyze, interpret, and gain a deeper understanding of your data, enabling you to uncover trends and derive answers to critical questions that drive your key business decisions.

Despite their reputation for complexity, Pivot Tables are surprisingly accessible and user-friendly. Join our training session to demystify their usage and learn how to create them effectively.

Your Benefits For Attending:
  • Harness the full potential of Pivot Tables to transform raw data into meaningful and enlightening reports and summaries.
  • Learn the optimal data structuring techniques to maximize the effectiveness of Pivot Tables.
  • Master the art of designing and formatting Pivot Table reports for clarity and comprehension.
  • Explore diverse data summarization methods, including totals, counts, and percentages.
  • Convert Pivot Tables into visually engaging charts.
Why You Should Attend

Pivot Tables are indispensable tools for professionals across a spectrum of industries, from global enterprises to burgeoning startups and small businesses.

Acquiring the skill of creating Pivot Tables is a must for anyone seeking to leverage Excel for rapid report and summary development. This training will equip you with a strong foundation to build your own Pivot Tables and reports.

Topics Covered:
  • Use cases: Identifying scenarios where Pivot Tables shine
  • Raw data best practices: What to do and what to avoid
  • Create Pivot Tables effortlessly with a few simple clicks
  • Data summarization techniques: Totals, counts, and percentages
  • Apply formatting for enhanced readability and comprehension
  • Arrange Pivot Table data alphabetically or numerically
  • Visualize Pivot Table data through charts and graphs
  • Managing updates when source data changes
  • Using Slicers to Slice, Dice and Filter your data
  • GETPIVOTDATA – What is it, when to use it and when to avoid it
Who Should Attend

This training is suitable for individuals who want to harness the power of Pivot Tables in Excel, whether you aim to swiftly create reports and summaries or simply enhance your Excel proficiency.

You don't need advanced Excel skills to participate; if you can create basic worksheets, copy and paste, and apply fundamental formatting to cells, you'll be able to follow along.

The training will be conducted using the latest version of Excel for Windows, although much of the functionality is applicable to earlier Excel versions.

Level: Basic
Instructional Delivery Method: Group Internet Based
Delivery Format: Live Webcast
NASBA Field of Study: Computer Software & Applications (2 hours)
Program Prerequisites: None
Advance Preparation: No
  1. Understanding Pivot Tables and Reporting Summaries 00:01:47
  2. Comparing Formula-Based Reports with Pivot Tables 00:03:44
  3. Creating a Pivot Table from Source Data 00:05:35
  4. Converting a Data Range into an Excel Table 00:07:20
  5. Formatting and Customizing Excel Tables 00:10:43
  6. Naming an Excel Table 00:12:24
  7. Creating a Pivot Table from a Named Table 00:13:07
  8. Using Rows, Columns, and Values Fields 00:15:17
  9. Adding and Removing Fields from Pivot Tables 00:17:55
  10. Analyzing Revenue by Location and Product 00:20:37
  11. Changing Pivot Table Headings and Number Formatting 00:22:09
  12. Adding Source Data and Refreshing Pivot Tables 00:24:49
  13. Creating Multiple Pivot Tables on One Worksheet 00:30:34
  14. Counting Records Instead of Summing Values 00:33:49
  15. Understanding the Excel Data Model 00:36:15
  16. Creating Pivot Tables from Related Data Tables 00:38:50
  17. Calculating Percentages in Pivot Tables 00:40:58
  18. Displaying Values as a Percentage of Grand Total 00:43:20
  19. Using Multiple Row Fields in Pivot Tables 00:45:51
  20. Rearranging Hierarchical Row Fields 00:48:08
  21. Creating Charts from Pivot Tables 00:50:47
  22. Customizing Pivot Chart Titles and Field Buttons 00:53:05
  23. Filtering Pivot Charts and Removing Legends 00:54:53
  24. Working with Multiple Data Series in Pivot Charts 00:58:48
  25. Creating a Separate Pivot Table for Charting 01:01:26
  26. Copying Pivot Tables 01:02:21
  27. Sorting Pivot Tables by Values 01:04:23
  28. Filtering Pivot Table Items 01:07:00
  29. Using Value Filters 01:07:46
  30. Using the Pivot Table Filters Area 01:09:26
  31. Filtering by Fields Not Displayed in the Pivot Table 01:10:31
  32. Grouping Dates into Monthly Reporting Periods 01:12:54
  33. Using Multiple Filters in a Pivot Table 01:15:08
  34. Drilling Down to View Source Data 01:17:18
  35. Creating and Using Slicers 01:21:09
  36. Filtering Pivot Tables with Slicer Buttons 01:25:13
  37. Connecting One Slicer to Multiple Pivot Tables 01:28:15
  38. Using Report Connections 01:29:39
  39. Building a Data Model from Multiple Tables 01:31:37
  40. Converting Related Data Sets into Excel Tables 01:34:42
  41. Enabling Power Pivot and Managing the Data Model 01:35:46
  42. Adding Tables to the Data Model 01:37:15
  43. Creating Relationships Between Tables 01:38:05
  44. Creating a Pivot Table from the Data Model 01:39:00
  45. Closing Remarks 01:40:03
  • Mike Thomas

    Mike Thomas

    Mike Thomas has worked in the IT training business for 26 years. His expertise and experience covers designing and delivering training courses, creating written training materials (Quick Reference Guides and step-by-step tutorials), recording and editing video-based tutorials and providing support t [...]

    View Full Profile

CPE Credit

Continuing Professional Education

Aurora Training Advantage is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

For more information regarding administrative policies such as complaint and refund, and cancellation please contact our offices at 407-542-4317 or [email protected].

You must answer all questions during the webinar, view the recording completely and pass the test at the end with 70% correct answers to receive CPE credit.

ATATX Credit

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in accounting.

ATAOP Credit

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in operations.

ATAAA Credit

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in administrative.

Browse previous versions of this webinar series:

  • Building a Reporting Tool with Pivot Tables in Excel
    Webinar Date: October 7, 2026
    VIEWING
  • Building a Reporting Tool with Pivot Tables in Excel
    Webinar Date: January 1, 2026
    View
  • Analyze 00:43:29, 00:54:30, 00:54:46, 00:56:20, 01:24:34, 01:24:48, 01:29:03
  • Cell 00:04:16, 00:05:51, 00:06:02, 00:06:07, 00:08:15, 00:10:19, 00:12:16, 00:22:59, 00:23:34, 00:23:34, 00:31:28, 00:31:37, 00:31:57, 00:31:59, 00:33:15, 00:33:33, 00:51:34, 00:55:35, 01:05:20, 01:17:18, 01:17:29, 01:17:29, 01:18:36, 01:19:11, 01:20:19, 01:20:36, 01:32:48
  • Chart 00:05:30, 00:49:34, 00:49:39, 00:50:47, 00:50:49, 00:50:51, 00:50:51, 00:50:51, 00:51:07, 00:51:07, 00:51:34, 00:51:52, 00:51:52, 00:52:02, 00:52:08, 00:52:08, 00:52:08, 00:52:08, 00:52:15, 00:52:15, 00:52:15, 00:52:30, 00:52:47, 00:52:51, 00:52:52, 00:52:52, 00:53:05, 00:54:30, 00:54:30, 00:54:46, 00:55:00, 00:55:46, 00:55:46, 00:56:11, 00:56:20, 00:56:20, 00:56:51, 00:58:00, 00:58:00, 00:58:00, 00:58:31, 00:58:31, 00:58:31, 00:59:08, 00:59:08, 00:59:24, 00:59:24, 01:00:07, 01:00:14, 01:01:50, 01:01:52, 01:02:01, 01:02:14, 01:03:05, 01:03:11, 01:03:11, 01:03:11, 01:03:11, 01:03:11, 01:03:52, 01:04:00, 01:04:00, 01:04:23, 01:04:23, 01:04:23, 01:04:23, 01:04:23, 01:04:23, 01:04:54, 01:05:05, 01:05:09, 01:05:09, 01:05:20, 01:05:20, 01:05:20, 01:05:20, 01:05:20, 01:05:20, 01:21:47, 01:21:50, 01:21:55, 01:25:25, 01:25:25, 01:28:26
  • Column 00:06:43, 00:16:07, 00:16:23, 00:16:23, 00:16:23, 00:17:59, 00:19:12, 00:20:09, 00:20:18, 00:20:37, 00:20:57, 00:21:11, 00:27:51, 00:32:17, 00:33:57, 00:34:20, 00:34:42, 00:35:06, 00:35:12, 00:35:12, 00:35:12, 00:35:12, 00:35:21, 00:35:31, 00:35:52, 00:49:05, 00:52:08, 00:52:15, 00:52:15, 00:54:20, 00:56:51, 00:56:51, 00:57:29, 00:57:35, 00:57:35, 00:57:47, 00:58:17, 00:58:17, 00:58:48, 00:59:08, 00:59:24, 00:59:24, 00:59:24, 00:59:43, 00:59:58, 00:59:58, 00:59:58, 01:00:07, 01:00:07, 01:01:39, 01:02:01, 01:02:01, 01:02:28, 01:02:47, 01:02:47, 01:04:00, 01:04:54, 01:05:20, 01:05:20, 01:08:12, 01:09:32, 01:09:47, 01:10:24, 01:12:00, 01:13:17, 01:13:32, 01:13:52, 01:22:33, 01:38:39
  • Column Headings 00:16:23, 00:20:37, 00:20:57, 00:35:06, 00:35:12, 00:35:12, 01:12:00
  • COUNT 00:34:42, 00:34:54, 00:35:21, 00:35:52
  • Data Model 00:36:15, 00:38:50, 00:39:00, 00:39:48, 00:39:56, 01:31:08, 01:31:22, 01:33:35, 01:33:51, 01:33:51, 01:33:51, 01:34:06, 01:34:10, 01:34:17, 01:34:18, 01:34:33, 01:34:33, 01:34:42, 01:35:32, 01:35:46, 01:35:53, 01:35:53, 01:36:00, 01:36:00, 01:36:14, 01:36:23, 01:36:32, 01:36:40, 01:36:59, 01:36:59, 01:36:59, 01:37:19, 01:37:25, 01:37:32, 01:37:35, 01:37:43, 01:37:51, 01:38:01, 01:39:00, 01:39:00, 01:39:23, 01:39:37, 01:39:52
  • Filter 00:10:55, 00:10:58, 00:54:57, 00:55:00, 00:55:00, 00:55:46, 00:55:46, 00:56:02, 00:56:11, 00:56:11, 01:05:20, 01:05:20, 01:05:20, 01:05:20, 01:05:20, 01:07:29, 01:07:29, 01:07:29, 01:07:29, 01:08:08, 01:08:12, 01:08:12, 01:08:29, 01:08:47, 01:08:47, 01:08:56, 01:09:02, 01:09:02, 01:09:02, 01:09:09, 01:09:23, 01:09:38, 01:09:44, 01:09:47, 01:09:56, 01:10:31, 01:10:31, 01:10:57, 01:11:06, 01:11:32, 01:11:56, 01:12:00, 01:12:20, 01:15:08, 01:15:15, 01:15:15, 01:15:22, 01:16:00, 01:19:11, 01:19:11, 01:19:11, 01:19:11, 01:21:55, 01:22:22, 01:22:27, 01:22:39, 01:22:39, 01:22:52, 01:22:58, 01:23:12, 01:24:14, 01:24:19, 01:25:17, 01:25:31, 01:25:31, 01:25:47, 01:25:47, 01:25:47, 01:26:31, 01:27:21, 01:27:26, 01:27:38, 01:27:52, 01:27:52, 01:30:41
  • Formula 00:03:54, 00:04:16, 00:04:16
  • Pivot Chart 00:54:30, 00:54:46, 00:55:00, 00:56:11, 00:56:20, 00:58:00
  • Pivot Table 00:00:01, 00:00:59, 00:01:47, 00:03:44, 00:03:49, 00:03:53, 00:04:16, 00:04:16, 00:04:55, 00:05:14, 00:05:14, 00:05:21, 00:05:30, 00:05:35, 00:06:12, 00:06:19, 00:06:21, 00:06:49, 00:06:56, 00:08:27, 00:08:27, 00:08:49, 00:08:49, 00:09:04, 00:09:04, 00:09:29, 00:09:29, 00:10:16, 00:10:25, 00:13:07, 00:13:22, 00:13:33, 00:13:41, 00:13:50, 00:14:00, 00:14:18, 00:14:23, 00:14:42, 00:15:00, 00:15:00, 00:15:17, 00:17:00, 00:17:09, 00:17:55, 00:19:04, 00:20:27, 00:20:27, 00:20:37, 00:22:00, 00:24:45, 00:26:18, 00:26:34, 00:26:47, 00:27:02, 00:27:12, 00:27:19, 00:27:19, 00:27:19, 00:27:37, 00:27:54, 00:28:40, 00:28:40, 00:28:57, 00:29:15, 00:29:15, 00:29:28, 00:30:34, 00:30:34, 00:30:52, 00:31:05, 00:31:08, 00:31:13, 00:32:05, 00:32:17, 00:32:17, 00:32:17, 00:32:17, 00:32:56, 00:32:56, 00:33:08, 00:33:15, 00:33:15, 00:33:33, 00:38:08, 00:38:08, 00:38:50, 00:39:56, 00:40:11, 00:40:44, 00:40:58, 00:41:11, 00:41:18, 00:41:18, 00:42:21, 00:42:25, 00:42:33, 00:42:37, 00:46:04, 00:46:04, 00:46:57, 00:47:38, 00:48:08, 00:48:37, 00:50:05, 00:50:10, 00:50:22, 00:50:30, 00:50:51, 00:51:07, 00:51:07, 00:51:34, 00:51:52, 00:52:30, 00:52:47, 00:53:05, 00:53:05, 00:53:55, 00:55:00, 00:55:00, 00:55:35, 00:55:46, 00:55:46, 00:56:02, 00:56:11, 00:56:51, 00:58:00, 00:58:00, 00:59:08, 00:59:08, 00:59:24, 01:00:07, 01:00:14, 01:00:14, 01:01:26, 01:01:39, 01:02:01, 01:02:09, 01:02:14, 01:02:21, 01:02:21, 01:02:47, 01:03:05, 01:03:11, 01:03:11, 01:03:11, 01:03:11, 01:03:11, 01:03:11, 01:03:52, 01:03:52, 01:04:00, 01:04:00, 01:04:23, 01:04:23, 01:04:54, 01:05:20, 01:05:20, 01:05:20, 01:05:20, 01:05:20, 01:05:20, 01:08:56, 01:09:15, 01:09:26, 01:10:07, 01:10:24, 01:10:41, 01:10:48, 01:12:14, 01:12:37, 01:13:09, 01:14:59, 01:17:29, 01:18:22, 01:20:49, 01:21:18, 01:21:27, 01:21:55, 01:22:27, 01:22:39, 01:22:39, 01:22:52, 01:23:12, 01:23:19, 01:24:14, 01:24:19, 01:24:19, 01:24:28, 01:24:34, 01:24:34, 01:24:48, 01:25:17, 01:25:25, 01:28:15, 01:28:32, 01:28:32, 01:28:47, 01:28:53, 01:28:53, 01:29:03, 01:29:03, 01:29:12, 01:29:12, 01:29:20, 01:29:20, 01:29:26, 01:29:33, 01:30:07, 01:30:07, 01:30:07, 01:30:27, 01:30:30, 01:30:30, 01:30:30, 01:30:30, 01:30:41, 01:32:48, 01:33:06, 01:33:10, 01:39:00, 01:39:00, 01:39:00, 01:39:00, 01:39:23, 01:39:23, 01:39:23, 01:39:23, 01:39:35
  • Power Pivot 01:36:50, 01:36:56, 01:36:59, 01:37:15, 01:37:19, 01:37:32, 01:37:43, 01:37:51
  • Refresh 00:27:02, 00:27:14, 00:27:37, 00:27:54, 00:49:49, 00:49:51, 00:50:05, 00:50:30, 01:03:11
  • Row 00:02:10, 00:02:20, 00:03:16, 00:05:55, 00:08:49, 00:09:21, 00:09:29, 00:10:08, 00:10:47, 00:11:14, 00:11:18, 00:13:33, 00:16:07, 00:16:23, 00:16:23, 00:20:37, 00:20:57, 00:22:14, 00:24:49, 00:24:53, 00:25:18, 00:25:39, 00:25:54, 00:29:28, 00:29:28, 00:29:28, 00:32:13, 00:33:49, 00:34:03, 00:35:52, 00:42:51, 00:46:47, 01:02:28, 01:09:38, 01:09:47, 01:10:41, 01:10:48, 01:13:00, 01:13:41, 01:13:52, 01:14:29, 01:14:29, 01:19:06, 01:20:05, 01:39:42
  • Row Headings 00:16:23, 00:20:37, 00:20:57
  • Slicer 01:24:34, 01:24:48, 01:24:58, 01:25:13, 01:27:26, 01:27:26, 01:27:38, 01:28:07, 01:28:15, 01:28:32, 01:28:32, 01:28:47, 01:29:39, 01:29:39, 01:29:39, 01:29:48, 01:29:48, 01:29:48, 01:30:41
  • SORT 00:10:55, 00:30:56, 01:04:23, 01:04:54, 01:05:20, 01:05:20, 01:05:20, 01:05:20, 01:05:20, 01:05:20, 01:05:20, 01:05:20
  • Spreadsheet 00:28:57, 01:32:48, 01:34:06, 01:36:27
  • SUM 00:16:44, 00:16:44, 00:19:12, 00:19:12, 00:19:12, 00:19:12, 00:20:13, 00:34:20, 00:34:35, 00:34:54, 00:35:12, 00:43:05
  • Worksheets 00:14:05, 00:14:21, 00:14:39, 00:31:17, 00:31:22, 00:33:15, 00:42:39, 00:46:38, 01:12:42, 01:34:10

Analyze: The ANALYZE tab has several commands that will enable you to explore the data in the PivotTable.

COUNT: Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.

Cell: In spreadsheet applications, a cell is a box in which you can enter a single piece of data. The data is usually text, a numeric value, or a formula. The entire spreadsheet is composed of rows and columns of cells.

Chart: In Microsoft Excel, a chart is often called a graph. It is a visual representation of data from a worksheet that can bring more understanding to the data than just looking at the numbers. A chart is a powerful tool that allows you to visually display data in a variety of different chart formats such as Bar, Column, Pie, Line, Area, Doughnut, Scatter, Surface, or Radar charts.

Column: A column is a vertical series of cells in a chart, table, or spreadsheet in Excel.

Column Headings : The column heading or column header is the gray-colored row containing the letters (A, B, C, etc.) used to identify each column in the worksheet. The column header is located above row 1 in the worksheet.

Data Model: A Data Model allows you to integrate data from multiple tables, effectively building a relational data source inside an Excel workbook. Within Excel, Data Models are used transparently, providing tabular data used in PivotTables and PivotCharts.

Filter: The Filter feature in Excel allows you to show or hide rows within a list of data by making selections from drop-down lists. The Filter feature is available on the Data tab of all versions of Excel as well under the Sort & Filter command on the Home menu.

Formula: A formula is an expression which calculates the value of a cell.

Pivot Chart: Pivot charts are an adjunct to Excel’s pivot table feature, which allows you to summarize data by dragging and dropping data with your mouse. Pivot charts are much more interactive than the traditional Excel charts.

Pivot Table: A report creation tool in Excel that enables you to quickly summarize lists of data into summary reports by clicking checkboxes and dragging fields onscreen.

Power Pivot: Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.

Refresh: The Refresh command appears on the Options tab of Excel 2007 and 2010 as well as the Analyze tab of Excel 2013. Pivot tables store a snapshot of the underlying source data, so they don’t immediately reflect changes to said data. You must periodically refresh any pivot table to ensure it reflects any changes to the source data.

Row: A row is the range of cells that go across (horizontal) the spreadsheet/worksheet. Rows are identified by numbers e.g. row 1, row 5. Examples of use. A row might contain the headings of a table e.g. product ID, product name, price, number sold.

Row Headings: The row heading or row header is the gray-colored column located to the left of column 1 in the worksheet containing the numbers (1, 2, 3, etc.) used to identify each row in the worksheet.

SORT: Sorting is the process of arranging objects in a certain sequence or order according to specific rules. In spreadsheet programs such as Excel and Google Spreadsheets, there are several different sort orders available depending on the type of data you're sorting.

SUM: Microsoft Excel defines SUM as a formula that “Adds all the numbers in a range of cells”. This definition clearly points that Sum function has a job to add numbers and the arguments can be supplied using combinations of both numbers and range of cells. =SUM The SUM function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUM function can be entered as part of a formula in a cell of a worksheet.

Slicer: You can insert slicers in Excel to quickly and easily filter pivot tables. Slicers were introduced in Excel 2010, and they make it easy to change multiple pivot tables with a single click

Spreadsheet: Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software.

Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.

Customer Satisfaction Guarantee
Invest in your future with confidence! Our Customer Satisfaction Guarantee eliminates all risk, letting you focus purely on mastering new skills and advancing your career. If you're not completely satisfied, we'll ensure you are. Your satisfaction is not just a promise; it's our guarantee.

Webinar Survey Overall Rating

This webinar received a total of 8 survey responses. Attendees have given an average rating of 4.7 stars out of a possible 5, reflecting the quality and value of the content presented.

Average rating

4.7 / 5
Webinar Presentation
How many of the objectives of the event were met?
4.8 Stars
How useful was the information presented at this event?
4.6 Stars
Overall, how satisfied were you with this event?
4.6 Stars
Speaker Performance
Overall, how satisfied were you with this presenter?
4.9 Stars
How closely did the presenter follow the schedule?
4.6 Stars

Reviews From Webinar Survey

Our webinars are crafted to deliver exceptional value and insight to business professionals. Below, you'll find genuine feedback from attendees.

Cindi F.
October 8, 2026
3.4 / 5
Webinar Rating:
3.3 Stars
Speaker Rating:
3.5 Stars
Do you have any other comments, questions or concerns?
nothing additional
Angela P.
October 8, 2026
5.0 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
no comment
Kelly C.
October 7, 2026
4.2 / 5
Webinar Rating:
4.0 Stars
Speaker Rating:
4.5 Stars
Do you have any other comments, questions or concerns?
no comment
Patty M.
October 7, 2026
5.0 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
I've enjoyed the training
Payroll D.
October 7, 2026
5.0 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
Mr. Mike Thomas was amazing. The detail was wow, so relevant to my needs in Finance. Thank you!
Kayla H.
October 7, 2026
5.0 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
Was a great webinar. I learned quite a bit about pivot tables
Juliana L.
October 7, 2026
5.0 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
none
Stacy C.
October 7, 2026
5.0 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
The presenter had time to answer I question that I asked, that wasn't within the scope of the training. His instructions were easy to follow. Very good training!

Frequently Asked Questions

A pivot table is one of Excel's most powerful data analysis tools, enabling users to instantly summarize, analyze, and reorganize large datasets without writing a single formula. With just a few clicks, a pivot table transforms thousands of rows of raw data into a structured summary report that answers specific business questions—total sales by region, headcount by department, expenses by month, or revenue by top 10 customers. Pivot tables earn their name from their ability to 'pivot' the same underlying data into completely different views simply by dragging and dropping field headings, making them extraordinarily flexible for exploration and reporting. They support aggregation by sum, count, average, percentage of total, running totals, and more. Pivot tables update dynamically when source data changes (after a refresh), making them far more maintainable than static summary tables built with manual formulas. For business professionals who regularly produce periodic management reports, pivot tables replace hours of manual data manipulation with a reusable reporting structure that delivers consistent, accurate summaries in minutes—making them an indispensable skill for anyone working with data in Excel.
Creating a basic pivot table in Excel takes as few as six clicks once your data is prepared. First, ensure your source data is in a flat table format with column headers in the first row and no blank rows or columns within the dataset—using Excel's Table feature (Ctrl+T) is recommended for flexibility. Click anywhere inside the data range, then go to Insert > PivotTable. In the dialog, confirm the data range and choose whether to place the pivot table on a new or existing worksheet, then click OK. The PivotTable Fields pane appears on the right. Drag the field you want to summarize (such as Sales Amount) to the Values area, then drag a categorization field (such as Region or Product) to the Rows area to break down the summary. Add a date field to Columns for a period comparison view. Right-click any value in the pivot table to change the aggregation from Sum to Count, Average, or other functions. To group dates by month or quarter, right-click a date in the table and select Group. The pivot table is now a dynamic reporting tool—refreshed by right-clicking and selecting Refresh whenever source data updates.
Slicers are visual, interactive filter buttons in Excel that allow users to filter pivot table data with a single click—no dropdown menus or dialog boxes required. Introduced to transform the user experience of pivot table filtering, slicers display a panel of clickable buttons representing each unique value in a selected field, such as Region, Year, or Product Category. Clicking a button instantly filters the pivot table to show only the data matching that selection; multiple values can be selected by holding Ctrl. This makes slicers ideal for presenting interactive reports to business stakeholders who need to explore data without understanding pivot table mechanics. A single slicer can be connected to multiple pivot tables on the same worksheet, enabling a dashboard where all reports respond to a single filter selection. Timeline slicers offer the same visual filtering experience specifically for date fields, allowing users to slice by month, quarter, or year with a drag-and-select interface. Together, slicers and timelines transform a static pivot table report into an interactive business intelligence tool that empowers non-technical decision-makers to explore data independently—dramatically increasing the value of Excel-based reporting.
Converting pivot table data into a chart in Excel is straightforward and produces a PivotChart—a dynamic chart that updates automatically when the pivot table is filtered or refreshed, making it ideal for management dashboards. To create a PivotChart, click anywhere inside the pivot table, then go to PivotTable Analyze > PivotChart (or Insert > PivotChart), and select the chart type. Column and bar charts work well for comparisons across categories; line charts suit time-series trends; pie charts are appropriate for showing parts of a whole (though they should be used sparingly for more than 5 categories). The PivotChart maintains a synchronized filter relationship with its source pivot table—applying a slicer filter to the table automatically updates the chart. Formatting the chart using the Design and Format tabs allows customization of colors, labels, gridlines, and chart titles to match organizational branding or presentation standards. For recurring reports, saving the pivot table and chart together in a template workbook enables a repeatable reporting workflow: simply paste in new data, refresh, and the chart automatically reflects the updated analysis—eliminating manual chart rebuilding for each reporting cycle.
Pivot tables do not automatically update when source data changes—they require a refresh to reflect new or modified records, which is a common source of stale reporting errors. The simplest way to refresh is right-clicking inside the pivot table and selecting Refresh, or using the Data tab > Refresh All to update all pivot tables in the workbook simultaneously. To automate this, configure the pivot table to refresh when the workbook is opened: right-click the pivot table, go to PivotTable Options > Data tab, and check 'Refresh data when opening the file.' The most robust best practice for ensuring the pivot table captures new rows of data is converting the source data range to an Excel Table using Ctrl+T before creating the pivot table. Excel Tables expand dynamically as new rows are added, whereas a static named range stops at the row count defined when the pivot table was created—causing new data to be silently excluded. When data lives in a separate workbook or external database, using Power Query to import and refresh the source provides a scalable, automated data pipeline. Documenting the refresh process and data source location in a workbook notes section protects reporting integrity when the file is used by multiple team members.