by Nate Moore | Feb 20, 2013 | Uncategorized
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...
by Nate Moore | Feb 18, 2013 | Uncategorized
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...
by Nate Moore | Feb 13, 2013 | Uncategorized
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...
by Nate Moore | Feb 11, 2013 | Uncategorized
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...
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...
