Almost every accountant says they are good at Excel. Most are good at the part of Excel they use every day, and that is a different thing. The gap shows up in the workbook nobody else can follow, the reconciliation that takes three hours because the data had to be fixed by hand, and the lookup that silently returned the wrong row.
This post is a skills checklist for Excel and accounting work, organized by the tasks accountants actually do rather than by menu. For each area it covers ...