Select Page

The last video demonstrated the way Excel groups dates in a Pivot Table. This video demonstrates how to apply the same grouping tools to text fields. You can also learn how to hide and show details of what you’ve grouped, which is helpful when printing or summarizing a large amount of data. Learning how to group and ungroup fields and how to show and hide the detail in the group will go a long way toward creating powerful Pivot Tables that manage a lot of medical practice data.