From the course: Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) Cert Prep
Join today to access over 25,200 courses taught by industry experts.
Challenge: Manage and format data - Microsoft Excel Tutorial
From the course: Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) Cert Prep
Challenge: Manage and format data
- [Narrator] Welcome to the Chapter 3 Challenge. For your challenge, you'll be using the 03_10 Challenge exercise file, and I believe you should be able to complete all the tasks in 12 minutes or less. Please keep in mind that if you find you're unable to complete all the tasks within that timeframe, you should go back and watch the videos for chapter three again, and come back and try the challenge. You can also watch my solution video to see how I completed all of the tasks for chapter three.
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
-
-
-
-
-
Fill cells using Flash Fill2m 45s
-
(Locked)
Fill cells using advanced Fill Series options5m 47s
-
(Locked)
Create custom number formats6m 41s
-
(Locked)
Configure data validation7m 1s
-
(Locked)
Group and ungroup, use subtotals and totals4m 51s
-
(Locked)
Remove duplicate records3m 14s
-
(Locked)
Create and manage custom conditional formatting rules8m 20s
-
(Locked)
Create conditional formatting rules using formulas7m 29s
-
(Locked)
Generate numeric data by using RANDARRAY()6m 26s
-
(Locked)
Challenge: Manage and format data33s
-
(Locked)
Solution: Manage and format data11m 24s
-
-
-
-