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...
by Nate Moore | May 14, 2012 | Basics
Excel Video 257 starts our discussion of another shortcut that can save you a ton of time. Excel calls it Fill, and you can Fill Down, Fill Right, Fill Up, or Fill Left. As you’ll see in the video, I think the Fill Handle is the fastest way to fill data. Watch how...
by Nate Moore | May 9, 2012 | Basics
Watch Excel Video 256 for two fast ways to sum data, one of the most common things to do in Excel. Today I’ll show you two quick ways, a sum icon you can click on or a Alt+= shortcut to type. Part of the reason the shortcuts save time is Excel takes its best guess for...
