This Week: Excel for Mere Mortals
This Week: Excel for Mere Mortals
| technology | productivity - Michael Hess

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.

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.

CBT Nuggets uses cookies to give you the best experience on our website. You can read more about our use of cookies, or just continue to use the site as you normally would if you agree.