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
From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)
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…
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.
Contents
-
-
-
-
-
-
Use AND/OR functions7m 53s
-
Use IFS functions5m 19s
-
Use the LOOKUP function6m 58s
-
Use the MATCH and INDEX functions5m 8s
-
Use date and time functions6m 12s
-
Troubleshoot formulas6m 10s
-
Use What-If Analysis5m 23s
-
Define named ranges and objects6m 13s
-
Use the PMT financial function4m 8s
-
Cube functions7m 52s
-
Challenge: Create advanced formulas27s
-
Solution: Create advanced formulas10m 1s
-
-
-
-