12:53 IMPORTANT TIP! While setting data validation he wrote "Indoor,Outdoor,Both". If it doesn't work for you, try "Indoor;Outdoor;Both". Use semicolons. Hope it helped!
@anthonycampazestupinan4922
2 жыл бұрын
this happened to me and it was getting me crazy hahaha I figured it out
@redkoba2671
Жыл бұрын
thanks so much dude i was going crazy because it wasnt working
@markkorchnoy4437
Жыл бұрын
LMAO, spend 15 minutes figuring this stuff out.
@khanyisilebotolo5636
Жыл бұрын
Definitely helped. Thank you👍🏼
@madkinggo9858
Жыл бұрын
Jesus, spent 20minutts trying to figure out how to do this! Much appriciated!
@TCflorida
Жыл бұрын
I started watching all your excel videos and practicing because I applied for a job promotion and needed to take a excel test, haven’t really had to use excel since high school (25yrs ago). Took my test and was very confident and comfortable, I’ll let everyone later if I passed or not.
@TCflorida
Жыл бұрын
Passed
@kyliaconaway5622
Жыл бұрын
@@TCflorida Thats great to hear! I have been watching his videos for days! So I am glad to see you really got something out of it! I am happy for you!😀
@myimran
2 жыл бұрын
Hello! Mr. Jamie, your videos are excellent without any question. I have a suggestion for you, please introduce "projects" on the basis of your videos, so we can apply your teachings as practical knowledge. regards.
@ashleygozo253
3 жыл бұрын
Spent the past couple of hours watching the series of beginners. Now I feel like I can conquer the world. Haha! Thank you for your existence :)
@TeachersTech
3 жыл бұрын
Happy to help!
@Karenhenders76
2 жыл бұрын
I just missed out on a job because my excel wasn't strong. Let me say that after I'm finished all your videos I think I'll have advanced knowledge. Thank you, Thank you, Thank you
@jacquespaquette9391
2 жыл бұрын
Hello Jamie, I will be watching Module 5 of this series on Excel for Beginners. After watching the first one, I must admit that I no longer needed to go anywhere else. You are really great in your way of explaining the functions and interactions of Excel. it is very clear and easy to assimilate, moreover by practicing with your example files, it is even better! I take a few moments to say hello and thank you for this great learning tool. Jacques from Canada :)
@KauDamasceno
2 жыл бұрын
So true! Excellent didactic
@warcraft7186
2 жыл бұрын
Where can find the sample files bro @jacques
@Carlton_Banda
Жыл бұрын
@@warcraft7186 would love to know as well.
@hjaji712
Жыл бұрын
@@KauDamasceno see switch exam and w so q a airporta aaaa a we
Here at level 4 can’t believe how easy it is to follow your videos, I’ve tried a few out there and so far yours is the best! Thank you!
@AmjadNasir1979
9 ай бұрын
Hello Jamie, your vids must have at least 1 Million views. I wonder why so many people are still deprived of the great stuff you put out over here. Hats off sir.
@arifiqbal4922
2 жыл бұрын
I have been trying to learn excel for quite some time now. But, all the channels I have found so far either works on the very basics or directly forwards to the advanced level. I think, yours is the best series I have foundon youtube to learn excel step by step. Thank you for your hardwork.
@allisonwendell9942
3 жыл бұрын
Thank you. Excel doesn't seem so intimidating after practicing these tips with you. Your instructional style is awesome. Clear, to the point! Ready to move onto formulas!
@TeachersTech
3 жыл бұрын
I’m happy I could help you out! You’re welcome!
@mukta81
2 жыл бұрын
Oh, you soeak of my mind. I was so scared to even look at excel but now it looks not that difficult. I kinda enjoy it now.
@el-visuals1
Жыл бұрын
Thanks, I'm new on computing but now getting better on self study having your videos and you as my lecturer.i started with Microsoft word for beginners and now I'm excellent....I want improve on typing and keyboarding
@bellendcheeses1208
3 жыл бұрын
Thanks so much, you are a fantastic teacher.Everything is explained simply and crystal clear. 👏👏👏💪
@TeachersTech
3 жыл бұрын
You are very welcome!
@ummuamira7376
3 жыл бұрын
You are helping sooo many people. Thank you!!!
@jonburnette2470
2 жыл бұрын
Jamie, you are amazing! I have been self-taught with excel have managed to get by but man! These instructional videos are having me do repeated face palms! I have been wasting way too much time and effort!! Many, many, many AHA moments. Can't wait to finish the series!
@milagrosdelvallefernandezy4957
2 жыл бұрын
Hh
@special1_28
Жыл бұрын
You're doing great job.
@TeachersTech
Жыл бұрын
Thank you!
@NusratHKhanNishi
3 жыл бұрын
I usually don't comment on videos. But your videos are amazing that I had to! I learned so much. Thank you.
@TeachersTech
3 жыл бұрын
You’re very welcome!
@robertnegron6804
3 ай бұрын
can you slow down when explaining what you're doing? I'm a bit slow, and I feel like you're explaining things way too fast.
@hwm7251
Жыл бұрын
wow, have been using excel for so many years and the lessons in this tutorial opened my eyes. Thanks for the effort.
@tiffanybailey2777
Жыл бұрын
I am so appreciative for the simplicity of your videos. Thank you!
@ashleyb5642
3 жыл бұрын
These tutorials are very helpful, thank you! Could you do a more in depth one on charts and graphs?
@soledadalejandraaprile7460
2 жыл бұрын
R mand eresbu Fhcifif
@nyusemotech849
2 жыл бұрын
YOU ARE A BLESSING. THESE ARE SKILLS WE PAY THOUSANDS OF DULLARS FOR EXPERTS TO DESIGN SHEETS FOR US. TODAY WE CAN DESIGN AND EVEN TRAIN OTHERS. WHEN YOU TEACH, WHAT IS DIFFICULT LOOKS SIMPLE
@marinajancev8807
3 жыл бұрын
Thank you very much for a great tutorial! Please keep uploading and if possible make some videos for formulas, as much as possible, especially with IF and some nested IF formulas. Hope you won't stop uploading!
@TeachersTech
3 жыл бұрын
Thanks! I’ll start plan some more videos.
@CandyQuackenbush911
Жыл бұрын
I’ve been teaching myself excel from KZitem for several weeks. Your videos are by far the best.
@jessicamunchkin1937
3 жыл бұрын
You a a life saver. A lot of Excel tutorials made me feel dumb. Thanks to you. I feel smart now. LOL.
@tariqrasheed3792
Жыл бұрын
Dear Jamie, u have done a great job by providing these tutorials on MS Excel. Bravo
@larab.9736
3 жыл бұрын
this beginners tutorial is very helpful. I use excel in work but i've forgotten how to do things a certain way, this video reminds me of all those techniques.
@TeachersTech
3 жыл бұрын
Glad it was helpful!
@mohansahareti4678
Жыл бұрын
On to level 5!! ALL ON THE SAME DAY! THANK YOU FOR MAKING IT SO EASY TO LEARN!
@belloabiola9190
3 жыл бұрын
Thank you for making me understand conditional formatting better.
@brennanang8979
3 жыл бұрын
These tutorials are priceless. Thank you so much!
@TeachersTech
3 жыл бұрын
You are so welcome!
@justusoyieko9867
2 жыл бұрын
Maaan this guy is pure gold. Making everything simple and clear.
@evinharrelson
2 жыл бұрын
So I have been watching your tutorials for job interviews to freshen up on, and came to realize that a tutorial going through each ribbons options and what they can, a quick summary of each, would be GREAT!!! that way we can know what everything does with quick examples. Doesnt have to be drawn out or long on each part.
@rachelnosce5884
2 жыл бұрын
Great video, enjoyed learning more about data validation and conditional formatting! Knew a little bit about data validation but nothing about conditional formatting and what its use could be.
@elizabethisaiah6754
3 ай бұрын
You are a great teacher. Thank you so much for your help on Excel
@AjayMishra-kl1wc
2 жыл бұрын
one of the best free course on KZitem . Thank you so much Sir. your teaching style is awesome.
@cherietheron9047
3 жыл бұрын
I never knew all the things i could do on Excell even after using it at work all the time, now im learning so much and im excited to check out the Videos
@valeriasanchez3069
Жыл бұрын
Thank you so much. I just started a new job and your videos have saved my life
@andyallenpcsmr4169
2 жыл бұрын
The Slicer part at the end really clicked with me! THank you so much and keep it up!!
@TeachersTech
2 жыл бұрын
You're very welcome!
@okparachukwuemeka2890
Жыл бұрын
Thank you so far for these series. Regarding the conditional formatting, I wanted to ask, using the icon sets for example, how are the arrows applied? I understand that Green is for the highest & Red the lowest, but is there a range or a mark especially to determine like a base or average? I don't know if you understand 😕 🤔 Really don't know how best to say it
@Giul_Ranz
2 жыл бұрын
Hi Jamie, I am currently looking for a job and your tutorials are so helpful. I've never been very confident using Excel, however that is slowly changing because of your fantastic tutorials. Looking forward to Tutorial B Level 5 :) Thank you so much!!!
@TeachersTech
2 жыл бұрын
Glad it was helpful! You're welcome.
@o74769
3 жыл бұрын
Hey your tutorials are great, i watched them in preparation for a job... i didn't get the job, but i know how to use excel now.
@t.miller5632
2 жыл бұрын
Very informative. I am learning a lot. Bringing back to memory things I had forgotten. thank you.
@corneliaroberts3381
2 жыл бұрын
thank you so so much. i got a new job and didnt know alot pertaining excel. great job
@John-yz4gz
4 ай бұрын
thank you so much for this tutorial, i have just know more about excel. And it's been a pleasure learning from your videos.
@albertoalamamoran6082
2 жыл бұрын
Suuuupeeeeerrr! I really appreciate your great videos Dear,Jamie and all the team at Teacher´s Tech..God BLESS YOU ALL. Regards from Trujillo - Peru.
@hamzehgralleh3601
Жыл бұрын
allow me to say that your tutorials are amazing and you are a wonderful person as well, thanks a lot from the bottom of my heart sir . KEEP GOING
@AshleyWelch-ld6cs
3 ай бұрын
Excellent tutorials, thank you. (note: I have never seen Indoor Surfing, must look that up)
@resshmi78
Жыл бұрын
Your excel videos are super useful, helpful and very easy to follow on during the tutorial, thank you for explaining everything so well :)
@myniebotha99
Жыл бұрын
Thank you very very much for this free teaching. I really appreciate it! I have learned a lot. I create my own sheets, stop the video and do physically what you are teaching to see if I can get it right. 😀😀😀😀😀
@Heathensauce
Жыл бұрын
I found the conditional formatting to be very useful thank you. I think I am going to watch your entire series here. So far ive got it all down.
@tarteelnoor6526
2 жыл бұрын
You the best teacher ever, thank you so much for the precious lessons for all of this tips and complete informations with practice sheets and everything is perfect. I hope you the nothing but the best in your life and everything you want, thanks again 💗😇
@annettebealemissman5996
Жыл бұрын
Jamie, thanks so much for your tutorials. I've been using Excel for years, but there's so many tricks/tips you introduced me to.
@saritasharma8470
3 жыл бұрын
This tutorial was really helpful. I'm looking for a MySQL tutorial if possible. Thanku :)
@muhammadasraf4038
3 жыл бұрын
this has been wonderfull full and its free, lets not skip the ads for the creator to gain some money thus helping him produce more informative content in the future
@alaukikamathu7182
3 жыл бұрын
All the first 3 beginners level videos were great! Thanks so much
@TeachersTech
3 жыл бұрын
Glad you like them!
@abrahammeshesha9074
Жыл бұрын
I'm very thankful that you are doing this great lesson. Unfortunately, I was unable to practice the slicer. I followed what you did on youtube, but Microsoft didn't give the option you did, and I appreciate any suggestion on how to do it.
@alexkamau1602
2 жыл бұрын
very helpful tutorials. helping me in my job application. much love from Kenya
@temmytopebayode9434
Жыл бұрын
Good morning Jamie. Thank you so much for the knowledge shared. I am grateful 🙏
@jinnylinn9542
3 жыл бұрын
Thank you very much. I'm learning a lot but I would like and I'm not sure that you've already taught cascading sheets? Multiple things you can do with the (Sheets) looking and comparing information?
@hema9822
2 жыл бұрын
You are a grt trainer... Thanks for these elaborate and very precise description on every single topic..
@letsplay8009
2 жыл бұрын
thank you. your way of explanation is perfect. you look like younger creed from the OFFICE
@benjaminduncan5515
2 жыл бұрын
Thank you so much for your help. It's been very useful so far. Can you do a video on how to make a parts and price list for a plumbing business. I'm new at Excel and need to make a price list on all our parts where I can constantly change the price when needed. Thank you for your consideration.
@kritijain1340
2 ай бұрын
you make really helpful videos. These tutorials are very easy to understand. THANK YOU!!
@TAKETHIA1
2 жыл бұрын
Mr. Jaime I just want to thank you so much for these tutorials! They are easy to understand I’ve learned do much in watching this first video, I truly appreciate you taking out time to do these videos.
@lilianchidinma665
3 жыл бұрын
your videos from the beginning has been so helpful, that I think my physical class is a joke. thank you so much
@adeyemimoshood3023
11 ай бұрын
Hi Jamie, with ur footprint I'm glad God has bless me with a beautiful job,may God bless u more..Pls in the dataset for AFTER SEASONS SALES", those arrows what does each of the arrows represent I can't figure out how they operate or represent each of the values,can you please explain them?...
@viveksaha1107
2 жыл бұрын
Love your personality. Keep making these videos.
@TeachersTech
2 жыл бұрын
Thank you! Will do!
@fatimabusari4276
3 жыл бұрын
Hi, thank you for this excellent series. My question is when applying the icon set during conditional formatting, what do the arrows depict?
@ijaniyifaith1894
Жыл бұрын
thanks for this god bless you .really love your teaching
@sotiris13
2 жыл бұрын
Thank you very much! Greetings from Greece.
@Devilinthehouse135
5 ай бұрын
It’s really helpful videos for us thank you for making the video and sharing the information with us ❤
@magdaleneochola6034
2 жыл бұрын
Thank you so much. Am interested in how to create different pricelists for different customers and use this information in a sales matrix.
@ginagonzalez9589
7 ай бұрын
Your videos are awesome I have learned a lot ...need to find a w.f.h job soon since i have physically become unable to work outside of house.But I want to know where an how do you know when to use each function or Formula ?? Ik ik its probably just my old 56 year old mind. Thanks Jamie for all your hard work an time to make this videos for us .
@hoshangoo
2 жыл бұрын
I like your explanation. Thanks!
@anuoluwababatunde3983
Жыл бұрын
thank you. You have made me a pro in only few lessons
@TheWes001
2 жыл бұрын
I want to ask about the arrows in conditional formatting. How does the excel decides which way the arrow should point? Does it calculate the average within the formula?
@lungdumtu_vawksa
2 жыл бұрын
Best teacher ever.
@MAMAKIJAANGUGU
Жыл бұрын
Thanks for the amazing information. Would love to know more about the Icon sets in Conditional Formating. How the direction of these arrows work? I don’t understand it
@ibejoseph19
2 жыл бұрын
You are an amazing tutor, Sir. God bless you.
@Preya31
Жыл бұрын
Hi, I cannot say thank you enough for all the cool and awesome things I am learning. Thank you so much🤓💚
@malaeolemateo8846
2 жыл бұрын
You are angel 😇 I really like how you explain everything in details with passion 💯
@bitayaghoubi9354
5 ай бұрын
Hi Jamie, Thank you very much for the courses that you present. These are the great presentations. I have a question regarding creating a table via Insert/Format Table. When we have a long list of more than 2 pages, how we can add the title in the top of the pages? thank you.
@lee-lee2418
Жыл бұрын
Thanks Jamie! these are REALLY great 🙂
@TeachersTech
Жыл бұрын
You're so welcome!
@fernandezibarriejohn3031
2 жыл бұрын
Thank you very much for this lessons, every part are very helpful.
@wandagreer9144
2 жыл бұрын
Again, thank you for this complete effort. I have enjoyed all your videos on Excel. I realize this series was created a few months ago, but it is still relevant and important, so thank you too for not removing it as it is extremely helpful. (I hope it will be available for a very long time!) I hope you still review these comments. (Actually, I'd welcome help from anyone.) I'd like to know if features of WORD can be used in EXCEL as I have not discovered such an available function? For instance, working on a database of addresses; somehow, the one doing the data entry did not use proper punctuation or capitalization. How to easily select the data and transform it from "tom jones on parkway st" to show a more standard format of "Tom Jones on Parkway St." without having to click each individual error to fix the issue? As it is now, I have to cut the data - take it to WORD, create a document and fix the issue and take the corrected data back to the Excel project. There seems that a better way would be available. Would also perhaps use the option to make all names (i.e.) "Tom Jones" to show as "TOM JONES"? I have hundreds of corrections to make. Or perhaps to make a global change (or per column/row) of updating or just changing the word "at" to the "@" symbol? Or, for example changing all entries of the abbreviation "Bros." to "Brothers"? And finally, I am noticing that some downloads I have the task of unraveling utilize something called a "Z.test" whereas a data field is purposely left blank, but has a double negative "--" in the data field. (Perhaps from an outdated version of this program?) When I want to recalculate the entries, I get a circular reference error and I cannot find this field to reference any other field to cause such an error message. Or, is it referring to itself? (And if so, why and how?) Without having to clear hundreds of data page entries individually of these blank flags (as I call them - to indicate the space is blank intentionally) what can be done to either remove these Z.test entries (what is a Z.test anyway?) or otherwise fix this issue? What can I use to indicate a blank field without leaving it totally empty or can I use some character that the system is going to mistakenly look at as a mathematical entry? Of course, this symbol would be exempt from search/sort criteria. I hope I am making sense. Thanks for any reply from anyone! (created Jan 2022)
@bdwdreamweaver
3 жыл бұрын
I was always wondering how this worked - now I know
@arjabosh888
Жыл бұрын
شكرا, انت شخص رائع واصل فيما تقدمه
@kartikjaju2118
2 жыл бұрын
Thanks for uploading such videos, really helpful also can you suggest some site where we can find data for practice please
@MoniMeka
Жыл бұрын
Hi, Jamie! First of all, thank you so much for doing these tutorials! I'm learning so much! I have a question, though! I see that you put the data we could use to input into excel, but it's not the same as the data you used. Do you have the data that you used? LOL, just don't wanna type all that. I couldn't, but my eyes are weak right now. I did level 3 before this. If you can't, that's ok! I maybe just have to break my sections up. My eyes hurt when I am looking at the screen too long. 😶 Again, thank you so much! Take care! 😃
@lisalupo2784
2 жыл бұрын
You are a lifesaver! Thank you so much for sharing your knowledge with all of us!
@tonetteaquino3230
2 жыл бұрын
Thank u so much for the learnings. You are an amazing teacher👏👏👏
@pariskhouri4678
3 жыл бұрын
Thank you so much for these videos. I need to know excel for a my new job and your videos are fantastic.
@evansaddo7431
2 жыл бұрын
Excellent presentation
@jorgecolin5698
3 жыл бұрын
I really love your videos. Please don’t stop sharing your knowledge. Thanks a lot.
@TeachersTech
3 жыл бұрын
You're welcome!
@annelinnane7949
2 жыл бұрын
Your tutorials are excellent. I would like to know whether you can create charts from filters using drop down arrows. I would appreciate any help thank you.
@cathrynryan3894
3 жыл бұрын
Hi. I am loving your tutorials. How do you name the slicers - when following your instructions, all I see is Column One, Column Two - they do not show the words "Conference, Division, Team. Can you rename them??
@ruthkreyoh5580
2 жыл бұрын
You’re such big help and great teacher.
@gerardocereceres2506
2 жыл бұрын
Hey thanks so much for your help!!! Can you show a video of how to pass the Google sheets data to excel?
@yicko1169
2 жыл бұрын
Thank you so much for these videos. Perfectly explained at a perfect pace. You are awesome.
@kareljina4105
3 жыл бұрын
13:00 FINALLY FOUND IT, ITS NAMED A DROP DOWN MENU OF ALL THINGS Seriously teacher wanted it for homework and I thought I would never find it.
@zainabmoibi520
Жыл бұрын
Sir , you are a great teacher
@Gangstadeath619
9 ай бұрын
Those slicers are cool, wish I knew about them at my old job lol
Пікірлер: 344