Lookups and Logic

Make a formula decide, pull a value out of a table, total on conditions, and catch an error before it reaches a number somebody is paid from.

Excel 35 lessons30 questions10-question final exam

What this course assumes and what it gives you

Assumes: Excel II, or you already use Tables and structured references.

You will be able to: You can build a commission run that reconciles, and prove that it does.

The spreadsheet is in the page. You type your answers here and the engine works them out against real data, cell by cell, so an answer that gets there a different way is still right.

Syllabus

0 of 5 lessons done

1IF: making a formula decideWrite an IF that returns one of two results, combine conditions with AND and OR, and choose IFS over a nested tower.6 teaching steps · 6-question quizNot startedStart lesson →
2Lookups: pulling a value out of a tableRetrieve a value from another table with XLOOKUP, handle the not-found case deliberately, and read VLOOKUP when you meet it in someone else's file.6 teaching steps · 6-question quizNot startedStart lesson →
3SUMIFS and COUNTIFS: totals with conditionsTotal and count rows meeting one or several criteria, and get the argument order right first time.6 teaching steps · 6-question quizNot startedStart lesson →
4Catching errors before they spreadRead Excel's error values, trap the ones you expect without hiding the ones you do not, and trace a wrong number back to its cause.6 teaching steps · 6-question quizNot startedStart lesson →
5Building a commission sheet end to endCombine lookup, conditional aggregation and banded rates into one commission calculation that survives new data.6 teaching steps · 6-question quizNot startedStart lesson →

Final exam