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
I will break my tv any day I couldn’t find any of your tutoring videos on TH-cam 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
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 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!
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 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 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.
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
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.
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!
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 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.
How can i pull data from excel to excel automatically but i have group function and every group needs to shows total amount (which i put =sum formula) Thank you
Excel is limited to only using MS Edge as its browser; there id no way to use Firefox or Brave as default browser. Directions found on the web are meanigless
please from 6:00 when i right clicked for properties. it didnt bring all the usage, definition and used in bar please what was the problem or was it difference in excel version?
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.
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, 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.
hi, i want some assist in how to create sub columns under one cell in table. For example main header is months and under it few months like Jan, Feb, Mar and etc. how do you do it . please help me.
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,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.
While importing from web, What if it is a page w/ credentials? I am attempting to import " Landed jobs" from my construction software but I cant get past the credential page.
Hello sir i have been follow your tutorials which have been very helpful, but i am having a problem in Microsoft Excel Tutorial - Beginners Level 5, when i pull up the data, it brings not just the table but all other data from the web, and when i delete them it refreshes and come back, is this because i am using the excel 2013?
Don't get me wrong, I'm grateful for your tutorials but this one really doesn't look like a level 5, your level 3 and level 4 video are much more difficult to learn than this. This is after I watched all of them in sequence.
the copy data and deleting it across multiple sheets is not working for me even tho i followed the same steps same for control +t it's also not working i removed the formatting and all but when i want to insert a table it says that i can't put a table on top of another one it was not clear in the video how you removed the table before clicking control + t
Is it different to import from websites when using MacBook? I tried and the set up is a bit different. I notice sometimes you mention the differences but not in this situation. Still trying to figure it out. Thanks.
I keep having issues doing minor things. Such as: When I try to delete multiple cells, it just clears that first cell and the rest won't delete. Is there a reason it does that? And also, when I copy and pasted to multiple sheets, when I deleted the items, it didn't update to the other sheets.
I also have a similar project with video files that i have from my Blu ray and dvds for my home network. i would want to be able to import each location of those files into a data base or table of what is on which drive and link websites for information on those series and stuff. let me know if this make any sense to you. i would like to learn, but i do better with visual tutorials then reading about it. thanks
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 😊
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.
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
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
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
I will break my tv any day I couldn’t find any of your tutoring videos on TH-cam 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
you are wonderful tutor Jamie, i can understand all videos you taught
Thank you so much for this class!
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 was waiting for part 5 thx for this it's really use full
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!
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
Thank you so much!
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.
Thanks!
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
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
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
You're the best excel teacher on youtube, thanks so much.
Thank you so much
Thank you very much😊
I scored a 78% in my Excel exam which is a Distinction at university 🎉
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.
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!
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🙏🙏
@Teacher Tech Literally needed this. So simplified and now I get it!!!!
No idea how much this is helping me - thanks so much ☺
የቐንየለይ ጂም / Thank you Jamie
This guy IS GREAT 💯#totally
Very kind, thanks! 🙏
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 for the amazing lessons. I never thought learning Excel could be so easy. It seemed impossible until I found your videos.
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
You are best ever teacher man, the way you teach is really easy and fascinating
very clear and helpful!
Great!
is it the same procedure
I'm a big fun...I'm a beginner learn a lot in a short period of time
Thanks again for another great tutorial...watched them all so far...
It"s a fantastic tutorial for beginner like me. now that I"l be practicing now. thank you very much.
thank you, it is really helpful. Have you posted any about financial modelling?
I'm grateful Teacher's Tech. Your resources are really helpful and refreshing. Keep up the good work.
I appreciate that!
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.
How can i pull data from excel to excel automatically but i have group function and every group needs to shows total amount (which i put =sum formula) Thank you
❤❤❤❤❤❤
Excel is limited to only using MS Edge as its browser; there id no way to use Firefox or Brave as default browser. Directions found on the web are meanigless
Hi Jamie-Do you provide one on one tutoring? I have a large project for work and I need some help. --Mark
please from 6:00 when i right clicked for properties. it didnt bring all the usage, definition and used in bar
please what was the problem or was it difference in excel version?
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.
I need help !!!!!!
I need basics of exel
Showing up consistently. Day 5.
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, 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
Thank you, great tutorial and short cuts😊
Glad it helped! You’re welcome.
hi, i want some assist in how to create sub columns under one cell in table. For example main header is months and under it few months like Jan, Feb, Mar and etc. how do you do it . please help me.
The copy is not clean from the computer. Pls do something about it .thank you .
Ive watch all the tutorial im greatful..
I wish you will do a video for how to past m.excell test
Thanks so much! These are the best classes so far! I enjoy learning!
Thank You so MUCH!!!
i'm using excel 2016 and this doesn't work
At wat point would you consider yourself intermediate excel?
How about a class on power BI
Can you make practice exams with an answer review video please?
Again. This tutorial is useless to me as my excel screen and menus do not match yours at all.
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 .
For anyone using a mac trying to import web data... It is not supported
Thank you, teacher Jamie! You're awesome!
Will there be part 6 or are we ready to be intermediate
I’ll be creating an intermediate one
You the best 💯
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.
My Data area is stating that I need permissions to do this download from the internet?
Problem
I couldn't bring up the table of the URL I copied.
Some help would be greatly appreciated! THNX!
While importing from web, What if it is a page w/ credentials? I am attempting to import " Landed jobs" from my construction software but I cant get past the credential page.
Hello sir i have been follow your tutorials which have been very helpful, but i am having a problem in Microsoft Excel Tutorial - Beginners Level 5, when i pull up the data, it brings not just the table but all other data from the web, and when i delete them it refreshes and come back, is this because i am using the excel 2013?
can u plz provide practice sheet for every related tutorial
Hi Jamie ,,I can’t find the navigation pane under view tab only ruler exists …( creating table of contents ) please help 🙏thanks
Hey Jamie, when I select the option of getting data from the web Excel(2016) does not give me the options yours did. Any tips? Cheers.
This doesn’t work if you are using Mac
Don't get me wrong, I'm grateful for your tutorials but this one really doesn't look like a level 5, your level 3 and level 4 video are much more difficult to learn than this. This is after I watched all of them in sequence.
I couldn't import data in a table format, it's coming in a different way and also the QUERY menu in not visible in my ribbon.
the copy data and deleting it across multiple sheets is not working for me even tho i followed the same steps same for control +t it's also not working i removed the formatting and all but when i want to insert a table it says that i can't put a table on top of another one it was not clear in the video how you removed the table before clicking control + t
Is it different to import from websites when using MacBook? I tried and the set up is a bit different. I notice sometimes you mention the differences but not in this situation. Still trying to figure it out. Thanks.
Very good lessons
I keep having issues doing minor things. Such as: When I try to delete multiple cells, it just clears that first cell and the rest won't delete. Is there a reason it does that? And also, when I copy and pasted to multiple sheets, when I deleted the items, it didn't update to the other sheets.
I also have a similar project with video files that i have from my Blu ray and dvds for my home network. i would want to be able to import each location of those files into a data base or table of what is on which drive and link websites for information on those series and stuff. let me know if this make any sense to you. i would like to learn, but i do better with visual tutorials then reading about it.
thanks
how to import web data to excel in MAC?
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.
Thankyou Very much, really really helpful 😄
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 😊
Hello!
As a beginner, after taking the level 5 of excel, what next can I learn in excel... Kindly advice me.
I get an unexpected error message when trying to import from the web. Is there any way to fix this?
Can please help me how to upload
data from notepad to excel .Your videos are great, thankyou.
Thank you sir, for teaching
Thank you very much sir..i find it very easy to understand and learn exel.❤❤
Hi
May i know how could I do projects scheduling by Excel?
Thanks
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.
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
The only place I got lost was convert to Range. You showed how, but what does that mean?
The best excel teaching
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 u very much. Your tutor helped me to excel my skill
Have watched all 5 beginners and they are so good, easy to understand
such a big help sir, pls continue for sharing
Alot of thanks
You’re welcome!
How to copy the attachment from mail
Hi Jamie thank for the beginners levels, next step intermediate level lets go
Thank you soo much for lesson 4 but how can i get the data that you used in the lesson 4