Skip to content

Calculate Moving (or Rolling) Average In Excel | Add Rolling Average Chart

      In this video I demonstrate how to perform moving (or rolling) average calculations. Typically rolling average calculations are performed over a seven day period, you might however perform the calculations over five or thirty days. Click here to download the featured file. Video Table of Contents 00:00 – Using formula to calculate moving averages… Read More »Calculate Moving (or Rolling) Average In Excel | Add Rolling Average Chart

    Google Sheets Pull Data from Another Worksheet Based on Criteria | Use Multiple Criteria Cell Values

        In this video I demonstrate in Google Sheets how to copy or pull data from one worksheet (or tab) to another based on single or multiple criteria. This can be achieved using Google Sheet’s FILTER function. The criteria can be hard-coded into the FILTER function or can be based on a cell value. Click… Read More »Google Sheets Pull Data from Another Worksheet Based on Criteria | Use Multiple Criteria Cell Values