From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Solution: Manage tables and table data
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Solution: Manage tables and table data
(upbeat techno music) - [Narrator] Welcome to the solution video for the Chapter 4 challenge. For this challenge, we're using the 04_04 challenge exercise file and I challenged you to complete all the tasks in five minutes or less. Let's jump right in. First, we'll save the file as 'my challenge' File, save as, and I'll navigate to the desktop to chapter 4, change the name and click save. Number two, complete the tasks on the project 1 worksheet. Here we go, our first step. Create a table from cells A13 to J117. Let's begin by selecting the columns, and then using control + shift + down arrow to select all of the records. We'll go to insert table, double check the range is correct and that my table has headers is checked off, looks good. Let's click okay. Next, apply light green table style light 17. We'll click back in the table, go to our table styles. We know we're looking for a light color. Light green table style light 17, right there. Number three, hide the table column that…
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.