by Nate Moore | May 2, 2012 | Basics
I hope you’re not mixed up after learning about mixed cell references in Excel Video 254. Now that you’re familiar with relative cell references and absolute cell references, we’ll mix things up a little. Instead of either letting both the row and column components of...
by Nate Moore | Apr 30, 2012 | Basics
You absolutely need to understand absolute cell references to be a power Excel user, so watch Excel Video 253 today. In Excel Video 252 the row and column references in our formula changed each time we pasted the formula to a new cell. While many times I want the...
by Nate Moore | Apr 25, 2012 | Basics
Excel Video 252 describes a relative cell reference, or a formula that changes the row and column references when it’s copied. Relative cell references are very common and very useful in Excel. For many formulas, you want the row and column references to change as the...
by Nate Moore | Apr 23, 2012 | Basics
Excel Video 251 covers one more worksheet tab trick I think you’ll find helpful. We’ve discussed how to write formulas to capture data from multiple tabs. While that’s very helpful, if you have 12 tabs for each month of the year, selecting all 12 cells on 12 monthly...
by Nate Moore | Apr 18, 2012 | Basics
If you have similar data on multiple tabs, Excel Video 250 will save you a ton of time. If your spreadsheet has a tab for each month in a year, each physician in your practice, each clinic location, or other similar data, it’s easy to change the same things on...
