VocordiaDownload for Mac

Get hands-on help with Vocordia

You can do it the hard way - reading guides, switching tabs, figuring it out step by step.

Or you can do it the easy way.

Vocordia is your AI copilot across Excel and any software on your screen - just say what you want, and your cursor will guide you step by step, so you can get it done instantly without leaving your window.

Try it nowHow it works

How to Create a Pivot Table in Excel

Pivot Tables summarize large datasets quickly - totals, averages, counts - without writing complex formulas. Start from a clean table with column headers.

Prepare your source data

  • Use a single header row with unique column names.
  • Avoid blank header cells; remove fully blank rows/columns inside the dataset when possible.
  • Prefer an Excel Table (Insert → Table) so new rows are included when you refresh.

Insert a PivotTable

  1. Click anywhere in your data.
  2. Go to Insert → PivotTable.
  3. Confirm the range/table and choose whether to place the PivotTable on a new worksheet or an existing location.
  4. Click OK.

Untitled (6)

Build the report

  1. In the PivotTable Fields pane, drag fields into Rows, Columns, Filters, and Values.
  2. For numeric fields, open the value field settings to switch between Sum, Count, Average, etc.
  3. Use filters and slicers to slice the summary interactively.

Untitled (5)

Refresh when data changes

Right-click the PivotTable → Refresh, or use Data → Refresh All. If your source is a Table, refreshing picks up new rows reliably.

Try it faster with guidance

Skip the manual steps—let Vocordia guide you through it with voice and step-by-step cursor guidance so you can place fields and formats without hunting menus.

Had to scroll back or switch tabs a few times?

That's the hard way.

Next time, just say what you want - and let your cursor guide you step by step to the result.

Try it nowHow it works