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.
Manage table styles and options
From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Manage table styles and options
- [Instructor] Once we've converted our data into a table format, we need to start thinking about how we can manage our table styles and other options. In this video, we'll review all of the table styles available to us. We'll also look at table options, how to insert a total row, which will give us access to our summary functions such as Sum, Average, Count, Min, and Max. We'll also learn how we can add alternative text to our table. This will allow any users who are visually impaired to receive information regarding the data that's in our table. I have the 04_02 exercise file open, so let's go ahead and get started. Here is our table, and you may recall from the previous video that we have around 2700 rows of data in this table. First, let's look at our styles available to us. I'll go ahead and go to the Table Tools Design tab, and over on the far right-hand side, we have all of our table styles. I'll use the down arrow in the scroll bar, and that gets me right into my gallery. I…
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.