From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Summarize and organize data
From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Summarize and organize data
- [Narrator] Let's take a look at two other ways that we can summarize and organize our data. So you'll be prepared to take on any tasks on the Excel 2016 MOS exam having to do with sparklines, I'll demonstrate how to insert both a column and a line sparkline. You may also be asked to demonstrate your knowledge of inserting subtotals into a worksheet, so I'll walk through the process of how to sort the information and then how to use our summary functions such as sum, average, max, and min to calculate the information for us and insert subtotals. I have the 03_04 exercise file open, so let's go ahead and get started. Let's start with our sparklines. On my Q1 travel worksheet, I'm going to put my sparklines right in column B. Let's start first with our San Francisco office. I'll click in B6, go to my Insert tab, go over to my Sparklines group. Notice that I have Line, Column, and Win/Loss sparklines that I can insert. Let's start with a column. In my Create Sparklines window, I'm first…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.