This Week: Excel for Mere Mortals
This week, we're taking a look at VLOOKUP's older sibling, essential formulas for beginners, and a few things you didn't even know Excel can do.
In many cases, merging data in Excel can easily be accomplished with a single INDEX-MATCH (or a VLOOKUP). Sometimes, though, it's time to bring out the big guns — the INDEX-MATCH-MATCH.
Excel has a ton of features. So many, in fact, that it's hard to know where to start. These nine formulas will make life easier for any Excel beginner. Once you master these formulas, you'll move from novice to intermediate, and still only be scratching the surface of Excel.
Excel is arguably the most under-utilized productivity software. Most people use Excel to simply sort and filter data. Diving deeper into Excel's advanced functionality, we found five Excel features you may be missing out on.