MSPTDA 06: Power Query: Merge, Append, & UnPivot - 3 Important Transformations

Подписаться 1 млн

Просмотров 94 тыс.

50% 1

Download Excel START Files:
people.highline.edu/mgirvin/A...
people.highline.edu/mgirvin/A...
people.highline.edu/mgirvin/A...
Download Excel FINISHED Files:
people.highline.edu/mgirvin/A...
Download pdf Notes about Power Query: people.highline.edu/mgirvin/A...
Assigned Homework:
Download Excel File with Homework:
Assigned Homework:
Download Excel File with Homework: people.highline.edu/mgirvin/A...
Download Files to import for Merge Homework:
people.highline.edu/mgirvin/A...
people.highline.edu/mgirvin/A...
Example of Finished Homework:
people.highline.edu/mgirvin/A...
In this Video learn about three important Power Query Transformations: Merge, Append and UnPivot.
Topics:
1. (00:15) Introduction.
2. (02:00) Example1: Merge 2 Tables to Replace VLOOKUP or Relationship
3. (08:11) Example 2: Transform 3 Non-Uniform Sales Tables Then Append into Single Proper Data Set
4. (16:31) Example 3: UnPivot to Convert Cross Tabulated Data Tables into Proper Data Set
5. (22:29) Summary
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
The Power Query logo used in this video is copyright of and used with the express permission of powerquery.training
Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!

Опубликовано:

13 июл 2018

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 308

@elactecnology Год назад

Who else agrees this is the best Power Query Training ever😊

@nsanch0181 5 лет назад

My company was laying people off today, and although there is nothing guaranteeing my future employment, I felt grounded, because I've been studying under you for the last 2-3 years; and developed skills which could give me options in job markets should I need them. I owe so much of that to you and your teaching. Thank you Mike.

@excelisfun 5 лет назад

You are welcome! That is EXACTLY why I post. I love to hear that your new skills may help you to avoid a layoff : ) You can give thanks on each vid with these comments and Thumbs Ups !!! Thanks for the support, Nick!

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

My pervious company was using older versions of excel and i really wanted to learn Power Query, Power BI and practice as well so, i switched my job only i can get access to MS office 365 and now i can finally learn all these skills. 🤣 By the way i have been watching your videos for last 7 years now and i have learned A LOT from you. My skills are also appreciated wherever i have worked so far and i owe it all to you. I am gonna watch all these videos in hopefully few days time. I also practice with the files you provide so i really appreciate you from the bottom of my heart. Thanks for sharing your knowledge for free.

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

I am glad that I have been able to help over the many years : ) : )

@timmytesla9655 2 года назад

I was given a task to append over 4000 tables this week at work. My boss suggested I use a faster method if I know any. I was able to apply what I have learnt just watching few videos from you. It made me so excited and saved me the whole week trying to copy and paste table after table. Thank you Mike!

@Dogpotter69 4 года назад

Mike I`am stuck in lockdown & have followed you for a couple of years now, the power query module I have studued hard as plenty of free time & have brought this into the work place your BRILLIANT thanks keep the great work I love it ALL & will continue learning from YOU.

@excelisfun 4 года назад

Glad to help during the lockdown and before! Thanks for your support with those comments, thumbs ups and of course your Sub : )

@hollydunne2687 2 года назад

Another fantastic video. Amazed at how easy unpivoting is with PQ and that trick of adding a column by selecting and multiplying existing columns blew my mind. Excellent homework questions to test how well it was all retained - am absolutely loving this series.

@excelisfun 2 года назад

Yes!!!!!! I love that you find value in these lessons. When I use these at Highline College in my classes, I most get grief from students because they say it is too much work to learn these important tools... : (

@ahmedal-dossary4386 6 лет назад

Dear Mike, I would like to take this opportunity to thank you for all videos you have posted, especially on power query & data model. Today, I had a challenging task from management and it was impossible to achieve w/o power query. Thanks for making me the person I’m today..!!!

@excelisfun 6 лет назад

You are welcome for the help! That is why I post - to make the world a better place and teach all who want to learn how to have fun AND Efficiency with MS Tools. I love hearing stories like yours!!! I need your help, though, please support with Thumbs Up on every video that you watch, comments when you are inspired, a Sub and tell all your friends.

@thiernoibrahimadiallo7740 6 лет назад

80% of my excel skills come from your videos. now i am passionate about excel and data analysis.

@excelisfun 6 лет назад

I am glad that the videos I post help you out!!!!! You have a great Excel Channel too - hopefully people will go and check your channel out: ru-vid.com/show-UCqQO1-7JxERnT6o1iKjXXzw

@HanifKhan-mg8vu 5 лет назад

You are totally right mate

@arifzainal9317 3 года назад

Professor Mike, as always thank you very much. I am bingeing on your MSPTDA power course and it's beyond brilliant. No word can describe how precious the gems you 'merged' and 'apended' over these 23 mins. It has transformed my life and I'm sure it did others' too. Thank you!!

@excelisfun 3 года назад

I love to read your comment : ) I am very happy to help : )

@timmytesla9655 2 года назад

No lies. It saved me this week when I was given thousands of tables to append.

@grzegorz2852 4 года назад

U are the best bro I have discovered your channel several days ago and now I watch only u U don't speak too fast and u try to explain everything Don't stop Thank u

@excelisfun 4 года назад

I won't stop! You don't syopp learning either, and I love the comments and thumbs ups : )

@shoeshines2121 4 года назад

What a great instructional video. These three transformations alone have saved me countless hours rearranging data in Standard Excel. Merge to return multiple matches, Append to attach many workbooks, and Unpivot Other Columns to transform a cross-tabular data set into a proper one. Thank you for the clear explanation and great video!

@LeilaGharani 6 лет назад

Add column from number! I like that! Thank you for a great video.

@excelisfun 6 лет назад

Yes, that is a useful feature : ) Thanks for your support, Teammate Leila!!!!

@randomguy-jo1vq 2 года назад

Quite unexpected to find you here

@vacilando86 5 лет назад

I'm really appreciate for these training videos. I've learned su much from them. Especiallay MSPTDA section is priceless and you give us them without any payoff. Respect !!!

@excelisfun 5 лет назад

Glad the resources and MSPTDA help you, Alpay!!! They do have a price, though: you must click thumbs up and comment on each video : )

@vacilando86 5 лет назад

@@excelisfun Sure, it's a pleasure for me

@excelisfun 5 лет назад

@@vacilando86 In this way we are a Team!!!!!

@pravinshingadia7337 5 лет назад

I love your tutorials as they are complete packages in their own right. It is brilliant that you can download the files for any individual topic you wish to learn and follow along and your passion and enthusiasm for teaching comes across really well. Yours are easily the best tutorial videos by far anywhere on the entire internet.

@excelisfun 5 лет назад

Yes, my intent when I started this channel 11 years ago was to provide free education to the world, with video, files, free book (pdf notes), practice problems and then try to tell a video story that can inform and inspire. I am glad that the resources help you. Please help my excelisfun channel reach more people in the world in a simple way; Sub, and then leave a thumbs up and comment on each video that you watch : ) Thanks, Pravin!!!

@vasilisa6128 3 года назад

Thank you, Mike! I'm always looking for your videos!. You share your professional advice on what is the best practice of doing things, such as name a query first, change columns formats last. I believe knowing such steps and their best order saved me a lot of time and pain during learning new things. It's great to learn this first from you and later gain more confidence and shuffle them when needed. Was interesting to learn that the order of clicking on columns before expanding other columns will result in their order on the next step. Thank you, Mike!

@excelisfun 3 года назад

That funny thing is, Vasilisa, always naming things is one of the most basic efficiency skills, that when done consistency leads to accuracy and easy of use. Most teachers and bloggers and RU-vid Excel people, including many of the greats, don't both to include it in their books, videos, articles and such. I always see that and just cringe. When you take a class from me, I try to always do the little things, and the big things in a smart way.

@excelisfun 5 лет назад

The Power Query logo used in this video is copyright of and used with the express permission of powerquery.training Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!

@cakirankale Год назад

Append is such a transformative tool which for a user which will save a lot of time. Unpivot was really first time introduction for me and it cleared basics about original raw data format which then is transformed using pivot. How easy is it to unpivot using power query. Thanks Mike. God bless you.

@excelisfun Год назад

You are welcome!!! #6 and counting : )

@joelngige5776 4 года назад

I can never thank you enough as i have really learnt so much from your videos. Keep up the good work.

@excelisfun 4 года назад

Glad it all helps, Joel!!

@Abdelrahmankali 5 лет назад

Awesome as usual! I am wrapping up the Functions we are using in your playlist to come up with a list we used during this amazing training classes. I got confused with regards to mechanism/usage for (Merge v.s. Vlookup v.s relationships) - hopefully by next videos that clarity would be elaborated as you said :)

@amerfarooq1142 3 года назад

Mike your videos are so helpful that it helped me to have drastic changes in the office work so every day want to say you THANKS. Love from Pakistan

@excelisfun 3 года назад

You are welcome, Amer!!!!

@mattschoular8844 6 лет назад

Your videos are making it easier to analyze and manage my business. Thanks Mike

@Luciano_mp 6 лет назад

Mike, como foi comentado a baixo, você é o cara, já acompanho os seus vídeos há anos, você é muito bom e tem uma didática muito boa, obrigado por tudo....Sem palavras... Google Translator: Mike, as commented below, you are the guy, I have watched your videos for years, you are very good and have a very good didactics, thanks for everything .... Without words..

@excelisfun 6 лет назад

Você é bem vindo! E obrigado por ajudar em cada vídeo com suporte:) Os vídeos continuarão chegando:) You are welcome! And thank you for helping out on each video with support : ) The videos will keep coming : )

@1877Pegasus 4 года назад

Seriously. Your channel is just unbelievable. THANK YOU SO MUCH!!

@excelisfun 4 года назад

You got it! I post so you and others can learn, have fun and support with awesome comments and thumbs ups like yours, 1877Pegasus!!!!

@nhattruong7651 6 лет назад

Thank you so much! Your channel is my favorite channel of all time! very informative and very helpful for my work!

@qingli7415 5 лет назад

Nhat Truong really？

@zenia462 5 лет назад

I am an addict to your channel!! Thank you for the amazing things you teach!!

@excelisfun 5 лет назад

You are welcome for the amazing addiction! Thanks for your support, Zenia, with your comment, thumbs up and your Sub : )

@macintouch83 Год назад

Awesome video Mike, I didn't know how to keep my output data set on a specific sheet and avoid recreating a new one from the query ribbon, the right click update was exactly what I needed, thank you so much !!!

@sudharshanr4997 3 года назад

Falling in love with Power Query thanks to your amazing videos Mike!

@sandip_bettereveryday 6 лет назад

Great video! I am sure many more to come... especially looking forward to Group By, Parameter, Create Function, Invoke Custom Function. Surely lots of fun in store! Thank you.

@excelisfun 6 лет назад

O yes, so much more fun to come!!!! Thanks for your support, Sandip!!!!

@scottgaines2677 6 лет назад

Another great video Mike! Thanks so much! There is so much information, I am starting to watch them all again to make certain I understand all the content. Looking forward to future videos!

@excelisfun 6 лет назад

Yes, don't forget the pdf notes too - such much free info between video, pdf, Excel file and practice problems. Thanks for supporting this channel, Scott! This series will run for about nine months with one or two video a week.

@MrBlereau 6 лет назад

Most underrated channel on RU-vid ! Thanks

@dani_danyalin Год назад

Your Explanation is very clear and to the point, I Like this

@excelisfun Год назад

Glad it helps!

@helenpyon9860 Год назад

Excellent PQ tutorial. Thanks!

@871340730 4 года назад

Thanks so much Mike! You are simply "AMAZING"! Thanks again!

@871340730 4 года назад

Thank you very much Mike! I just can't repeat it enough!

@excelisfun 4 года назад

Once on each video is enough : ) I love it!

@TeamGarlic 5 лет назад

Simply awesome and highly recommended! The feature of merging fitted exactly into an assignment and the solution was a lot prettier and better! Really enjoy your videos. Thanks a lot!

@excelisfun 5 лет назад

You are welcome! What assignment? Assignment at work? Or, Are you taking a class somewhere, where Power Query is being taught and required for assignments? What was the assignment?

@TeamGarlic 5 лет назад

Hi Mike. It is an assignment at work in order to combine two different worksheets from two different external sources and create an XML file in a specific format which will be loaded into the software I work with. It has been quite interesting as I am not a programmer, but had to think about a lot of steps in this solution as my colleagues must be able to perform the same job. Love your teaching style. Your enthusiasm is a great example for all to teach others.

@excelisfun 5 лет назад

Thank you for your reply, Lars! I am glad that the videos can help with work : ) Thanks also for the kind words and for your regular support : )

@evgeniam8882 5 лет назад

Outstanding and maybe the most useful trasformations! thank you once again Mike!

@excelisfun 5 лет назад

You are welcome, Evgenia!!! Thank you for your support : )

@ExceliAdam 6 лет назад

It's cool that they are still working on Power Query and adding new features that make life easier like Append three or more tables

@excelisfun3903 6 лет назад

Yes, they keep adding new features : ) That is good : )

@excelisfun 6 лет назад

Yes, it is great becasue MS adds lots of useful features : ) Thanks for the support : )

@ncnc2896 6 лет назад

As usual you are so clear and a great teacher!! Thank you

@excelisfun 6 лет назад

You are welcome! Thanks for the kind words, and thanks for the support with your comment, Thumbs Up and Sub : )

@clalgbarros 4 года назад

Just great! Amazing! And there´s one thing I like to add.... I understand everything you say, even with my English not that fluent. Thanks a lot!

@excelisfun 4 года назад

You are welcome a lot, Clovis!!!!

@petermyran4986 6 лет назад

I am really enjoying and learning from this class series. Each video moves my understanding a little further down the field. Thanks Mike again and again :)

@excelisfun3903 6 лет назад

You are welcome, Peter, much more further to go down the field! Soon, we will all be outstanding in our field : )

@excelisfun 6 лет назад

You are welcome again and again for the path further down the field - so we will be outstanding in our field : ) Thanks for the support!!!!

@filipsvakjaroski20 3 года назад

Thank you, Mike. Relearning video for me today. :)

@himanshudalai1028 6 лет назад

Thank you sooooo much Mike for this awesome video.

@elactecnology 3 года назад

What a great video. Thank you Mike

@cmaman1 4 года назад

Seriously, This free playlist is better than many paid courses, I have tried many paid courses, but I have never ever understood the concepts like your learning style. I will make a refund because of you :). haha Thank you, sir

@excelisfun 4 года назад

I agree. And that is why I do not know why there are so few views and subscribers to my content. The story in each video is created so that anyone can learn the hard concepts, and it is free. And yet, so few views and subs. I have do everything that I know with marketing... But I have never figured about how to get this free content out to more people... BUT: The great news is that you, M. Alomery found it!!!!

@TheConanwarrior 3 года назад

Thanks Mike! Such great content as always! Big thumbs up

@excelisfun 3 года назад

You are welcome, William!!!

@romanguz 5 лет назад

Another fantastic video, thank you!

@siaozam 6 лет назад

This is incredible. Thanks for the lesson!

@excelisfun 6 лет назад

You are welcome for the lesson. It is partially incredible because of the consistent support form viewers like you with your comments, Thumbs Ups and Subscriptions : ) Thanks, siaozam!!!!

@MalinaC 6 лет назад

3 Important Transformations everybody should know! Thanks for the video, it was obviously awesome! :)

@excelisfun 6 лет назад

Thanks Teammate, Malina : ) : )

@wajdimatoussi 6 лет назад

Many many thanks Mike ..you are the best

@excelisfun 6 лет назад

Just trying to be a good Teammate. Thanks for your support, Wajdi, and many you are welcomes : )

@mohamedchakroun4973 6 лет назад

Always something new to learn or to brush up on it :-) thanks a lot mike you contribute a lot to our professional skills in excel :-)

@excelisfun 6 лет назад

You are welcome! I am happy to contribute to your Excel Skills!!! Go Team : )

@MdIslam-zj6yt 5 лет назад

This is really a great session. Thank you.

@excelisfun 5 лет назад

You are welcome, Md Islam!!! Thanks for the support with your comment, Thumbs Up and Sub : )

@lalitsharma9417 2 года назад

Thanks for the amazing examples. 👍

@excelisfun 2 года назад

You are welcome, Lalit : )

@iankr 2 года назад

Excellent tuition, sir. Many thanks.

@excelisfun 2 года назад

Glad it was EXCELlent for you, Ian : )

@sasavienne 4 года назад

This Power Query is a real Power. Thanks Mike. I never stop learning from you. 👍 And of course a Happy New Year 2020.. 🌟 🌟 🌟

@excelisfun 4 года назад

Happy New Year, K D Salim!!!!

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

Very helpful! Thanks 🙏

@dougmphilly 6 лет назад

unpivot lecture is pure gold

@excelisfun 6 лет назад

Glad you like the gold : ) And thank you for the support with your comment, Thumbs Up and Sub, doug : )

@PassportAndPixels 3 года назад

This is an amazing channel for Excel. Almost everything covered. I have been liking the videos so far. There are some queries to which I at times don't answer. Please let me know where can I put up those questions. A big Thumbs up 👍

@thiernoibrahimadiallo7740 6 лет назад

The coolest thing is that not only do you share your knowledge, but especially your files to follow step by step. If there are misspellings, I am self-taught in English

@excelisfun 6 лет назад

I am sure there are some mistakes, like misspelling because i do not have an editor to help - it is just me in one office making all the things that go into this video. If you find misspellings, let me know : )

@thiernoibrahimadiallo7740 6 лет назад

I talk about myself; my poor english, not you

@hi2832 4 года назад

Another excellent video. You really made it fun.

@excelisfun 4 года назад

Glad it is fun and informative, raheel!!!

@kosalanef 5 лет назад

Thank you very much again for sharing your knowledge... Cant ask for more.

@excelisfun 5 лет назад

You are welcome, Asantha!!!! Thanks for your support : )

@jimmys0307 5 лет назад

Wonderful...simply awesome! Thank You

@excelisfun 5 лет назад

You are welcome, Gagandeep Saggu!!!! Thank you for the support with your comment, Thumbs Up and Sub : )

@manfredzink6289 3 года назад

all lessons are "super", excellent

@excelisfun 3 года назад

Glad you like them : )

@rodrigocustodio1955 5 лет назад

Mike, you are 100% the best dude !

@excelisfun 5 лет назад

Thanks, Albert! Thanks also for your support with your comment, Thumbs Up and Sub : )

@kss2066 3 года назад

Enjoyed this class!

@excelisfun 3 года назад

: ) : ) : )

@yolandavelasco1889 5 лет назад

Great Videos!!! Thank you Mike

@excelisfun 5 лет назад

You are welcome, Yolanda!!! Thanks for your support : )

@Dome0497 4 года назад

great video, thanks!

@chriswebb4797 4 года назад

Excellent video, thanks!

@excelisfun 4 года назад

You are welcome for the EXCELlent video, Chris : ) : )

@pollo_ragg5080 4 года назад

Thank you a lot for your videos. they are amazing..

@excelisfun 4 года назад

You are welcome for the videos, Pollo_Ragg : ) Thanks for the support with comments and thumbs ups on each video that you learn from : )

@armondnazarian4455 4 года назад

Fantastic explanation! :)

@FRANKWHITE1996 4 года назад

Very informative video. Thanks. 🙌🙌🙌

@excelisfun 4 года назад

You are welcome! : )

@sunkannamadigonde721 6 лет назад

Great videos and easy to understand

@excelisfun 6 лет назад

Glad it is easy to understand! Thanks for your support, Sunkanna!!!

@kamranb1369 6 лет назад

Thanks for this great video Mike 👍

@excelisfun 6 лет назад

You are welcome, K B!!! Thanks for the awesome support : )

@mazarata73 6 лет назад

Once more a great tutorial Mike. The unpivot function is a pure releave for all who had to do that manually. There is one example I have prepared to demonstrate how to unpivot a cross-tabular table having multiple header rows per column. If fine for you, I will mail it to your gmail account. Awaiting your thumbs up or down. Thank you Mike.

@hermelindapartidas5928 2 года назад

Excelent!!! As usual

@AVINASHKUMAR-yi4od 2 года назад

Excellent explanation

@excelisfun 2 года назад

Glad it helps!

@barttitulaerexcelbart9400 6 лет назад

No suggestions this time Mike. Only one short remark: E X C E L L E N T !!

@excelisfun 6 лет назад

Thanks Bart, but did you really mean EXCELlent?

@fiazhitachi5732 5 лет назад

yes just another one word... Wow!!!!!

@letsexcel8077 5 лет назад

Superb, sir. Thanks for this video!

@excelisfun 5 лет назад

You are welcome, Gunabalan!!! Thanks for your support on each video with your comment and thumbs up, and of course your Sub : )

@davebowman5392 6 лет назад

Thanks Mike, great vid.

@excelisfun 6 лет назад

You are welcome, Dave! Thanks for the support : )

@mohamednofal4725 4 года назад

Thanks so much. I appreciate it hugely.

@excelisfun 4 года назад

You are hugely welcome, mohamed!!!

@ozansen_ozibaba 6 лет назад

Thanks , great tutorial.

@excelisfun 6 лет назад

You are welcome, ozan sen! Thanks for the support with your comment, Thumbs Up and Sub : )

@johnborg6005 6 лет назад

Thanks Mike. Awesome Staff!!! :) :)

@excelisfun 6 лет назад

Glad you like it, John!!!!

@OzduSoleilDATA 6 лет назад

GOOD STUFF! I like being able to change the column name without an additional step. 👍

@excelisfun3903 6 лет назад

Go Team!!!!!

@excelisfun 6 лет назад

Go Team!!!!! : ) : )

@AnhTuan-fv2kn 4 года назад

rất hay, cảm ơn bạn, tôi đến từ Việt Nam

@excelisfun 4 года назад

Toi rat vui khi ban thich video cua toi . Toi dang o My.

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

Thanks Professor Mike

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

You are welcome!!

@dorissweanapo9860 6 лет назад

Just finish watching this video, so I'm looking forward for the next one :)

@excelisfun 6 лет назад

it takes 25 - 50 hours to prepare one of these videos, and that is on top of my normal job. I can't wait for the next one either - I am working on it right now : )

@dorissweanapo9860 6 лет назад

I just want to tell you that I'm learning so much from your channel. All your videos are excellent and so easy to follow. I really appreciate the time you put to make them :)

@excelisfun 6 лет назад

Thanks, Doris. It means a lot to get support and hear that the content is useful : ) : )

@nimanitto 3 года назад

Keep safe my friend. you are great.

@excelisfun 3 года назад

Glad this helps!

@ismailismaili0071 6 лет назад

the video was so much fun i don't know how to thank you i'm still waiting for more i'm starving to your videos Mr. Mike hhhhhh thank s again

@excelisfun 6 лет назад

You are welcome again, Ismail!!!! Thank you for your support : )

@SyedMuzammilMahasanShahi 6 лет назад

Thanks Mike for this amazaing video

@excelisfun 6 лет назад

You are welcome, Syed! And thank you for the great support : )

@Fxingenieria 3 месяца назад

Espectacular

@shrekikiki 6 лет назад

Great job!!!

@excelisfun 6 лет назад

Glad it was great for you, LI LY!!! Thank you for the support with your comment, Thumbs Up and SUb : )

@chrism9037 6 лет назад

Amazing Mike!

@excelisfun 6 лет назад

Glad it is amazing for your Chris!!! Thanks for your amazing support : )

@kishanpanchal2965 4 года назад

Thank you very much

@excelisfun 4 года назад

You are welcome for the MSPTDA #6 fun, Kishan : )

@sadyaz64 6 лет назад

Very usefull Thank you

@excelisfun 6 лет назад

You are very welcome, sadyaz64!!! Thank you for the support with your comment, Thumbs Up and Sub : )

@pravinshingadia7337 5 лет назад

Thank you!

@excelisfun 5 лет назад

You are welcome, Pravin!!

@rrrprogram8667 6 лет назад

ALWAYSS THE BESTTTT

@excelisfun 6 лет назад

Thanks for your kind words and support, RRR!!!!!

@CarlosEliezerHernandezPintor 3 года назад

This is top!

@dafeac 5 лет назад

Great, homeworks are best practice, solved class 05 homework differently

@excelisfun 5 лет назад

So great to hear that you are being creative with your homework practice, NanoBanano!!! Thank you for your support on the excelisfun channel at RU-vid : )

@dafeac 5 лет назад

@@excelisfun no sir Thank you, in this vid homework I had to change type using locale since I use ddmmyy, you really learn when your run into trouble

@excelisfun 5 лет назад

@@dafeac I think you are right about running into trouble - it actually helps us to learn : )