MEWC
FMWC
TAC
EEO
TASK
Lana Banana snuck into your office and has been messing with your data! Get to know the data and answer your boss’s questions so you can go home! In this “Ninja Challenge” format, your goal is to answer a total of 15 questions (overcome 15 obstacles) to reach the finish line as fast as you can. You will see only 1 question at a time and you can’t skip the sequence. If you get stuck and run out of time, then your result is the number of questions you have correctly answered. Note that all needed references are provided below the answer cells to save you time. You might want to name a few ranges to save even more time!
WALKTHROUGH VIDEO PROVIDED BY DAVID BROWN
In this guide, David will explain how to solve the Ninja Style Challenge “Report Rescue Mission” efficiently using basic Excel formulas.
You will learn about things like:
- Named ranges
- Functions: COUNT, MAX, SUM, AVERAGE, MIN, COUNTIF, SUMIFS, UNIQUE, LARGE, SMALL, LEFT, VALUE, RIGHT, FIND, IFERROR
- The importance of dynamic functions
- The #SPILL! error
- Nested functions