Part 3: Data Analysis

According to Microsoft, VLOOKUP is the third most frequently used worksheet function, falling behind the SUM and AVERAGE functions. Despite its popularity, VLOOKUP hasn’t aged well, and so modern times call for a modern lookup function known as XLOOKUP. The XLOOKUP function is part of a new class of worksheet functions known as dynamic arrays that can spill results into as many adjacent cells as needed. Even better, almost every worksheet function in Excel now has the ability to take on dynamic characteristics. This part will then delve into two other recent additions to Excel, the LET and LAMBDA functions, that can greatly simplify complex formulas. This part closes out with a discussion of Power Query. The Power Query feature isn’t new, but most Excel users are unaware of this code-free solution for connecting to data sources. Power Query enables you to easily transform results into refreshable connections that protect data from being overwritten...