From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Apply custom data formats and layouts
From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)
Challenge: Apply custom data formats and layouts
“
(bright music) - [Instructor] Welcome to the chapter three challenge. For this challenge, we'll be using the 03_08 challenge exercise file. I believe you should be able to do this challenge in 12 minutes or less. So go ahead and get started.
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)
Create custom formats (number, time, and date)5m 19s
-
(Locked)
Populate cells by using advanced Fill Series options3m 25s
-
(Locked)
Create custom conditional formatting rules using operators and formulas5m 58s
-
(Locked)
Manage conditional formatting rules3m 42s
-
(Locked)
Create custom styles and themes7m 56s
-
(Locked)
Insert and configure form controls5m 39s
-
(Locked)
Configure data validation5m 32s
-
(Locked)
Challenge: Apply custom data formats and layouts21s
-
(Locked)
Solution: Apply custom data formats and layouts10m 21s
-
(Locked)
-
-
-
-