Excel & Google Sheets Skills for Accountants Workbook
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.
Everything you get
-
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.
Not a template you fight with
| Feature | This system | A generic template |
|---|---|---|
| The formulas | Visible and editable. You can trace any number back to its source. | Often locked or protected so you can't see the working. |
| When it doesn't fit | Change it. The structure is yours once you download it. | Work around it, or start over. |
| Formats | Google Sheets and Excel, both included. No installation. | Usually one, often the one you don't use. |
| Who built it | An analyst who has had to defend a number to a CFO. | Frequently unclear. |
How it arrives
A download link, immediately after checkout. Nothing is posted to you.
What you get
Google Sheets and Excel files, plus printable PDFs where the product includes them. No installation.
What you can change
All of it. Rename tabs, add rows, rewrite formulas - it is your copy.
Refunds
Digital files cannot be returned once downloaded. If something is broken or not as described, email hello@analyticsbyshanikwa.com and it will be put right.