Excel - Flash Fill Tutorial

In this video, you will learn about Flash Fill, a feature in Microsoft 365 that automatically fills in and formats data.
The video covers how to use Flash Fill with different types of data, such as names and phone numbers.
It also demonstrates how to use unique formatting and provide additional examples to help Flash Fill understand patterns.
Additionally, the video shows how Flash Fill can be used to combine and format names, as well as split up columns of data.
This will help you efficiently manipulate and format data in Microsoft 365 using Flash Fill.

2:59
1211 views

An error occurred while attempting to play the video

We recommend
Excel

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - AutoFill and Flash Fill

In this video, you will learn about Autofill and Flash Fill in Excel.
The video covers how to use Autofill to automatically fill in repetitive information, such as dates, by dragging the black plus sign.
It also demonstrates how to use Flash Fill to format data, like correcting a list of names, by typing the desired format and letting Excel provide a preview.
These features are tremendous timesavers and can do much more than what is covered in this introduction.
Mastering Autofill and Flash Fill will enhance your productivity in Excel.

1:36
1394 views

Excel - AutoFill

In this video, you will learn about Autofill and Flash Fill in Excel.
The video covers how to use Autofill to automatically fill in a series of repetitive information, such as dates, by dragging the black plus sign.
It also demonstrates how to use Flash Fill to quickly format a list of names by typing the first name and letting Excel provide a preview of the formatted names.
These features are tremendous timesavers and can do much more than what is covered in this introduction.
Mastering Autofill and Flash Fill will help you save time and improve your productivity in Excel.

2:55
1601 views

Excel - Add a conditional column

In this video, you will learn about adding a conditional column using Microsoft 365. The video covers the steps to add a conditional column in Microsoft 365 and demonstrates how to do it effectively.
This will help you enhance your data analysis and make more informed decisions based on specific conditions.

542 views

Excel - Split a column

In this video, you will learn about how to split a column using Microsoft 365. The video covers the steps to split a column in a concise and easy-to-follow manner.
This tutorial will help you enhance your skills in data manipulation and organization using Microsoft 365, improving your productivity and efficiency.

571 views

Excel - Using functions

In this video, you will learn about using functions in Microsoft 365. The video covers the basics of functions and demonstrates how to use them effectively in various Microsoft 365 applications.
This will help you enhance your productivity and make the most out of the Microsoft 365 suite.

5:12
1583 views

RELATED COURSES This tutorial is part of the following courses

Video Training Microsoft Excel - Intermediate level

Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivot tables, and take advantage of all that Excel has to offer!

Your trainer for this course
Cours E-learning

204 vues

ALL COURSES