In the daily work of an accountant, seven key formulas — for VAT, depreciation, personal income tax, amount in words, cost consolidation, and period comparison — save hours of manual labor.

For example, to calculate personal income tax with deductions, ROUND and SUM are used, while for consolidation by items, the powerful SUMIFS is used. The formula for amount in words often requires a macro.

It is convenient to collect these formulas into one template for automation. Detailed examples of working with the SUMIFS function in Excel will help you master it faster.

🔗 Source: excel.rf