From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Create and manage tables

Solution: Create and manage tables

From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

Start my 1-month free trial

Solution: Create and manage tables

“

- [Instructor] Welcome to the Chapter 4 Challenge Solution video. For this challenge we use the 04_04 challenge exercise file, and I challenged you to complete all the tasks in under five minutes. Let's go ahead and get started. Starting on our Instructions tab, save the file as My 04_04 Challenge. File, Save As, browse back to my Desktop, Chapter 4, insert the word My in front of the document title, and click Save. Complete the tasks on the Project 1 Worksheet. When we've completed all the tasks, we'll save and close the workbook. Okay, here's Project 1. First, we're going to convert the data in cells A13 to L117 to a table. Just going to click anywhere in this data. Control T is that great keyboard shortcut that will really help you convert quickly. We want to make sure we start in 13. It looks like Excel grabbed a couple of rows up above, so I'm just going to click in the field and change it to A13 to L117. My table does have headers, and click OK, perfect. Apply Table Style Medium…

Contents