For those using Microsoft (2016), select tab “Data” > select “New Query” under group “Get & Transform” > “From Other Sources” > “From the Web” > Paste URL > Ok > Under “Navigator” select whether you want to attach the entire document or the table > Select “Load”
I will break my tv any day I couldn’t find any of your tutoring videos on RUclips I mean it. You have given me hope to continue learning this excel program because You are very easy to understand. I just discovered your channel and stop going for an excel class I paid for. May Good things never depart from your household. Many thanks from Lagos, Nigeria
I watched all these beginner level videos and you helped me so much! I would love to see intermediate and advanced levels too! You teach very well! Thank you!
am so grateful to u sir. have been trying to learn excel from many other channels but i got confused halfway but your explanations are so simple but detailed and easy for even 11 year old to follow. may God reward you sir. some times i just watch your explanations then rewatch again but this time with practice. i love the fact that you time stamped the videos .easy to navigate. love from UK
You have made this journey so easy for me cos i never believe i can still learn this again. this course was abandoned over a decade because of bad tutor. I am grateful for this and i hope we meet in the future to thank you once again. from Abuja, Nigeria .
This is testimony, you training landed me a promotion never knew it will come when my manager asked me the you know Excel, then all because of your training I really went far thanks alot
After watching all the beginner playlists, I will go and watch the intermediate playlist. I hope the advance playlist comes out. Nice and easy tutorial to understand
Hi,thank you for your video,i'm learning so much, and creating some tables as I'm watching your video,. I'm at the beginners level.thank you learning so much.
Why in the hell I didn’t find this channel at the first place. Sir, may I tell that you are serving the the best for many needy people /students / ppl yearning to learn new things. May God give you a long, healthy, prosperous and honourable life. May God give u the strength to continue all the good things u feel like to do like this Excel tutorial class.
Hi Jamie, thank you for all your videos. Excel on my new Mac has a different format to “Get Data”. I didn’t see most of the things you talked about. Can you please do an updated video for the newest excel version or reply with some pointers? Thanks.
Thank you Jamie for this wonderful lesson. Will there be an intermediate lesson? Can i go ahead to learn Data Analysis with this basic excel lessons? Thank you for your response.
Hi, I cannot say enough about these Excel tutorials for beginners. It is helping me so much. I will be rewatching a few times so that I can retain it because I am not practicing at the moment. Thank you so much for your time and for these videos😌👏💚
Thank you so much, it was very helpful for a beginner like me. I loved that you also provided us with the data we can practice while watching your tutorial. Thank you so much.
The best teacher, Jamie, clear and step-by-step teaching. I gained a lot from your teaching from Tutorial Level 1 up to level 5. This is helpful for my career, Data Analysis for Health Programme 😊
I can't get the data for the NFL table you have. You set it to Viewing only so I can't do anything with it. EDIT: I got it! I just selected it all in did a copy an paste! I swear, i studied Graphic Design, and the computer skills i learned from it really has helped me navigate Excel! Lmaoooooo. I love this!
Thank You Jamie and a wonderful job on all your tutorials. I would like to know if you have a video on transferring CVS data for inventory use in example food and beverage related.
Hi I thought I should let you know that the practice data file has been overwritten by someone who was practicing, so the data and sheets are a complete mess. The data for the quarter backs is messed up, theres 9 random data sheets and lots of things wrong. I fixed it enough so I could follow along but I thought I would let you know so you can fix it for others if you wished. Thanks for the great videos man. Helpful as always.
So, I had a job interview with a company, and I'm familiar with excel but wanted a refresher because my job uses preset worksheets that have already been made. So mostly I would just search/filter/scan. The tests that I have taken in regard to excel have been 60 percent shortcuts and 40 percent application. So be careful when taking these tests for job's, know the shortcuts.
Hey sir I have a question, So I watched all your 'Excel for beginners' videos and I've found them very simple to understand and beneficial for me I would like to ask you do you have intermediate and advanced levels? Because I want to Ace my Excel exam and get my certificate hence it will help me improve my CV when I apply for jobs! Thank you so much I'm waiting for ur Reply🙏🙏
Hello Jamie, thank you for your video! It's amazing. I'm currently using a MacBook Air and is there a way to import web data on Mac? I couldn't find the function and I searched for it on the internet but no one seems to know how to do it.
Hi Jamie - I went in to start this Level 5 video but when I downloaded the excel practice sheet it was a sheet with a tab at the bottom "aggregated players statistics" it was not one with movies - how can i access this practice sheet so i can follow along easier and download - I like to have the sheets in front of me - they are so helpful
On the pasting to different sheet, Should I press the shift and down arrow and select multiple sheets or what. Bcause in my case it is only pasting to only on.
Hi Jamie! I’m new to your channel and Im super hook Currently Im on the sales department and Im not that happy with the level I know in Ecxel so I tried last night to check some of the excel tutorial and saw your channel and Im so happy that you are very easy to understand Im now on this video and will continue on your mpre videps on execel tutorial I just have a question if you have a video, say I have the data and I wanted to do a formula on a different sheet. Now the formula I need is that I wanted to search the specific word/text/numbers the on the sheet if you will input the word or numbers it will automatically populated the said data on below of that specific word/number. Thanks in advance 😊 hope to hear from you soon 😊
What happed in the duplicate values remove option . I tried to figure out looking at the table specifically the Justin Herbert’s row and column . Pls tell me what duplicate values were removed from Justin Herbert.
For those using Microsoft (2016), select tab “Data” > select “New Query” under group “Get & Transform” > “From Other Sources” > “From the Web” > Paste URL > Ok > Under “Navigator” select whether you want to attach the entire document or the table > Select “Load”
thank you, it works
I will break my tv any day I couldn’t find any of your tutoring videos on RUclips I mean it. You have given me hope to continue learning this excel program because You are very easy to understand. I just discovered your channel and stop going for an excel class I paid for. May Good things never depart from your household. Many thanks from Lagos, Nigeria
Glad to help! Thanks for the kind words.
@@TeachersTech you are amazing 💖
The best teacher ever😊
Hey brother ... Hope you're f9 ... letme know what u doing nowadays ... wanto get motivated more by learning dz
I watched all these beginner level videos and you helped me so much! I would love to see intermediate and advanced levels too! You teach very well! Thank you!
You're the best excel teacher on youtube, thanks so much.
Thanks again for another great tutorial...watched them all so far...
am so grateful to u sir. have been trying to learn excel from many other channels but i got confused halfway but your explanations are so simple but detailed and easy for even 11 year old to follow. may God reward you sir. some times i just watch your explanations then rewatch again but this time with practice. i love the fact that you time stamped the videos .easy to navigate. love from UK
I'm grateful Teacher's Tech. Your resources are really helpful and refreshing. Keep up the good work.
I appreciate that!
You have made this journey so easy for me cos i never believe i can still learn this again. this course was abandoned over a decade because of bad tutor. I am grateful for this and i hope we meet in the future to thank you once again. from Abuja, Nigeria .
Hi Jamie thank for the beginners levels, next step intermediate level lets go
This is testimony, you training landed me a promotion never knew it will come when my manager asked me the you know Excel, then all because of your training I really went far thanks alot
Thank you very much😊
I scored a 78% in my Excel exam which is a Distinction at university 🎉
After watching all the beginner playlists, I will go and watch the intermediate playlist. I hope the advance playlist comes out. Nice and easy tutorial to understand
Thank you for the amazing lessons. I never thought learning Excel could be so easy. It seemed impossible until I found your videos.
Showing up consistently. Day 5.
Thank you so much for this class!
You are best ever teacher man, the way you teach is really easy and fascinating
Thank you teacher Jamie! You're amazing. All your tutorial lessons are concise, clear and comprehensive. Keep up the good work! God bless you!
some stunk
Thank you so much Jamie! You're an amazing teacher.
Omg, this tutorial is amazing! God bless you! 😊
very clear and helpful!
Have watched all 5 beginners and they are so good, easy to understand
@Teacher Tech Literally needed this. So simplified and now I get it!!!!
No idea how much this is helping me - thanks so much ☺
I've enjoyed these sessions. Thank you. You explain things very well. Many of these points I did not learn when I first did Excel.
የቐንየለይ ጂም / Thank you Jamie
The best excel teaching
Thanks so much! These are the best classes so far! I enjoy learning!
Hi,thank you for your video,i'm learning so much, and creating some tables as I'm watching your video,. I'm at the beginners level.thank you learning so much.
you are wonderful tutor Jamie, i can understand all videos you taught
Simple and easy to understand. Thank you
Hello from lebanon🇱🇧🇱🇧🇱🇧
Why in the hell I didn’t find this channel at the first place.
Sir, may I tell that you are serving the the best for many needy people /students / ppl yearning to learn new things. May God give you a long, healthy, prosperous and honourable life. May God give u the strength to continue all the good things u feel like to do like this Excel tutorial class.
I'm a big fun...I'm a beginner learn a lot in a short period of time
Amazing tutorials. Thank's a lot !
Hi Jamie, thank you for all your videos. Excel on my new Mac has a different format to “Get Data”. I didn’t see most of the things you talked about. Can you please do an updated video for the newest excel version or reply with some pointers? Thanks.
same here
It"s a fantastic tutorial for beginner like me. now that I"l be practicing now. thank you very much.
Thank you, teacher Jamie! You're awesome!
Ive watch all the tutorial im greatful..
I wish you will do a video for how to past m.excell test
Thank u very much. Your tutor helped me to excel my skill
Thank you, great tutorial and short cuts😊
Glad it helped! You’re welcome.
Teacher's Tech Videos are very vital it has help me to learn vase about Excel
thank you, it is really helpful. Have you posted any about financial modelling?
Thank you Jamie for this wonderful lesson. Will there be an intermediate lesson? Can i go ahead to learn Data Analysis with this basic excel lessons? Thank you for your response.
i was waiting for part 5 thx for this it's really use full
I love your tutorials...they have helped me with my new job! Any plans for a Level 6?
Thank you! Check out my intermediate lessons.
@@TeachersTech Can you send me a link; for some reason, I cannot find it.
Hi, I cannot say enough about these Excel tutorials for beginners. It is helping me so much. I will be rewatching a few times so that I can retain it because I am not practicing at the moment. Thank you so much for your time and for these videos😌👏💚
such a big help sir, pls continue for sharing
Thank you for the five levels for beginners. It was great.
I really enjoyed your tutorials
Thank you very much sir..i find it very easy to understand and learn exel.❤❤
your videos are very helpful.
YOUR TUROTORIALS ARE VERY HELPFUL
Thank you so much, it was very helpful for a beginner like me. I loved that you also provided us with the data we can practice while watching your tutorial. Thank you so much.
Great videos. Could not download the data. May be im stupid
This guy IS GREAT 💯#totally
Very kind, thanks! 🙏
Thank you sir, for teaching
Thank you sir from India.
Very good lessons
Thanks for your amazing videos!
Can you make practice exams with an answer review video please?
Thank u so much sir for all this Excel teachings.. I love it. God bless you real Good.
God bless you. So clear
Thankyou Very much, really really helpful 😄
You the best 💯
Thank you for this valuable information
thank you for this amazing tutorial , you helped me so much !
Very Helpful👍
You are the best....
I watched from Level 1 to 5 and they're very comprehensive. Thanks Jamie
Thank you so much teachers tech
The best teacher, Jamie, clear and step-by-step teaching. I gained a lot from your teaching from Tutorial Level 1 up to level 5. This is helpful for my career, Data Analysis for Health Programme 😊
Hey ... what you're doing nowadays after learning dz ?? Want for info
I can't get the data for the NFL table you have. You set it to Viewing only so I can't do anything with it.
EDIT: I got it! I just selected it all in did a copy an paste! I swear, i studied Graphic Design, and the computer skills i learned from it really has helped me navigate Excel! Lmaoooooo. I love this!
Can please help me how to upload
data from notepad to excel .Your videos are great, thankyou.
This need more views!
I guess not mamy people are like us who dont know excel lol
Thank You Jamie and a wonderful job on all your tutorials. I would like to know if you have a video on transferring CVS data for inventory use in example food and beverage related.
Not yet! Great suggestion.
@@TeachersTech Level 6 link .?
is it the same procedure
Hi Jamie-Do you provide one on one tutoring? I have a large project for work and I need some help. --Mark
Concise and fun
can u plz provide practice sheet for every related tutorial
How about a class on power BI
Thank You so MUCH!!!
Hi I thought I should let you know that the practice data file has been overwritten by someone who was practicing, so the data and sheets are a complete mess. The data for the quarter backs is messed up, theres 9 random data sheets and lots of things wrong. I fixed it enough so I could follow along but I thought I would let you know so you can fix it for others if you wished.
Thanks for the great videos man. Helpful as always.
Thanks, I’ll upload it again and make sure my permission are correct
Persons should just download or copy it onto their systems so that they don't mess up the original.
So, I had a job interview with a company, and I'm familiar with excel but wanted a refresher because my job uses preset worksheets that have already been made. So mostly I would just search/filter/scan. The tests that I have taken in regard to excel have been 60 percent shortcuts and 40 percent application. So be careful when taking these tests for job's, know the shortcuts.
Thank you so much for providing the practice sheet! I've watched through all your beginner videos 1-4 and they've been great!
Great help. Thank you so much
Hey sir I have a question, So I watched all your 'Excel for beginners' videos and I've found them very simple to understand and beneficial for me I would like to ask you do you have intermediate and advanced levels? Because I want to Ace my Excel exam and get my certificate hence it will help me improve my CV when I apply for jobs! Thank you so much I'm waiting for ur Reply🙏🙏
Hello Jamie, thank you for your video! It's amazing.
I'm currently using a MacBook Air and is there a way to import web data on Mac? I couldn't find the function and I searched for it on the internet but no one seems to know how to do it.
I'm using a Macbook as well, I can't seem to figure out how to import data from the web
Great Man. Thanks
Thank you Soo much....this has been very useful right from tutorial 1.....big hug mate 🙂 thank you 😭🤗
Alot of thanks
You’re welcome!
simply love you
Hi Jamie - I went in to start this Level 5 video but when I downloaded the excel practice sheet it was a sheet with a tab at the bottom "aggregated players statistics" it was not one with movies - how can i access this practice sheet so i can follow along easier and download - I like to have the sheets in front of me - they are so helpful
Many thanks
On the pasting to different sheet, Should I press the shift and down arrow and select multiple sheets or what. Bcause in my case it is only pasting to only on.
Thank you! 😃
God Bless you.
Hi Jamie!
I’m new to your channel and Im super hook
Currently Im on the sales department and Im not that happy with the level I know in Ecxel so I tried last night to check some of the excel tutorial and saw your channel and Im so happy that you are very easy to understand
Im now on this video and will continue on your mpre videps on execel tutorial
I just have a question if you have a video, say I have the data and I wanted to do a formula on a different sheet. Now the formula I need is that I wanted to search the specific word/text/numbers the on the sheet if you will input the word or numbers it will automatically populated the said data on below of that specific word/number.
Thanks in advance 😊 hope to hear from you soon 😊
thanks a loot Mr. teach
Thank you Sir
Problem
I couldn't bring up the table of the URL I copied.
Some help would be greatly appreciated! THNX!
Thank you soo much for lesson 4 but how can i get the data that you used in the lesson 4
What happed in the duplicate values remove option . I tried to figure out looking at the table specifically the Justin Herbert’s row and column . Pls tell me what duplicate values were removed from Justin Herbert.