studiox
2023.10
false
- Release Notes
- Getting Started
- Tutorials
- Automation Projects
- Creating Automations
- Automation Basics
- Object Repository
- Automation Best Practices
- Tutorial: Creating a Pivot Table
- Tutorial: Iterating Through Rows in a Table
- Tutorial: Comparing Excel Files and Emailing Reconciliation Errors
- Tutorial: Extracting Data From Automated Emails and Moving It to a Desktop Application
- Tutorial: Filtering Data in Excel
- Tutorial: Formatting Cells
- Tutorial: Adding Information About the Files in a Folder to an Excel File
- Tutorial: Adding Your Own Formulas to the Project Notebook
- PowerPoint Automation
- Data Automation
- Common Activities
- Google Workspace Automation
- OneDrive & SharePoint Automation
- Troubleshooting
Tutorial: Creating a Pivot Table
StudioX User Guide
Last updated Aug 7, 2024
Tutorial: Creating a Pivot Table
In this tutorial, we have an Excel file with data about suppliers and we want to find out how many suppliers there are in each city and what number of employees the suppliers have in each city. To achieve this, we will build an automation that creates a pivot table.