You are a God sent. Taking time to help strangers is a hearty thing
@LearnitTraining3 ай бұрын
You are very welcome!
@HannahNugent-x8y6 күн бұрын
I love how clear your step-by-step guides are!
@LearnitTraining3 күн бұрын
Thanks!
@LukeIamYourFather94 Жыл бұрын
The whole excel in less than 4 hours God!! what a genius and a phenominal teacher!!
@LearnitTraining Жыл бұрын
Thank you so much! We think Faz is great as well!
@tien0521 Жыл бұрын
Thank you for this awesome tutorial! You are a phenomenal teacher; everything is so clear and nicely paced, and it feels you thought to go over functions more than once, but in different scenarios, which really helped me to remember them! I’m starting new work soon which will require good MS command. And your teaching really helps me be more confident. A big thank you for your awesome work!!
@LearnitTraining Жыл бұрын
You're very welcome!
@JessileGergioАй бұрын
😢😢😢 ayos
@ArzoCanada8 ай бұрын
I can't say THANK YOU enough!! You're one AMAZING teacher.
@LearnitTraining8 ай бұрын
Thanks!
@amerudinyassinm14 күн бұрын
Masha Allah! Thank you!
@LearnitTraining13 күн бұрын
You are welcome!
@skylineza16 Жыл бұрын
It worked like a charm, thanks.
@LearnitTraining Жыл бұрын
👍
@yusuphsolution27619 ай бұрын
I'm loving this course 🎉❤
@LearnitTraining8 ай бұрын
👍👍👍👍
@arifuzzamansumon686510 ай бұрын
I am from Bangladesh. Thank you for this excellent tutorial.
@LearnitTraining10 ай бұрын
You are very welcome!
@adinamanolache51 Жыл бұрын
Awesome tutorial, dude! Thanks!
@LearnitTraining Жыл бұрын
Glad it helped!
@madevelopers4644 Жыл бұрын
Exactly what I have been looking for. Thanks!!!!!!!!!!!!!!
@LearnitTraining Жыл бұрын
Glad we could help!
@ryuren2363 Жыл бұрын
thanks! simple and understandable guide!
@LearnitTraining Жыл бұрын
You are welcome!
@srinivaskr12905 ай бұрын
Awesome .... Thank you for helping in finding out the solution for my issue 😊
@LearnitTraining5 ай бұрын
Most welcome 😊
@microsoftsarker9 ай бұрын
This is amazing!!
@this_is_nessar5398 ай бұрын
Thank U FAZ Much appreciated ❤
@LearnitTraining8 ай бұрын
You are so welcome
@anshojacob82956 ай бұрын
Thanks you for your tutorial I'm from Nigeria. But try to carry us along the more by creating everything (file) you are going to use to so that we too can learn how to do them instead of coming with auto made ones.
@LearnitTraining6 ай бұрын
Noted!
@AnuragKumar-wx6bg6 ай бұрын
Great course ❤ effortlessly
@LearnitTraining6 ай бұрын
Glad you think so!
@krisatkins61068 ай бұрын
An excellent course well structured with plenty of prompts to give things a try. Thank you very much Faz!
@LearnitTraining8 ай бұрын
Glad you liked it!
@csaaung4 ай бұрын
thanks very much indeed!
@LearnitTraining4 ай бұрын
You are welcome!
@Debbie_obasi6 ай бұрын
Thank you so much for the tutorials(beginners to advanced) i understood everything. Great work Faz and Learnit.
@LearnitTraining6 ай бұрын
You are welcome!
@DanielG10_2011 ай бұрын
Excellent video, I am brand new to Excel and this video is one of the better ones with all the keyboard shortcuts. One funny thing that happened when I was typing in "todays date" around the 42:10 mark, was that today is actually 2 years to the day (October 27) it showed on the video 🤣.
@LearnitTraining11 ай бұрын
🤣🤣🤣 that is a great coincidence
@IsmailQuranJourneyandGaming6 ай бұрын
I learn many things thank you
@LearnitTraining6 ай бұрын
You are very welcome
@linhjaja-nm7sv10 ай бұрын
Very good questionnaire app I used. And earn money.
@Mary.151 Жыл бұрын
thanks i never think that will work so good job!
@LearnitTraining Жыл бұрын
👍
@lisamccray64815 ай бұрын
Thanks!
@LearnitTraining5 ай бұрын
Thank you again for your continued support Lisa! We really do appreciate it and it helps us continue to make these great videos freely available!
@zpk535117 күн бұрын
U are a god send 🎉😊
@LearnitTraining16 күн бұрын
Thanks!
@AndreFerreira-ne2oq Жыл бұрын
Thanks it really worked thanks alot man appreciated
@LearnitTraining Жыл бұрын
👍
@jianlingwang8497 Жыл бұрын
gracias pór el buen programa, saludos de desde México!
@LearnitTraining Жыл бұрын
¡De nada!
@gjstrangers7615 Жыл бұрын
Many many thanks
@LearnitTraining Жыл бұрын
Most welcome!
@sinhiapli2147 Жыл бұрын
Muchas Gracias amigo
@LearnitTraining Жыл бұрын
You are very welcome!
@McGrathBloombergАй бұрын
Overall, a masterpiece
@LearnitTrainingАй бұрын
Thanks!
@luanreis4190 Жыл бұрын
It Work ! Thank you
@LearnitTraining Жыл бұрын
You're welcome!
@onlinesolution2145 Жыл бұрын
Thanks A Lot Dude
@LearnitTraining Жыл бұрын
You are welcome!
@JagatBhatnagar5 ай бұрын
Sportive Video shared.....Thanks
@LearnitTraining5 ай бұрын
Thanks for that!
@pablomachado5916 Жыл бұрын
Gracias!
@LearnitTraining Жыл бұрын
¡De nada!
@ssekyanzipatrick68628 ай бұрын
Thank you sir keep it up
@LearnitTraining8 ай бұрын
Most welcome
@nazeebiscool6 ай бұрын
Sometimes after so many videos it's just so nice to see a muslim brother. Thanks for all the effort mate!
@LearnitTraining6 ай бұрын
Thanks!
@mustaphamiftahulkhair71095 ай бұрын
Can someone kindly drop the exercise files here I'm unable to create a Microsoft account
@drewsoffice Жыл бұрын
Great video! Thank you sir!
@LearnitTraining Жыл бұрын
Glad you liked it!
@yelitzaarrieta0095 Жыл бұрын
That really work POGchamp
@LearnitTraining Жыл бұрын
👍
@MianIrfan-10015 ай бұрын
Excellent
@LearnitTraining5 ай бұрын
Thank you so much 😀
@odarahanthony9194 Жыл бұрын
Thank you so much for the training.....👍🤛👏✍👈🙏
@LearnitTraining Жыл бұрын
Our pleasure!
@odarahanthony9194 Жыл бұрын
@@LearnitTraining cool🥰
@vinayakmathakari8254 Жыл бұрын
Thank youuuu
@LearnitTraining Жыл бұрын
You are welcome!
@wahidshahzadran1712 Жыл бұрын
in Excel Adv Clean file, all commands in Data tab doesn't work for me. they are all disabled. could you help me please?
@LearnitTraining Жыл бұрын
Hello Whahid Shah Zadran! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@BerieBini4 ай бұрын
You are awesome teacher. Thank You so much. I have a Big respect for you.
@LearnitTraining4 ай бұрын
We appreciate that!
@اسلامعبدالفتاح-ن2ر Жыл бұрын
Muy bien.
@LearnitTraining Жыл бұрын
Thanks!
@karolhara3839 Жыл бұрын
Good place to start
@LearnitTraining Жыл бұрын
We think so too!
@ratnamathu18349 ай бұрын
Sir did u explain finctions like count if and sumif etc
@markjoshuavejerano2484 ай бұрын
Is there a way were I can wrap the text additional columns? It seems that the template can only wrap the columns headers and not the text values at Additional columns fields. Thanks in advance :)
@ZacAmiri Жыл бұрын
thanks bro
@LearnitTraining Жыл бұрын
No problem
@salsabilmuhammad-js9vy Жыл бұрын
muchas gracias, funciono 100%
@LearnitTraining Жыл бұрын
de nada
@valerielaconi9 ай бұрын
Thank you. I had trouble grouping worksheets. Only the word would carry over to the workbook, not the formatting (size and color). Also, the word would not show up in A3 unless I inserted columns above the Salesperson data first.
@LearnitTraining9 ай бұрын
Hello Valerie! You can always get help at www.learnit.com
@bobby7354 Жыл бұрын
Thank you so much for this! I always used Excel superficially only & and am now looking to improve my skills for my future profession, this is so helpful! I got a bit stuck at creating a table from the list though, for some reason the shortcut does not work and I cannot click on "table" either after choosing the insert tab. There seems to be some sort of error. Do you have any idea why? My cursor indeed has selected a cell within the list so it can't be that. I would appreciate your help! :)
@LearnitTraining Жыл бұрын
Hello Bobby! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@bobby7354 Жыл бұрын
Thank you! :)
@ArzoCanada8 ай бұрын
I am in the advanced section now and when I open the Excel Adv Clean file, a lot of the menu in the ribbon bar is greyed out i.e. the Insert tab, the Data tab, Review, View..etc. it doesnt seem to be protected sheet either-Please assist. Thank you
@LearnitTraining8 ай бұрын
Hello ArzoCanada! We just tested the clean file and there were no issues. Sometimes you will need to enable editing.
@dwreborn9077 Жыл бұрын
Amazing!
@EmmaCG2X4 ай бұрын
Excellent course, thank you so much! Can I ask you what program are you using to draw or make anotattions on the screen? :)
@LearnitTraining4 ай бұрын
That is Zoomit!
@elpinguwn Жыл бұрын
so cool man
@LearnitTraining Жыл бұрын
Thanks!
@Jarppiavelli8 ай бұрын
The Insert, Draw and Data Tabs disabled from some reason in Excel Adv Clean file.xlsx
@joaoeduardoreis8189 ай бұрын
"Faz is even better than I expected!" 02:37:37
@LearnitTraining8 ай бұрын
Thanks!
@อะเหล่มเกมเมอร์ Жыл бұрын
big thenks bro work for me
@LearnitTraining Жыл бұрын
Welcome 👍
@jameskalenga7546 Жыл бұрын
thanks for sharing
@LearnitTraining Жыл бұрын
You are welcome!
@realitybeckons4120 Жыл бұрын
Great. Thank you for the upload
@LearnitTraining Жыл бұрын
You are welcome!
@nomatusi7514 Жыл бұрын
@@LearnitTraining Thank you, Thank you and Thank you. I have learned the new features in excel.
@pekTiger Жыл бұрын
it work thankssss
@LearnitTraining Жыл бұрын
You're welcome!
@heathershaw57053 ай бұрын
I downloaded the files and I can't use them. I've made copies and tried to copy and paste the data to a new workbook. Nothing gives me acces to try the steps.
@LearnitTraining3 ай бұрын
Use the file Excel Adv Clean file
@Maneekumar11563 ай бұрын
Still I'm also facing same issue.
@andreausa123 Жыл бұрын
Thank you so much Sir ❤
@LearnitTraining Жыл бұрын
Most welcome!
@ratnamathu18349 ай бұрын
Did you expalin about nestif functions
@gibbsroslin57714 ай бұрын
Smart Look up is not available if you access Excel via web access.
@LearnitTraining4 ай бұрын
Great call out!
@bmitchell34913 ай бұрын
on the file Excel adv clean the insert table is greyed out how do I turn in on
@kigwa11266 ай бұрын
nice
@LearnitTraining6 ай бұрын
Thanks
@hope.1250 Жыл бұрын
How can I get a Microsoft Excel certificate through Microsoft? Thanks.
@LearnitTraining Жыл бұрын
Here is a link to the official Microsoft certification exam: certiport.pearsonvue.com/Certifications/Microsoft/MOS/Certify/Excel
@Briantechnology Жыл бұрын
Thanks 😊
@monicadewi3839 Жыл бұрын
it is easy if you are in the developer mode
@LearnitTraining Жыл бұрын
Noted!
@pat.p Жыл бұрын
When I group the sheets, it won't copy the font color and Bold to the other sheet, just the words
@LearnitTraining Жыл бұрын
Hello pat p! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@pat.p Жыл бұрын
@@LearnitTraining thank you!
@DadriaChen9 ай бұрын
It doesn’t work under Mac version, I cannot find alt on Mac keyboard 😢
@demwifo6808 Жыл бұрын
I cannot edit the downloaded document in some capacity. Do I have to purchase the excel file somehow?
@LearnitTraining Жыл бұрын
Hello DemWiFo! We just the files and they are currently working. Please be sure to use the file labeled "Clean"
@ranatejs.r789611 ай бұрын
Bro data analytics job lo python course gurinchi video cheyyaledu bro
@LearnitTraining11 ай бұрын
We will have a video covering Python in Excel soon!
@zebastiandavidfernandezmat67574 ай бұрын
why do you have such a soothing voice?
@LearnitTraining4 ай бұрын
Born that way
@ileonelyt2800 Жыл бұрын
eccellente...
@LearnitTraining Жыл бұрын
Thanks!
@whamjampamham Жыл бұрын
Hi Thankyou for this wonderful tutorial. I actually saw that chart made in charting 1 when saved as template didnt save the combo chart but only the bar chart. And when you used this chart in charting 2 it didnt mimic the chart but just mimiced the theme and color. Is there a particular reason for this?
@LearnitTraining Жыл бұрын
Hello What's Your Sin! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@dkerze Жыл бұрын
Are you aware of any way to print the filter selections sort of like in a report summary sense. For example I work in construction and I receive a large data dump from both out estimating software and at other times from our design software. I make various filter selections based on what I am looking to display or print as far as relevant data is concerned. When printing the final filtered dataset I want to also have a printout that outlines the criteria that has been selected to filter the dataset. I.e. let’s say I select 15 specific items out of a list of 100. I want those to be displayed on a separate report recap sheet so that a third party person could independently confirm that the correct selections were made (from a paper / printed view, without having access to the digital file and drilling down on each menu independently).
@LearnitTraining Жыл бұрын
Hello David! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@dkerze Жыл бұрын
@@LearnitTraining Thanks! I signed up and will start to explore.
@ayodexter Жыл бұрын
Thanks for this easy and very educative video. You an unparalleled instructor. However, it looks like your downloadable file (Excel Adv Clean file) is encrypted.
@ayodexter Жыл бұрын
Sorry. Have been able to resolve it. The sheets were grouped.
@LearnitTraining Жыл бұрын
👍👍👍
@alexafian9849 Жыл бұрын
awesomely done video, Mr. Faz
@LearnitTraining Жыл бұрын
Glad you liked it!
@reality4689 Жыл бұрын
2:01:00
@manaalkhan4503 Жыл бұрын
In comments and notes section if we protect the cell with password Can we still leave a note or a reply to that existing comment Thank you Faz Karim
@LearnitTraining Жыл бұрын
Hello Manaal! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@user-kd9hr5ft6h Жыл бұрын
buen video
@LearnitTraining Жыл бұрын
Thanks!
@lydiamulfinger5 ай бұрын
3:21:00 How did he add extra columns so fast?
@HIGHLIGHTS569 Жыл бұрын
thanks man +1 sub ;)
@LearnitTraining Жыл бұрын
Thanks for the sub!
@Sanatan_shiksha1 Жыл бұрын
Your any paid certification course for data analyst
@fenixrising1972 Жыл бұрын
These files don't let me create tables. I selected enable editing but it's still read only, and under properties read only is not checked so I can't uncheck it.
@LearnitTraining Жыл бұрын
We just checked the files and they worked fine. We recommend to delete the first download and try again. Also be sure to use the "clean" file.
@fenixrising1972 Жыл бұрын
@@LearnitTraining Did both. It doesn't work.
@Rena0142 Жыл бұрын
@@LearnitTraining I also have this problem, after downloading the zipfile and extrating the files, the "Clean" one doesnt seem to let me create tables as well (or to insert anything really). I tried the other 2 and they both work well. Maybe creating a new dowload link might work. *UPDATE:* I clicked on "file" and then in the "info" section where it says "inspect workbook" I used the "check compatibility" feature. It detected 2 issues - one of them wich said "A table style is applied to a table in this woorkbook. Table style formatting cannot be displayed in earlier versions of excel. Location:'Sparklines'. I only clikced find below that mesage , and it seems to solve the issue by it self. At least now im able to use the insert features! @fenixrising1972 try that out, but maybe the problem itself has to do with our excel verion!
@tobioluwasegun4042 Жыл бұрын
It happened to me also, I was able to deduce that if the function only works for excel 21 and you have anything below that, you won't be able to perform such function.
@DanielG10_2010 ай бұрын
If there is a way to make this Updated comment near the top of the list, that would be awesome! Totally worked for me, however it doesn't mimic the table that's on the video. Better than nothing though.
@ashokmhaske3433 Жыл бұрын
Awesome
@LearnitTraining Жыл бұрын
Thanks!
@raviravindra6650 Жыл бұрын
it's magical
@LearnitTraining Жыл бұрын
Thanks!
@Sneha050324 күн бұрын
bro nen bsc stats and mca completed 1 month ago, will it be useful if i do DA,ante meru bba bcom valake use untundhi annatu chepparu ga, plz reply bro , waiting for ur reply
@LearnitTraining23 күн бұрын
Not sure what the questions is
@Sneha050323 күн бұрын
@@LearnitTraining meru chepparu kadha only bca bba or MBA chesina vallaki data analyst use avthundhi ani , but nen mca chesa ,, will it be usefull for me ani asking anna
@gfssgrr17 күн бұрын
@@Sneha0503 Hey, I see what you're saying! Even though he mentioned it’s useful for BCA, BBA, or MBA grads, Data Analytics will still definitely be useful for you too with your MCA background. Your skills from MCA will help a lot in this field. Go for it!😊😊😊
@allstarsacademydaycare54055 ай бұрын
Thank for this video. Can you help me create an excel calculator? I will send you a video of what i need. It's icm911 where to go yh for now.
@LearnitTraining5 ай бұрын
You can get consulting for such a project at www.learnit.com