Your videos is best . Because I'm learn English still and you speak every word so clearly so i can understand everything you explain... you explain everything step by step and that's the reason you are the best excel teacher
Thank you for teaching us with such dedication and sincerity. Your guidance and kindness inspire us to keep learning and growing. We are truly grateful. Thanks, Sir
Only a beginner here but if you use concat function using the function area you can include the space by placing a space, not spelling space, "space" between the two ranges or the two words, and it will concatanate
Thank you so much for teaching this intermediate skills tutorial. I learned so much and took many notes. You teach it in such an easy follow way. Outstanding!
Greetings from Australia! Fabulous revision of Intermediate level!! I will complete my revision with your "Level Up" Tutorial. Thanks for being so thorough. It's reassuring to know I haven't forgotten anything!
I really love watching your tutorials, it's like you explain it in detail and step by step so I can follow it on my own sheets and make more practice. But I'm a little bit confused because I tried the IF FUNCTION that works on spreadsheets but not on MS Excel. So I don't know how to use it on MS EXCEL hahaha
Great Session I Really Wanna Appricate Your Efforts You Have Putted There To Explain It With So Much Of Ease Please Make A Complete Video On Crafting A Complete Excel Dashboard . It Would Be Really Helpfull. Thank You 🤟
Appreciate what you have taught me, However I found it hard to follow along and learn due to the worksheets were already modified and showed later into the video, for instance, on Data Validation there was no table set onto the fruits and every fruit was already listed. Either than these issues, everything was good. thank you.
Great video. The table section scares me. The fact that excel is calling the final row a total when it can be a sum, average, etc on multiple cloumns can really screw you over
I have a question, in data validation, is there a way to type a name that is not on the list? or does it always have to be restricted to the list? I have a table of office assistants and we have substitutes that work on random days and it is impossible to know their names and I don't know how to have an option for them to type in their name without being in the table.
An issue I have with this is that I don't have the text at the bottom of my window that is in blue and orange on the video so I can't do all of the exercises. Am I using a different version of excel or do I need to open that somehow?
Hello Thank you for this treasure. Some one could help me telling me how to work on this workbook? I'm not able to work on this online workbook. Thanks
0:45 I have an attendance register that has to report on the number of times a person is absent or sick within a 10 week cycle. Counting starts the second time the person is absent within the 10 week cycle. I hope you can help me. Thank you
I noticed at 9:50, when you flash filled the phone numbers... the ending was all the same (as in 2475), I am wondering why this happened and why it didn't formulate the numbers from the left cells???
Keep learning more Excel skills with this intermediate class: th-cam.com/video/PqczHnsNFdM/w-d-xo.html
Your videos is best . Because I'm learn English still and you speak every word so clearly so i can understand everything you explain... you explain everything step by step and that's the reason you are the best excel teacher
Thank you for teaching us with such dedication and sincerity. Your guidance and kindness inspire us to keep learning and growing. We are truly grateful. Thanks, Sir
Just amazing resource for individuals looking to get into excel. So many high level professionals have a skills gap in this. Thank you so much!
You're very welcome!
Only a beginner here but if you use concat function using the function area you can include the space by placing a space, not spelling space, "space" between the two ranges or the two words, and it will concatanate
I am satisfied by your online courses. I want to learn more about excel courses on which I am interested. Please keep it ongoing.
Thank you so much for teaching this intermediate skills tutorial. I learned so much and took many notes. You teach it in such an easy follow way. Outstanding!
super great videos you are sharing, thanks a lot to Teacher´s Tech and personal thanks to You Jaime Keet. Regards from Trujillo - Peru.
Thank you!
Greetings from Australia! Fabulous revision of Intermediate level!! I will complete my revision with your "Level Up" Tutorial. Thanks for being so thorough. It's reassuring to know I haven't forgotten anything!
Thank you so much!!!
I really enjoy learning about excel and definitely you explain very well and make it very easy.
Fantastic! Learnt so much in one hour! Very concise and to the point :) Thank you so much
You're very welcome!
I really love watching your tutorials, it's like you explain it in detail and step by step so I can follow it on my own sheets and make more practice. But I'm a little bit confused because I tried the IF FUNCTION that works on spreadsheets but not on MS Excel. So I don't know how to use it on MS EXCEL hahaha
Indeed your tutors are insightful it's really helpful 👍
Thank you!
This was really helpful and much appreciated. Thank you.
You're very welcome!
I have to watch the video again after this lesson.
Great Session I Really Wanna Appricate Your Efforts You Have Putted There To Explain
It With So Much Of Ease Please Make A Complete Video On Crafting A Complete Excel Dashboard . It Would Be Really Helpfull. Thank You
🤟
Great video ,thank you.
Appreciate what you have taught me, However I found it hard to follow along and learn due to the worksheets were already modified and showed later into the video, for instance, on Data Validation there was no table set onto the fruits and every fruit was already listed. Either than these issues, everything was good. thank you.
Great video! Very informative. Could you make a similar video about R2 Copilot?
Very Good, thank you.
Great video. The table section scares me. The fact that excel is calling the final row a total when it can be a sum, average, etc on multiple cloumns can really screw you over
A very well-organized, thorough, and logical presentation! Thank you!
You’re welcome!
sir, lm appreciated much your lecture.i learned a lot.
Thank YOU!
You're welcome!
Thank you, great tech teacher
You’re welcome and thank you!
THANK U MAN✌🏻🙏🏻 u really helping
So glad to be able to help. You’re welcome!
Thanks for the video. Really insightful. Please i cant seem to find 'flashfill' on my excel
You’re welcome! I’m glad you found it helpful. What version of excel are you using.
I have a question, in data validation, is there a way to type a name that is not on the list? or does it always have to be restricted to the list? I have a table of office assistants and we have substitutes that work on random days and it is impossible to know their names and I don't know how to have an option for them to type in their name without being in the table.
Thanks!
so powerful
An issue I have with this is that I don't have the text at the bottom of my window that is in blue and orange on the video so I can't do all of the exercises. Am I using a different version of excel or do I need to open that somehow?
At 9:42, when you do the FlashFill for the Pone Number Formatting, it did not work. Probably it is an oversight?
Hello Thank you for this treasure.
Some one could help me telling me how to work on this workbook? I'm not able to work on this online workbook.
Thanks
You’re welcome, choose the download option to work on your computer.
0:45 I have an attendance register that has to report on the number of times a person is absent or sick within a 10 week cycle. Counting starts the second time the person is absent within the 10 week cycle. I hope you can help me. Thank you
I noticed at 9:50, when you flash filled the phone numbers... the ending was all the same (as in 2475), I am wondering why this happened and why it didn't formulate the numbers from the left cells???
I wrote the number down incorrectly. The last 4 numbers were wrong so it didn’t recognize the pattern.
Would you mind sharing your excel version,we download. I'll really appreciate.
Here you go: go.teachers.tech/IntermediateExcelClass
On Wednesdays we eat carrots
Thanks!