No video

Excel 2016 Intermediate Tutorial

  Рет қаралды 971,832

Learnit Training

Learnit Training

Күн бұрын

Пікірлер: 398
@Polydoros66
@Polydoros66 3 жыл бұрын
"Go ahead and catch up with me" you are just being nice. We can't catch up with you man, you are in a different level
@djmartinez5054
@djmartinez5054 4 жыл бұрын
This is the gold standard of How to Teach so that people actually learn. And plus it's free! God bless yo sir!
@teachandtrained3985
@teachandtrained3985 4 жыл бұрын
kzfaq.info/get/bejne/icyDfpdmrKy9poE.html
@jamajama7159
@jamajama7159 3 жыл бұрын
@@teachandtrained3985 the video and the exercise file are not the same
@donnaw555
@donnaw555 2 жыл бұрын
This training answers my "why" and "how" questions - I love it!!!
@LearnitTraining
@LearnitTraining 2 жыл бұрын
We are glad you learned so much! Thank you for watching!
@sasavienne
@sasavienne 4 жыл бұрын
After watching the first 5 minutes, I stopped the video to *LIKE* . Thanks a lot. 👍 That is amazing.
@earth7451
@earth7451 3 жыл бұрын
Thank you so much for attaching the Excel forms to follow the class. You are a gift from Heaven! I'm watching all the ads as a way to say THANK YOU!
@LearnitTraining
@LearnitTraining 3 жыл бұрын
You're very welcome!
@akaghaprosper
@akaghaprosper Жыл бұрын
Please how did you download the Excel form. I'm a newbie, so I don't really know much about it
@domnicbollo2708
@domnicbollo2708 3 жыл бұрын
I love how you particularly simplify the concepts and use recap after explaining every point.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
You are welcome Domnic! Thank you for watching!
@Paulus_Wachu
@Paulus_Wachu 2 жыл бұрын
I am appreciative of how you are explaining these tools in the simplest and effective way.
@maler921
@maler921 3 жыл бұрын
Great job Sean in teaching even it kind of complicated sometimes but with the way you teach even the beginners can pick it up.Excel need patient, perseverance and attention to details.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you Lerma!
@kensimba7868
@kensimba7868 3 жыл бұрын
Thanks very much Sean. All these for free and very clear from u. Now my career in IT is made possible by Learn it and the likes! God bless you and all. Sean ur really appreciated man
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Hi Ken! Glad we were able to help and good luck in IT!
@turboromy
@turboromy 4 жыл бұрын
Ah... I should have see a little below... I typed in lots of data... already. Great video!!! Thanks for being very clear without being repetitive.
@kannanaiyar5291
@kannanaiyar5291 3 жыл бұрын
Thank you. I used to know Excel well, but I have not got into the newer tools that have been introduced in the last 10 years. Your explanation of the Table Tools is an eye-opener. Your style of explaining is the best I have seen. I have been trying to find a solution to a problem for a while, so I have been checking out a lot of other tutorials lately. I still have one nagging problem, but I learned a lot from your 3 levels of Excel videos.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Glad it was helpful!
@veronicaromero8642
@veronicaromero8642 4 жыл бұрын
YOU are an Excellent Trainer... You are funny and your info is easy to follow! Thank you for this video I am work on not allowing Excel to scary me but embrace all it's possibilities! I will be looking into more of your videos👍🏻
@Ben-kp1dh
@Ben-kp1dh 3 жыл бұрын
Huge thanks to this guy. I learned quite a lot from this tutorial. Great teacher with fun little jokes.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Glad you enjoyed it!
@sasavienne
@sasavienne 4 жыл бұрын
This tutorial is unprecedented and it covers important features in Excel efficiently.
@sammitchell7310
@sammitchell7310 4 жыл бұрын
Watched this before my exam and aced it 100% thanks!!!!
@LearnitTraining
@LearnitTraining 4 жыл бұрын
Excellent!
@ebenezertanwani4011
@ebenezertanwani4011 Жыл бұрын
You are such a good teacher, maybe you should be teaching teachers how to teach. Thank you so much
@LearnitTraining
@LearnitTraining Жыл бұрын
You are very welcome!
@nickrobinson9486
@nickrobinson9486 8 ай бұрын
Very helpful video! Great teaching style that makes it easy to practice and comprehend.
@LearnitTraining
@LearnitTraining 8 ай бұрын
Glad it was helpful!
@Mmm.5255
@Mmm.5255 3 жыл бұрын
Week starts with Monday, not Sunday, and it is DD.MM.YYYY(it's seconds, minutes, hours, days, months, years etc and not the other way around guys). These are logical, universal, and normal, but some people try to be unreasonably different
@huijiang4532
@huijiang4532 2 жыл бұрын
The best presentation ever. Can not Thank you more.
@LearnitTraining
@LearnitTraining 2 жыл бұрын
You're very welcome!
@DoctorKeo
@DoctorKeo 3 жыл бұрын
Excellent tutorial - Thanks. So ideal for the lockdown - I've no idea what I will do with these new skills when (if!) Coronavirus is defeated.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
You're very welcome!
@fjennewell
@fjennewell 4 ай бұрын
Aside from the value your bring to the viewers through the topics, I really appreciate your enthusiasm. We can feel it the way you speak. Just like in 00:50:57 :D Thank you so much! Learned a lot!
@LearnitTraining
@LearnitTraining 4 ай бұрын
Sean is a Microsoft super fan! Check out his podcast here - www.youtube.com/@jumpto365
@t3geek
@t3geek 5 жыл бұрын
I appreciate the rationale behind the Excel reasoning/logic!
@kwrer6087
@kwrer6087 4 жыл бұрын
This article is great to know! How to subtract in Excel? > l.linklyhq.com/l/5rOi
@kushalkirti4123
@kushalkirti4123 3 жыл бұрын
Very useful, well detailed, and easy to understand tutorial to learn excel. It saves a lot of time. Thank you.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you Kushal! We appreciate it!
@irfanshaikh-zz3ov
@irfanshaikh-zz3ov 4 жыл бұрын
Good work mate.. Appreciate your efforts towards teaching excel in so simpler way.Thanks
@kaliharris8143
@kaliharris8143 4 жыл бұрын
This is a fantastic video. Thank you! I will be watching them all multiple times!
@faranahmed4762
@faranahmed4762 4 жыл бұрын
Excellent, quality training. Videos like these are priceless 🙌
@rossgroves9554
@rossgroves9554 4 жыл бұрын
Fantastic tutorial, very easy to follow, the exercise files were appreciated. Good Job.
@thefamouseugenekrabs
@thefamouseugenekrabs 3 жыл бұрын
Thank you so much for posting this. You're a great teacher! Learning Excel is going to help me be more employable once the pandemic is over!
@LearnitTraining
@LearnitTraining 3 жыл бұрын
You're very welcome! Good luck!
@dayanajonsongoncalvesgener6005
@dayanajonsongoncalvesgener6005 4 жыл бұрын
I am completely filling in love for your videos!!!! Thank you so much
@TheFrancisChowdhury
@TheFrancisChowdhury 2 жыл бұрын
Very nice and well paced tutorial. Thanks a lot.
@LearnitTraining
@LearnitTraining 2 жыл бұрын
You are welcome! Also a big thank you for subscribing! It helps us tremendously!
@eleanorastaphan2302
@eleanorastaphan2302 4 жыл бұрын
Excellent tutorial. Interactive nature especially useful.
@369-DRK
@369-DRK 3 жыл бұрын
Very interesting specially Pivot tables, Data validation and Conditional formatting . you made me subscribe this channel. 1,2,3,4 Don't tell anyone 😉
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Welcome aboard!
@javiqbal637
@javiqbal637 3 жыл бұрын
fantastic tutorial, great presentation, clear, concise, useful, honestly brilliant
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you for watching Jav!
@abhishekroy8125
@abhishekroy8125 Жыл бұрын
This is absolute quality. The best Excel course I have seen on the internet. Kudos to you man :)
@easymatheducationalandictc1376
@easymatheducationalandictc1376 3 жыл бұрын
Yet to watch the lesson, but moved to like the video first... Thanks in advance!!!
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Hope you like it!
@dannnnnnnnnnnnnnn595
@dannnnnnnnnnnnnnn595 4 жыл бұрын
Thanks for providing useful information.
@amaruf2008
@amaruf2008 3 жыл бұрын
Great Excel Lessons. Thanks a heap. The manuals are also very helpful.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
You are welcome!
@coolangelhouse
@coolangelhouse 4 жыл бұрын
Awesome 👏 that You provide exercises file as well . Really amazing !😉
@amysu4465
@amysu4465 4 жыл бұрын
Very detail explanation and very practical. Thank you!
@excelsquad8518
@excelsquad8518 4 жыл бұрын
Sir Please upload Excel Expert tutorial . I have learned more things from you thank you!
@saurabhmishra4881
@saurabhmishra4881 Ай бұрын
The way you taught is awesome
@LearnitTraining
@LearnitTraining Ай бұрын
Thanks!
@stevehunt525
@stevehunt525 4 жыл бұрын
It's strange that the screen recording software is not showing any of the sub menus, like the conditional formatting section
@FelixArdLykke
@FelixArdLykke 4 жыл бұрын
Wow this is awesome video dude. You explain it so easy to understand and this will definitely help me in my daily work. 👌🙏👍 Now I need to create source file with 3 different regions with chart presentation. I going to search in your video for help thanks
@jessicapfeifer723
@jessicapfeifer723 3 жыл бұрын
You are an amazing teacher! I learned so much from this training video and I really enjoyed listening to your calm and pleasant voice. Thank you for sharing!!
@LearnitTraining
@LearnitTraining 3 жыл бұрын
You are very welcome Jessica!
@HOTTBUTTERLUV
@HOTTBUTTERLUV 4 жыл бұрын
I am truly loving these videos.
@theoptimist6252
@theoptimist6252 2 жыл бұрын
Great tutorial. Thank you for the upload
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Glad it was helpful!
@rosecanjura9799
@rosecanjura9799 4 жыл бұрын
Great way of delivering the material, details are very important. I am very much obliged . Keep safe.
@pushpalatasinha5877
@pushpalatasinha5877 4 жыл бұрын
It's really helpful. Thank you very much for every detail.
@Teacherman1955
@Teacherman1955 4 жыл бұрын
Which exercise file covers this video? I like the way you cover the different functions and formulas, giving the viewer time to practice each one before advancing to the next. Also, I like the way you cover each one, explaining them in easy to understand language.
@Valhalaal
@Valhalaal 4 жыл бұрын
Very informative tutorial. Clearly explained and justified.
@MiguelArevalo
@MiguelArevalo 4 жыл бұрын
Where can we find the Global Wine Sales file for importing the data exercise? The link above leads only to the main workbook.
@LightRibbon
@LightRibbon 3 жыл бұрын
Great video and explained in a fun/ interactive way. thank you!
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Glad you enjoyed it!
@shzb1
@shzb1 4 жыл бұрын
Amazing work and excellence is simply delivered... keep it up
@Jess-hv6rq
@Jess-hv6rq 4 жыл бұрын
Thank you for making this video. I really learned a lot! Keep up the good work!
@jijojose2574
@jijojose2574 4 жыл бұрын
You are too good. Thanks for the session.
@chanthathou3274
@chanthathou3274 4 жыл бұрын
I am so much appreciated to your full details.
@RohitChouhan-dj7se
@RohitChouhan-dj7se 4 жыл бұрын
MINE OF INFORMATION THANKS FOR THE QUALITY VIDEO
@chantellenorman4714
@chantellenorman4714 4 жыл бұрын
Highly enjoyed your training video!!!
@lanhrefons2029
@lanhrefons2029 4 жыл бұрын
Executive Coaching! Good stuff.
@chriswattson2476
@chriswattson2476 4 жыл бұрын
Excellent tutorial - I learned so much. Thank you.
@teachandtrained3985
@teachandtrained3985 4 жыл бұрын
kzfaq.info/get/bejne/icyDfpdmrKy9poE.html
@JohnS-il1dr
@JohnS-il1dr 2 жыл бұрын
awesome tutorials and thank you very much! just an observation the sub menus are not showing up especially during the Numbers Filter tutorial where you choose "less than" at 20.18
@younissyousif1260
@younissyousif1260 8 ай бұрын
Abig thanks for teaching in intermediate Level
@joe21lester
@joe21lester 4 жыл бұрын
Elegantly presented........amazing.
@babuumakantvuppala9598
@babuumakantvuppala9598 4 жыл бұрын
Great learning experience once again. Looking forward to your teaching methodolies in more excel tutotrials. Regards,
@tioyaw4387
@tioyaw4387 Жыл бұрын
Excellent! But l would love that with the video, you add to the materials to practice or teach with, so that the teaching becomes simple.
@LearnitTraining
@LearnitTraining Жыл бұрын
Exercise Files: bit.ly/2HDoEpM
@tioyaw4387
@tioyaw4387 Жыл бұрын
@@LearnitTraining Thanks so much, for sending me materials to practice with, l'm very grateful. God bless you. 😘
@marka565
@marka565 3 жыл бұрын
Thank you for spending time and post this amazing video. It was very informative and I learn a lot. Great jobs. Thank you again! :-)
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Thank you for watching!
@haneefqaazee3988
@haneefqaazee3988 4 жыл бұрын
Thank you very much Sean! This is a great video.
@LearnitTraining
@LearnitTraining 4 жыл бұрын
My pleasure!
@AestheticLinesUrdu
@AestheticLinesUrdu Жыл бұрын
Thanks for great lesson. So easy to understand.
@LearnitTraining
@LearnitTraining Жыл бұрын
You're very welcome!
@nghiepdam2061
@nghiepdam2061 4 жыл бұрын
Great tutorial for Excel. Thanks so much!
@LearnitTraining
@LearnitTraining 4 жыл бұрын
You're very welcome!
@wiser1147
@wiser1147 3 жыл бұрын
Can you please send another version of the exercise file so that I can practice on it?I'm not able to download it from the description. Extremely helpful video btw!
@frag_out1500
@frag_out1500 4 жыл бұрын
Huge Thanks! Appreciate your efforts.
@vicvic553
@vicvic553 3 жыл бұрын
When you talk about conditional formatting - thing which you click are not seen on a screen here, it means we cannot se what you are doing...
@mpumiedubesiwela1188
@mpumiedubesiwela1188 Ай бұрын
Wow! what a tutorial, incredible work thank you. I wanted to know how to i access the excel files and be able to make changes. Currently shows an read-only files on my end. Thanks
@LearnitTraining
@LearnitTraining Ай бұрын
Thanks Mpumie! You can download the file and save a copy. You can then edit that copy all you want.
@usmanabdullahi3560
@usmanabdullahi3560 2 жыл бұрын
Awesome Tutorial. Thank you
@LearnitTraining
@LearnitTraining 2 жыл бұрын
You're welcome!
@karianderson5912
@karianderson5912 4 жыл бұрын
Brilliant! Excellent tutorial.
@lechkoper5378
@lechkoper5378 3 жыл бұрын
Thank You kindly for that lecture it was great.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
You are very welcome Lech!
@onesandzeroes
@onesandzeroes 3 жыл бұрын
There isn't a world where days of the week are sorted alphabetically. But it turns out there is a world where Sunday is the first day of the week. They call it the US. It's also a world where the day comes after BETWEEN a month and a year. It's an alternative universe, where things defy logic.
@vivienzhang4457
@vivienzhang4457 2 жыл бұрын
Great and Thorough tutorial! Thank you!
@LearnitTraining
@LearnitTraining 2 жыл бұрын
You're very welcome!
@rpvlogs9399
@rpvlogs9399 3 жыл бұрын
Good work sir. Your teaching style is awesome.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you Ramraj! A bigger thank you for subscribing as that really helps us!
@curlymosquito2089
@curlymosquito2089 3 жыл бұрын
When you removed the duplicate, you removed the new row you just added with Amy's new last name. Is there a way to choose which duplicate to remove?
@deemcghee-piepie3089
@deemcghee-piepie3089 2 жыл бұрын
I enjoy your voice and you are amazing!
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Thank you so much!
@feralcanadian3947
@feralcanadian3947 2 жыл бұрын
Very helpful video. Thanks
@LearnitTraining
@LearnitTraining 2 жыл бұрын
You're welcome
@seyitalp7644
@seyitalp7644 4 ай бұрын
lecturer has a great voice btw
@LearnitTraining
@LearnitTraining 4 ай бұрын
Thanks!
@ricro880
@ricro880 4 жыл бұрын
Many thanks for this well presented information.. I have created a count down timer in a worksheet using the command buttons to for start and stop. My problem is when I try to repeat this in other worksheets I keep getting an ambiguity error. Can you explain how I can use command buttons in several worksheets in a workbook?
@alexafajardo8448
@alexafajardo8448 4 жыл бұрын
I think I love you. Thank you so much.
@LearnitTraining
@LearnitTraining 4 жыл бұрын
Glad it helped!
@qimipa3316
@qimipa3316 3 жыл бұрын
Very good tutorial. Excellent job!
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you! Cheers!
@monicawalls8184
@monicawalls8184 4 жыл бұрын
I took a shot every time he said "simply"
@LearnitTraining
@LearnitTraining 4 жыл бұрын
That definitely was a party then!
@jiahaowu9395
@jiahaowu9395 3 жыл бұрын
lol me too, i have seen the video severel times!
@aboaiah
@aboaiah 4 жыл бұрын
he's not only a great instructor but funny too
@LearnitTraining
@LearnitTraining 4 жыл бұрын
Thank you!
@aaronrambo1996
@aaronrambo1996 4 жыл бұрын
I watched the beginers tutorial and came to this but it seems like a huge jump. Im very new to excell. Is there an order to rhe videos i need to watch?
@hemaanthsivakumar2118
@hemaanthsivakumar2118 3 жыл бұрын
This video is not the follow up to the one you watched - its from a different course This is the link to the video to the video you want to watch: kzfaq.info/get/bejne/g8t7f8Kfm7nNiY0.html
@kadogo7712
@kadogo7712 4 жыл бұрын
you are a talented teacher
@LearnitTraining
@LearnitTraining 4 жыл бұрын
Thank you!
@MrTNVolsFan
@MrTNVolsFan 3 жыл бұрын
When you click on some tools like Conditional Formatting, the drop downs do not show in the video!
@ToXiCdArT5796
@ToXiCdArT5796 2 жыл бұрын
Great tutorial! It helped a lot understand powerful excel functions. Thanks alot.. :)
@LearnitTraining
@LearnitTraining 2 жыл бұрын
You are welcome!
@kyomuhendochristina7624
@kyomuhendochristina7624 3 жыл бұрын
Your the best. God bless you
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you Kyomuhendo!
@OmarMohamed-rq8ww
@OmarMohamed-rq8ww 2 жыл бұрын
Best tutorial bro I appreciated and I thank you for presenting it
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Our pleasure!
@fungsweewong3774
@fungsweewong3774 3 жыл бұрын
The Remove Duplicate Tool should highlight any Row/Record for people to inspect before removing the Duplicated Row/Records, otherwise people will not know what Row/Records are removed. Don't you think so?
@abinashkarmakar360
@abinashkarmakar360 3 жыл бұрын
Thank learnit for this..
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you for watching!
@elizabethbremmer3757
@elizabethbremmer3757 2 жыл бұрын
Amazing tutorials!
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Glad you like them!
@noviandani4968
@noviandani4968 3 жыл бұрын
thanks so much for the tutorial. May Allah bless you
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Glad it helped!
@cherylfountain5348
@cherylfountain5348 2 жыл бұрын
This was Fantastic! Thank you!
@LearnitTraining
@LearnitTraining 2 жыл бұрын
You're so welcome!
@cesarpassmore3772
@cesarpassmore3772 4 жыл бұрын
40:11, 55:09, 1:53:23, 2:00:40, 2:12:53
Excel 2016 Advanced Tutorial
2:38:45
Learnit Training
Рет қаралды 2,6 МЛН
Excel for Beginners - The Complete Course
54:55
Technology for Teachers and Students
Рет қаралды 6 МЛН
Prank vs Prank #shorts
00:28
Mr DegrEE
Рет қаралды 7 МЛН
Ouch.. 🤕
00:30
Celine & Michiel
Рет қаралды 48 МЛН
天使救了路飞!#天使#小丑#路飞#家庭
00:35
家庭搞笑日记
Рет қаралды 85 МЛН
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 158 М.
How to Use VLOOKUP in Excel (free file included)
15:15
Leila Gharani
Рет қаралды 188 М.
Can You Pass This Excel Interview Test?
11:20
Kenji Explains
Рет қаралды 884 М.
Excel Advanced Tutorial
1:17:37
Learnit Training
Рет қаралды 42 М.
50 Ultimate Excel Tips and Tricks for 2020
50:17
Sele Training
Рет қаралды 1,8 МЛН
Master Pivot Tables in 10 Minutes (Using Real Examples)
11:33
Kenji Explains
Рет қаралды 426 М.
Excel for Intermediate Users - The Complete Course
1:29:56
Technology for Teachers and Students
Рет қаралды 356 М.
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 7 МЛН
Prank vs Prank #shorts
00:28
Mr DegrEE
Рет қаралды 7 МЛН