Microsoft Excel PivotTable Tutorial
What is a PivotTable?
PivotTables are a powerful tool in Microsoft Excel that allow you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report. This Microsoft tutorial ‘
Make your first PivotTable’ teaches you everything you need to know to get started making PivotTables with your
iCarol data exports.
PivotTables might be of benefit to you if you're interested in quickly summarizing and analyzing your data to find potential patterns. For example, you may with to report on demographics related to particular referrals made within contact records, like how many Females, in the age range 18-35 were referred to a specific clinic in your community. With PivotTables you can easily do this and more!
Important Note
iCarol Support does not include support, assistance, troubleshooting, or help with how to use PivotTables and Microsoft Excel. Instead it's the responsibility of you, the user, to learn and understand how to use Microsoft Excel and the tools available within it so you can manipulate your iCarol data as you wish. This tutorial is provided as just one place where you can go to learn how to create PivotTables. If you want to learn more about Excel, you're encouraged to explore other training and tutorials available, including but not limited to using the 'Tell Me' search bar directly within Microsoft products, and those available online like the tutorials found on the
Excel Video Training page.
Related Articles
Tutorial Videos: Specialized Exports to Word/Excel
The tutorial videos on specialized exports to Word/Excel include: Introduction: Use of specialized exports and an overview of what fields and filters can be used to build templates Demo: Where to access specialized exports, how to build a template, ...Contact Record Data Export File Reporting - Excel Tips
The purpose of this Knowledge Base is to guide you to use different tools available in Microsoft Excel to help you learn how to get the most out of your Contact Record Data Export files to meet your reporting needs. Important notes to consider before ...Training Plan: Statistics, Exports and Reports
Training Plan: Statistics, Exports and Reports The information in this training plan is meant to be reviewed by your organization, and used as guidance on what should be included in your individualized training materials created for your users when ...Specialized Resource Exports to Word/Excel
What is Specialized Exports of Resources to Word/Excel? Specialized Exports of Resources to Word/Excel (Specialized Exports of Resources) allows Admins to create printable directories of your resources, giving you the ability to choose what fields ...Tutorial Videos: Statistics Overview
The tutorial video on Statistics Overview includes: how to access Statistics, high level overview of the reports available