From the course: Excel: Data Storytelling for Beginners

Unlock the full course today

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

Creating interactive Excel elements to engage the audience

Creating interactive Excel elements to engage the audience - Microsoft Excel Tutorial

From the course: Excel: Data Storytelling for Beginners

Start my 1-month free trial Buy for my team

Creating interactive Excel elements to engage the audience

“

- [Instructor] Let's add some interactive elements to our data story. This is going to allow our audience to actually go into our data and figure out what's going on. Now, one thing we can add to our Total Activities is a timeline. A timeline allows us to slice on date when we have a date field in our data set. So click anywhere into the pivot table, click on the Insert tab, and click Timeline. Now it's going to ask you for which fields are a date field. Well, we already have a field called Date field, so I'll click that and hit Ok. This is going to allow us to take a look at our data over a period of time. Recall that June had the most sales, so we can use this to actually zero in and figure out what happened in June. Now, let's go to the TotalDue Return tab. Notice the salespeople who had the most amount returned, so we see salesperson with ID 128, 113, 148, and so on. Let's go see if we can investigate what's…

Contents