I am starting to really like Excel and never thought this would happen! I think in the past I was just fearful because I did a short course many years ago, and then never had the opportunity to use Excel much in my job, however a lot of EA jobs now require a very good understanding of excel. I just used SUMIF in a table and it worked! You are such a fantastic teacher. THANK YOU AGAIN!!! :)
Thank you! This was so helpful!!! I was scouring the internet trying to get the answer to this, and in just a few minutes you had shown me exactly what I needed! :)
Thank you so much sir,I was supposed to go for an interview and had to have an idea on Excel,I watched this video and went and was able to do my interview.🙏
Jamie i've been going through your videos on teachers tech, n believe me you ,you and the most talented and the best teacher in the whole world for me, your videos are so clear and crisp, so much clarity of information , thank you so very much pls do keep up the good work of uploading videos and education people thanks a million, god speed and god bless you.
Wow I'm short of words I just finished watching from lecture 1-4 and I most say I learned alot and will keep implementing it may God bless you and replenish u
Top class videos, i've watched all 5 of the beginners one's and really reminded myself of the basics!. Will be moving onto the pivot table ones now. Great content and sub'd!
I'm taking over a construction business from my father, I worked for him but didn't have the time for all of the management side. Thank you so much for explaining it so easily that I could understand in less than an hour... It's helped the budgeting side of things tremendously
Thank you so much. That SUMIF function is wonderful for what I do at work and so time saving, Before I'd data sort based on the criteria then add each separately. I'm really grateful to learn this.
Thanks for all these vids. It took me from the first tutorial until now to realize this, but you look like Michael Keaton. More Birdman than Batman but does anyone else see it? lol
Your way is straightforward and I like it so much. Not related but can you make a video about tips or easy steps to do in order to how clean your computer and make it quicker.
Until recently I was indifferent towards learning Excel. But because the last two jobs I worked for required a good Excel background I'm now prioritizing myself towards learning as much as I can regarding Excel (along with Word, Outlook and Power Point).
Hi Jamie nice work Just finished watching excel tutorials for beginners and was wondering if there are more higher level excel video tutorial intermediate advanced etc..
HI, I am encountering a problem after I am using " sign in excel and space or other character is showing me teh $ sign , it is very annoying in formulas, i dont know how to get rid of it !
I’ve been watching several of your very helpful videos. I’m wondering if you have a video that shows how to add # of hours, for example 10:09am to 10:00pm, a formula to calculate 12 hours. Thank you
thank you for all that info also I have inventory sheet always have change how do I know if i change the inventory or not ? or what about date and time in same cell ? also some time the formula give the real time and some time give me time and date and some time give wrong time why all that since im using Mac thank you so much
Great video! How can a write a equation in one tab and then call that equation up in other tabs? I presently copy and paste the equation in one tab which is easy, but in the future many more tabs will be used. As time goes by the equation is getting updated and I don't want to copy it to all of the tab again. Thank you
Thank you for the information, I have just watched all four of your first videos plus this one. I need constant refreshing on how to use Excel because I keep forgetting the simplest things. I work with pretty complex spreadsheets that upload thousands of lines of information that have been already set up by others. I am hoping to just get some insight as to how they set them up and if I can do the functions myself. Listening to what you have reviewed, I realize I know most of the basics, but appreciate your overview. I am not sure whether to use VLookups, Pivot Tables or other formulas to achieve my end result. Currently I have a spreadsheet, where there is a listing of numbers and words that I need to relate to a separate worksheet but these are constantly changing. Which worksheet should I use to make the changes, the main one where the info is updated or the smaller ones that are broken down pieces of information from the main one. Just getting a bit lost, it is probably an easy solution, I am not thinking clearly.
Hi, I've just discovered your you tube page. I find it very interesting and helpful. Can I ask, do you have any video's to create a spreadsheet for a Forex Trading Journal.
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
I just finished watching tutorials 1-4 and you really did a great job making it so easy to follow through. Thank you, sir!
You’re welcome!
@@TeachersTech You really are easy to follow and you have a very nice demenor.
Welele, inganekwane
I am starting to really like Excel and never thought this would happen! I think in the past I was just fearful because I did a short course many years ago, and then never had the opportunity to use Excel much in my job, however a lot of EA jobs now require a very good understanding of excel. I just used SUMIF in a table and it worked! You are such a fantastic teacher. THANK YOU AGAIN!!! :)
I wish I would have had you as a college professor! You are an excellent teacher. Thank you.
0:21
Thanks!
I liked your tutorial because it was concise and to the point, not too much self-promotion, which goes on too much on youtube nowadays.
Thank you! This was so helpful!!! I was scouring the internet trying to get the answer to this, and in just a few minutes you had shown me exactly what I needed! :)
This is THE BEST tutorial on excel functions & formulas I've ever watched! Sooooooooo helpful! Thanks SO much! :)
You're very welcome!
Jamie,you are doing a great job. The truth is you have brought the school in my home. Congratulations!
Thank you so much sir,I was supposed to go for an interview and had to have an idea on Excel,I watched this video and went and was able to do my interview.🙏
Jamie i've been going through your videos on teachers tech, n believe me you ,you and the most talented and the best teacher in the whole world for me, your videos are so clear and crisp, so much clarity of information , thank you so very much pls do keep up the good work of uploading videos and education people thanks a million, god speed and god bless you.
Wow, thank you!
By far the best tutorials I have seen. Thank you for dummying it down for beginners
I am doing an ECDL at the moment, these videos are much better than the software provided, These videos really help thanks a million.
Wow I'm short of words I just finished watching from lecture 1-4 and I most say I learned alot and will keep implementing it may God bless you and replenish u
Excellent professor, quick and simple and easy to understand. Thank U!
Top class videos, i've watched all 5 of the beginners one's and really reminded myself of the basics!. Will be moving onto the pivot table ones now. Great content and sub'd!
Awesome, thank you!
Thanks
I'm taking over a construction business from my father, I worked for him but didn't have the time for all of the management side.
Thank you so much for explaining it so easily that I could understand in less than an hour... It's helped the budgeting side of things tremendously
or you can let me be your cheap manager 😭[and i might gain experience and learn a thing or two]
Didn't know learning excel would be this easy. Thank you so much.
Thanks for lovely tutorials
Your videos are helping me alot it was beneficial for me .....
blessed to have a sir like you .
So nice of you
THANK YOU SO MUCH! You are truly educating this old man. You are a wonderful teacher.
Hi Jamie, I just want to say thank you for all your tutorial. I have learnt so much and growing in confidence using Microsoft 365
Wow I watch these at work during downtime. I really learned a lot so far, thanks very much!
Thank you for working hard to create this simplified tutorial videos. 💜 I couldnt thank you enough 🙏
Thank you so much. That SUMIF function is wonderful for what I do at work and so time saving, Before I'd data sort based on the criteria then add each separately. I'm really grateful to learn this.
I finished all 5 of beginers. Looking forward to your video on adavnced excel. You are a great teacher
Dude .... DUDE .... YOU ARE A DAMN LEGEND!!!!!! ❤❤❤❤❤
I watch all of the ads because I appreciate the free information. Thank you
Thank you so much! Being able to follow with your spreadsheets is awesome!
Jamie you are the G.O.A.T thank you so much. Would like to learn more about pivot tables
Here you go! ruclips.net/video/PqczHnsNFdM/видео.html
Thankyou so much you make me confident to use excell many blessings to you
I do like your tutorials. Thank you.
Thank you for these tips! You're amazing teacher!
That's an amazing tutorials, so helpful!!!Thank you very much!
Thanks to being my rain drop again✊🤝
Thank you so much for this course!
this is one of the most awesome tutorials I have ever seen
Thanks for all these vids. It took me from the first tutorial until now to realize this, but you look like Michael Keaton. More Birdman than Batman but does anyone else see it? lol
Loving all your videos! This is helping me tremendously thank you
Your way is straightforward and I like it so much. Not related but can you make a video about tips or easy steps to do in order to how clean your computer and make it quicker.
Until recently I was indifferent towards learning Excel. But because the last two jobs I worked for required a good Excel background I'm now prioritizing myself towards learning as much as I can regarding Excel (along with Word, Outlook and Power Point).
Great teacher
Love your tutorials. Simple and effective
Happy to hear that!
This is so helpful and really simplifies MS.Excel.
Thank you so much for how easy you make this for me😊
You are an excellent teacher 👏
I actually needed this, job interview tomorrow and I'm giving myself a crash course... 🤞
I'm glad I could help!
@Ste_drag yay how did it go pls
Was so mad he didn't get the job - rammed car into tree..... 💀
Muito obrigada! Thank you so much!
Powerful. Thanks.
Great Job,
Thankyou so much!!
Thanks for that great tutorial :D
Love the vids
You're an amazing teacher
I appreciate that!
On the next one 😁👍
Thank you!! Your wonderful Teacher.
Thank you so much it helps me a lot 🙏
Hi Jamie nice work
Just finished watching excel tutorials for beginners and was wondering if there are more higher level excel video tutorial intermediate advanced etc..
Working on putting out one of these very soon.
Best tutorials!!!
Thank you, well explained.
Very clever and concise presentation
thank you sir , you did a great job
HI, I am encountering a problem after I am using " sign in excel and space or other character is showing me teh $ sign , it is very annoying in formulas, i dont know how to get rid of it !
Thanks for your great job, I appreciate.
Very helpful. thank you sir.
Thanks again.
You’re amazing!!
Thank you teacher
I so appreciate the timestamps!
Please do more Excel videos..! U r awesome
great lesson !
You are very helpful 😊
i really want to know more
but thanx
for your services
Thank you for your videos! Very helpful. :)
You're very welcome!
I’ve been watching several of your very helpful videos.
I’m wondering if you have a video that shows how to add # of hours, for example 10:09am to 10:00pm, a formula to calculate 12 hours.
Thank you
Appreciate your time. God bless you.
Do you have any videos on how to use multiple functions within one another ..
thank you for all that info also I have inventory sheet always have change how do I know if i change the inventory or not ? or what about date and time in same cell ? also some time the formula give the real time and some time give me time and date and some time give wrong time why all that since im using Mac
thank you so much
Great video!
How can a write a equation in one tab and then call that equation up in other tabs?
I presently copy and paste the equation in one tab which is easy, but in the future many more tabs will be used. As time goes by the equation is getting updated and I don't want to copy it to all of the tab again.
Thank you
ur the best
I reckon your the best
Thank you. =)
Thank you Sir.. 👍
Thank you!!
How does the countifs function work if the columns aren’t next to each other? I can only select the range of one column.
Thanks a lot!
can you do a video on how to freeze a pane in excel and if you can freeze multiple at the same time?
Thank you for the information, I have just watched all four of your first videos plus this one. I need constant refreshing on how to use Excel because I keep forgetting the simplest things. I work with pretty complex spreadsheets that upload thousands of lines of information that have been already set up by others. I am hoping to just get some insight as to how they set them up and if I can do the functions myself. Listening to what you have reviewed, I realize I know most of the basics, but appreciate your overview. I am not sure whether to use VLookups, Pivot Tables or other formulas to achieve my end result. Currently I have a spreadsheet, where there is a listing of numbers and words that I need to relate to a separate worksheet but these are constantly changing. Which worksheet should I use to make the changes, the main one where the info is updated or the smaller ones that are broken down pieces of information from the main one. Just getting a bit lost, it is probably an easy solution, I am not thinking clearly.
What trip I am watching this video on November 17th! if it is actually the day of your bday happy bday!
Never thought Excel could be kinda easy & fun!!
Can you use IF statements on dates to determine if for example If a bill is past due? Using the current date?
nice video, so helpful thankful sir
Most welcome
Hi , I am beginner on excel, I have a one question , how i minus the 9:00 AM from 2:00 AM second day time?
Thanks. How do I get rid of that hidden behind that function at record 22.34? It happens all the time.
Hey Jamie, anything on Pivot table?
Nice one
Thanks!
You da man
Hi, I've just discovered your you tube page. I find it very interesting and helpful. Can I ask, do you have any video's to create a spreadsheet for a Forex Trading Journal.
You're awesome!!!
Please do more videos!
You bet!
Have a video on how to get the last 4 week average?
Please I want you to teach me how to do data entry.