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!!
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.
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 🤣.
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 :)
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.
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
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! :)
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.
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.
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?
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).
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 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!
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.
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.
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
@@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
@@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!😊😊😊
You are a God sent. Taking time to help strangers is a hearty thing
You are very welcome!
I love how clear your step-by-step guides are!
Thanks!
The whole excel in less than 4 hours
God!! what a genius and a phenominal teacher!!
Thank you so much! We think Faz is great as well!
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!!
You're very welcome!
😢😢😢 ayos
I am from Bangladesh. Thank you for this excellent tutorial.
You are very welcome!
I'm loving this course 🎉❤
👍👍👍👍
Masha Allah! Thank you!
You are welcome!
I can't say THANK YOU enough!! You're one AMAZING teacher.
Thanks!
It worked like a charm, thanks.
👍
Awesome tutorial, dude! Thanks!
Glad it helped!
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.
Noted!
Exactly what I have been looking for. Thanks!!!!!!!!!!!!!!
Glad we could help!
Awesome .... Thank you for helping in finding out the solution for my issue 😊
Most welcome 😊
Overall, a masterpiece
Thanks!
Very good questionnaire app I used. And earn money.
thanks! simple and understandable guide!
You are welcome!
U are a god send 🎉😊
Thanks!
This is amazing!!
Thank U FAZ
Much appreciated ❤
You are so welcome
Great course ❤ effortlessly
Glad you think so!
I learn many things thank you
You are very welcome
Thank you!
You're welcome!
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 🤣.
🤣🤣🤣 that is a great coincidence
thanks very much indeed!
You are welcome!
Sometimes after so many videos it's just so nice to see a muslim brother. Thanks for all the effort mate!
Thanks!
An excellent course well structured with plenty of prompts to give things a try. Thank you very much Faz!
Glad you liked it!
Can someone kindly drop the exercise files here
I'm unable to create a Microsoft account
Good place to start
We think so too!
That really work POGchamp
👍
Thanks A Lot Dude
You are welcome!
Thank you so much for the tutorials(beginners to advanced) i understood everything. Great work Faz and Learnit.
You are welcome!
Sportive Video shared.....Thanks
Thanks for that!
Thank you sir keep it up
Most welcome
Many many thanks
Most welcome!
thanks i never think that will work so good job!
👍
Thanks it really worked thanks alot man appreciated
👍
Great video! Thank you sir!
Glad you liked it!
You are awesome teacher. Thank You so much. I have a Big respect for you.
We appreciate that!
Excellent
Thank you so much 😀
"Faz is even better than I expected!"
02:37:37
Thanks!
It Work ! Thank you
You're welcome!
gracias pór el buen programa, saludos de desde México!
¡De nada!
Muchas Gracias amigo
You are very welcome!
it is easy if you are in the developer mode
Noted!
Gracias!
¡De nada!
thanks bro
No problem
Sir did u explain finctions like count if and sumif etc
big thenks bro work for me
Welcome 👍
in Excel Adv Clean file, all commands in Data tab doesn't work for me.
they are all disabled.
could you help me please?
Hello Whahid Shah Zadran! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
Thank you so much for the training.....👍🤛👏✍👈🙏
Our pleasure!
@@LearnitTraining cool🥰
Did you expalin about nestif functions
Muy bien.
Thanks!
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 :)
nice
Thanks
Smart Look up is not available if you access Excel via web access.
Great call out!
so cool man
Thanks!
muchas gracias, funciono 100%
de nada
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.
Hello Valerie! You can always get help at www.learnit.com
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
Hello ArzoCanada! We just tested the clean file and there were no issues. Sometimes you will need to enable editing.
why do you have such a soothing voice?
Born that way
The Insert, Draw and Data Tabs disabled from some reason in Excel Adv Clean file.xlsx
it work thankssss
You're welcome!
Amazing!
thanks for sharing
You are welcome!
Thank you so much Sir ❤
Most welcome!
Thank youuuu
You are welcome!
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! :)
Hello Bobby! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Thank you! :)
Great. Thank you for the upload
You are welcome!
@@LearnitTraining Thank you, Thank you and Thank you. I have learned the new features in excel.
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.
Use the file Excel Adv Clean file
Still I'm also facing same issue.
How can I get a Microsoft Excel certificate through Microsoft?
Thanks.
Here is a link to the official Microsoft certification exam: certiport.pearsonvue.com/Certifications/Microsoft/MOS/Certify/Excel
Thanks 😊
Excellent course, thank you so much!
Can I ask you what program are you using to draw or make anotattions on the screen? :)
That is Zoomit!
on the file Excel adv clean the insert table is greyed out how do I turn in on
Your any paid certification course for data analyst
eccellente...
Thanks!
It doesn’t work under Mac version, I cannot find alt on Mac keyboard 😢
2:01:00
When I group the sheets, it won't copy the font color and Bold to the other sheet, just the words
Hello pat p! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@@LearnitTraining thank you!
Bro data analytics job lo python course gurinchi video cheyyaledu bro
We will have a video covering Python in Excel soon!
I cannot edit the downloaded document in some capacity. Do I have to purchase the excel file somehow?
Hello DemWiFo! We just the files and they are currently working. Please be sure to use the file labeled "Clean"
3:21:00 How did he add extra columns so fast?
thanks man +1 sub ;)
Thanks for the sub!
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.
Sorry. Have been able to resolve it. The sheets were grouped.
👍👍👍
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
Hello Manaal! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
awesomely done video, Mr. Faz
Glad you liked it!
Awesome
Thanks!
buen video
Thanks!
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?
Hello What's Your Sin! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
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).
Hello David! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@@LearnitTraining Thanks! I signed up and will start to explore.
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.
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.
@@LearnitTraining Did both. It doesn't work.
@@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!
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.
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.
it's magical
Thanks!
how can i download the excel 2021
www.microsoft.com/en-US/microsoft-365/p/office-professional-2021/CFQ7TTC0HHJ9?activetab=pivot:overviewtab
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.
You can get consulting for such a project at www.learnit.com
THX
YW
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
Not sure what the questions is
@@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
@@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!😊😊😊
Can you translate these courses into Arabic?
We are definitely working on getting better translations for all our videos.
20/09/2023 Love Cyprus house home economics 2003!
👍👍
ga bisa windows geting ready mulu
Thanks!
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!
thanks bro
Any time!
Thanks bro! your a freaking legend I honestly don't know what I would've done without you a huge thanks!
No problem 👍