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.
moving average
Bollinger Bands with Excel
Discover how to create and interpret Bollinger Bands in Excel for stock price analysis. Improve your trading strategies.
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)
