6 Excel Functions for Accountants

This workbook teaches you 6 of the most useful Excel functions

Instructions

Use this workbook to learn the following Excel functions:

SUMIFS
XLOOKUP
COUNTIFS
IF
EOMONTH
UNIQUE

Each tab has instructions and a problem to solve for each of these excel functions

More Templates

Sales Dashboard

This dashboard shows you total sales compared to last year, average monthly sales to set realistic targets, quarterly breakdowns to reveal seasonal patterns...

Financial Health Dashboard

This dashboard showcases your financial and cash metrics, indicating how good your business is doing

Cash Flows Dashboard

The Cash Flows Dashboard tracks your company’s cash inflows and outflows, offering insights into liquidity and cash management...

Excel Proposal

This template is a structured spreadsheet designed to outline project details, objectives, timelines, costs, and deliverables...