Skill path · IntermediateLive
Data Analysis with Formulas
Text and date cleanup, FILTER, SORT, UNIQUE and reconciliations.
15 exercises · 107 min · 79 checked cells
3 of 15 exercises free, no account needed.
The route
- 1Text CleanupCleaning Exported Data3 exercises · 21 minFree
- 2Date CleanupCleaning Exported Data3 exercises · 21 minFull access
- 3FILTERDynamic Arrays3 exercises · 21 minFull access
- 4SORT and UNIQUEDynamic Arrays3 exercises · 21 minFull access
- 5Reconciling Two ListsReconciliations3 exercises · 23 minFull access
What it ends in
A FinX certificate of completion, which anyone can verify by link.
Questions
- How long does Data Analysis with Formulas take?
- About 107 min: 15 exercises in 5 lessons, with 79 checked cells between them. Times are estimates from writing the lessons.
- What can I do for free?
- 3 of the 15 exercises are free, with no account: Text Cleanup. Full access opens the rest.
- 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?
- Business and Operations Analyst. A career path strings skill paths together in the order a job uses them.