Here is a quick tutorial on using PivotTables to count the number of times a date appears in a long list of data, plus how to fix a small quirk in Excel.
Tag Archives | Grouping
Excel has some great features to create outlines and groups which will show summary or detailed data for your worksheet. In this video we will review both options so you can compare and contrast the values of each.
Not only can you group by dates in PivotTables, but you can also group by values. Here’s how…..
Here is how you can group your PivotTable data into weekly periods in Excel…..
Here are the basics for grouping rows and columns of data in Excel, but with a slick option to make your outlines more logical…..
Here are three different ways to group your data in PivotTables in Excel…..