Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
XLOOKUP
You don’t need to be a spreadsheet pro to master these top Excel skills! See our list of easy-to-learn Excel skills with hands-on tutorials.
Read MoreExcel is one of the most powerful accounting software tools out there, and most of that power comes from the ability to use Excel formulas to automate your work. When you’re first learning how to use them, it’s easy to get a little overwhelmed – luckily, this Excel formulas cheat sheet is here to help…
Read MoreWondering how to get better at Excel? Whether you’re a new user or a pro, these are some easy steps to help you quickly master new skills.
Read MoreIn this article, we’ll show how to easily create and update Excel reports from QuickBooks. But, let’s back up a second. When QuickBooks has the report you want, awesome! But, when it doesn’t, we often turn to Excel. This can happen when QuickBooks doesn’t have all of the data you need for the report, for…
Read MoreLooking to make work easier? Instead of trying to do it all, focus on learning these nine useful advanced Excel functions.
Read MoreNeed Excel skills for work? Save time job searching by finding out exactly what Excel skills employers are looking for.
Read MoreThis is the third post in the Dynamic Arrays series. In the first two posts, we discussed the spill range and the spill reference operator. If you’ve enjoyed the first two posts, I think you’ll enjoy this one even more because we get to talk about the FILTER and XLOOKUP functions. Video Overview So far,…
Read MoreI was recently asked how to find the last occurrence of a value in a column. Although there are multiple ways to accomplish this, in this post, I’ll talk about how to use XLOOKUP. Objective Before we jump into Excel, let’s confirm our objective. Let’s say we have a bunch of transactions that look like…
Read MoreMicrosoft has been hard at work updating Excel’s calculation engine. Depending on the version of Excel you’re using, you either have—or will have when you update—access to some capabilities that are sure to change how you think about and use Excel. I wrote about one of the new capabilities called Dynamic Arrays for California CPA…
Read MoreXLOOKUP is the next-gen lookup function designed to address the limitations of VLOOKUP and related workarounds. It combines the capabilities of numerous functions including VLOOKUP, INDEX, MATCH, HLOOKUP, and IFERROR. Many have asked me to teach this via webinar. So, I created this short webinar that covers the basics 🙂 This on-demand webinar is about…
Read More