From the course: Excel for Sales Professionals

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create monthly and yearly summaries

Create monthly and yearly summaries

From the course: Excel for Sales Professionals

Start my 1-month free trial

Create monthly and yearly summaries

“

- [Instructor] Running performance summaries are an important gauge of how your business is performing, especially if you're affected by seasonality. In this lesson, we'll show you how to quickly create some dynamic monthly running summaries with pivot tables, then add in a year-over-year running summary for good measure. We'll also introduce a feature called sparklines. We're using the 05_02 Running Summaries workbook from the chapter five practice files. Starting with our sales leaderboard from our three-year data, I'm gonna click order date. Notice that Excel has gone in and added years as well as order date into the rows section. Now this isn't really all that intuitive because years are grouped vertically, and I could click on each one to expand it, or I could right-click, expand and collapse, and expand the entire field, but then everything disappears off the field, so that's not the best view. So now what I want to do is grab order date, and just order date, and drag that into…

Contents