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