From the course: Microsoft Office Specialist: Expert (Office 365 and Office 2019) Cert Prep
Join today to access over 25,200 courses taught by industry experts.
Challenge: Manage and format data
From the course: Microsoft Office Specialist: Expert (Office 365 and Office 2019) Cert Prep
Challenge: Manage and format data
(upbeat techno music) - [Instructor] Welcome to the Chapter 3 Challenge. For this challenge, you'll be using the 03_09 challenge exercise file, and you should be able to complete all the tasks in 12 minutes or less. Now, as always, if you find you're unable to complete all of the tasks within this timeframe, go back and watch the videos for Chapter 3 again, and come and try the challenge one more time.
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)
Fill cells using Flash Fill2m 58s
-
(Locked)
Fill cells using advanced Fill Series options6m 44s
-
(Locked)
Create custom number formats8m 19s
-
Configure data validation9m 3s
-
(Locked)
Group and ungroup data and use subtotals and totals7m 10s
-
(Locked)
Remove duplicate records4m 24s
-
(Locked)
Create and manage custom conditional formatting rules9m
-
Create conditional formatting rules using formulas8m 8s
-
(Locked)
Challenge: Manage and format data30s
-
(Locked)
Solution: Manage and format data10m 35s
-
(Locked)
-
-
-
-