Excel & Google Sheets Skills for Accountants Workbook

Excel & Google Sheets Skills for Accountants Workbook — the spreadsheet skills accounting classes assume you already have. 5 files · instant download.

What's inside

• VLOOKUP/XLOOKUP for Reconciliations Practice Tab — two mock ledgers to reconcile with lookup formulas, plus a working answer file.
• Pivot Table for Expense Summaries Practice Tab — raw transaction data with step-by-step instructions to build a category/month expense summary.
• SUMIF/COUNTIF for Account Totals Practice Tab — build conditional totals across a multi-account transaction log.
• Bank Reconciliation Template — pre-built formulas that auto-flag the difference between book and bank balance.
• Keyboard Shortcuts & Formula Cheat Sheet — the 25 shortcuts and formulas used most in daily accounting spreadsheet work.

What you get

• 5 files. No installation.
• Instant download through Shopify.

Bought separately: $49.97. Bundle price: $27.99.

Questions? Email hello@analyticsbyshanikwa.com.

— Shanikwa · Built from real work. Not theory.