by Nate Moore | Aug 1, 2012 | Pivot Tables
I’ve decided to go back and cover Pivot Tables again, starting in Excel Video 280. Since I recorded the first Excel Video almost 3 years ago, I’ve made almost 25 presentations across the country on using Pivot Tables in a medical practice. I know a little more about...
by Nate Moore | Feb 1, 2010 | Pivot Tables
All of the Pivot Chart examples we’ve been through in prior videos involved creating a Pivot Chart and the related Pivot Table from scratch. What if you already have a Pivot Table you’ve been using and want to create a Pivot Chart? You don’t have to start over. Watch...
by Nate Moore | Jan 28, 2010 | Pivot Tables
This is one of those videos that may take a minute to load. Excel Video 28 is an extended example of how to use a Pivot Chart. There are a couple of ideas demonstrated that I hope you’ll find helpful. We look at E&M codes by the coding level (the last digit of...
by Nate Moore | Jan 26, 2010 | Pivot Tables
I hope by now you’re a fan of the power and flexibility of Pivot Tables. Now that you’ve seen some of the things Pivot Tables can do, imagine a chart or graph in Excel tied to the Pivot Table so that any time you add a column, change a filter, or update your Pivot...
by Nate Moore | Jan 25, 2010 | Pivot Tables
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...
by Nate Moore | Jan 20, 2010 | Pivot Tables
Excel Video 25 wraps up our discussion of the Pivot Table Options Menu by discussing the Printing tab and the Data tab. The Printing tab has three pretty straight-forward check boxes that control whether to print the expand/collapse buttons on a printed Pivot Table...
