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 🤟
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
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
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.
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
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???
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
Keep learning more Excel skills with this intermediate class: ruclips.net/video/PqczHnsNFdM/видео.html
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!
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!
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!
Thanks!
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!
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
Thank you so much!!!
I really enjoy learning about excel and definitely you explain very well and make it very easy.
Indeed your tutors are insightful it's really helpful 👍
Thank you!
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
🤟
I have to watch the video again after this lesson.
This was really helpful and much appreciated. Thank you.
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
so powerful
Great video ,thank you.
A very well-organized, thorough, and logical presentation! Thank you!
You’re welcome!
sir, lm appreciated much your lecture.i learned a lot.
Very Good, thank you.
THANK U MAN✌🏻🙏🏻 u really helping
So glad to be able to help. You’re welcome!
Thank YOU!
You're welcome!
Thank you, great tech teacher
You’re welcome and 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
Great video! Very informative. Could you make a similar video about R2 Copilot?
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.
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.
At 9:42, when you do the FlashFill for the Pone Number Formatting, it did not work. Probably it is an oversight?
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
You’re welcome, choose the download option to work on your computer.
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
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
On Wednesdays we eat carrots
Thanks!