Select Page

Excel Video 262 Custom Sorting in Excel

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...

Excel Video 261 Sorting in Excel

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...

Excel Video 260 Use Fill Justify to Manage Text

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...

Excel Video 259 Fill Trends

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...

Excel Video 258 Fill Series

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...