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...
by Nate Moore | Apr 16, 2012 | Basics
Now that we’re more familiar with tabs, watch Excel Video 249 to write formulas that reference data on other tabs. As you watch how to write formulas to reference data on other tabs, one of the biggest takeaways is that I don’t get too worked up about Excel syntax for...
