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

Excel Proposal

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

Every Excel Chart

This template is a comprehensive showcase of all chart types, designed for education and reference. Each chart is paired with example data...

CFO Report

This template outlines key financial metrics, including revenue, expenses, profitability, and cash flow. It includes sections for financial performance analysis...

Balance Sheet workpapers

This template is a detailed tool for preparing and reconciling balance sheet accounts. It includes structured schedules, formulas...