Inside Microsoft Excel

Working with changing data? Spot and track trends with moving averages

Inside Microsoft Excel

by Kara Hiltz

Moving averages are a frequently used data analysis method, especially for finding trends over long periods. For example, you can find the 50-day trend of a stock to get a good picture of where it’s been and where it’s headed. A moving average helps you decide whether the stock is a good long-term investment. By focusing on the stock’s big picture, moving averages smooth over the data that can mislead you when[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)