Скачать
Flash fill and formula AI in Excel
Автор: David Benaim
Загружено: 2025-07-23
Просмотров: 483
Описание:
Excel's often neglected flash fill can extract, combine or capitalise text based on an example. Formula from example can do the same but create the formula for you too (and work on numerical and date columns too), then column by example is Power Query's version of the same thing. I also show how to get Chat GPT/Copilot to generate formulas for you from a prompt.
00:00 Introduction
00:49 Tailoring the machine learning
02:22 Combine data
04:16 Separate a numbered list
04:55 Issues wth flash fill
05:47 Column from examples in Power Query
07:13 Banding
09:11 Formula by examples (Excel for the web)
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
