From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)
Join today to access over 24,500 courses taught by industry experts.
Challenge: Create advanced formulas
From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)
Challenge: Create advanced formulas
(upbeat electronic music) - [Instructor] Welcome to the chapter four challenge. For this challenge we'll be using the 04_11 Challenge exercise files, and I believe you should be able to complete all the tasks in 12 minutes or less. If you find you're unable to complete all the tasks within that timeframe, go back and watch the videos for chapter four again and come on back and try the challenge.
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.
Contents
-
-
-
-
-
-
(Locked)
Use AND/OR functions7m 53s
-
(Locked)
Use IFS functions5m 19s
-
(Locked)
Use the LOOKUP function6m 58s
-
(Locked)
Use the MATCH and INDEX functions5m 8s
-
(Locked)
Use date and time functions6m 12s
-
(Locked)
Troubleshoot formulas6m 10s
-
(Locked)
Use What-If Analysis5m 23s
-
(Locked)
Define named ranges and objects6m 13s
-
(Locked)
Use the PMT financial function4m 8s
-
(Locked)
Cube functions7m 52s
-
(Locked)
Challenge: Create advanced formulas27s
-
(Locked)
Solution: Create advanced formulas10m 1s
-
(Locked)
-
-
-