Finally, Microsoft Excel brings PivotTables to iPads

Reading time icon 1 min. read


Readers help support MSPoweruser. When you make a purchase using links on our site, we may earn an affiliate commission. Tooltip Icon

Read the affiliate disclosure page to find out how can you help MSPoweruser effortlessly and without spending any money. Read more

Microsoft Excel for iPad has introduced full-fledged PivotTable creation and editing, expanding data analysis capabilities beyond the desktop.

With a few taps, you can generate a PivotTable from existing data and customize it to your needs. The interface is optimized for the iPad’s touchscreen, making dragging and dropping fields a breeze.

The Field List simplifies rearranging data points across rows, columns, and filters, facilitating insightful data exploration. Moreover, the PivotTables can seamlessly adapt to updated source data through a dedicated side pane, ensuring analysis remains accurate and current.

A side pane for Settings lets users customize PivotTable formatting, calculations, and more. Users can easily relocate PivotTables across different sheets using cut-and-paste functionalities.

Here’s how to do it:

  • To create a PivotTable, select PivotTable from the Insert tab and choose a source and insertion location.
  • Use the field list to rearrange fields easily and tailor the PivotTable to meet your needs.
  • Adjust your PivotTable’s source data seamlessly by engaging the Change Data Source side pane.
  • Fine-tune your PivotTable effortlessly with the Settings side pane.
  • Move your PivotTable within and across worksheets through cut and paste in the context menu.

This feature requires Excel on iPad version 2.80.1203.0 and above.

More here.

More about the topics: Apple iPad, Excel