Skill path · Beginner–intermediateLive
Lookups: VLOOKUP to XLOOKUP
VLOOKUP, INDEX and MATCH, and XLOOKUP, on finance data.
12 exercises · 98 min · 27 checked cells
No lesson of this path is free: every exercise needs full access.
The route
- 1Lookup FunctionsLookup & Reference3 exercises · 20 minFull access
- 2Index & MatchLookup & Reference3 exercises · 25 minFull access
- 3INDEX/MATCH CombinationsLookup & Reference3 exercises · 30 minFull access
- 4XLOOKUPLookup & Reference3 exercises · 23 minFull access
What it ends in
A FinX certificate of completion, which anyone can verify by link.
Questions
- How long does Lookups: VLOOKUP to XLOOKUP take?
- About 98 min: 12 exercises in 4 lessons, with 27 checked cells between them. Times are estimates from writing the lessons.
- What can I do for free?
- None of this path's lessons is free: every exercise needs full access, and See the first lesson opens its first one with the full access offer. To see how checking works before you pay, Excel Formulas and Functions has free lessons in the same course.
- Do I need Excel installed?
- No. Every exercise runs in a spreadsheet in your browser, and each answer is checked cell by cell, so you see exactly which cell is wrong.
- What do I get at the end?
- A FinX certificate of completion, which anyone can verify by link.
- Which career paths include it?
- Financial Analyst, Business and Operations Analyst, FP&A Analyst and Accountant. A career path strings skill paths together in the order a job uses them.