by Nate Moore | Aug 12, 2013 | Excel 2013
Excel Video 374 showcases the Quick Analysis button, another easy shortcut in Excel 2013. If you highlight a group of data in Excel 2013, watch for the Quick Analysis button in the lower right-hand corner. The Quick Analysis button brings up a window with five...
by Nate Moore | Aug 5, 2013 | Excel 2013
If you’re wondering whether Excel 2013 can you save you time, watch Excel Video 373. Flash Fill is a clever new feature in Excel 2013 that can quickly extract data or reformat data without complicated formulas or macros. Watch how quickly Excel can learn from an...
by Nate Moore | Jul 29, 2013 | Excel 2013
Welcome to Excel Video 372, the first video on Excel 2013! Excel 2013 has some really cool features that I think will help you a lot. As powerful as the new features are, one of the first things we’ll do is turn off animation in Office 2013. The way I’ll show you how...
by Nate Moore | Jul 22, 2013 | Arrays
I have one more array trick in Excel Video 371 before we move on to a new topic. Today we’ll use a COUNTIF function inside a MAX function inside an IF function to determine if a list is unique. It’s really not quite as bad as that sounds. We’ll set up a COUNTIF...
by Nate Moore | Jul 15, 2013 | Arrays
Excel Video 370 has an array formula that tells you if your list isn’t sorted. The trick is to know that Excel treats B as being greater than A, so our array formula will catch times when A comes after B in a sorted list. Remember the AND function is true if all of...