Split Date and Time Using Power Query

Veröffentlicht am: 25 August 2022
auf dem Kanal: Pivot Skills Global

615

#powerquery #exceltips #excel #datacleaning #textfunctions
In excel data cleaning can become tedious and tiresome however the good news is that power query can automate repetitive tasks especially data cleaning and transformation in excel and one of the key transformations that power query can handle is text manipulation including separating and splitting dates and time values in excel.

In this video I take you through step by step how you can split date and time values in excel using power query with ease and at the end of the video I also provide links for videos on how to automate the data cleaning process as well as split date and time in excel using text functions or formulas like INT function and Text to Columns feature.

Remember that research shows that Data analysists and Business Analysts in the world spend 80% of their time in data cleaning and therefore deploying such tactics like use of power query for data cleaning comes in really handy and helpful because it does the rest for you as you focus on other tasks.

You can skip to different parts of this video using the timestamp as below
00:00 Introduction to Data Cleaning using Power Query
00:59 How to load data into the power query from table or range option
01:14 Split Column by delimiter in excel using power query
02:11 Replace value option using power query
02:31 Close and Load Data into Excel worksheet using power query
03:01 Linked videos on Splitting Date and time using formulas

Auf dieser Seite können Sie das Online-Video Split Date and Time Using Power Query mit der Dauer online in guter Qualität ansehen, das der Benutzer Pivot Skills Global 25 August 2022 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 615 Mal angesehen und es wurde von 15 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

16,763

421