Name: Excel for Accounting - 10 Excel Functions You NEED to KNOW!
Uploaded: 2026-01-13T17:28:11.533Z
Duration: 1145 s
Description: This video tutorial introduces 10 essential Excel functions for accounting professionals, demonstrating how to use them to summarize data, handle errors, round numbers, manage dates, calculate working days, and create 3D formulas. It focuses on practical applications to streamline financial data analysis.

AI Commentary

Play the video to see AI commentary

Oh, this AGGREGATE function sounds super useful, especially the part about ignoring errors and hidden cells. That's a big upgrade from SUBTOTAL, which I always found a bit limited.

Yeah, that ignore option with AGGREGATE is key. The fact that SUBTOTAL couldn't handle error values is a classic pain point, so it's good to see that addressed. It makes calculations much cleaner.

This is where AGGREGATE really shines – ignoring hidden rows is a game-changer for dynamic reports. Being able to filter sums based on visible data without extra steps is incredibly efficient.

Want more insights? Sign up to see the full conversation

Video summary will appear here after you start watching

The AGGREGATE function, introduced early on [0:00], offers a powerful way to summarize data by allowing users to ignore error values and hidden cells, a significant improvement over the older SUBTOTAL function. This flexibility is demonstrated when summing amounts, where AGGREGATE can specifically exclude errors [0:30] or hidden rows [1:00], providing more accurate calculations. It's particularly useful for calculating profit before tax by summing specific ranges while ignoring other aggregated values [1:30].

Want to access full features?

Current Section Summary

Video summary will appear here after you start watching

Want to access full features?

Excel for Accounting - 10 - AI Video Analysis

AI Commentary

Current Section Summary