test yourself
Getting to know Excel inside out is all about practice. The more you use it, the better you get at it. Therefore, instead of reading endless blog posts, I want you to be able to practice what you have learned.
Below are various exercises that you can challenge yourself with. Download the file, see how well you can do without any help, and if you get stuck, the solution is also available for download. If you really don't know where to start, there will be a suggested blog post to read that deals with the skills required to be able to complete the challenge.
Every challenge has more than one task, starting with an easy, beginner-level task and ending with more challenging ones that will get your Excel brain working. Therefore, no matter your skills level, I am sure that you will learn something new with each challenge.
Below are various exercises that you can challenge yourself with. Download the file, see how well you can do without any help, and if you get stuck, the solution is also available for download. If you really don't know where to start, there will be a suggested blog post to read that deals with the skills required to be able to complete the challenge.
Every challenge has more than one task, starting with an easy, beginner-level task and ending with more challenging ones that will get your Excel brain working. Therefore, no matter your skills level, I am sure that you will learn something new with each challenge.
IF functions
Required skills: Understanding of the IF function, nesting of the IF function, AND & OR function and IFS function. Suggested reading: Blog post explaining basics of IF, AND, OR and IFS functions. |
|
Date formulas
Required skills: Knowledge of EDATE, EOMONTH and WORKDAY formulas. Suggested reading: Calculations with dates blog post. |
|
Absolute & relative references
Required skills: Understanding of the difference between a relative and an absolute cell reference. Suggested reading: Blog post explaining relative and absolute cell references. |
|