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.
Index-Match-Match: How to Index-Match Rows and Columns
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.
9 Essential Excel Formulas for Beginners
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.
5 Things You Didn’t Know Excel Does
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.