Tag Archives: Intermediate

VLOOKUP vs XLOOKUP, What’s the Difference and When to Use Them

VLOOKUP vs XLOOKUP, What’s the Difference and When to Use Them thumbnail

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.   VLOOKUP Syntax and Examples Here is the syntax: VLOOKUP (lookup_value, table_array, col_index_num,…
Read More

Intermediate Excel Skills – Which Ones Do You Need?

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…
Read More

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.

Categories