From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Unlock the full course today

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

Solution: Create advanced formulas

Solution: Create advanced formulas

From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Start my 1-month free trial

Solution: Create advanced formulas

(energetic music) - [Instructor] Welcome to the solution video for the chapter four challenge. For this challenge, we used the 04_11 exercise file and I challenged you to complete all of the tasks in 12 minutes or less. Let's get started. First, we'll save the file as My 04_11 Challenge. File, Save As, navigate to the desktop where I have my files saved. Chapter four, let me change the title here. Save it, and we'll move on. Next, we're going to complete the tasks on the project one, two, three, four, and five worksheets. Let's get started with project one. Use query to load the data from the Womens Clothing workbook, from the 2018 worksheet located in the chapter four folder. Load the data beginning in A7, do not include the date field. I'll go ahead and click in A7. Go to Data, New Query, From File, From Workbook. Here's our Womens Clothing workbook, the 2018 worksheet. We'll go to Edit so that we can choose the columns that we want to include. And in this case, we're actually not…

Contents