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: Full-length practice exam

Solution: Full-length practice exam

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

Start my 1-month free trial

Solution: Full-length practice exam

“

(electronic tone) - [Instructor] Hi, welcome to the Solution video for the final challenge. For this challenge we'll use the 07_01 challenge exercise file, and I really want you to be able to complete all of the tasks for all the projects in 40 minutes or less. Let's go ahead and get started. Save the file as My 07_01 Challenge. Let's go to File and Save As, browse back to my Chapter 7 folder, we're going to type My and a space in front of the document title, and click Save, awesome. Number two, import the Western Inventory tab delimited file into a new worksheet named Inventory. Move the worksheet after the Project 8 worksheet. Let's go to Data, Get External Data, From Text. Here's our file. It is a delimited file, we do have headers in there. Next, Tab delimited, looking good, Next. Everything looks good, let's go ahead and click Finish. This is where we can ask Excel to put it on a new worksheet for us. I'll select New worksheet and click OK. Here we go, let's go ahead and double…

Contents