Join David Rivers for an in-depth discussion in this video Using Quick Analysis options, part of Migrating from Office 2010 to Office 2013.
One change you're going to notice right away. When you start selecting content here in Excel 2013 is a little icon that's going to allow you to quickly analyze your data. And do certain things, that's what we're going to look at right now as we continue with our No Obstacles Home sales spreadsheet here. Looking at the sales by region tab. If you skipped to this movie, just open up NoObstaclesHomeSales2, from the chapter three folder of your exercise files, and you'll have what I have. Let's start by selecting some data here.
We'll click and drag next to bamboo coffee table, the first value under northeast, all the way across to get all four of those values. You can see right away the icon that appears in the bottom right hand corner, that's the Quick Analysis tool. And when you move down to that and give it a click, you'll notice different categories. There's formatting options, and as you hover over those, you going to see what might happen in those cells if you select any of those formatting options. There are charting options as well.
Were going to get into these a little bit later. How about Totals? Select Totals and you'll see that we can do things like sum, average, count. There are percent totals and running totals that can be calculated on the fly, and when you see the blue bar across the bottom it means it's actually going to total up columns and display values underneath. That's why we're seeing the wrong data in our real time preview up here. But as we go over to the right you can see we can also sum up the rows, and that's where we see a preview over here of what our sum will be for the selected values.
Click that little arrow to see the other options. There's the Average, for example, and Count. So all we have to do now is click Sum to get the total in there. And if we like that, and want to add it to the rest of the cells down below, we go to the bottom right corner with that little plus sign. We click and drag straight down. Including the grand total. And that was easy, thanks to the Quick Analysis tool. Now we can do other things too, like sparklines for example. These are mini graphs. If we go to the Insert tab, you'll see sparklines as something we can use in 2013.
So we're not in compatibility mode anymore, we have access to these new features. There are line, column, win, loss, for example, but we can access those from the Quick Analysis tool, as well. Let's click and drag across those values, including the total, and we'll make a change after. There it is again, the Quick Analysis tool, we can click to select it, go to Sparklines now, and when we click there you'll see Lines, Columns, and Win/Loss. Columns is going to work well for us.
It's a visual representation of those numbers to the left. Give it a click. And now we see we have a number of options up above under the design tab, for working with sparklines. The one thing we should probably do is exclude the total though. You can see there are five values here. So let's go to Edit Data. The Data Range can be changed now. All we're going to do is select the values for northeast, west, southeast and southwest. And press Enter on your keyboard then click OK. That looks good. Those are the sparklines from the Quick Analysis tool.
Click and drag down, to add those to the remaining cells as well. So with the Quick Analysis tool we can quickly analyze data, but perform certain functions that are available to us on the ribbon. For example, conditional formating, charting, that's all coming up in this chapter as well.
- Understanding user interface differences
- Exploring Office Online
- Working in Compatibility mode
- Exploring Word document changes
- Creating macro-enabled workbooks and templates
- Managing files in a mixed environment
- Importing Outlook contacts, email, and calendars