Excel Video 334 Changing Constraints in Solver
Some of the real power of Solver comes when Solver can’t find a solution. I’ll show you what I mean in Excel Video 334. In today’s example, the number of patients decreases so much that even after changing the reimbursement and the cost of the equipment, Solver can’t...
Excel Video 333 Introducing Solver
Goal Seek is great, but as things get more complex, Solver can help you in Excel Video 333. We’ll start with one more Goal Seek example, but as the examples get more complicated, the challenge is that Goal Seek can only change one variable at a time and you can’t put...
Excel Video 332 Goal Seek Part 2
Excel Video 332 has more Goal Seek examples. I’ll also spend a minute demonstrating how complicated your spreadsheet could get if you try replicate everything that Goal Seek does. It’s much easier to maintain one formula to manage all of the variables than to try to...
Excel Video 331 Introducing Goal Seek
Now that you’re a Pivot Table Master, Excel Video 331 introduces an Excel feature I’ve been waiting to show you, What-If tools. Excel is great tool for data analysis and there are several Excel tools to make that analysis even more powerful. We’ll start with Goal...
Excel Video 330 Create a Pivot Chart from Scratch
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...
Excel Video 329 Pivot Chart Field Buttons
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...
Excel Video 328 Introducing Pivot Charts
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...
Excel Video 327 Pivot Table Custom Subtotals
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...
Excel Video 326 Pivot Table Layouts
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...
Excel Video 325 Pivot Table Style Options
Your CPA friend can’t teach you very much about style, but he can show you how to change Pivot Table styles in Excel Video 325. There are a bunch of preset styles to customize the way your Pivot Table looks. Styles are a great way to make your Pivot Tables look...
Excel Video 324 Remove Deleted Items from Pivot Table Drop Down List
The first time you see what I’ll show you in Excel Video 324, you might think Excel has a bug. If you delete data in your Pivot Table because a name changed or you fixed some incorrect data, you’ll still see the name in the drop down manual filter list, even though...
Excel Video 323 Pivot Table Display Options
Watch for two display tips in Excel Video 323. The first tip is helpful if you used to use Pivot Tables in versions of Excel prior to Excel 2007. Now that I’m familiar with the Pivot Table Field List, I don’t use the Classic Pivot Table layout any more, but it was...
Excel Video 322 Sort Pivot Tables with Custom Lists
Excel Video 322 addresses a project I’m currently working on for one my clients. For reporting purposes, this practice cuts off their month two or three business days before the end of the calendar month. When you group dates in Pivot Tables, you can group by January,...
Excel Video 321 Allow Multiple Filters per Field
The next time you need a complex filter in your Pivot Table, remember this trick from Excel Video 321. We’ve discussed manual filters, label filters, and value filters in these Excel Videos. The filters are great, but normally you can only use filter at a time. If you...
Excel Video 320 Pivot Table Format Options
If you haven’t been frustrated by the Pivot Table behavior we’ll discuss in Excel Video 320, you probably will be at some point. If you’ve created the perfect Pivot Table and have it formatted to precisely fit one page, you might be frustrated when you refresh your...
Excel Video 319 Pivot Table Layout Options
Excel Video 319 has several ways to adjust the layout of your Pivot Table. If you have several columns in your Pivot Table and you’d like to center your column label over those columns, you need to spend a few minutes in the Pivot Table Options menu. That same Options...
Excel Video 318 Show Report Filter Pages
If you need to create a series of filtered Pivot Tables quickly, Excel Video 318 has a trick for you. If you’ve created a Pivot Table and now want to show a filtered Pivot Table to each of your 8 doctors or for each of your 3 practice locations, Show Report Filter...
Excel Video 317 Pivot Table Menu Tips
Excel Video 317 is a collection of several tips from the Pivot Table Options Menu to make your life easier. The first tip is how to quickly remove all filters. Be careful to clear filters, not clear all. Clear all will clear your entire Pivot Table without an undo...
Excel Video 316 Refreshing Pivot Table Data
Excel Video 316 has one of the most important things to know about a Pivot Table. One of the reasons Pivot Tables can manipulate so much data so quickly is that once you set up a Pivot Table in Excel, Excel never goes back to the original data to see if the data has...
Excel Video 315 Pivot Table Field List
Pivot Tables are easier to organize and manage if you know the tricks to using the Pivot Table Field List shown in Excel Video 315. Watch how to hide the Pivot Table Field List when you’re presenting your Pivot Table. We’ll also discuss several ways to display your...