We talked about grouping data in prior videos, but there’s another grouping trick that will come in handy. When Excel sees you’re grouping dates, it offers a number of ways to group the dates, such as by month, quarter, and year. When Excel recognizes you’re grouping numbers, it brings up a small window that allows you to choose the number to start the grouping, the number to end the grouping, and the interval for each group.
Excel Video 26 shows you an example of grouping numbers based on the age of the patient using 50,000 sample E&M visits. You’ll see how Excel by default selects the lowest and highest numbers in the range and suggests an interval to group by. Watch how I change the starting and ending numbers so that the grouping makes more sense. Even better, once you’ve set up the grouping, Excel will apply the group categories to new data as well.
Thanks for watching. Stay tuned. I’m planning on showing Pivot Charts next.
