Excel
17 BEST Excel Alternatives in 2021 (Free/Paid)
Excel is a spreadsheet software included in the Microsoft office suite. It widely is used to...
There will be times when you will be required to analyse large amounts of data and produce easy to read and understand reports. Pivot tables allow us to analyse such data and produce reports that meet our business reporting requirements.
In this tutorial, we are going to cover the following topics;
A Pivot Table is a summary of a large dataset that usually includes the total figures, average, minimum, maximum, etc. let's say you have a sales data for different regions, with a pivot table, you can summarize the data by region and find the average sales per region, the maximum and minimum sale per region, etc. Pivot tables allow us to analyse, summarize and show only relevant data in our reports.
The image below shows the sample sales data collated from North wind access database.
You can download the sample Excel data here.
Download the above Excel Data File
As you can see from the above image, our spreadsheet contains a lot of data. Let's say we want to create a summary of customers, group all of their orders by product, and show the quantities, unit price and subtotals for all the transactions.
A two-dimensional pivot table is a table that has fields on both rows and columns. Let's say we want to list employee names as rows and use columns to represent customer names and fill in the cells with the total sales.
Your pivot table will now look as follows
With Excel 2013, you do not need to create the charts manually. Excel will create the charts for you as you create your pivot tables, change aggregate functions, apply filters, etc.
The chart below was automatically created for us from the simple pivot chart exercise that filtered data for Alfreds Futterkiste only.
Pivot tables and charts enable us to summarize and analyse large datasets. We can use aggregate functions such as SUM, MINIMUM, MAXIMUM, AVERAGE, etc. the charts are automatically created and updated for us by excel as we work with the data.
Excel is a spreadsheet software included in the Microsoft office suite. It widely is used to...
The following Best Excel Online Courses and Classes will help you to learn Microsoft Excel from...
Training Summary Excel is the most powerful tool to manage and analyze various types of Data. This...
"Money is a tool. Used properly it makes something beautiful- used wrong, it makes a mess!" -...
Data is the bloodstream of any business entity. Businesses use different programs and formats to...
What is Office 365? Office 365 is a suite of programs from Microsoft that run both locally and can be...