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...
by Nate Moore | Jun 6, 2012 | Basics
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,...
by Nate Moore | Jun 4, 2012 | Basics
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...
by Nate Moore | May 30, 2012 | Basics
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...
