Accounting Clerk Mock Interview

Practice 25 Accounting Clerk interview questions covering reconciliations, accuracy, and accounts payable processes.

WRITTEN BY SAMANTHA HAMILTON
QUESTION 12 OF 25

How proficient are you with Excel? Please share some projects you created and regular accounting tasks you completed on Excel.

"I'm a basic user. I can do searches and filtering but haven't used it much in my career at this point. In college, I learned how to do use formulas like vlookups and hlookups, and feel comfortable doing those as well as pulling data from one tab and inserting it on another."

"I'm an advanced user. I've undergone training directly from Microsoft on power queries and all formulas they created through 2019. I've led training in my previous company to show other users how to use advanced Excel techniques to include power queries and macros."

Be candid with the interviewer when sharing your level of experience with Excel. Your honest response will help the interviewer prepare a better training plan for you if you're hired for the job. Tell the interviewer if you're a beginner, intermediate, or advanced user of the system. Then share a few projects you created using Excel as well as accounting tasks that you regularly complete in the system.

Don't assume that you don't need Excel knowledge to handle an accounting role. Yes, there are many types of software available but none can currently replace Excel. It's the most widely used and most companies prefer it.

"I'm an intermediate user. I can use formulas to do vlookups and concatenations. I'm well versed with most Excel functions but I can't do power queries yet. I'm open to training opportunities to further my knowledge on this."

Samantha Hamilton
25 QUESTIONS & ANSWERS · ACCOUNTING CLERK
See membership