Excel for iPad has recently introduced the ability to create pivot tables, which allows users to easily analyze and summarize their data. Today, the official Microsoft Excel blog was recently updated. The blog announced that the iPad version of Excel now supports Pivot Tables. The company said in the blog post
“We are excited to announce support for PivotTable creation and editing on iPad. PivotTables allow you to calculate, summarize, and analyze data. We have tailored this powerful tool for the iPad’s smaller screen and touch interface. Now, you have the flexibility to move seamlessly between desktop, web, and iPad while maintaining a consistent experience across the board. Unleash the full potential of PivotTables, making every calculation and analysis simple on the go.”
Excel for iPad users can create a new PivotTable by opening the Insert tab and selecting the PivotTable option. Users can then select the source and insertion location to insert their PivotTable on the iPad touchscreen. Users can also change the source data on the PivotTable report by clicking on the “Change Data Source” option. This will bring up a sidebar where changes can be made, and users can also click on the Settings sidebar to fine-tune the PivotTable’s information. Pivot tables are powerful tools for calculating, summarizing, and analyzing data, helping you see comparisons, patterns, and trends in your data. We can use pivot tables to perform calculations on data based on certain criteria. For example, sales per store, sales per year, average discounts per region, etc…
How to create a Pivot Table
Here is a step-by-step guide by Microsoft on how to create a Pivot Table on an iPad
1. Create a Pivot Table
To create a pivot table, go to the “Insert Tab” at the top of the screen and click on “PivotTable. ” Then select a Source and Insertion location and insert the pivot table with a single click.
2. Use the Field List
You can customise the pivot table to exactly what you need seamlessly by using the field list. The bottom areas section allows you to easily rearrange fields by dragging them across the different sections to obtain an intelligent data representation.
3. Change the Source Data
Navigate to the PivotTable tab and select the Change Data Source side pane to make changes to your PivotTable’s source data. It’s a simple process that ensures your analysis is dynamic and up to date.
4. Change the Settings
Go to the Settings side pane to easily fine-tune your Pivot Table. Make the necessary changes and save your changes with a single tap to ensure that your PivotTable works exactly as you want it to.
5. Move the PivotTable
Cut and paste in the context menu to move your PivotTable within and across worksheets.
Other ways to use a PivotTable on an iPad
Before the official introduction of pivot tables for iPad, the iPad version of Excel did not support creating new pivot tables directly within the app. Instead, users must either create a pivot table in the Office on the Web or use an alternative workaround. One such is deleting the Excel app from their iPads and logging in to Office.com through a web browser. If you do not have the update bringing pivot tables to the iPad, you can still try the old workaround below
Creating Pivot Tables in Excel for iPad
As we said earlier, you can not create a new pivot table but can work on existing pivot tables in a file. To create a pivot table in Excel for iPad, you will need to use the Office on Web. This is accessible through a web browser by signing in with your Microsoft Account. Once you have signed in, select the Excel App and follow the steps provided below
Pivot Tables with Subheadings
Although the Excel app for iPad does not yet support creating pivot tables with subheadings, the Office on Web allows users to create and modify pivot tables with subheadings. To create a pivot table with subheadings in Excel for iPad, follow these steps:
1. Sign in to Office.com through a web browser on your iPad.
2. Select the Excel App and create a new sheet or open an existing one.
3. Click on the “Insert” tab and select “PivotTable.”
The new update for Excel on iPads now supports this feature. For this reason, users do not need to use the log workaround to use this feature. Users have expressed their desire for this feature, and Microsoft did listen and it is now available.
Conclusion
Microsoft has just announced that Excel on iPad now supports PivotTables. This is a feature that many people especially those in academics have been craving for. It is not always convenient to go to your laptop whenever you want to work with a pivot table. With a few clicks, users can now create and modify a pivot table on their iPads. For those who do not have the update yet, they can still create and modify pivot tables with subheadings using the Office on the Web. They can also import that table to the iPad and modify it.
Author Bio
Efe Udin is a seasoned tech writer with over seven years of experience. He covers a wide range of topics in the tech industry from industry politics to mobile phone performance. From mobile phones to tablets, Efe has also kept a keen eye on the latest advancements and trends. He provides insightful analysis and reviews to inform and educate readers. Efe is very passionate about tech and covers interesting stories as well as offers solutions where possible.
