Category: Excel Guides

shape
shape
shape
shape
shape
shape
shape
shape
Standard

How to Calculate a Moving Average in Excel: Simple, Weighted and Exponential

A moving average smooths out the ups and downs in a series of numbers so that you can see the trend. Instead of looking at each month on its own, you average the last few periods and move the window forward one step at a time. It is used for sales, website visits, stock prices,

Standard

How to Create a Pivot Table in Excel: Step-by-Step Guide for Beginners

A pivot table is the fastest way to summarize a large table of data in Excel. In a few clicks you can turn thousands of rows into a short report that shows totals by region, product, month or any other field, without writing a single formula. You can then rearrange it by dragging fields, which

Standard

How to Calculate Correlation in Excel: CORREL Function and R-Squared

Correlation measures how strongly two sets of numbers move together. If sales rise when advertising rises, the two are positively correlated. If the number of umbrellas sold falls when temperature rises, they are negatively correlated. Excel gives you the correlation coefficient, also called r, with a single function named CORREL. The value always lies between

Standard

How to Use the AND and OR Functions in Excel (With IF Examples)

The AND and OR functions in Excel let you test more than one condition at the same time. AND returns TRUE only when every condition is true, and OR returns TRUE when at least one condition is true. On their own they only give TRUE or FALSE, but combined with the IF function they become