Today Excel Video 274 will use Go To Special to find a cell’s precedents and dependents. We talked about precedents and dependents in Excel Video 197. Precedents and dependents are like having a crystal ball with a rear view mirror attached. Precedents are like the...

If you’ve hidden rows or columns and don’t want to copy what you’ve hidden, watch Excel Video 273. There are a couple of different ways to not display something in Excel. You can format your data as a table and then filter out the rows you don’t want to display. If...

Excel Video 272 is the first of several Excel Videos with practical examples using Go To Special. Today we’ll create a reusable expense form that makes it easy to delete all of last month’s data without having to recreate the form to enter this month’s data. There are...

When you want to tell Excel where to go, Excel Video 271 may not be what you had in mind. Today we’ll talk about how to get Excel to quickly go to a specific cell or to quickly select and highlight all of the formulas, comments, conditional formatting, constants or...

In Excel Video 270 we’ll find cells based on the format of the cell. If you don’t care about the contents of the cell but want to find all of the cells with a red background color or a blue font, here’s how to do it. You can also find cells based on both the content...

If you need to find comments, search throughout your Excel spreadsheet, or make your searches case sensitive, watch Excel Video 269. We’ll start on the options available in the Find and Replace window today. You’ll see how to search across an entire workbook instead...

Now that we know how to find things in Excel, Excel Video 268 shows how to find parts of things. By parts of things I mean rather than looking for an entire CPT code like 99201, we can search for all of the codes that start with 992 or that end in 1. The trick is to...

If you still haven’t found what you’re looking for, watch Excel Video 267 today. Excel Video 267 is the first in a series of videos about the find and replace features in Excel. As we go through the basics, watch for a potential gotcha. If you highlight an area of...

Excel Video 266 walks you through 5 different ways to clear components of your data from a spreadsheet. The Clear menu is the tool we’ll use to do the clearing. We can clear everything with Clear All, we can just remove the formats with Clear Formats, we can just...

If you liked filtering data in the last Excel Video, you’ll really like the added advantages of filtering data in a Table shown in Excel Video 265. Once you format your data as Table, you’ll automatically get the drop-down arrows with all of the filtering and sorting...

Excel Video 264 covers filtering, a powerful way to focus on the data you need to work on. It’s easy to turn on filters, but you may find it helpful to get your data organized with column headers in the top row before you turn the filters on. Once you turn on filters,...

Tables are an easy way to sort data in Excel without worrying about scrambling your data. Watch how easy it is to sort data in a table in Excel Video 263. Once you’ve created a table that includes all of your data, you don’t have to worry about scrambling your data...

Excel Video 262 will let you customize your sorting options. One of the main things you can do in the custom sort window is to sort by more than one column. In our example, we’ll sort by the payer, then by the balance of the accounts receivable on a claim. It’s easy...

Sorting data in Excel is a very common task. Watch Excel Video 261 to see how to sort data and how NOT to sort data in Excel. Sorting data is a powerful way to focus on the important parts of your Excel data. If you aren’t careful when you sort, however, you can...

If you type instructions, details supporting spreadsheet values, or other text in a spreadsheet, you’ll love the shortcut in Excel Video 260. Justify, the bottom entry in the Fill menu we’ve been working with, automatically fits the text you’ve entered into the...

Take your fill skills to the next level by watching Excel Video 259 about the Fill Series window. Learn how to add linear trends (adding) and growth trends (multiplying) to quickly enter a series of numbers in your spreadsheet. We’ll also go through an example with...

Show Excel a pattern to fill in Excel Video 258 and you’ll be surprised how many patterns Excel can recognize and how much time you can save entering data. As we saw in the last Excel Video, Fill is a really fast way to enter data. The more ways we can teach Excel how...

Excel Video 257 starts our discussion of another shortcut that can save you a ton of time. Excel calls it Fill, and you can Fill Down, Fill Right, Fill Up, or Fill Left. As you’ll see in the video, I think the Fill Handle is the fastest way to fill data. Watch how...

Watch Excel Video 256 for two fast ways to sum data, one of the most common things to do in Excel. Today I’ll show you two quick ways, a sum icon you can click on or a Alt+= shortcut to type. Part of the reason the shortcuts save time is Excel takes its best guess for...

There are four ways to do just about everything in Excel. Excel Video 255 has some additional ways to do things you may already be doing in Excel. This is an easy video today. We’re back to the Home tab on the Ribbon working our way across the basics of Excel. We’ll...