Data Cleanup and Analysis with Formulas
Clean the text, numbers and dates a system exports, answer questions of the data with FILTER, SORT and UNIQUE, and reconcile two lists. Every step is a formula, so it still works when next month’s export arrives.
- 15 exercises
- 79 graded cells
- 107 minutes of practice
- 1 free lesson
Syllabus
Cleaning Exported Data
Text CleanupFree
Fix spacing and capitals, turn amounts exported as text into numbers, and pull a number out of a reference code.
Date CleanupFull access
Rebuild real dates from exported codes, bucket dates by month end and label them by quarter.
Dynamic Arrays
FILTERFull access
Pull matching rows into a live list on one condition, on two, and on either of two, with a fallback when nothing matches.
SORT and UNIQUEFull access
Sort a table with a formula, list each value once and count them, and build a sorted summary by region.
Reconciliations
Reconciling Two ListsFull access
Flag each invoice as matched or missing, measure the differences, and list the exceptions on both sides.
Guides for this course
Review a concept before your next exercise.
Keep practising
Check your skills with the free financial modeling test, or explore a related course.
Included in full access
This course and every other on FinX, plus every course added later.
$99.99 USD · paid once
One-time payment. No recurring subscription. 30-day money-back guarantee. Review the final total at checkout.
Secure checkout by Paddle. Tax is added where it applies; you see the total before you pay.
Read the refund policyWhat you'll build:
- • Cleaning Exported Data
- • Dynamic Arrays
- • Reconciliations