This was phenomenal training. I truly appreciate your style of teaching and the active worksheets made a huge difference. Keep you this wonderful training.
These are the best excel videos I could find on TH-cam and thanks for the tremendous effort that went into creating this series. But the audio is broken in all your videos and it's very frustrating. This is a minor issue that's easy to fix but spoils the fun.
This video was definitely awesome & I learned the beginner level very well without any doubt.. Still halfway to go.. Will reply on this comment after completing the whole video ❤
@@LearnitTraining just completed the intermediate level & I have to say that the way you explain is easy to understand... Keep up the good work bro. Now I'm going to complete other courses too 🔥
Does this really explain everything there is to know about excel?? I'm a student and in math class we're currently working on a chapter that involves excel use in almost every assignment, but I truely have no idea how to use excel, at all. And to put it lightly, I'm kinda doomed for the next test if I don't figure out how to use excel like really fast.
It is a very good program, the caption is coming up on screen, I mean whatever Mr. Kevin says it shows up at the bottom of screen that covers many things. How do we turn off the caption?
Turn default setting to on or off Click your profile picture . Click Settings . From the left-hand menu, click Playback and performance. Check or uncheck Always show captions. Check or uncheck Include auto-generated captions (when available).
Hi, I have an Excel workbook with multiple worksheets. On worksheet One, I want to add buttons to click that will take me to the other worksheets. How can I do that? Thanks
Certainly! You can create buttons in Excel that allow you to jump to different worksheets. Here are a few ways to achieve this: Inserting Shapes to Create Buttons: Go to the Insert tab, click on Illustrations, and select Shape. Choose the Rectangle shape. Insert a rectangle into your sheet by dragging it. Format the shape by going to the Shape Format tab. Select a theme style and type the name you want for your button (e.g., “January”). Copy the shape (Ctrl+C) and paste it (Ctrl+V) for other months (e.g., February and March). Right-click on a shape, choose Link, and select the corresponding sheet (e.g., January, February, or March) from the Insert Hyperlink dialog box. Using Form Controls: Go to the Developer tab (if not visible, enable it in Excel options). Click on Insert and choose a Button from the Form Controls section. Draw the button on your sheet. Assign a macro to the button (e.g., “Prevw1_Click”) that activates the desired sheet. Command Button from ActiveX Controls: Go to the Developer tab and click on Insert. Choose a Command Button from the ActiveX Controls section. Draw the button on your sheet. Assign a macro to the button that switches to the desired sheet. Remember to adjust the sheet names and customize the buttons according to your needs. These methods will allow you to create buttons that navigate to different worksheets in your Excel workbook. Happy Excel-ing!
I do not like the whole 365 paradigm. I would rather have software on my own computer. Or max, on a small local network. Therefore, libreoffic Calc is preferable.
We definitely agree that the SAAS is not ideal, especially for small businesses and individuals. The programs for the most part are not being radically updated. All that being said we also see the value in the uptime that SAAS provides.
Why is it that when I type the date one (12/27/2023) and I double click to autofill, it doesn’t do an autofill per day? It does it per year. Like when I did it, it did 12/27/2023, 12/27/2024, 12/27/2025. Instead of 12/27/2023, 12/28/2023, 12/29/2023, etc. How can I change this?
This article may help: www.solveyourtech.com/how-to-sort-multiple-rows-and-columns-in-excel-a-step-by-step-guide/#:~:text=Sorting%20multiple%20rows%20and%20columns%20in%20Excel%20is,can%20lead%20to%20clearer%20insights%20and%20better%20decision-making.
Exercise Files: learnitanytime.com/p/exercise-files-excel-full-course-tutorial-2024
This was phenomenal training. I truly appreciate your style of teaching and the active worksheets made a huge difference. Keep you this wonderful training.
Like the speed. Thank you
Hi Joe. Thank you for this increadible lesson. This one of the best videos that I have come across on Excel.
I'm glad you found it helpful!
one of the best video right now for new learners, amazing
Thank you so much!
This is very insightful. Great job, Joe. Amazing. Thank you so much. All the best.
Thank you so much. The best video out there for leveling up real quick
Glad it helped
Wonderfu😮and great speed for better quality understanding
9:08
25:58
43:31
1:01:15
1:25:05
1:45:45
👍
@@LearnitTraininghey i've got a question. When i autofill the date cell, it changes the year instead of the day. How to fix this?
Nvm, found out my format is dd/mm/yy and yours mm/dd/yy😅
If you want a quick refresh of intermediate and beginner excel skills... this is your video. You just need patience and willingness to learn
Thank you for the kind words!
@@LearnitTraining Thank you for your content!
sound good
Returning to finish the course, this is really good and detailed information.
Glad it was helpful!
i enjoyed the class, you really are God sent
Glad it was helpful!
Thanks so much for the knowledge
Reply
We are glad you found it helpful!
Great Lessons. I Learned Lots of Easy Methods. Greetings from Sri Lanka
Thanks for the greeting from Sri Lanka!
Your the best man
Thanks!
Thank God for this class.. even though my autofill is not working ugggh.. But this is a God sent
You are very welcome!
Thanks so much for the knowledge
You are very welcome!
These are the best excel videos I could find on TH-cam and thanks for the tremendous effort that went into creating this series. But the audio is broken in all your videos and it's very frustrating. This is a minor issue that's easy to fix but spoils the fun.
Noted!
You're the absolute best Excel teacher for beginners, I can't thank you enough💙
Give Joe Patti a raise @LearnitTraining
Working on it!
how awesome is this video
Super Awesome!
Thank you very much🥰🥰
You’re welcome 😊
Really good course, thank you very very much!
You're very welcome!
Excellent video. Great teaching style.
Dr. Hussain
Thanks for liking!
Thanks for sharing, great video. 🥰🥰
You are so welcome!
Amazing video really helpful 👍👍
Thanks!
Very useful 👍🔥
Glad you think so!
Amber ❤❤❤❤
Thank you so much!
Amazing tutorial,thank you a million times.
Glad it was helpful!
Iam so glade to have attended this course, I have benefited a lot
Glad you learned so much!
The best explanation you can find 👏
Wow, thanks!
Great tutorial for Excel, thanks Joe!
Glad it was helpful!
Thanks and u got a new subscriber
Welcome aboard!
Thanks
No problem
thnx a lot ! amazing video
You are welcome!
I am happy to your education.
Thanks!
This has been very helpful
Thanks!
This video was definitely awesome & I learned the beginner level very well without any doubt.. Still halfway to go.. Will reply on this comment after completing the whole video ❤
Keep it up!
@@LearnitTraining just completed the intermediate level & I have to say that the way you explain is easy to understand... Keep up the good work bro. Now I'm going to complete other courses too 🔥
good stuff here, thanks
You are welcome!
Thank you for this video. I'd like to know if this video alone would prepare me for an entry level data entry job? Thanks Joe.
Practice, practice, and more practice is what we preach.
Really helpful lecture
A humble request: Can you please improve audio quality
Sure thing!
Good thanks
No problem
you are the best
Thanks!
Audio is fine!
👍👍
Cool
Thank you. i learned a lot❤❤❤ about this course
To anyone watching ×1.25 is the perfect speed.
👍
for me 2😆
Lied in my resume, now I am here
And thousand others! We are here to help you all!
Does this really explain everything there is to know about excel?? I'm a student and in math class we're currently working on a chapter that involves excel use in almost every assignment, but I truely have no idea how to use excel, at all. And to put it lightly, I'm kinda doomed for the next test if I don't figure out how to use excel like really fast.
Who is here 2024 learning. Thank you for a well explained video. Let's keep learning
Keep on keeping on!
Just starting today and want to thank you for such a great training session, that’s easy to follow along. ❤
Thank you learnit
You are welcome!
waiting for this
Tanks ❤😂
👍
It is a very good program, the caption is coming up on screen, I mean whatever Mr. Kevin says it shows up at the bottom of screen that covers many things. How do we turn off the caption?
Turn default setting to on or off
Click your profile picture .
Click Settings .
From the left-hand menu, click Playback and performance.
Check or uncheck Always show captions.
Check or uncheck Include auto-generated captions (when available).
Waiting 😊
You're like the Bob Ross of Excel. Thank you.
Wow, thanks!
@LearnitTraining man, upgrade your mic. Its an excellent tutorial but the audio quality sucks.
Noted!
I am using an iPad, do I need to get a laptop to get the most out of Microsoft Office or there is no difference? I’m really confused
With the 365 web versions there should be too many differences but for the full robust experience we definitely recommend using a Windows 11 PC.
Waiting for This
Hope you liked it!
1:58:45 the sorting function doesn't work for me there
WE are here yippeeeee
Thanks for joining us!
Suggestion, pls used zoom in. The data is very small
Noted!
At 39 min you are explaining totals. no if you change one number in the addition columb why does the total no change with the addition adjustment?
I am multiplying at 56:30 but nothing shows in my sheet, its blank. Does any of you know how to do it?
Is it possible for me to watch this video in one sitting and learn
You can learn everything you need for a great foundation in Excel. Nothing though can replace practice, practice, practice!
Excel 2019 friendly?
We have this video series for Excel 2019: th-cam.com/play/PLoyECfvEFOjaPZI7IsJKM2bBmPZhRmmbs.html
Hi,
I have an Excel workbook with multiple worksheets. On worksheet One, I want to add buttons to click that will take me to the other worksheets.
How can I do that?
Thanks
Certainly! You can create buttons in Excel that allow you to jump to different worksheets. Here are a few ways to achieve this:
Inserting Shapes to Create Buttons:
Go to the Insert tab, click on Illustrations, and select Shape. Choose the Rectangle shape.
Insert a rectangle into your sheet by dragging it.
Format the shape by going to the Shape Format tab. Select a theme style and type the name you want for your button (e.g., “January”).
Copy the shape (Ctrl+C) and paste it (Ctrl+V) for other months (e.g., February and March).
Right-click on a shape, choose Link, and select the corresponding sheet (e.g., January, February, or March) from the Insert Hyperlink dialog box.
Using Form Controls:
Go to the Developer tab (if not visible, enable it in Excel options).
Click on Insert and choose a Button from the Form Controls section.
Draw the button on your sheet.
Assign a macro to the button (e.g., “Prevw1_Click”) that activates the desired sheet.
Command Button from ActiveX Controls:
Go to the Developer tab and click on Insert.
Choose a Command Button from the ActiveX Controls section.
Draw the button on your sheet.
Assign a macro to the button that switches to the desired sheet.
Remember to adjust the sheet names and customize the buttons according to your needs. These methods will allow you to create buttons that navigate to different worksheets in your Excel workbook. Happy Excel-ing!
Thanks
what should I do if my autofill doesn't work? instead of the dates moving a day later, it just copies the same first date already written. Thanks
1:30:33
👍
I do not like the whole 365 paradigm. I would rather have software on my own computer. Or max, on a small local network. Therefore, libreoffic Calc is preferable.
We definitely agree that the SAAS is not ideal, especially for small businesses and individuals. The programs for the most part are not being radically updated. All that being said we also see the value in the uptime that SAAS provides.
Waiting
Us too!
more real world exercise videos joe
Noted!
Why is it that when I type the date one (12/27/2023) and I double click to autofill, it doesn’t do an autofill per day? It does it per year.
Like when I did it, it did 12/27/2023, 12/27/2024, 12/27/2025. Instead of 12/27/2023, 12/28/2023, 12/29/2023, etc.
How can I change this?
Great video, very helpful! Just FYI, espresso doesn’t have an x. 😂
My bad
The "Smart Lookup" feature was discontinued on Jan. 1, 2025
Please help me.
There's no "sort, sortby, and unique functions on my Microsoft Excel 365".
How do I go about it please.
Same problem 😢😢😢
what excel version do you have -- I have 365 @ august 2024 my View does not even look like this leson
This was recorded using Excel 365 but with all 365 products they do get updated quickly so there maybe some minor changes
The way he teaches makes me feel like a granny learning how to use the internet. im 27 :(( lol
👍
Is class ko lekr job mil skti h ye enough h ms Excel coaching me 6 ,6 mahine lete h
you should've mentioned in the video's descriptions that this is for Excel 365 instead of just Excel... because not everyone has 365...
We do have videos from Excel 2016 to Excel 365 on our channel
Still can’t understand the importance of multiple sorting
This article may help: www.solveyourtech.com/how-to-sort-multiple-rows-and-columns-in-excel-a-step-by-step-guide/#:~:text=Sorting%20multiple%20rows%20and%20columns%20in%20Excel%20is,can%20lead%20to%20clearer%20insights%20and%20better%20decision-making.
Hottie❤❤❤😊😊😊😘😘😘😘🥰🥰🥰🥰
👍
Hindi me shikha
👍
What tf
Great tutorial for Excel, thanks Joe!
Glad you enjoyed it!