Join David Rivers for an in-depth discussion in this video Filling empty cells using Flash Fill, part of Office 2013 New Features.
- View Offline
- Exercise Files
The first new feature we're going to explore here in Excel 2013 is a huge timesaver.…It's called Flash Fill and it will help you to fill in empty cells in a spreadsheet …based on patterns that already exist.…To show you what I'm talking about, we will work with this file named, …No Obstacle Sport Customer Database.…Once you've open it from the exercise files, we'll just zoom out to about 100%,…so we can see all of the columns in our spreadsheet.…We have our First Name and Last Name column.…What we're missing is log in information.…This is the information our customers will use to access our website, let's say.…
So, we'll just type in a heading here in cell G6, type in Login.…Press Enter and we're ready to start creating the login credential.…Let's say it's going to be a combination of their First Name, Last Name and some additional information.…So for our first customer, we'll type in their first name, evan.…Let's use a period dot, santos, then the @ sign.…We'll type in No-Obstacles-Inc.com.…That's a bit of data to type in for every single customer.…
- Exploring the new user interface
- Using the bookmark feature
- Inserting online video in Word documents
- Editing PDFs in Word
- Filtering records using the timeline in Excel
- Exploring new slide transitions in PowerPoint
- Creating web apps for SharePoint or Office 365 with Access
- Inserting online pictures with Publisher
- Embedding files in a OneNote notebook
- Connecting to social networks with Outlook
Skill Level Appropriate for all
1. Suite-Wide Enhancements
Using the Weather bar1m 42s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.