by Nate Moore | Nov 16, 2009 | Pivot Tables
Today’s video demonstrates how to group dates in Pivot Tables fields. As long as Excel sees the dates are in a date format, the group function allows you to easily group dates by a variety of time intervals, such as days, months, quarters, and/or years. It’s easy to...
by Nate Moore | Nov 11, 2009 | Pivot Tables
Today’s video introduces the basic filtering options in a Pivot Table using the same sample medical practice data. Filtering data is key to carving up your data into smaller slices for better analysis. You’ll see how easy it is to filter your data and what Excel does...
by Nate Moore | Nov 11, 2009 | Pivot Tables
Here’s another video I hope you’ll find helpful. Today’s video shows how to sort both values and labels in a Pivot Table. You’ll see how to sort ascending (A-Z) and descending (Z-A) amounts, and I’ll also show you how to manually sort data that you may need sorted in...
by Nate Moore | Nov 10, 2009 | Pivot Tables
I hope you enjoy the latest addition to MooreSolutionsInc.com. I’ve been working for some time on a way to create training videos to illustrate how to use Excel’s Pivot Tables in a medical practice. I’m going to start by creating and posting an introductory video that...
