I just want to thank you for providing practical steps for learning Excel. I paid for courses and couldn’t understand. I learned and understood four of videos in less than 2 hrs. Much gratitude. Great intuitive teacher!
I’m developing dashboards in 2 hrs. I barely knew how to use Sum function- Such a useful tool. The formatting and other fxs were well instructed . I have subscribed and will land on your page for all my computer needs. Do you have formatting videos for Word and other 365 products?
I learned by the way you explained, words that comes from your mouth is very clear, unlike others youtuber that teaches Excel. Their words are not Clear. Yours are easy to understand. Feature more about excel. God bless you
For years I had major anxiety over using Excel. Thanks to your method of teaching, I have lost my fear and have learned so much from your videos. Thank you!
I've gone through the W, O and PP playlists. Now working my way through E. I am SO grateful I found these. Your tutorials are by far the most clear and easy to follow on TH-cam. I would suggest changing your account name from Tech for Teachers and Students to something more broad, because these are helpful for anybody. I'm not a student or teacher, and I'm learning for office work. I think maybe people who would benefit from your videos might not find them, because seeing the name of your channel they'd think it wouldn't apply to them. I'm seeking employment now, but once I have an income I'll surely donate to your Patreon. I paid a lot of money for an online course that was not nearly as helpful. Your channel is of great value and I hope many more people find it.
Thank you so much. I find that I'm depending on a lot of primary lessons that I studied at school to run my household expenses lately. (This was a great reminder).
I found it tremendously helpful in trying to learn basic excel to keep track of invoices for a garden club annual meeting. Your teaching style is the best! Good pace and clear instructions.....thank you so much.
It would be highly useful to see a tutorial on calculating discounts by percentage in Excel. You are the best instructor I've encountered for Excel. However, I scored only a barely passing grade at 70% on an Excel eval today for a prospective employer. They claimed that it was going to cover only basic features. I studied your vids up through Advanced; however, I encountered questions not represented in your vids and we're CLEARLY advanced. Just thought I'd put in my two cents.
Hello, may you please do an automated duty roster video. I like how you explain and zoom in. I haven't found any video on how to make an "automated duty roaster" that explains it like you. Hopefully you find this comment. Thank you in advance. Stay blessed.
I’m hooked , excel is about to go from my Achilles heel to my strength .. question i was making a sum and all the numbers went to 2 decimal places ( no decimals before ) how do I change this to who,e numbers please ,, keep up the good work ✅
Great content! I am also creating MS Excel tutorials. MS Excel is such a powerful tool that almost 90% of businesses nowadays use. Happy Excel - ing😉😉😉
If you would have made this an Excel table, you wouldn’t have to freeze the pane to keep first line in sight. Then, the header line would occupy the column headers (A, B, C, D,...) when scrolling down. One of the many wonders of using Excel tables. Also MIN, MAX, AVERAGE are also directly available as sub item of the Sigma button you clicked for SUM.
Hello, if you could help me out with this. I am trying to make a formula, i am a begginer. So what i need is for exampl: I have 2 coloms 1: Apple,Orange,Carrot 2: XX,XXXX,XXXXX. I would like it to be : If you choose apple then it must be 2-XX, if choose carrot it must be XXXX-4xs.
=IF(R1C1="Apple", "XX", IF(R1C1="Carrot", "XXXX", "XXX")) R1C1 is the cell reference you want to evaluate, If it is True, meaning if R1C1 value is "Apple" then Apple = Apple, is TRUE, it will return the value XX, if not then it will move on to the next IF condition, is R1C1 equal to Carrot? If Yes, then it will return XXXX, but if it is false, it will return XXX. Enter the formula above in Column 2, the result should be like the one below COLUMN 1 COLUMN 2 Apple XX Orange XXX Carrot XXXX
I've been using Excel for well over 20 years. I item I've never been able to solve. My default font color is Red. I change it to black, and the next time I open Excel, it is Red again. Advice please.
I just want to thank you for providing practical steps for learning Excel. I paid for courses and couldn’t understand. I learned and understood four of videos in less than 2 hrs. Much gratitude. Great intuitive teacher!
I’m developing dashboards in 2 hrs. I barely knew how to use Sum function- Such a useful tool. The formatting and other fxs were well instructed . I have subscribed and will land on your page for all my computer needs. Do you have formatting videos for Word and other 365 products?
I learned by the way you explained, words that comes from your mouth is very clear, unlike others youtuber that teaches Excel. Their words are not Clear. Yours are easy to understand. Feature more about excel. God bless you
For years I had major anxiety over using Excel. Thanks to your method of teaching, I have lost my fear and have learned so much from your videos. Thank you!
I've gone through the W, O and PP playlists. Now working my way through E. I am SO grateful I found these. Your tutorials are by far the most clear and easy to follow on TH-cam. I would suggest changing your account name from Tech for Teachers and Students to something more broad, because these are helpful for anybody. I'm not a student or teacher, and I'm learning for office work. I think maybe people who would benefit from your videos might not find them, because seeing the name of your channel they'd think it wouldn't apply to them. I'm seeking employment now, but once I have an income I'll surely donate to your Patreon. I paid a lot of money for an online course that was not nearly as helpful. Your channel is of great value and I hope many more people find it.
What an amazing tutorial!!! I have adhd and usually have to rewind these a million times then give up… I wish school was taught like this …thank you
If possible to like ur videos a zillion times, I will definitely do so. Thanks for making ms office easy to understand. 👌👌👌👍👍
Oh wow! I love this. I just started a youtube channel for teachers and will most defs refer my peeps here. Respect to all teachers at this time!❤💯
As usual the best one who makes anything simple , cheer
Your videos are clear and easy to follow. Thank you!
Thank you so much. I find that I'm depending on a lot of primary lessons that I studied at school to run my household expenses lately.
(This was a great reminder).
Marvellously presented,thank you
You make data inputting fun & even existing. Thank you
Thanks!
Sherri, thank you for your kind gift! I'm glad you found my video to be helpful.
I found it tremendously helpful in trying to learn basic excel to keep track of invoices for a garden club annual meeting. Your teaching style is the best!
Good pace and clear instructions.....thank you so much.
You are an amazing teacher. I am actually enjoying learning this! Thank you!
It would be highly useful to see a tutorial on calculating discounts by percentage in Excel. You are the best instructor I've encountered for Excel. However, I scored only a barely passing grade at 70% on an Excel eval today for a prospective employer. They claimed that it was going to cover only basic features. I studied your vids up through Advanced; however, I encountered questions not represented in your vids and we're CLEARLY advanced. Just thought I'd put in my two cents.
please do another excel functions video on sum average, max , min etc this was great but I would like to know more about this
Where have I been? Am your new student, thanks for all your teachings.
Very useful, as always. Thanks.
Love all ur videos. Very detailed
Thanks very much for the presentation, please I would like to ask a question.the 1701 is the total number for the profit or from and other columns?
great videos simple to the point - many thanks
Very useful, thank you!
Hello, may you please do an automated duty roster video. I like how you explain and zoom in.
I haven't found any video on how to make an "automated duty roaster" that explains it like you.
Hopefully you find this comment.
Thank you in advance.
Stay blessed.
Thank you for making this tutorial
I’m hooked , excel is about to go from my Achilles heel to my strength .. question i was making a sum and all the numbers went to 2 decimal places ( no decimals before ) how do I change this to who,e numbers please ,, keep up the good work ✅
Great content! I am also creating MS Excel tutorials. MS Excel is such a powerful tool that almost 90% of businesses nowadays use. Happy Excel - ing😉😉😉
Ctrl+down arrow to go all the down of the row or columns. =sum(range)
Very useful thanks
Thank you so much sir
I love ❤️ you so much!!!!!
Thank you so much!!!!
Looking forward to the intermediate guide n advanced guide
very good thank you
👍 helpful for sure 😁
If you would have made this an Excel table, you wouldn’t have to freeze the pane to keep first line in sight. Then, the header line would occupy the column headers (A, B, C, D,...) when scrolling down. One of the many wonders of using Excel tables. Also MIN, MAX, AVERAGE are also directly available as sub item of the Sigma button you clicked for SUM.
....any chance of a tut. on vlookup please
Pleas do an intermediate tutorial because you do tutorials for these functions and formulas but thanks for your effort
Soooo helpful!
Thank you
Hello, if you could help me out with this. I am trying to make a formula, i am a begginer. So what i need is for exampl: I have 2 coloms 1: Apple,Orange,Carrot 2: XX,XXXX,XXXXX. I would like it to be : If you choose apple then it must be 2-XX, if choose carrot it must be XXXX-4xs.
=IF(R1C1="Apple", "XX", IF(R1C1="Carrot", "XXXX", "XXX"))
R1C1 is the cell reference you want to evaluate,
If it is True, meaning if R1C1 value is "Apple" then Apple = Apple, is TRUE, it will return the value XX, if not then it will move on to the next IF condition, is R1C1 equal to Carrot? If Yes, then it will return XXXX, but if it is false, it will return XXX.
Enter the formula above in Column 2, the result should be like the one below
COLUMN 1 COLUMN 2
Apple XX
Orange XXX
Carrot XXXX
Thank
How do you email a spreadsheet?
I like it
I've been using Excel for well over 20 years. I item I've never been able to solve. My default font color is Red. I change it to black, and the next time I open Excel, it is Red again. Advice please.
Wow that is... pretty big
Yh, very good i liked
I need a little more time at the end of your videos to click like, it often goes to the commercial before I can do that.
Yes o
This is Ishaan guys like my comment lol hahahahahaha Ishaan in ur classy bro like it lol hahahahahah
Never gonna give u up
Never gonna let u down
Never gonna turn around and leave u
Nevr gonna make u cry never gonna say goodbye woooooaaaaaaaa
I usually hate Execl too much, but I am sure no more.