Changing Excel's Power Query Load Defaults - Monkey Shorts Episode 001

preview_player
Показать описание
In this episode, Ken shows the first Power Query setting he changes when he installs Excel.
  1. Skillwave Training
Рекомендации по теме
How to make 0:02:34

How to make the Currency Format stick in the Excel sheet after refreshing a Power Query table

How to change 0:00:44

How to change the Loading Destination of a Power Query query in Excel

Power Query Basic 0:07:14

Power Query Basic 02 - Close and Load... To table or connection? That's the question

How Power Query 0:09:02

How Power Query Will Change the Way You Use Excel

Power Query Replaces 0:01:00

Power Query Replaces XLOOKUP?!

I Learned How 0:04:02

I Learned How to Change the Default Close and Load To Option in Power Query

You WON'T BELIEVE 0:12:17

You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯

How to use 0:16:35

How to use Microsoft Power Query

How to use 1:16:17

How to use Python for doing data analytic on Excel

Combine Files from 0:10:18

Combine Files from a Folder with Power Query the RIGHT WAY!

Change the Power 0:02:33

Change the Power Query Default Load Location

7 METHODS to 0:05:59

7 METHODS to change source data location in Power Query | Excel Off The Grid

Getting data from 0:07:49

Getting data from current workbook with Power Query | Excel Off The Grid

Change the Power 0:06:53

Change the Power Query source based on a cell value | Data refresh automation | Excel Off The Grid

Power Query - 0:01:04

Power Query - How to return to the Query Editor

Easiest way to 0:10:29

Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)

Bulk Combine PDF 0:09:27

Bulk Combine PDF files to Excel without losing formatting & NO 3rd party software

Properly Convert PDF 0:11:28

Properly Convert PDF to Excel

INSANE AMAZING Power 0:05:38

INSANE AMAZING Power Query tip to quickly change data sources in Power BI and Excel

Master Data Cleaning 0:09:26

Master Data Cleaning with Power Query in Excel in 9 Minutes

Data Cleanup in 0:00:53

Data Cleanup in Excel with Power Query: Mastering the Ultimate Guide to Boost Your Excel Game!

Import ONLY The 0:09:25

Import ONLY The Latest File - Power Query

Get Data From 0:14:00

Get Data From SharePoint or OneDrive with Power Query - Demystified!

4 Ways To 0:09:46

4 Ways To Fix Your Power Query Date Errors Locale

Комментарии
Автор

I realize this is your first video- but it's the seventh or eighth I've watched this morning. Thanks for all the helpful and easy to follow tips!

amberpechin
Автор

Thanks for sharing Ken this great trick even if I knew it and reviewed it some days back on the "I asked 6 Excel experts to share their *BEST* tips & tricks" video

mehdihammadi
Автор

Thanks Ken, it has been a long time since we met in Amsterdam (Excel Summit). I very liked your way of teaching live, looking forward to see you once in a while online...😉

barttitulaerexcelbart
Автор

Thanks Ken, I love your video's and eagerly waiting for your next video. Thank you

balakrishnaj
Автор

Hello Ken, great tip, thank You. I recommend to add a subject of the video to the video title. Google and YouTube will find You easier. Episode 001 itselfs says nothing ;-)

ZdenekMoravecCZ
Автор

Hi Ken, great series idea. Great PQ tips.

I noticed in the PQ data load options settings the Fast Data Load isn't ticked by default but yours is. Any special or particular reason you turn yours on?

roderickmose
Автор

Hi Ken, there is also an option "Fast Data Load". What is your advice/experience with that?

barttitulaerexcelbart