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...
by Nate Moore | May 28, 2012 | Basics
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...
by Nate Moore | May 23, 2012 | Basics
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...