Data For Knowledge
Data For Knowledge
  • Видео 63
  • Просмотров 330 566
How to split a column in Excel | Divide text into multiple columns
📊 Learn how to split text into separate columns in Excel without formulas! This step-by-step tutorial shows you how to use the Text to Columns feature with delimiters.
In this Excel tutorial you'll learn:
✅ How to split text using delimiters
✅ How to use the Text to Columns function
✅ Where to safely place your new columns
✅ How to avoid accidentally overwriting data
✅ Limitations - handling multiple delimiters
⚠️ PRO TIP: Make a backup of your spreadsheet before using Text to Columns!
⭐ TIMESTAMPS:
00:00 Introduction to using Text to Columns to split text
00:42 Understand format of data
01:00 ⚠️Backup spreadsheet - Watch out for unintended results
01:15 Scenario 1 - How to split text into adjacent c...
Просмотров: 123

Видео

Excel Tutorial: How to Count Unique Categories Using COUNTA UNIQUE Function
Просмотров 2,4 тыс.6 месяцев назад
Learn how to quickly count unique categories in Excel using the COUNTA and UNIQUE functions 💡 New to Excel? Subscribe for more Excel tips, tricks, and tutorials! www.youtube.com/@DFK_data PLAYLIST Excel: ruclips.net/p/PL856L03J0TRyRU1ZAHJ2WQOepI0Zo_Zky #excel #exceltips #spreadsheets #counta #exceltutorial #excelformulas #microsoftexcel #excelforbeginners #dataanalysis
Excel - Calculate Duration - number of days between two dates
Просмотров 11 тыс.6 месяцев назад
Excel - one method to find the number of days between two dates, ie the duration or date difference. SUBSCRIBE Like and subscribe for more Excel tutorials! www.youtube.com/@DFK_data PLAYLISTS Excel: ruclips.net/p/PL856L03J0TRyRU1ZAHJ2WQOepI0Zo_Zky #excel #exceltips #ExcelDuration #ExcelDateDifference #spreadsheets #NumberOfDays
How to Move Columns In Excel Desktop App (Quick Tutorial 2024)
Просмотров 8386 месяцев назад
Learn how to quickly rearrange columns in Excel with this simple drag-and-drop technique for the desktop app. 💡 New to Excel? Subscribe for more Excel tips and tutorials! www.youtube.com/@DFK_data PLAYLISTS Excel: ruclips.net/p/PL856L03J0TRyRU1ZAHJ2WQOepI0Zo_Zky #excel #exceltips #spreadsheets #exceltutorial #excelforbeginners
Excel import to Power BI - Watch out for strikethroughs!
Просмотров 15810 месяцев назад
When importing excel into Power BI watch out for strikethroughs. Remember strikethroughs are formatting in excel and Power BI does not recognise formatting. SUBSCRIBE Like and subscribe for more Power BI and data visualisation tips! www.youtube.com/@DFK_data PLAYLISTS Power BI: ruclips.net/p/PL856L03J0TRxECKNvqxtTbfqAaBiVz_wv Power BI projects: ruclips.net/p/PL856L03J0TRz2UwQjSJvFfm2wPGtsDomi D...
Understanding Layers in Data Reports: A Visual Guide | Why Layer Order Matters In Data Visualisation
Просмотров 6 тыс.10 месяцев назад
Layers allow multiple diagrams or elements to be stacked in the same spot in a data report. This video: - Starts with a practical demonstration using 3 pieces of card to explain the concept of layers in data reports - Explores the importance of layer order in creating clear and informative visualisations - Using a digital example demonstrates how the sequence of layers can impact data visibilit...
How to Combine Diagrams in Power BI | Grouping and Layering Tips
Просмотров 1,7 тыс.10 месяцев назад
#datavisualization #businessintelligence #datavisualizationtips Today I'd like to share with you how to combine diagrams in Power BI to create more dynamic and interactive visualizations. We’ll walk through the process of layering diagrams like cards and donut charts, adjusting layer orders, and managing interactivity between your visual elements. This is a good solution if you're looking to gr...
Power BI - Misplaced diagrams - Layer order matters
Просмотров 23810 месяцев назад
In Power BI, has your diagram disappeared? It maybe that the diagrams is hidden behind another. Here, I discuss the order of layers and why layer order can result in the accidental hiding of diagrams. Videos referenced: ruclips.net/video/HAwc16JWg74/видео.html Power BI - Combining diagrams - Items to consider ruclips.net/video/V9yE-MLNRic/видео.html Layer order matters in data visualisations SU...
Power BI check background and font colours if words disappear
Просмотров 5010 месяцев назад
Power BI: when making cosmetic changes, it can be easy to use colours which obscure other items. It's worth checking background and font colours if words appear to have magically disappeared. SUBSCRIBE Like and subscribe for more Power BI and data visualisation tips! www.youtube.com/@DFK_data PLAYLISTS Power BI: ruclips.net/p/PL856L03J0TRxECKNvqxtTbfqAaBiVz_wv Power BI projects: ruclips.net/p/P...
Power BI: View pbix file from Sharepoint and Onedrive in a browser (new feature Oct23)
Просмотров 2,3 тыс.10 месяцев назад
Discover how to easily view Power BI reports without downloading the PBIX file! Learn how to view your Power BI pbix files directly in SharePoint and OneDrive using the new "Open in browser" feature. This new feature removes the hassle of downloading and opening reports in the Power BI Desktop to view the report pages. Please note that this feature's availability depends on your Power BI licens...
Power BI - Hide interactivity on chart
Просмотров 1 тыс.Год назад
In Power BI there may be the rare occasion when you prefer the user not to be able to interact with a chart/diagram. Currently in Power BI it is not possible to turn off the interactivity. This video presents a work around solution. Timings: 00:00 - 00:32 Hide interactivity on chart - the problem 00:32 - 00:40 Overview of a solution 00:41 - 02:05 Implementation of solution 02:02 - 04:23 Edit in...
Welcome to Data For Knowledge
Просмотров 9 тыс.Год назад
Data, data, data, I love it. Hi, I’m Pauline. I analysis and visualise data and this is my channel Data For Knowledge. Here, I share data projects in Power BI and R Studio alongside technical insights to help you gain knowledge from your data. So what does this involve? Well, using Power BI or R Studio I create follow along projects using open data, which is data anyone is free to use. I explai...
Power BI insert blank column to table and remove wording in column header
Просмотров 12 тыс.Год назад
In a Power BI table to insert a blank column, you first create a column. Once created, formatting is required and any words/characters in the column header are removed. This video shows why a column header may not be visible on a Power BI report yet appears when the Print facility is selected. Timings: 00:00 Insert blank column to table and remove wording in column header 00:32 Create blank/emp...
Linking cells in excel - link within tab, to another tab, to another spreadsheet
Просмотров 30 тыс.Год назад
Linking cells in excel - link within tab, to another tab, to another spreadsheet
Power BI - remove/alter default column header line or total lines on table or matrix
Просмотров 6 тыс.Год назад
Power BI - remove/alter default column header line or total lines on table or matrix
Power BI - in a table hide unwanted tooltips
Просмотров 3,8 тыс.Год назад
Power BI - in a table hide unwanted tooltips
How to Fix Incorrect Totals in Power BI: Data Type vs Format
Просмотров 1,5 тыс.Год назад
How to Fix Incorrect Totals in Power BI: Data Type vs Format
Power BI Gantt chart - day month year format on tooltip/hover over
Просмотров 4,8 тыс.Год назад
Power BI Gantt chart - day month year format on tooltip/hover over
Simplifying Complex Calculations in Power BI DAX Step-by-Step: Using Variables vs Calculated Columns
Просмотров 2,1 тыс.Год назад
Simplifying Complex Calculations in Power BI DAX Step-by-Step: Using Variables vs Calculated Columns
Power BI - Text filter visual (Search box) to help search for words appearing in a specified field
Просмотров 21 тыс.2 года назад
Power BI - Text filter visual (Search box) to help search for words appearing in a specified field
Power BI - How to insert a line break into a page title using DAX UNICHAR
Просмотров 6 тыс.2 года назад
Power BI - How to insert a line break into a page title using DAX UNICHAR
R programming - ggplot2 legend- examples of how to add, remove, alter the legend
Просмотров 3,4 тыс.2 года назад
R programming - ggplot2 legend- examples of how to add, remove, alter the legend
R programming - how to create small multiples diagram using facet_wrap and facet_grid from ggplot2
Просмотров 2,5 тыс.2 года назад
R programming - how to create small multiples diagram using facet_wrap and facet_grid from ggplot2
Sort order of categories in diagrams - have you used the order expected by the user?
Просмотров 1872 года назад
Sort order of categories in diagrams - have you used the order expected by the user?
Power BI - Gantt chart showing asset hire periods. How to create off-hire periods in gantt chart.
Просмотров 6 тыс.2 года назад
Power BI - Gantt chart showing asset hire periods. How to create off-hire periods in gantt chart.
How to Create Line Charts with Points Using ggplot2 & plotly in R | Data Visualization Tutorial
Просмотров 9 тыс.2 года назад
How to Create Line Charts with Points Using ggplot2 & plotly in R | Data Visualization Tutorial
Why Chart Labels Matter: Making Your Data Understandable
Просмотров 1392 года назад
Why Chart Labels Matter: Making Your Data Understandable
R Project - how to create bar chart (ggplot2) from spreadsheet-includes data pivot & remove a column
Просмотров 20 тыс.2 года назад
R Project - how to create bar chart (ggplot2) from spreadsheet-includes data pivot & remove a column
Left Join Mistakes That Could Cost You: Data Merging Dangers Explained
Просмотров 1922 года назад
Left Join Mistakes That Could Cost You: Data Merging Dangers Explained
CRUD - User requirements for data record in a database
Просмотров 2992 года назад
CRUD - User requirements for data record in a database

Комментарии

  • @Rory87
    @Rory87 11 дней назад

    Thank you for this very simple to implement :)

    • @DFK_data
      @DFK_data 11 дней назад

      Thank you! I'm glad you found the video helpful.

  • @apsrats
    @apsrats 20 дней назад

    Thank you

    • @DFK_data
      @DFK_data 20 дней назад

      Thanks for watching the video!

  • @shubhamgupta-nf7fk
    @shubhamgupta-nf7fk Месяц назад

    is it possible to add a custom tooltip on svg though, for example instead of getting whole code on tooltip, I'll get product name (apple in this case) as my tooltip?

  • @arunperala
    @arunperala Месяц назад

    On using the conditional formatting, we are getting the total value by default in the bottom. How to remove it?

  • @SandraRodriguezDominguez-ui4cg
    @SandraRodriguezDominguez-ui4cg Месяц назад

    Wow, your video is incredibly helpful! Thank you! I need to do something similar to this. Do you know if there is an option to create a table from 0 choosing the rows and columns that the user chooses (with a slicer for the dimensions and another one for the measures).

  • @omastria
    @omastria Месяц назад

    tks!

    • @DFK_data
      @DFK_data Месяц назад

      Thanks for watching the video!

  • @datarocksnz
    @datarocksnz Месяц назад

    Thank you so very much for this! I scoured the entirety of the internet looking for a solution, and your video did it. I wish I could like it more than once!! ❤❤❤❤❤

    • @DFK_data
      @DFK_data Месяц назад

      Thank you! Glad the video helped.

  • @IgorPlotnikov-d2f
    @IgorPlotnikov-d2f Месяц назад

    thank you so much!

    • @DFK_data
      @DFK_data Месяц назад

      You're welcome. Thanks for watching the video.

  • @andreashermle2716
    @andreashermle2716 Месяц назад

    Great Tutorial, thank you, very detailed yet easy to follow. Keep up the good work!

    • @DFK_data
      @DFK_data Месяц назад

      Thanks! Glad you enjoyed the video.

  • @wikisouthsudan
    @wikisouthsudan Месяц назад

    This definetly the type of presentation I wanted, thanks, so much for this

    • @DFK_data
      @DFK_data Месяц назад

      Thank you! Glad you enjoyed the video.

  • @luisamcginnis3782
    @luisamcginnis3782 2 месяца назад

    This is great content, If I want to just add an emoji if a field shows up when using my master filter do I need to create a measure?

  • @leongjinyuan8769
    @leongjinyuan8769 2 месяца назад

    How can I display the strikethrough in PowerBI table?

  • @chepravlogs
    @chepravlogs 2 месяца назад

    Awesome - it helped to create a link to webpage url & Chain symbol - Thank you👏👏👏

    • @DFK_data
      @DFK_data 2 месяца назад

      Thank you! Glad the video helped.

  • @jenswoldikejensen524
    @jenswoldikejensen524 3 месяца назад

    Brilliant and so simple!

    • @DFK_data
      @DFK_data 3 месяца назад

      Thank you!

  • @alondraespinal5115
    @alondraespinal5115 3 месяца назад

    Great video, what about if the field is multi select? And in some cases the user picks two choices how can I write the measure so it shows both emojis in the same cell.

  • @terungwaemmanuel-i8h
    @terungwaemmanuel-i8h 3 месяца назад

    The video is interesting

    • @DFK_data
      @DFK_data 3 месяца назад

      Thank you! Thanks for watching the video

  • @alboy1233
    @alboy1233 3 месяца назад

    Does anyone know how to show a Power Automate visual in this view?

  • @claudiopereira5163
    @claudiopereira5163 5 месяцев назад

    Amazing!

  • @zhirayrbebutyan9046
    @zhirayrbebutyan9046 5 месяцев назад

    Thank you! Even ChatGPT 4 was not able to help with solution

  • @joserochefort7778
    @joserochefort7778 5 месяцев назад

    it helped a lot merci

    • @DFK_data
      @DFK_data 5 месяцев назад

      Thanks! Glad you found the video helpful

  • @APerson-ky2gh
    @APerson-ky2gh 6 месяцев назад

    Thanks so much, I'm a second year biology student who just started learning r for ecology data stuff and this video was so helpful

    • @DFK_data
      @DFK_data 6 месяцев назад

      Thank you! Glad the video helped. Good luck with your studies!

  • @benysmart1643
    @benysmart1643 6 месяцев назад

    Thanks for sharing.. welcome to Algeria

    • @DFK_data
      @DFK_data 6 месяцев назад

      Thank you! Thanks for watching the video.

  • @jhaneman1231
    @jhaneman1231 6 месяцев назад

    Hello, this helped me at this exact moment with a Dashboard that had this "issue". Thanks a lot.

    • @DFK_data
      @DFK_data 6 месяцев назад

      Thank you! Glad the video helped.

  • @ThrillsofAwe
    @ThrillsofAwe 6 месяцев назад

    OMG this helped alot!!!!!!!! thanks !!!!!!!!!!!!!!!

    • @DFK_data
      @DFK_data 6 месяцев назад

      Thank you!

  • @sureshthongati1532
    @sureshthongati1532 6 месяцев назад

    Thank You Ma'am need starting classes video if possible

    • @DFK_data
      @DFK_data 6 месяцев назад

      Thank you for your kind words and suggestion

  • @leanne-se2sp
    @leanne-se2sp 6 месяцев назад

    Hi, I'm in my 2nd year at university and have never been able to grasp R in any of the workshops but your video made it so easy! Thank you so much, I have been panicking about this assignment for weeks, and with your video, I can finally get it done, thank you again :) 10/10!

    • @DFK_data
      @DFK_data 6 месяцев назад

      Thank you! Glad the video helped. Good luck with your studies!

  • @baxbanni2226
    @baxbanni2226 6 месяцев назад

    Nice explanation. I am wondering what wiki makes possible and will defenitly try it out. 👍👍

    • @DFK_data
      @DFK_data 6 месяцев назад

      Thanks! Yes, there is quite a lot of data in Wikidata. Hope you enjoy exploring!

  • @smg1928
    @smg1928 6 месяцев назад

    This is awesome! Thank you! My excel crashed and now I'm trying to use R studio. This is exactly what I needed.

    • @DFK_data
      @DFK_data 6 месяцев назад

      Thank you! Glad you found the video helpful.

  • @shubhamsanas5242
    @shubhamsanas5242 7 месяцев назад

    Hello, Thankyou for an eye opening video. Very well-researched and fine-made video this is.

    • @DFK_data
      @DFK_data 7 месяцев назад

      Thank you! Glad you enjoyed the video

  • @viralcutz958
    @viralcutz958 8 месяцев назад

    Nyz explanation.. tq mam❤

    • @DFK_data
      @DFK_data 8 месяцев назад

      Thank you!

  • @KameronYork-h8t
    @KameronYork-h8t 8 месяцев назад

    Thank you for this video! Very helpful tutorial!

    • @DFK_data
      @DFK_data 8 месяцев назад

      Thank you! Glad you found the video helpful.

  • @ren.auguste2200
    @ren.auguste2200 8 месяцев назад

    Excellent video! If I may ask, do you have any for species accumulation curves? Or know where can point me in the right direction? Hoping you have one, as you explained so well!

    • @DFK_data
      @DFK_data 8 месяцев назад

      Thank you! No I haven't done a video on species accumulation curves but perhaps a good idea for a future video.

    • @princerashedbartido5656
      @princerashedbartido5656 2 месяца назад

      @@DFK_data hello, how to install tidyr huhu mine wont work

  • @TradeWithKola
    @TradeWithKola 8 месяцев назад

    Nice and well detailed video.

    • @DFK_data
      @DFK_data 8 месяцев назад

      Thank you!

  • @lindalangford320
    @lindalangford320 8 месяцев назад

    Thanks for such an informative video. It is greatly appreciated.

    • @DFK_data
      @DFK_data 8 месяцев назад

      Thank you!

  • @debbieking8688
    @debbieking8688 9 месяцев назад

    Thank you very much indeed - that was exactly what I was looking for. Worked a treat. 🙂

    • @DFK_data
      @DFK_data 9 месяцев назад

      Thanks! Glad you found the video helpful.

  • @cristianjesus255
    @cristianjesus255 9 месяцев назад

    OMG, this video helped me so much!!

    • @DFK_data
      @DFK_data 9 месяцев назад

      Thanks! Glad you found the video helpful.

  • @user-dm8dl4ef3v
    @user-dm8dl4ef3v 9 месяцев назад

    Thanks for sharing, I was looking for something similar and this concept helped me to solve the problem. Glad to find your channel and lovely explanation.

    • @DFK_data
      @DFK_data 9 месяцев назад

      Thank you! Glad you found the video helpful.

  • @KhushiGupta-tr2vp
    @KhushiGupta-tr2vp 9 месяцев назад

    No RUclips video that explains this as clear;y as you did. Thank you very much!

    • @DFK_data
      @DFK_data 9 месяцев назад

      You're welcome! Thank you!

  • @kebincui
    @kebincui 10 месяцев назад

    Very vivid explanation❤👍

    • @DFK_data
      @DFK_data 10 месяцев назад

      Thank you!

  • @richardpenman1936
    @richardpenman1936 10 месяцев назад

    excellent video. straight to the point and everything worked.

    • @DFK_data
      @DFK_data 10 месяцев назад

      Thank you! Thanks for watching the video

  • @kebincui
    @kebincui 10 месяцев назад

    ❤👍

    • @DFK_data
      @DFK_data 10 месяцев назад

      Thank you!

  • @MDTPBI
    @MDTPBI 10 месяцев назад

    Great video- never knew this existed until now. Helps with what was going to be a massive headache

    • @DFK_data
      @DFK_data 10 месяцев назад

      Thank you! Glad you found the video helpful

  • @soujanyapisipati6260
    @soujanyapisipati6260 10 месяцев назад

    Thank you very much, your video has helped me a lot!

    • @DFK_data
      @DFK_data 10 месяцев назад

      Thank you! Glad you found the video helpful.

  • @naveediqbal8683
    @naveediqbal8683 10 месяцев назад

    greatly explained, Hats off!

    • @DFK_data
      @DFK_data 10 месяцев назад

      Thank you! Glad the video was helpful.

  • @DingDongGrahamBell
    @DingDongGrahamBell 10 месяцев назад

    Thank YOU so much! Quite informative! Have a Blessed New Year!

    • @DFK_data
      @DFK_data 10 месяцев назад

      Thank you! Glad you found the video helpful

  • @seifeldinazzam
    @seifeldinazzam 11 месяцев назад

    very simple , thank you

    • @DFK_data
      @DFK_data 11 месяцев назад

      Thanks!

  • @jenniferenekebe8475
    @jenniferenekebe8475 11 месяцев назад

    I spent 12 hours trying to get this. I watched several RUclips videos and no one explained it as clearly as you did. This is wonderful. Thank you!

    • @DFK_data
      @DFK_data 11 месяцев назад

      Thank you! Glad you found the video helpful.

  • @zenboxs8128
    @zenboxs8128 11 месяцев назад

    nice...very simple 100% working

    • @DFK_data
      @DFK_data 11 месяцев назад

      Thanks!

  • @MarcoLavazza-z9o
    @MarcoLavazza-z9o Год назад

    Super useful video. Thank you so much

    • @DFK_data
      @DFK_data 11 месяцев назад

      You're welcome. Thanks!

  • @ZarahDominguez-cf2uc
    @ZarahDominguez-cf2uc Год назад

    Thank you so much for this video, it helped me a lot