Популярное

Музыка Кино и Анимация Автомобили Животные Спорт Путешествия Игры Юмор

Интересные видео

2025 Сериалы Трейлеры Новости Как сделать Видеоуроки Diy своими руками

Топ запросов

смотреть а4 schoolboy runaway турецкий сериал смотреть мультфильмы эдисон
dTub
Скачать

13 Mind Blowing Power Query Features to Automate Your Excel Work (Beginners Tutorial Part II)

Автор: Josh Aharonoff (Your CFO Guy)

Загружено: 2025-03-30

Просмотров: 46246

Описание:

Download the practice files from this video here: 👇
http://yourcfoguy.kit.com/13-things-p...
---------------------------------------------------------------------------
Step-by-step Power Query follow-along guide here: 👇
https://docs.google.com/document/d/1q...
---------------------------------------------------------------------------
Access 100+ accounting & finance templates: https://www.modelwiz.com
---------------------------------------------------------------------------

Power Query has totally changed the way I work in Excel, saving me what feels like thousands of hours!

In this tutorial, I'll show you 13 mind-blowing Power Query features that will help you automate your spreadsheets and transform your data with just a few clicks.

Learn everything from extracting data from tables and folders to creating custom columns, merging queries, and building powerful pivot tables.

⏱️ Timestamps:
00:00 Intro
00:30 What Power Query is?
02:17 Power Query Feature 1 - Extracting Data From Table
02:57 Power Query Feature 2 - Loading Data Back as a Table
05:12 Power Query Feature 3 - Extracting Data From a File
07:55 Power Query Feature 4 - Extracting Data From a Folder
09:38 Power Query Feature 5 - Deleting Columns
10:14 Power Query Feature 6 - Filtering Data
10:30 Power Query Feature 7 - Adding A New Column
12:10 Power Query Feature 8 - Make Edits via M Code
13:58 Power Query Feature 9 - Merging in Column
17:40 Power Query Feature 10 - Extract Data From a Named Range
19:50 Power Query Feature 11 - Unpivotting Data
21:15 Power Query Feature 12 - Loading Back as a Pivottable
24:15 Power Query Feature 13 - Loading Data Into The Data Model


ABOUT THIS CHANNEL
Looking to level up your career in Finance & Accounting? You're in the right place. Each week I upload videos around Accounting, FP&A, and Excel to help you grow in your career and learn something new.

⚡️ Check out my channel here:    / @yourcfoguy  
Don’t forget to subscribe!

🔎 FIND ME AT
https://www.yourcfoguy.com

➡️ Subscribe to my Newsletter!
https://www.yourcfoguy.com/newsletter

🔗 FOLLOW ME ON SOCIAL
Get updates or reach out to Get updates on our Social Media Profiles!
LinkedIn:   / joshaharonoff  
Twitter:   / yourcfoguy  

#Excel #ExcelExpert #MasterExcel #ExcelTips #Accounting #Finance #financials #accountingprofessionals #Tutorial #yourcfoguy

13 Mind Blowing Power Query Features to Automate Your Excel Work (Beginners Tutorial Part II)

Поделиться в:

Доступные форматы для скачивания:

Скачать видео mp4

  • Информация по загрузке:

Скачать аудио mp3

Похожие видео

array(10) { [0]=> object(stdClass)#7118 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "QXzopqpHlSs" ["related_video_title"]=> string(82) "Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)" ["posted_time"]=> string(27) "5 месяцев назад" ["channelName"]=> string(29) "Josh Aharonoff (Your CFO Guy)" } [1]=> object(stdClass)#7091 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "fJ7-7irXah8" ["related_video_title"]=> string(30) "Make a Custom Sidebar in Excel" ["posted_time"]=> string(22) "11 дней назад" ["channelName"]=> string(14) "Kenji Explains" } [2]=> object(stdClass)#7116 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "GB6wLooVFEI" ["related_video_title"]=> string(101) "Deep Focus Radio - Музыка для кодирования и производительности" ["posted_time"]=> string(0) "" ["channelName"]=> string(15) "Chill Music Lab" } [3]=> object(stdClass)#7123 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "4Oaveqn2YwY" ["related_video_title"]=> string(125) "Эти 5 СЕКРЕТНЫХ функций в Excel НИКТО не использует. Вот, что они делают!" ["posted_time"]=> string(23) "1 месяц назад" ["channelName"]=> string(54) "Эксперт ЭКСЕЛЬ и ГУГЛ-ТАБЛИЦЫ" } [4]=> object(stdClass)#7102 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "HF57j8cyucA" ["related_video_title"]=> string(56) "Harnessing the power of the SCAN and MAP Excel Functions" ["posted_time"]=> string(23) "1 месяц назад" ["channelName"]=> string(10) "Excelevate" } [5]=> object(stdClass)#7120 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "BkIjEoC8oIQ" ["related_video_title"]=> string(44) "These 10 Excel Tips Will EXPLODE Your Career" ["posted_time"]=> string(23) "1 месяц назад" ["channelName"]=> string(29) "Josh Aharonoff (Your CFO Guy)" } [6]=> object(stdClass)#7115 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "ns-cJRcEP5M" ["related_video_title"]=> string(64) "7 MIND BLOWING Power Query Functions (Beyond the User Interface)" ["posted_time"]=> string(27) "5 месяцев назад" ["channelName"]=> string(6) "Goodly" } [7]=> object(stdClass)#7125 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "rcrsqyFtJ_4" ["related_video_title"]=> string(92) "Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)" ["posted_time"]=> string(27) "8 месяцев назад" ["channelName"]=> string(15) "Maven Analytics" } [8]=> object(stdClass)#7101 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "fV0YG4nE5s4" ["related_video_title"]=> string(39) "Build a DYNAMIC budget with POWER QUERY" ["posted_time"]=> string(27) "8 месяцев назад" ["channelName"]=> string(29) "Josh Aharonoff (Your CFO Guy)" } [9]=> object(stdClass)#7119 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "a3-nkc_VUF0" ["related_video_title"]=> string(123) "Эти ОШИБКИ совершает КАЖДЫЙ новичок в Excel. Избавься от них НАВСЕГДА!" ["posted_time"]=> string(25) "2 недели назад" ["channelName"]=> string(54) "Эксперт ЭКСЕЛЬ и ГУГЛ-ТАБЛИЦЫ" } }
Power Query for Beginners: Transform Excel Data in Minutes  (2025 Tutorial Part I)

Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)

Make a Custom Sidebar in Excel

Make a Custom Sidebar in Excel

Deep Focus Radio - Музыка для кодирования и производительности

Deep Focus Radio - Музыка для кодирования и производительности

Эти 5 СЕКРЕТНЫХ функций в Excel НИКТО не использует. Вот, что они делают!

Эти 5 СЕКРЕТНЫХ функций в Excel НИКТО не использует. Вот, что они делают!

Harnessing the power of the SCAN and MAP Excel Functions

Harnessing the power of the SCAN and MAP Excel Functions

These 10 Excel Tips Will EXPLODE Your Career

These 10 Excel Tips Will EXPLODE Your Career

7 MIND BLOWING Power Query Functions (Beyond the User Interface)

7 MIND BLOWING Power Query Functions (Beyond the User Interface)

Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)

Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)

Build a DYNAMIC budget with POWER QUERY

Build a DYNAMIC budget with POWER QUERY

Эти ОШИБКИ совершает КАЖДЫЙ новичок в Excel. Избавься от них НАВСЕГДА!

Эти ОШИБКИ совершает КАЖДЫЙ новичок в Excel. Избавься от них НАВСЕГДА!

© 2025 dtub. Все права защищены.



  • Контакты
  • О нас
  • Политика конфиденциальности



Контакты для правообладателей: [email protected]