Excel - CONCAT Tutorial

In this video, you will learn about Microsoft 365 and how it can enhance your productivity.
The video covers the various Office apps like Word, Excel, and PowerPoint, which allow you and your team to be creative and work together securely.
You can save your files in the cloud with OneDrive, making them accessible from anywhere.
Microsoft 365 also enables real-time collaboration with your coworkers, whether you're in the office or on the go.
With mobile apps and Office for the web, you can stay organized, connected, and productive on any device.
Using Microsoft 365 will help you optimize your workflow and achieve better results.

0:51
2965 views

Available in Microsoft365

00:00:05

Die CONCAT-Funktion ersetzt die CONCATENATE-Funktion. Es kombiniert eine Liste oder einen Bereich von Textzeichenfolgen.

00:00:14

Hier möchten wir einen Satz mit den oben erhaltenen Daten erstellen.

00:00:18

Mit der CONCAT-Funktion....

00:00:26

Ich kombiniere Texte und Zellen, um meinen Satz zu erstellen...

00:00:44

Das wird dynamisch nach den gewählten Kriterien sein.

00:00:05

A função CONCAT substitui a função CONCATENATE. Ele combina uma lista ou intervalo de seqüências de caracteres de texto.

00:00:14

Aqui nós gostaríamos de criar uma sentença com os dados obtidos acima.

00:00:18

Com a função CONCAT....

00:00:26

Eu combinar textos e células para criar a minha sentença...

00:00:44

Que será dinâmico de acordo com os critérios escolhidos.

00:00:05

CONCAT 関数は連結関数を置き換えます。これは、テキスト文字列のリストまたは範囲を組み合わせたものです。

00:00:14

ここでは、上記で得られたデータを含む文を作成したいと思います。

00:00:18

CONCAT 関数を使用すると、

00:00:26

テキストとセルを組み合わせて文章を作成します。

00:00:44

選択した条件に従って動的になります。

00:00:05

Hàm CONCAT thay thế chức năng CONCATENATE. Nó kết hợp một danh sách hoặc phạm vi của chuỗi văn bản.

00:00:14

Ở đây chúng tôi muốn tạo một câu với dữ liệu thu được ở trên.

00:00:18

Với chức năng CONCAT....

00:00:26

Tôi kết hợp văn bản và các tế bào để tạo câu của tôi...

00:00:44

Mà sẽ được năng động theo các tiêu chí đã chọn.

00:00:05

Функция CONCAT заменяет функцию CONCATENATE. Он сочетает в себе список или диапазон строк текста.

00:00:14

Здесь мы хотели бы создать предложение с данными, полученными выше.

00:00:18

С функцией CONCAT....

00:00:26

Я сочетаю тексты и клетки, чтобы создать свое предложение ...

00:00:44

Который будет динамичным в соответствии с выбранными критериями.

00:00:05

Функцията CONCAT заменя функцията CONCATENATE. Той комбинира списък или диапазон от текстови низове.

00:00:14

Тук бихме искали да създадем изречение с данните, получени по-горе.

00:00:18

С функцията CONCAT....

00:00:26

Комбинирам текстове и клетки, за да създам моето изречение...

00:00:44

Което ще бъде динамично според избраните критерии.

00:00:05

Функція CONCAT замінює функцію CONCATENATE. Він поєднує в собі список або діапазон текстових рядків.

00:00:14

Тут ми хотіли б створити речення з отриманими вище даними.

00:00:18

З функцією CONCAT ....

00:00:26

Я об'єдную тексти і клітинки, щоб створити моє речення...

00:00:44

Яка буде динамічною відповідно до обраних критеріїв.

DiLeaP AI: THIS MIGHT BE HELPFUL

Excel - Retrieve part of a text in a cell

In this video, you will learn how to retrieve specific information from different places using Microsoft 365. The video demonstrates how to search for topics on SharePoint, the Office portal, and even within Word documents and PowerPoint presentations.
It also highlights the ability to find information using Microsoft Yammer and Teams.
This tutorial will help you efficiently find knowledge from various sources within the Microsoft 365 ecosystem.

4:56
500 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
3617 views

SharePoint (Modern Sites) - Editing of Items

In this video, you will learn about the editing of items in Microsoft 365. The video covers the process of editing items in Microsoft 365 and demonstrates how to make changes to tasks, projects, and lists.
This will help you become more efficient and organized in managing your tasks and projects using Microsoft 365.

2:37
1868 views

Excel - Merge two columns

In this video, you will learn about merging two columns using Microsoft 365. The video covers the process of merging columns in Microsoft Excel and demonstrates how to do it step by step.
This will help you organize and manipulate data more efficiently in Excel using Microsoft 365.

3:27
782 views

Excel - How things are organized

In this video, you will learn about how things are organized in Microsoft 365. The video covers the search tools in Microsoft 365 and demonstrates how to find documents, emails, notes, and more.
This will help you save time and be more efficient in your searches, allowing you to easily access the information you need.

1:58
3332 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

1762 Views

ALL COURSES