Categories

Get Started Now

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.

 

Not a CBT Nuggets subscriber? Start your free week now.

CBT Nuggets has everything you need to learn new IT skills and advance your career — unlimited video training and Practice Exams, Virtual Labs, validated learning with in-video Quizzes, Accountability Coaching, and access to our exclusive community of IT professionals.

Learn more about the CBT Nuggets Learning Experience.

 

Comments are closed.