From the course: Excel 2016 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Splitting and combining columnar data with Flash Fill
From the course: Excel 2016 Essential Training
Splitting and combining columnar data with Flash Fill
- If you saw the previous movie on splitting data, you saw how we could deal with data like this and split those names into separate columns using a text to columns feature. But on the sheet called Flash Fill, we're going to be using a relatively new tool available starting in Excel 2013. It's called Flash Fill and many times it's going to be faster and better, although it doesn't ultimately have as much flexibility as Text to Columns. If you slide over the Flash Film button on the Data tab, the description reads, "Automatically fill in values. Enter a couple of examples you want as output and keep the active cell in the column you want filled in." It doesn't tell us everything, but it sounds kind of interesting. Look at Column A. Two problems; the major one is we cannot sort this list by last name. The minor problem possibly; it's all uppercase. We'd prefer to have just the first letters capitalized. I'm going to insert a new column to the left of Column B; right-click insert. Now…
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)
Sorting data9m 44s
-
(Locked)
Inserting subtotals in a sorted list8m 39s
-
(Locked)
Using filters6m 43s
-
(Locked)
Splitting data into multiple columns8m 26s
-
(Locked)
Splitting and combining columnar data with Flash Fill6m 40s
-
(Locked)
Removing duplicate records2m 23s
-
(Locked)
Using validation tools10m 45s
-
(Locked)
-
-
-
-