It’s not Disney, folks, but I think you’ll find these videos very helpful. 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 shows how to create a basic Pivot Table from sample medical practice data. From there, I’ll add additional videos on filtering, sorting, and doing a variety of different calculations in Pivot Tables. Pivot Tables are an incredible way to manage medical practice data. A well designed Pivot Table can replace dozens of canned reports and is much easier to use in carving up and drilling down to analyze a practice’s revenue cycle. I hope you find these training videos useful as you incorporate Pivot Tables in your medical practice.
Please feel free to make suggestions on other Excel topics you’d like to see in these training videos. While I’m starting with Pivot Tables, I intend to add videos on other Excel topics as well, such as VLOOKUP, Conditional Formatting, Charts and Graphs, etc.