So the exam I took was the Certiport one, and it took a lot of functions and whatnot. I studied for I’d say 1 month for regular excel and 1 month for excel expert. It took a few tries, but I passed in the end. Hope this helps
This tutorial is well planned and easy to follow! I had been struggling to know when to use certain functions. With there remaining one day for me to certify in Excel Expert, I decided to follow this video and it really helped. Thank you!
Really well put together. A lot better than any of the paid for courses I have seen. Clear explanation of how nested functions work and super useful explanation of some of the analytics functions like the WhatIf analysis tabs. Perfect jumping off point at the end for anyone hoping to progress to learn macros. I added notes in a text box to each sheet of the student workbook provided as I followed along with the video - this will be a great resource for quick reference to the tools covered.
Thank you so much for these Great Tutorials of Excel. I always tried to learn Excel from Other platforms just for the certificate, but always failed to complete it. Then I found your channel and I was so grateful to not only complete the Excel tutorial but also learned the importance of having skill than a certificate. Thank you so very much.
Thanks for intuitive tutorial excels. I haven't used excel for awhile so your tutorials really helped me a lot. So many excel tutorial out there but this one is the best.
I was looking for Excel 2019 tutorial, lucky to find your site. You have done a awesome job explaining it in detail and giving chance to practice together. No dough you are excellent tutor and keep your audiences engage. They are many utube tutorials on excel but none matches with your. Thank you
PMT Data Table. Practices grid still needs to use the same order for Months and rates (apparently does not affect the switch between months and rates. I tried but i had to use the same order as Alternative in order to get the same result). Regards
How do make a title start in the middle of the row. For example, I’m on row b and I’m trying to make one cell start in the middle of row b. How do you do that?
Great video. I have a problem, when I click on the Visual Basic button, it shows me error;" 'VBE6EXT.OLB' could not be loaded". and when I click okay, it shows me another error; "out of memory"
I am looking forward to watching it mate! I am sure that it's going to be another effective tutorial as good as previous tutorials which I'd had watched regarding excel were so cool.
Hi, Can you please check the below question & try to find the solution if possible. Definitions: Client: This is Exotel's client for the call made Call duration: Duration for the call made Vendor: Operator for the call made There are around 2000 random calls samples. Please calculate the following and share the excel: Total revenue from these calls Total cost from these calls Total Margin from these calls (Margin = (revenue - cost)/revenue ) Assumptions Selling rate for Quikr: 40 paise for 60 second pulse Selling rate for Snapdeal: 24 paise for 30 second pulse Selling rate for Flipkart: 10 paise for 15 second pulse Cost from Reliance: 6 paise for 15 second pulse Cost from Aircel: 2 paise for 5 second pulse Cost from Vodafone: .5 paise for 1 second pulse.
how can i write a formula that only compares 2 cells in a given row that will have 4 values? For example, cell B1 has a value of 6 and C1 has a value of 2. the "Difference cell" will total C1-B1 = -4. then when i add a value of 3 into cell D1 of 3, the "difference cell" will total D1-C1 = 1. then when i add a value of 3 into cell E1, the "difference cell" will total E1-D1 = 0. Hope this makes sense lol
hi dear team,,i found out some wrong calculation in the consolidate table,,,,total should be like 3,700..5,200...8,500...3,400.....for q1, q2, q3, q4, respectively please checek...
Well, SOMEBODY understands. In no way, shape or form is this an EXPERT tutorial. DO NOT try to take the expert exam by doing this tutorial. If this is new information to you, you are NOT an expert. Keep studying other resources as well.
I wonder why u hate using the formulas from the function library. Your approach to formulas makes it look more complicated especially for a beginner. You can make it more interesting if u demonstrate the formulas by typing and from the function library
I can advise u'all to search for those tutorials done by Chelsea Dohnmann and will look for other eloquent ones. Unfortunately Faiz doesn't simplify it the best to a beginner
Hi there, how are you doin? very good video!! Would like to ask if there's a way to import an .txt file in which the text is divided only by space? Some like: aaa aaa aaaa 12332
One of the few tutors that I truly enjoyed listening to and kept me interested all the way! Your random sense of humor is on point too!
Thank you for watching and thank you for subscribing!
@@LearnitTraining 1:01:36
Tomorrow is my last chance to pass my excel expert exam! I am studying right before so I’ll update you. If I pass I owe you the world!😅
Good luck!!!!
@@LearnitTrainingUpdate: I passed !! Thank you for the knowledge !😄
@@StellarStrider 15:26
Can you say more about that exam? How long have you been studying excel to get to that point? Levels, etc.
So the exam I took was the Certiport one, and it took a lot of functions and whatnot. I studied for I’d say 1 month for regular excel and 1 month for excel expert. It took a few tries, but I passed in the end. Hope this helps
Another effective tutorial on Microsoft Excel. Being an ICT tutor myself, I believe alot of us will benefit from this. Thank you
You're very welcome and thank you for your continued support CHITUS!
@@LearnitTraining 1:01:46
This tutorial is well planned and easy to follow! I had been struggling to know when to use certain functions. With there remaining one day for me to certify in Excel Expert, I decided to follow this video and it really helped. Thank you!
You are very welcome!
@@LearnitTraining 1:00:57
Really well put together. A lot better than any of the paid for courses I have seen. Clear explanation of how nested functions work and super useful explanation of some of the analytics functions like the WhatIf analysis tabs. Perfect jumping off point at the end for anyone hoping to progress to learn macros. I added notes in a text box to each sheet of the student workbook provided as I followed along with the video - this will be a great resource for quick reference to the tools covered.
Glad it was helpful!
@@LearnitTraining 1:00:36
Thank you so much for these Great Tutorials of Excel. I always tried to learn Excel from Other platforms just for the certificate, but always failed to complete it. Then I found your channel and I was so grateful to not only complete the Excel tutorial but also learned the importance of having skill than a certificate.
Thank you so very much.
You're very welcome!
Are you kidding!!!! This is FANTASTIC! The samples are PHENOMINAL & dude is crystal clear! Thanks so much!!
Wow, thank you!
Thanks for intuitive tutorial excels. I haven't used excel for awhile so your tutorials really helped me a lot. So many excel tutorial out there but this one is the best.
Thank for the kind words Huong! We are glad you learned a lot!
@@LearnitTraining 1:08:24
Let take a moment of appreciation to the guy who makes our jobs easier.
Thank you David!
I have completed Excel Advanced class... Amazing experience
Great 👍
This was a very helpful Excel course. The instruction is clear and the practice assignments reinforce the concepts. I learned a lot!
We are glad you learned so much! Thank you for watching!
@@LearnitTraining 1:01:06
D1: IF Functions (Part 2) 15:17
D2: Introduction to VLOOKUP 29:40
D3: Text Functions 46:13
D4: Goal Seek 1:00:31
D5: Macros - Adding the Developer Tab 1:12:28
D6: Macros - Exercise 1:27:38
D7: To go over
1:12:37
I was looking for Excel 2019 tutorial, lucky to find your site. You have done a awesome job explaining it in detail and giving chance to practice together. No dough you are excellent tutor and keep your audiences engage. They are many utube tutorials on excel but none matches with your.
Thank you
You are welcome!
well explained and easy follow. with this i see no reason for me to start those paying courses. this is just straight forward.
Thanks!
I love how you can keep my adhd brain focused with your voice
Thank you for watching CrudeSplash 55!
yeah it's great. But I also watch it at 1.75 speed 😂
One of the best class on Excel!!!
Wow, thanks!
I do appreciate your time and effort in creating this fruitful tutorial. You rock!
We appreciate that!
@@LearnitTraining 1:01:14
You can do Xlookup instead of either Vlookup or Hlookup as Xlookup can look up vertically or horizontally.
ini bener" lengkap dan komprehensif, matur nuwun kang learnit.. gusti ingkang bales
Sampeyan olèh!
Great teacher and educational chennel. Please upload pivote table master and expert lever.👏🏽👏🏽👏🏽👍🏾👍🏾👍🏾
Watched all three videos and learned many things. Thank you very much Faz
Thank you so much for watching Chamath!
Awesome sir.. you made my life easy in my office...
Happy to help!
Thank you so much I had no idea about using excel, and now I can do many things independently)))
You are very welcome!
Excellent tutorial! Nicely paced and easy to follow.
Glad it was helpful!
@@LearnitTraining 1:08:12
This is soooo helpful!!! Thank you so much!!!
You are very welcome!
Thanks a lot for putting together such a comprehensive training
Glad it was helpful!
MUCHAS GRACIAS por adjuntar el archivo y poder seguirlo simultáneamente.
¡Usted es bienvenido!
Incredibile Course. Easy to understand. Hope to find some other Expert Videos about Excel (Macro&Pivot Tables)! Thanks Faz. From Italy
Glad you liked it!
Congratulations brother, I really appreciate your clear explanations, you give us what we needed it's really outstanding, I understand. Thanks
You are welcome!
@@LearnitTraining 1:01:23
best excel's tutorial ever
Glad it was helpful!
i like ur hard work
Thank you!
Thank you for the detailed and easy to understand module, It really kept me active all the time!!!
Thank you for watching!
Thank you so much for this tutorial!
You are very welcome!
Thank you sooo much for this wonderful course. Really enjoyed learning it!
You're very welcome!
PMT Data Table. Practices grid still needs to use the same order for Months and rates (apparently does not affect the switch between months and rates. I tried but i had to use the same order as Alternative in order to get the same result). Regards
Super Useful!
Glad it was helpful!
It is just perfect and clear!! Thanks a lot 😀
You're welcome 😊
Thank you so much, really appreciate the time and effort for completing this useful tutorials for us. :)
Thanks Faz. This is an awesome course
Glad you think so!
Was tremendously helpful
You are very welcome!
Fantastic! Thank you!
You're very welcome!
that was really really great way of teaching. excellent. please start sql also.
That's the plan!
You guys are amazing. Thank you so much for the free lesson
Our pleasure and thanks for watching!
Thank you so much for caring and sharing of excel learning for your learner!
My pleasure!
Thank you! Appreciated! This help me so much
You are welcome!
Great video, thank you very much
You are welcome!
Thanks a lot! Incredibly helpful for me
You are welcome!
Could you also do a video on managing stock using Excel
thank you so much, this was very educational!
Glad it was helpful!
Hi Faz, thank you very much for this beautiful corse . in one word you are awesome!!!
Thank you too!
How do make a title start in the middle of the row. For example, I’m on row b and I’m trying to make one cell start in the middle of row b. How do you do that?
Hi Sierra! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
Thank you for these amazing videos!
Glad you like them!
This is really helpful!! Thanks!
You're so welcome!
Thank you :)
You are welcome!
Very good, thank you
Our pleasure!
Thank you very much.
You are welcome!
very incredible video, thank you very much!
You're very welcome!
Thank you very much!
You're welcome!
Great video. I have a problem, when I click on the Visual Basic button, it shows me error;" 'VBE6EXT.OLB' could not be loaded". and when I click okay, it shows me another error; "out of memory"
You're a legend!
Thank you for the kind words!
might not understand the PMT yet, but if i do, i think you swaped the rows with columns by mistake on the bigger data set. please let me know
this is the best news in Covid-19 year!
Your Excel exercise spreadsheet has a Date Function tab, but the video does not cover that tab. How can I find your Date Function video discussion?
I am looking forward to watching it mate! I am sure that it's going to be another effective tutorial as good as previous tutorials which I'd had watched regarding excel were so cool.
Alrightyyyyyy!
Thank you for watching!
Hi,
Can you please check the below question & try to find the solution if possible.
Definitions:
Client: This is Exotel's client for the call made
Call duration: Duration for the call made
Vendor: Operator for the call made
There are around 2000 random calls samples. Please calculate the following and share the excel:
Total revenue from these calls
Total cost from these calls
Total Margin from these calls (Margin = (revenue - cost)/revenue )
Assumptions
Selling rate for Quikr: 40 paise for 60 second pulse
Selling rate for Snapdeal: 24 paise for 30 second pulse
Selling rate for Flipkart: 10 paise for 15 second pulse
Cost from Reliance: 6 paise for 15 second pulse
Cost from Aircel: 2 paise for 5 second pulse
Cost from Vodafone: .5 paise for 1 second pulse.
Thanks and appreciate !
You are welcome!
should one focus on 2016 tutorials or 2019 ones? Im not sure how much has changed since 2016
2019 ones, but only if you're on the version DN
Where can I get the file used in the video?
Hi Catherine - the link to the exercise files is in the video description!
Number one !!!!
Thank you Hassan!
how can i write a formula that only compares 2 cells in a given row that will have 4 values? For example, cell B1 has a value of 6 and C1 has a value of 2. the "Difference cell" will total C1-B1 = -4. then when i add a value of 3 into cell D1 of 3, the "difference cell" will total D1-C1 = 1. then when i add a value of 3 into cell E1, the "difference cell" will total E1-D1 = 0. Hope this makes sense lol
Hello Chad! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Really helpful... Thank you so much :)
Glad it was helpful!
thank u for ur guidance, and can you pls show how to enable the search box in excel recent file list view
yea you just have to enable DN
great tutorial but too many ads
Noted
I tryed to doenload files and it would not let me?
Hello Sam! We just tested the files and links. They are currently working
how do you draw arrows and/or squares around certain areas of the spreadsheet, during your presentation? Is that an Excel add-in?
HI Tywin! That is Zoomit!
Can you make time nodes and directories?Please
Pivot table in advance video tutorial upload
how do l get the sample file to work with as l study with u?
Hi Adebola! The link to the exercise file is in the video description
sir ek formula bta skte ho
where do i get the F1 function?
Hi Olushola - F1 is a key on your keyboard
Hello Faz! How do you draw those arrows with red marker while using the mouse simultaneously? Can you please help?
Hi Rakib - that app is called Zoomit
@@LearnitTraining Thanks Faz ! I appreciate your assistance 💙
Thanx
👍
How do you grab the sample file for learning this tutorial?
Hi Joe! The link to the exercise files is in the video description!
Where do I get the sample workbook to follow along?
Exercise Files: bit.ly/36ZPKzO
hi dear team,,i found out some wrong calculation in the consolidate table,,,,total should be like 3,700..5,200...8,500...3,400.....for q1, q2, q3, q4, respectively please checek...
Thanks for letting us know! We'll look into this issue.
amazing
Thank you! Cheers!
Hi
What version of Excel 2019 are you using? My ribbon in my Excel 2019 home version looks different than yours.
Hes using Excel DN
11:26
28:15
44:44
this is entry level excel
Well, SOMEBODY understands. In no way, shape or form is this an EXPERT tutorial. DO NOT try to take the expert exam by doing this tutorial. If this is new information to you, you are NOT an expert. Keep studying other resources as well.
can u upload the exercise file again....?
Hi Imran - we tested the link to the files and it is working
I wonder why u hate using the formulas from the function library. Your approach to formulas makes it look more complicated especially for a beginner. You can make it more interesting if u demonstrate the formulas by typing and from the function library
If you watch the Advanced 2016 tutorial you will understand better, they use the functions library. I understood this because of the 2016 tutorial.
I can advise u'all to search for those tutorials done by Chelsea Dohnmann and will look for other eloquent ones. Unfortunately Faiz doesn't simplify it the best to a beginner
How, I get Certificate of completion any course
HI Amit - you can join our Patreon and the Bronze level offers the ability to earn certificates of completion
exercise file is missing
Hi Ashraf! We just tested the link and the exercise files are working fine currently
I notice there's no XLOOKUP?
Excel 365 only
Can you please teach me the ms word 2019
they do provide videos of it as well
hello , How I can get this sample file please
Hi Saman - the link to the files is in the video description
Ms word in master video upload
Hi there, how are you doin? very good video!! Would like to ask if there's a way to import an .txt file in which the text is divided only by space? Some like:
aaa aaa aaaa 12332
1:20:41