Get cumulative total using quick analysis tool in excel

#Get cumulative total using quick analysis tool in excel pro#

Go ahead and link straight out to that sheet, and what you'll see is a simple range of cells here.

#Get cumulative total using quick analysis tool in excel pro#

Alright, so if you'd like to follow along, go ahead and open up your pro tip workbook, head to your table of contents, and we're going to scroll all the way to the right to our analytics tips, and in this case, we want the Quick Analysis tools demo. Got a good range of data that we can use to practice some of these Quick Analysis tools. And also I've found it's a great way to quickly add calculated rows or columns for things like sums, counts, averages, totals without having to actually type in a single formula. So in most common use cases here, obviously just quickly exploring a variety of popular data analysis tools without having to manually navigate through different ribbon options. So if your selected data isn't compatible with a certain type of tool like a sparkline or pivot, for instance, you may not see that option in your Quick Analysis toolbar. You won't always see all of these options because those options and those tools may require the data to be in a certain format. I like to go through the traditional menus, but I'm actually quite impressed by how smooth and how convenient this Quick Analysis tool menu is, and as a result, I've started to use it quite a bit more myself. Anyone who knows me and knows my courses knows that generally speaking, I try to avoid these shortcut tools like this because I guess I'm oldschool. All sorts of very, very interesting and powerful analytics tools all consolidated into this single menu here for quick access, and what that allows us to do is take a raw, basic range of cells like you see at the top of the slide and convert it into something like this, either color scale or adding a calculated column with the average values or inserting a clustered column chart with the click of a button.

Looks like a lightning bolt with a bar chart underneath it, and when you click that option or press Control + Q, you'll access a Quick Analysis tool menu, and within this menu, you'll find all sorts of analytics tools including conditional formats, chart types, calculated rows and columns. You'll see a pop-up appear in the bottom right.

So most recent versions of Excel, I believe 2013 and onward, include an option called Quick Analysis tools, and all you need to do is select a range of cells kind of like this one. Very simple to use but a really interesting tool to play with. Alright, for this pro tip, I want to talk about how we can instantly explore our data using something called Quick Analysis tools.