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.

Posts

Battle of Heavyweights: Round 7

By Jeff Lenning | October 16, 2019 |

The purpose of this round is to examine the issue of multiple lookup columns. Often, we have a single unique ID that we can use as the lookup value. When that is true, great. But, what happens when we need to use multiple columns for our lookup value? That is exactly what this round is…

Read More

Battle of Heavyweights: Round 6

By Jeff Lenning | October 9, 2019 |

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 inserting a new worksheet column break the formula? Or, will it keep working? Let’s find out … the round begins now. Round 6  We would like to retrieve some information…

Read More

Battle of Heavyweights: Round 5

By Jeff Lenning | October 2, 2019 |

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 lookup value is not found in the data table. Do the functions return an error? The closest match? 0? Well, that is why we are here, so let’s…

Read More

Battle of Heavyweights: Round 4

By Jeff Lenning | September 25, 2019 |

Welcome to round 4. In this round, we want to explore the issue of return values. Specifically, the data types that our two heavyweights can return. Can they return text values? Numbers? So, that’s the idea … let’s jump right in. Round 4 … ding! Round 4  We have some account numbers, but we…

Read More

Make Quick Work with these 10 Excel Skills

By Jeff Lenning | September 18, 2019 |

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 work faster? The answer depends on what you’re working on. For common accounting and finance tasks, I believe the following 10 Excel skills can help improve the efficiency…

Read More

Battle of Heavyweights: Round 3

By Jeff Lenning | September 10, 2019 |

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 table columns matter to these functions. Let’s find out! Round 3 … begins now! Round 3  We are trying to build a little report, and…

Read More

XLOOKUP

By Jeff Lenning | August 29, 2019 |

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. XLOOKUP? That’s not a typo. Depending on your version of Excel and when you are reading this, you may see this function immediately, or it may be a while before…

Read More

2019 Scholarship Winners

By Jeff Lenning | August 27, 2019 |

I am thrilled to announce this year’s Excel University scholarship winners! These scholarships are supported by the Excel University Alumni Association, so thanks to all of you who have helped make these awards possible. Based on the number of Alumni Association members, I’m so happy to be able to award four scholarships this year! Each…

Read More

Battle of Heavyweights: Round 2

By Jeff Lenning | August 19, 2019 |

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 types. Different data types? Cells can store many kinds of data, including numbers, text, dates, times, and so on. The format you apply to a cell doesn’t impact the data…

Read More

Excel Breakout Puzzle 7

By Jeff Lenning | August 12, 2019 |

The next Excel breakout puzzle is ready! And it’s a goodie 🙂 I realize fall doesn’t officially start for a few weeks, but, our kids start school next week and so it already feels like fall is upon us. Fall means back-to-school, cooler weather, falling leaves, and … american football. My son plays, and so…

Read More