by Nate Moore | Feb 22, 2012 | Basics
Excel Video 234 includes a couple more tips as we analyze the sample fee schedule we’ve been working on. Watch for how the F2 key not only lets you edit the formula, but Excel also color codes the formula components so you can easily find the cells that influence the...
by Nate Moore | Feb 20, 2012 | Basics
Watch for more Excel tips as part of our fee schedule analysis example in Excel Video 233. We’ll use the division rules from Excel Video 231, format the results as a percentage, and then once we have our formulas ready, we’ll use the double-click trick to fill the...
by Nate Moore | Feb 15, 2012 | Basics
I’m taking a different approach to the next couple Excel Videos, starting with Excel Video 232. Instead of covering a specific Excel function or feature, I’m going to use several Excel features as part of sample fee schedule analysis. I hope this approach makes it...
by Nate Moore | Feb 13, 2012 | Basics
The next time you need to “do the math,” do it in Excel with the basic math functions explained in Excel Video 231. Excel makes it easy to add, subtract, multiply and divide. Today we’ll go through an example of each function in the context of a sample fee schedule....
by Nate Moore | Feb 8, 2012 | Basics
Excel Video 230 shows how easy it is to get data from the internet into your Excel spreadsheet. If you’re downloading static data on a one-time basis, you can save time by having Excel enter the data for you. Not only does importing the data beat typing the data into...