Split Date and Time Using Power Query

Pubblicato il: 25 agosto 2022
sul canale di: 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

In questa pagina del sito puoi guardare il video online Split Date and Time Using Power Query della durata di online in buona qualità , che l'utente ha caricato Pivot Skills Global 25 agosto 2022, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 615 volte e gli è piaciuto 15 spettatori. Buona visione!

134,156

3.8K