Weighted and Exponential Moving Average in Excel
Give more weight to recent days: calculate a weighted moving average with SUMPRODUCT and an exponential one in Excel, and see which reacts faster.
data analysis
GROUPBY function: The future of COUNTIF SUMIF
Find out how to build and use the GROUPBY function in Excel 365. Group data, calculate summaries, and update instantly.
How AI can be used in Excel for your data?
Discover how AI tools can automate tasks, identify trends, and make predictions to enhance your Excel experience
Calculate Moving Average in Excel
Calculate a moving average in Excel with the AVERAGE function: smooth out daily spikes, see the real trend on your chart, and avoid the $ trap.
Categories
- AI & Excel (3)
- Conditional (13)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (12)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (13)
- Excel Tutorial (16)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (19)
- Lookup functions (14)
- Manage data (18)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (6)
- Quiz Premium (7)
- Shortcuts (5)
- Statistical functions (27)
- Text functions (21)
- Tips and Tricks (22)
