Building Excel Formula Test File

[yazman08]

Hey all, before I reinvent the wheel maybe you all can point me in the right direction. I currently have 5 or 6 new employees that have limited excel skills, I am thinking about creating like a test workbook with some of the following formulas for them to practice.

Vlookup,Hlookup, if , if and ,if or, count, countif,sum if, concatenate,sum to name a few......Was justing going to do a here is the answer sheet you try and re-create the formula. Has anyone else built something like thi, or is there anything on the web that I can get my hands on? Thanks all

Yaz

 

[juster21]

I have created a test workbook using 2 sheets and then locked the answer sheet. Or you could protect the cells with a password where the correct formula is the password....just a thought