If your spreadsheet contains a list of times, it is useful to group them into intervals such as 30 minutes, hourly or every 6 hours.
Fortunately Excel provides a variety of methods to group time depending on what you need. In this blog post we look at 4 ways to group times using PivotTables and Excel formulas.
[Read more…] about 4 Ways to Group Time in Excel – PivotTables and FormulasPivotTables are one of the most useful tools in Excel. They allow you to easily summarise, examine and present a complex list of data.
This blog post explores 5 advanced PivotTable techniques.
[Read more…] about 5 Advanced PivotTable Techniques
When using a PivotTable to summarise a large list of data, you may need to count unique occurrences in a particular field.
For example, you may have a list of data like the one below and want to count the number of different customers in each country, or the number of different products that were sold in each country.
If you added the Customer Name field to the Values area of a PivotTable and summarised it with a Count you would get the result below.
However this is counting all of the transactions in each country. We need to count the unique customers making those transactions in each country.
[Read more…] about Count Unique Values in a PivotTable
In Excel 2010 a feature was introduced to easily rank the fields of your PivotTables.
Yes, you can sort the fields of a PivotTable to view items in order from largest to smallest, or smallest to largest depending on what you are trying to achieve. But you may wish to keep your list of products, customers, salespersons or whatever the field is your are ranking in alphabetical order.
Take the table below for instance. This PivotTable displays the number of sales and conversion rate for the members of a sales team.
We would like to add a rank field to the PivotTable for both fields.
[Read more…] about Ranking Fields of a PivotTable in Excel 2010
Timeline Slicers are a new addition to Excel 2013. They are a new filter tool that is available exclusively to the date fields in your PivotTables. They are visually appealing and easy to use.
To use a Timeline with your PivotTable;
[Read more…] about Using Timeline Slicers in Excel 2013
