From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Fill cells using advanced Fill Series options
From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Fill cells using advanced Fill Series options
- [Instructor] Autofill is the feature that fills cells based on existing data. There are also a few Advanced Fill Series options that you should be aware of. After watching this video, you'll know how to complete a list of dates, months, or numbers; complete a list with or without formatting; create linear and growth series; and create a custom list. We have a lot to do so let's jump right in. Here's our Advanced Fill Options workbook. And first I will show you how you can complete a list of months and not copy the formatting. We have January through June. If I click in June and use the Autofill handle, left-click and bring that across, you can see the Help text underneath showing me which month I'm on, there's December. So, when I first let go of my mouse, the formatting has been copied. But if use my Autofill Options menu, I can select Fill Without Formatting. Now notice that I can also just copy the cells,…
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)
Fill cells using Flash Fill2m 59s
-
(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)
-
-
-
-