What Excel skill level is needed for Transfer Pricing senior consultant

I am interested in applying theTransfer Pricing senior Consultant position at Deloitte. On the ads, it is stated that "Computer skills with knowledge of MS Excel preferred". I am not quite sure how advanced the Excel skill needs to be for Transfer Pricing senior Consultant. Do they use Pivot table/chart? VBA editting? Monte-Carlo simulation? I learned about them a little bit, but not enough to list them on my resume. So I want to check with the current professionals in this area. You don't have to be from Deloitte, any big four will do. I really want to get the job, but I am not in a hurry. I am willing to get prepared before submitting my application. Thanks for your help!