by Nate Moore | Nov 19, 2009 | Pivot Tables
If you’ve ever been challenged on whether a number in your report is correct, you need to know how to drill down to see the details behind that number. This video shows how to drill down to look at the data underlying a cell in a Pivot Table. All you have to do is...
by Nate Moore | Nov 17, 2009 | Pivot Tables
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...
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...
