AI in Excel - Part 1 - Flash Fill

preview_player
Показать описание
AI in Excel. As artificial intelligence (AI) seems to be the buzzword of the day. Excel is the BI application of the day. How do the two combine? This video is part 1 of the AI in Excel Series, and it's all about the Flash Fill command. The command made its debut in excel 2013 and quickly became a staple as it made some tasks much quicker and much more straightforward. Technically speaking, Flash Fill is not strict AI but more a search for patterns in your data, but it does qualify for this Part 1 of the series.

This tutorial was made using Excel 365, but the techniques shown apply to all Excel versions from 2013 onwards.

Chapters:
0:00​ Excel Olympics Animation
0:08 Introduction to the Series
0:39 Introduction to Flash Fill
1:03 Examples
12:44 Conclusion to Part 1
13:44 Outro

Gear Used:

US Links

EU Links



Disclaimer: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!

#Excel #ExcelOlympics #gasperkamensek
Рекомендации по теме
Комментарии
Автор

Enjoying your channel! FYI - I particularly like the Beatles references😀. I use the flash fill all the time, it is a huge time saver!

utubeAgape
Автор

Great tutorial and advice! Thanks and thumbs up!!

wayneedmondson
Автор

Can't trust when you work in professional environments with large amount of data.
Better to use some old fashioned formulas to split or joint text.

shoaibrehman