Loading...

Follow Excel University Blog on Feedspot

Continue with Google
Continue with Facebook
or

Valid
Welcome to Round 6! In this round, we’ll discover how both functions behave when we insert a new worksheet column. In other words, does ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Round 5 begins now! In this post, the goal is to understand the results of each function when no matching rows are found. That is, when the ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Welcome to round 4. In this round, we want to explore the issue of return values. Specifically, the data types that our two heavyweights ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Excel is big … really big. It has hundreds of functions and features, but which of these have the most potential to save time and help us ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Welcome to Round 3. In this round, we want to explore the idea of column order. That is, we want to find out if the order of the lookup ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Excel University Blog by Jeff Lenning - 1M ago

Raise your hand if you love VLOOKUP? Me too! We Excel users have grown to love VLOOKUP over the years. But, XLOOKUP offers some advantages ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
I am thrilled to announce this year’s Excel University scholarship winners! These scholarships are supported by the Excel University ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Round 2 begins! In this round, the goal is to understand what happens when values that are supposed to match are stored as different data ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
It is time! In the first post, we met VLOOKUP. In the second post, we met SUMIFS. And now, the battle begins! Here is how it will work. The ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview