From the course: Learning Excel: Data Analysis

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Solution: Summarize operational data visually

Solution: Summarize operational data visually - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial Buy for my team

Solution: Summarize operational data visually

“

(bouncy music) - [Instructor] In the previous movie, I asked you to perform three tasks with the Sales data that is contained in columns A through C. So we have the day of the month, and if we scroll down, you see that I have 30 days of data, and then the number of customers for a given day and sales for a given day. So let's start out by calculating a running average. I'll click in cell D4 type an equal sign, and the average is the average of all of the days up to a certain point. So, for example, for day four, we would want to find the average of sales from days one through four. For day three, one through three. We do this using a mix of absolute and relative references. So in D4, I'll type AVERAGE, and then I need to define my range of values, and I'll start in cell C4. I don't want this cell reference changing, so I'll press F4 on Windows. On the Mac, it would be Command + T. Then a right parentheses, and then we will end this range also at C4, except I will leave this reference…

Contents