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.
Challenge: Perform operations with formulas and functions
From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Challenge: Perform operations with formulas and functions
(cymbal burst) - [Instructor] Welcome to the Chapter Five Challenge. For this challenge, we'll be using the 05_06 challenge exercise file. You should be able to complete all of these tasks in 10 minutes or less. If you find that you're unable to complete the tasks in less than 10 minutes, go back and watch the videos and come back and try the challenge again. You can also watch my solution video to see how I completed each of the tasks.
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
-
-
-
-
-
-
-
(Locked)
Summarize data by using functions6m 17s
-
(Locked)
Use conditional operation functions: IF and COUNTIF functions5m 18s
-
(Locked)
Use conditional operation functions: SUMIF and AVERAGEIF4m 37s
-
(Locked)
Format and modify text by using functions3m 1s
-
(Locked)
Combine text using functions and flash fill4m 16s
-
(Locked)
Challenge: Perform operations with formulas and functions27s
-
(Locked)
Solution: Perform operations with formulas and functions7m 9s
-
(Locked)
-
-
-