Need Proficient Excel Master

I have several reports and data sheets that I need help creating a master reporting document to pull all sheets of ---------- 's too complicated to write out but will be looking for someone full-time to help build this out for me and manage the ---------- order to fit this position, you must be familiar with:

Vlookups
Power query editor
etc.

Please respond with some examples of advanced excel formulas you've worked with before so i can get an idea of your capabilities.

Thanks!
-M