by Nate Moore | Jun 25, 2012 | Basics
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...
by Nate Moore | Jun 20, 2012 | Basics
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...
by Nate Moore | Jun 18, 2012 | Basics
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...
by Nate Moore | Jun 13, 2012 | Basics
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...
by Nate Moore | Jun 11, 2012 | Basics
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...
