by Nate Moore | Jul 29, 2019 | Business Intelligence, Pivot Tables, Podcasts
Podcast: Play in new window | DownloadSubscribe: Android | RSS CMS recently released the 2017 Provider Utilization File. That data provides an opportunity for savvy practice managers to get a sense of their market share, especially for Medicare patients. The data...
by Nate Moore | Feb 6, 2013 | Pivot Tables
If you know you’ll need a Pivot Chart when you start creating a Pivot Table, Excel Video 330 shows you how to create a Pivot Chart and a Pivot Table at the same time. You don’t have to create a Pivot Table first and then create a Pivot Chart. If it helps you visualize...
by Nate Moore | Feb 4, 2013 | Pivot Tables
Excel Video 329 introduces Pivot Chart Field Buttons. I’ll describe what Pivot Chart Field Buttons are and when they might be helpful. With each version of Excel, Microsoft seems to rotate whether or not Pivot Chart Field Buttons are on or off by default. Once you...
by Nate Moore | Jan 30, 2013 | Pivot Tables
Watch Excel Video 328 to see how easy it is to chart Pivot Table data with Pivot Charts. A Pivot Chart is an Excel chart linked to a Pivot Table. You’ll find all of the chart types and features you’re used to with charts conveniently linked to a Pivot Table. If you...
by Nate Moore | Jan 28, 2013 | Pivot Tables
Now that you’re familiar with subtotals in Pivot Tables, Excel Video 327 takes subtotals to a whole new level. Watch how we can turn one subtotal into several subtotals and show the sum, count, average, maximum and/or minimum values as part of a subtotal. You need to...
by Nate Moore | Jan 23, 2013 | Pivot Tables
Watch Excel Video 326 for four ways to tweak what your Pivot Table looks like. We’ll walk through several examples today of some Pivot Table layout choices like adding a blank row after each subtotal, whether or not grand totals are used, and where subtotals are...
