Complete Guide - Flash Fill in MS Excel

Name: Complete Guide - Flash Fill in MS Excel
Rating: 4.5 (103 reviews)

Understand the Complete usage of Flash Fill in MS Excel to quickly combine, extract, transform, clean data

Created byiTech Analytic Solutions

Last updated 10/2020

English

What you'll learn

What is Flash Fill?
Why it is used?
Where is Flash Fill in MS Excel?
How to Use Flash Fill in Excel?
How to Enable or Disable Flash Fill
Understanding the Flash Fill Options Button
Flash Fill Error
Potential Remedies When Flash Fill Fails
Limitations of Flash Fill
20 Real time Examples on How to use Flash Fill in MS Excel

Course content

2 sections • 27 lectures • 1h 0m total length

What is Flash Fill?1:22
This Lecture will explains about
- What is Flash Fill in MS Excel
Where is Flash Fill in MS Excel?1:33
This Lecture will explains about
- Where is Flash Fill in MS Excel
How to Use Flash Fill in Excel?7:37
This Lecture will explains about
- How to use Flash Fill in MS Excel
How to Enable or Disable Flash Fill2:04
This Lecture will explains about
- How Enable and Disable Flash Fill in MS Excel
Understanding the Flash Fill Options Button6:00
This Lecture will explains about
- What are the Flash Fill Options Available
- How to use Flash Fill Options in MS Excel
Flash Fill Error3:00
This Lecture will explains about
- What are the errors occur while using Flash Fill
- What are the potential remedies should be taken when Flash Fill fails
Limitations of Flash Fill1:59
This Lecture will explains about
- What are the Limitations of Flash Fill

Add Line Breaks1:47
This example will explains
- How to use Flash Fill when we Add Line Breaks
Combine First And Last Names To Create Full Name1:47
This example will explain
- How to Combine First And Last Names To Create Full Name
Combine Hour, Minute, Seconds1:27
This example will explain
- How to Combine Hour, Minute, Seconds from various columns
Extract Hour, Minute, Seconds3:17
This example will explain
- How to Extract Hour, Minute, Seconds
Concatenate with Custom Text2:45
This example will explain
- How to Concatenate with Custom Text
Convert Date Formats to ISO Formats1:42
This example will explain
- How to Convert Date Formats to ISO Formats
Convert ISO Formats To Date Formats2:33
This example will explain
- How to Convert ISO Formats To Date Formats
Convert Names To Initials1:40
This example will explain
- How to Convert Names To Initials
Convert Text To Lower Case1:11
This example will explain
- How to Convert Text To Lower Case
Convert Text To Proper Case1:07
This example will explain
- How to Convert Text To Proper Case
Convert Text To Upper Case1:24
This example will explain
- How to Convert Text To Upper Case
Create Email IDs From Names1:40
This example will explain
- How to Create Email IDs From Names
Extract Domain Name From Email Address1:44
This example will explain
- How to Extract Domain Name From Email Address
Extract Name From Email Address1:49
This example will explain
- How to Extract Name From Email Address
Extract Numbers1:17
This example will explain
- How to Extract Numbers
Extract Text2:03
This example will explain
- How to Extract Text
Extract the First and Last Name from Full Name2:09
This example will explain
- How to Extract the First and Last Name from Full Name
Format Numbers As Phone Numbers2:16
This example will explain
- How to Format Numbers As Phone Numbers
Remove Unwanted Spaces from Text1:22
This example will explain
- How to Remove Unwanted Spaces from Text
Replace Text2:18
This example will explain
- How to Replace Text

Requirements

Basic Knowledge of MS Excel
Understanding of Data

Description

Excel Flash Fill is a Programming by Example (PBE) data manipulation tool that is applying machine learning to binary decision diagrams.

It is a Data Tool in Microsoft Excel that will allow to

COMBINE
EXTRACT
TRANSFORM DATA

Analyzes the information entered and automatically fills data when it identifies a pattern.

Flash fill automates repetitive string transformations using examples.

It’s very easy to use and can finish the tasks quickly and Flash Fill will save time in working on complex formulas or writing VBA Macros to the same work.

The Flash Fill feature was introduced in Excel 2013 and is available in all later versions of Excel 2016, Excel 2019, and Excel for Office 365.

Who this course is for:

MIS Analytics, Business Analyst, Data Analyst, Reporting Specialist, Excel Experts

Complete Guide - Flash Fill in MS Excel

What you'll learn

Explore related topics

Course content

Complete Guide on Flash Fill in MS Excel7 lectures • 24min

Examples on Flash Fill in MS Excel20 lectures • 37min

Requirements

Description

Who this course is for: