It’s not an exaggeration to say that Excel is the most-used business software tool in the world. Some have even described it as the “Swiss Army Knife” of business analytics, but whether you use the blade or the spork, all users benefit from learning keyboard shortcuts that keeps their hands on the keyboard.
The “new” XLOOKUP function was introduced in Excel 2021 and Office 365, and improves upon the heavily used VLOOKUP function in several ways. Let’s start by reviewing the syntax and an example of each function to understand the differences, starting with VLOOKUP.
Definitions of what Excel tasks are considered “basic”, “advanced”, “intermediate” and in between can vary from company to company or industry to industry. An accounting firm, for example, may consider specific accounting functions, VLOOKUP and INDEX/MATCH “basic” tools for the job while an HR department might consider these unnecessary but require knowledge of Power Query and advanced conditional formatting.
When it comes to storing, analyzing and visualizing data, Microsoft Excel is the preferred choice. But, when the source of the data you need to analyze is contained within a PDF file, your first step is going to be getting it into Excel.
The Portable Document Format, known best by its acronym and file type “PDF”, was developed by Adobe Systems in 1993 and has remained the standard for consumer printing, publishing and electronic sharing ever since. It is no wonder, then, that every now and then the need to convert information stored in a PDF into an Excel worksheet comes up. Powerful tools are destined to collaborate.
Your event planning company is preparing for a large company meeting. Managers from each department have been tasked with gathering and reporting meal orders, chosen from six meal options, into a shared event spreadsheet. This is the form you sent and the list of meal options offered:
Why is this mentioned in a post about Freezing Rows? Imagine trying to read a sheet with the headers 1000 rows above the data you are looking at.
We’ve all done it. Mis-clicked. Mis-typed. Hit enter when we meant to hit tab. And while it’s frustrating to make mistakes in a spreadsheet of our own data, when managing important company assets those mistakes can have expensive consequences.