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...

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...

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...

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...

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...

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...

Excel Video 248 shows you how move and copy tabs within your existing workbook, to an open workbook, or to a new workbook. Once you start organizing your spreadsheets with tabs, you’ll find it very helpful to move and copy tabs around workbooks. You’ll see in the...

Excel Video 247 introduces tabs, a handy way to organize data in your workbook. Watch how easy it is to add and delete tabs, to rename tabs, and to change the color of tabs in your workbook. Watch for the shortcut to add a worksheet tab that’s faster than...

Excel Video 246 introduces a second way to insert and delete. It’s more flexible, but you have to be careful. The Insert and Delete buttons offer more flexibility to insert and delete cells, rows, and columns. The catch to the flexibility is that if you aren’t...

There are two ways to insert and delete rows and columns. Excel Video 245 has the easier way. There’s another way to insert and delete rows and columns that offers more flexibility, but with a catch. We’ll cover that next time. Watch today’s video to see how to easily...

Freeze Panes is a great way to take the pain out of navigating around a large spreadsheet in Excel Video 244. Freeze Panes is a way to lock in rows and/or columns so that when you scroll down or to the right you still see the row and column headings you need to make...

AutoCorrect is a great trick that will save you from frustration and save you time, all in Excel Video 243. AutoCorrect is a feature built into Excel to correct things like typos and misspellings. AutoCorrect is a great thing until you get burned by typing CNA and...

Excel Video 242 has another data entry shortcut to make your life easier. Excel calls the feature AutoComplete. AutoComplete looks at text you’ve already entered and uses that to anticipate what you intend to enter as you start typing. For example, if Blue Cross is in...

Excel Video 241 will help you make entering data easier by controlling what happens after you hit Enter in Excel. Instead of hitting an arrow key to move to the next cell, you can get Excel to move to the next cell for you as you enter data. If you have a long list of...

There seem to be several ways to do everything in Excel. Excel Video 240 has another way to work with Comments that may be helpful for you. If you go to the Review tab, the middle section includes a variety of ways to work with Comments. Most of the functionality on...

If you liked Excel’s comment feature in the last Excel Video, Excel Video 239 has some additional options for comments that will help you. Watch Excel Video 239 to see how to delete comments and how to make comments always display even if you aren’t hovering over the...

If you haven’t used comments, Excel Video 238 will show you that you’re missing an easy way to document your Excel spreadsheet. By right-clicking and selecting Insert Comment, you can add notes to any cell in Excel. Comments are a great way to document the sources for...

If you’re spending too much time hiding and unhiding rows and columns on your spreadsheet, watch Excel Video 237 to learn about custom views. Custom views are simply a way to save a view of your spreadsheet. You can hide the rows and/or columns you want to and then...

Since Leap Day only appears once every four years, it’s a good time to discuss how to hide and unhide data in Excel Video 236. Hiding rows and columns is an easy way to clean up some of the sometimes messy calculations that go into creating a spreadsheet. You can hide...

Would you like to make your spreadsheets consistently look great? Watch Excel Video 235. Today we’re talking about Cell Styles, a way to consistently format headings, input cells, good news, bad news, calculations, and more. Cell Styles are on the Home tab in the...