Learn how GROUPBY passes both subset and full arrays into LAMBDA in Excel, letting you compute percent shares fast and explain results clearly.

For many years, I used the SUBTOTAL function in Microsoft Excel to create easily visible subtotals at the top of my worksheets. However, when I encountered AGGREGATE, this became my go-to function for ...

Unlike SUM, which ignores filters, SUBTOTAL dynamically adjusts to display only visible data. It offers 11 built-in functions, with additional options (101-111) that account for hidden rows. When ...

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...

FORECAST.ETS applies an exponential triple smoothing (ETS) algorithm to create forecasts that can include trend and seasonal ...

Lucas Downey is the co-founder of MoneyFlows, and an Investopedia Academy instructor. Dr. JeFreda R. Brown is a financial consultant, Certified Financial Education Instructor, and researcher who has ...

The declaration date is when a company announces its next dividend payment; it's also an option's expiration date. Once a dividend is declared, it becomes the company's legal responsibility to ...

Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.