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...
by Nate Moore | Apr 11, 2012 | Basics
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...
by Nate Moore | Apr 9, 2012 | Basics
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...
by Nate Moore | Apr 4, 2012 | Basics
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...
by Nate Moore | Apr 2, 2012 | Basics
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...
by Nate Moore | Mar 28, 2012 | Basics
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...
