Thank you so much for making this readily available and free. I need it for my new job, but couldn't afford to pay for a course, so you not only saved the day but also saved my new job. I'm sorry I can only offer you a modest "Thank you", but I did like the video and subscribed as well. Not to mention, I will talk about it to others. I want to help you as much as you helped me.
I'm a fresh grad wanting to pursue HR, but don't really have foundation due to poor quality education. My friend sent this to me, thank you very much! This would be a big help for me as I'm in my job hunting era. Bless such kind soul like you ❤
I have terrible patience. It took me more than a month to finish this video only. I'm glad i could finish it finally. Thank you so much for giving away these contents for free.
Hey, lots of greetings from India. Thankyou so much for providing a quality video on excel, thank you so very much Joe for providing so deep teaching in an easy way.
Sir, I can't thank you enough for this video! I've learnt so many things that are gonna make my career so easy. I really appreciate sharing these infos for free.
You're doing a great job here, thank you for dishing out this wealths of knowledge for free. But I do have a question " does it mean each time I have an excel version upgrade, I'll have to undergo a fresh training ?" I really do hope you answer me as I am so burdened by this question.
Excel for the most is unchanged from it's core for nearly a decade now. There are obviously new features and a different UX/UI but the core functions of a spreadsheet software have not changed much. Any of our videos are going to give you a solid foundation on Excel.
I want to take the opportunity to thank you for all the hard work and dedication you put into this its amazing how all this information is free thank you thank you!!!!!!
I've never used excel for some mathematics and making charts for college projects, mostly using Word or Oracle DB. Now I'm here to brush up my excel skills.
This course is the osm course i have ever got of ms excel and i decided to buy the courses online but after watching your video i get the full beginer friendly lectures here❤
There are so many Excel courses from different years on this channel. The videos and dedication is superb but it is confusing for me as a beginner on which excel courses I need to learn. Will I become good in Excel if I just follow 2024 Excel courses alone? The quality of teaching is amazing btw.
We have all versions of Excel from different office suites such as Excel 2016, Excel 2019, etc. We always recommend watching the videos for the version of Excel you use most.
Thank you so much! You may not have an idea, bu you're helping a lot of people. Thank you so much for amazing effort that you put just to teach us! Have a blessed day! Jesus loves you!
I learned 😌 💯 Excel starting in 2004 at Wake Technical Community College 😅A Mandatory Excel Project is required 👌 👍 in 🇳🇬 👌 every science and 🤓 mathematics course 😉 🎉❤
Your video is amazing. But there's a problem for me. The problem is I have the excel 2013 not the excel 2024. So, I have a question about it. "Can I do all thing the same way you are doing in excel 2024 in my excel 2013?" ( I HOPE and WISH that you will give answer of my question as soon as possible)
Core stuff like formulas and functions will work the same but there have been many improvements since then. We recommend our 2016 Excel videos to begin with in you case.
Certainly! Let’s dive into formatting totals and year-to-date (YTD) totals in Excel. Formatting Totals: When you want to display a total for a row (such as the sum of values in that row), you can use the Total Row feature in Excel. Here’s how: Create a Table: First, convert your data range into an Excel table (select your data and press Ctrl + T or go to the “Insert” tab and choose “Table”). This step is essential because it enables the Total Row feature. Activate the Total Row: Once your data is in a table, you’ll see a new row at the bottom labeled “Total.” Click the checkbox in the Total Row for the column(s) where you want to display totals. Excel will automatically calculate and display the sum, average, or other aggregate functions for those columns. Customize the Total Row: You can right-click on the Total Row cell and choose different aggregate functions (like Sum, Average, Count, etc.). Additionally, you can format the Total Row cells (font, color, etc.) to make them stand out. Calculating Year-to-Date (YTD) Totals: Now, let’s tackle YTD totals. These are cumulative sums of data from the beginning of the year up to a specific month. Here are a few methods: Using SUM Functions: Suppose you have monthly sales data in columns C (quantity sold) and D (total price). In cell E5 (for January), enter this formula: =SUM($D$5:D5)/SUM($C$5:C5) Drag this formula down to calculate YTD totals for subsequent months. Combining Functions: You can use a combination of functions like SUM, IF, MONTH, and OFFSET. For instance, if your data starts in cell B5 (with dates in column B), and prices are in column D: =IF(MONTH(B5)=1, D5/C5, SUM(OFFSET($D$5,0,0,1,1):D5)/SUM(OFFSET($C$5,0,0,1,1):C5)) This formula calculates YTD price per unit, considering the month. Using SUMPRODUCT: In cell E5: =SUMPRODUCT($D$5:D5)/SUMPRODUCT($C$5:C5) Drag down to fill for other months. Dynamic Formula for YTD Growth Rate: Compare sales data between two years (e.g., 2020 and 2021). Use SUM, OFFSET, and MATCH functions: =SUM(OFFSET(E5,1,1,1,MATCH($I$5,$F$5:$H$5,0)))/SUM(OFFSET(B5,1,1,1,MATCH($I$5,$C$5:$E$5,0)))-1 Adjust cell references as needed. Remember, Excel provides various ways to achieve the same result, so choose the method that suits your specific scenario.
This double click function of black haired arrow while taking up the sum of total sales is it accessible only to Excle 365 only or the normal one too?? Coz I'm not able to access it
To group worksheets in Excel 365 online, you can follow these steps: Right-click any worksheet tab. Click Select All Sheets. Hold down the Ctrl key and click the sheet tabs of interest one by one. To group adjacent (consecutive) worksheets, click the first sheet tab, hold down the Shift key, and click the last sheet tab. To remove a worksheet from the group, hold down Ctrl as you click the worksheet's tab.
Hello Earthell Flowers! You can access the member only version of the video here: ruclips.net/video/eQrVXQW25KM/видео.html Also you can make your own bookmarks by leaving the time stamp in the comments of the video. Example below: Search and Help 8:37
Exercise Files: learnitanytime.com/p/exercise-files-excel-beginner-tutorial-2024
I cant really access the file dont know why. Could you help me plz.
The tutorial was so profound and interesting....
Can't wait for the intermediate tutorial...
Glad you liked it!
Thank you so much for making this readily available and free. I need it for my new job, but couldn't afford to pay for a course, so you not only saved the day but also saved my new job.
I'm sorry I can only offer you a modest "Thank you", but I did like the video and subscribed as well. Not to mention, I will talk about it to others. I want to help you as much as you helped me.
You support is more than payment enough! One goal of our channel is to make sure everyone has access to software training.
Thank you. Thanks a lot.
I'm a fresh grad wanting to pursue HR, but don't really have foundation due to poor quality education. My friend sent this to me, thank you very much! This would be a big help for me as I'm in my job hunting era. Bless such kind soul like you ❤
We are glad to help! Good luck on job hunting!
I have terrible patience. It took me more than a month to finish this video only.
I'm glad i could finish it finally.
Thank you so much for giving away these contents for free.
You're very welcome!
😂😂😂
Super pure gold, this trainer is a master. Thank you so much!
You're very welcome!
Hey, lots of greetings from India. Thankyou so much for providing a quality video on excel, thank you so very much Joe for providing so deep teaching in an easy way.
You're very welcome!
By far the best, most useful course I have taken. Excellent work and thank you for the content! I'm now moving onto Intermediate and excited to learn!
You are welcome!
Sir, I can't thank you enough for this video! I've learnt so many things that are gonna make my career so easy. I really appreciate sharing these infos for free.
You are welcome!
you are a life saver man
Happy to help!
good luck man neds
These videos are very useful if you don't use the programs every day. They are always a good refresher.
Thanks!
Data Scientist is the goal...and this is just perfect🤗🤗
Thanks!
Excellent lesson! You were born to be a teacher Joe! You've got a subscriber!
Thanks!
You explained it so simply and repeated instructions which was SO helpful. THANK YOU SO MUCH
You are so welcome!
Next month I have to learn everything you teach. Thank you so much for your efforts. I hope I can do well in my job.
You can do it!
completed in 3days very much enjoyable and engaging and learnt a lot thank you.
You're very welcome!
Thank you so much for this training. It is easy to understand. Now I am not that scared anymore when I'm faced with excel at work. Thank you.
You are very welcome! We are glad we made Excel easier to use!
You're doing a great job here, thank you for dishing out this wealths of knowledge for free.
But I do have a question " does it mean each time I have an excel version upgrade, I'll have to undergo a fresh training ?" I really do hope you answer me as I am so burdened by this question.
Excel for the most is unchanged from it's core for nearly a decade now. There are obviously new features and a different UX/UI but the core functions of a spreadsheet software have not changed much. Any of our videos are going to give you a solid foundation on Excel.
I want to take the opportunity to thank you for all the hard work and dedication you put into this its amazing how all this information is free thank you thank you!!!!!!
Glad you enjoy it!
Thankyou for your kind efforts to help out the NOBODYs. This is truly priceless.
😍😄🙏
It's our pleasure
I've never used excel for some mathematics and making charts for college projects, mostly using Word or Oracle DB.
Now I'm here to brush up my excel skills.
We hope you learned everything you needed!
This course is the osm course i have ever got of ms excel and i decided to buy the courses online but after watching your video i get the full beginer friendly lectures here❤
Thanks for watching!
There are so many Excel courses from different years on this channel. The videos and dedication is superb but it is confusing for me as a beginner on which excel courses I need to learn. Will I become good in Excel if I just follow 2024 Excel courses alone? The quality of teaching is amazing btw.
We have all versions of Excel from different office suites such as Excel 2016, Excel 2019, etc. We always recommend watching the videos for the version of Excel you use most.
@@LearnitTraining Thank you
Greatest video ever shot in the history of mankind .
We think so too!
Your teaching method is wonderful. Thank you so much
You are welcome!
I must say, this is incredibly advantageous to me.
Thanks!
Thank you so much for the comprehensive videos about the Excel! It helps a loooot:)
You're very welcome!
I lied in my resume..Now I'm here..
You got this!
Same 😅
😂I was offered a position that requires this 😢and that why I’m here help us lord learn this stuff!
LOOOOOOOOOOOOL SAME. WISH YOU ALL THE BEST
@@jNICE5600 🤣🤣🤣May God help us
Best teaching methodology so far …thank you
Glad you think so!
Thank you, i got new knowledge here
Glad to hear that
Really got a lot out of this course, Joe! Thanks
Glad it was helpful!
Good day. Very wonderful and insightful video😊. I'm looking forward to the rest. But I'm not able to open the exercise files.
Hello! We just tested the link and files they are currently working
Thank you so much! You may not have an idea, bu you're helping a lot of people. Thank you so much for amazing effort that you put just to teach us! Have a blessed day! Jesus loves you!
You are very welcome!
wow for the first time i watched a full video🥰
Congrats!
Best trainer tht i ever have
Thank you for the kind words!`
I realy appreciate your video. It is very clear and helpful. I will wacth it again and again and start practice. Thank you to much. Be blessed.
Glad it was helpful!
Thanks , I have learnt a lot
You are very welcome!
Great tutorial Joe..... Gonna check out some of your others......
Wow perfect teaching with understanding
Glad you think so!
The best excel beginners course
This tutorial was very explanatory and helpful.
Glad it was helpful!
Thank you for making this vedios. This is very helpful my job. Again ..thank you so much.
You're very welcome!
I learned 😌 💯 Excel starting in 2004 at Wake Technical Community College 😅A Mandatory Excel Project is required 👌 👍 in 🇳🇬 👌 every science and 🤓 mathematics course 😉 🎉❤
We hope you learned even more in this course!
@@LearnitTraining 🏫 👨🏫 🚸 🎒 🏫 👩🏫 🚸 🎒 🏫 🤓 😎 🆒️
so detailed, I loved it. I feel like a pro for beginners
Glad it was helpful!
you trained very well thanks a lot .
You are welcome!
Thank you so kindly, Joe. This video has helped me so greatly.
You are very welcome
Incredible video! Thanks for the help!
Glad it helped!
Thank you so much for your informative and excellent presentation.
You are very welcome!
This has helped me greatly, thank you!
Thank you for fantastic courses that I can comprehend!
You're very welcome!
This is wow.
It kept me awake till 3am 😂
Thanks so much Joe
Glad you enjoyed it!
Thank you very for this excellent presentation
Are there any additional exercises on your site or only courses and certifications ?
Thank you
We have 60 more videos on Excel you can enjoy here: ruclips.net/p/PLoyECfvEFOjbdwpIOtm_8PFzB_CPAD2_H&si=bbWKVzXXMRlnvOiJ
Your video is amazing. But there's a problem for me. The problem is I have the excel 2013 not the excel 2024. So, I have a question about it. "Can I do all thing the same way you are doing in excel 2024 in my excel 2013?"
( I HOPE and WISH that you will give answer of my question as soon as possible)
Core stuff like formulas and functions will work the same but there have been many improvements since then. We recommend our 2016 Excel videos to begin with in you case.
Very easy to learn from Joe
We hope all our instructors are easy to learn from!
Completed this tutorial and I really Like it.
Thanks!
boom, you are amazing Joe. Thank You So Much
You are welcome!
Wow that was so helpful thanks brother
No problem 👍
So helpful, thank u buddy! Keep it up!
Thanks, will do!
tysm for this amazing Tutorial!
Happy to help!
WoW....Very Helpful Tute....Thanks.
You are very welcome!
Excellent, I'm enjoying this lesson
Glad to hear that!
THis has been very helpful ,Thanks
You are very welcome!
Very good 👏
Thanks!
Blessings from the heart......
You are welcome!
Do you have a video for how to format a total and year to date total for a row?
Certainly! Let’s dive into formatting totals and year-to-date (YTD) totals in Excel.
Formatting Totals:
When you want to display a total for a row (such as the sum of values in that row), you can use the Total Row feature in Excel. Here’s how:
Create a Table:
First, convert your data range into an Excel table (select your data and press Ctrl + T or go to the “Insert” tab and choose “Table”).
This step is essential because it enables the Total Row feature.
Activate the Total Row:
Once your data is in a table, you’ll see a new row at the bottom labeled “Total.”
Click the checkbox in the Total Row for the column(s) where you want to display totals.
Excel will automatically calculate and display the sum, average, or other aggregate functions for those columns.
Customize the Total Row:
You can right-click on the Total Row cell and choose different aggregate functions (like Sum, Average, Count, etc.).
Additionally, you can format the Total Row cells (font, color, etc.) to make them stand out.
Calculating Year-to-Date (YTD) Totals:
Now, let’s tackle YTD totals. These are cumulative sums of data from the beginning of the year up to a specific month. Here are a few methods:
Using SUM Functions:
Suppose you have monthly sales data in columns C (quantity sold) and D (total price).
In cell E5 (for January), enter this formula:
=SUM($D$5:D5)/SUM($C$5:C5)
Drag this formula down to calculate YTD totals for subsequent months.
Combining Functions:
You can use a combination of functions like SUM, IF, MONTH, and OFFSET.
For instance, if your data starts in cell B5 (with dates in column B), and prices are in column D:
=IF(MONTH(B5)=1, D5/C5, SUM(OFFSET($D$5,0,0,1,1):D5)/SUM(OFFSET($C$5,0,0,1,1):C5))
This formula calculates YTD price per unit, considering the month.
Using SUMPRODUCT:
In cell E5:
=SUMPRODUCT($D$5:D5)/SUMPRODUCT($C$5:C5)
Drag down to fill for other months.
Dynamic Formula for YTD Growth Rate:
Compare sales data between two years (e.g., 2020 and 2021).
Use SUM, OFFSET, and MATCH functions:
=SUM(OFFSET(E5,1,1,1,MATCH($I$5,$F$5:$H$5,0)))/SUM(OFFSET(B5,1,1,1,MATCH($I$5,$C$5:$E$5,0)))-1
Adjust cell references as needed.
Remember, Excel provides various ways to achieve the same result, so choose the method that suits your specific scenario.
The best video!!😊👌🏼
Thanks!
Can I learn spreadsheet basics for “pages” on Mac with this video?
Yes
Sure can!
@@LearnitTraining awesome, thank you 🙏
@@ramsyrama thanks for your reply…👍
Excellent
Thank you!
THANK YOU SO MUCH!
You're welcome!
Really helpful
👍💯
Did anyone else wake up to this
Big thanks. so useful.
Glad it was helpful!
Content is awesome Thank you so much
Glad you enjoy it!
Thank u a lot that really helped me✨
You are very welcome!
thank you so much
You're welcome!
This guy seems to be head over heels in love with Excel... Quite a lunatic!
Excel is great!
Thank you very much.
You are welcome!
So helpful. Thanks alot
You are welcome!
pls can you send the link for the functions ,but the one that belongs to you, not the google one🙏🙏
Thank you.
You're welcome!
Excellent Training!! Thank You!
You're very welcome!
Thanks!
Thank you so much for your support! It helps us continue to make new videos for everyone each Friday!
Thank you so much!! I wish i know your channel earlier.
You are very welcome!
Thank you🙏🏼💙
You are so welcome
loved it
Thanks!
hi sir, mine doesn't have custom view. where can i get it
It would be even better if you could give learners a certificate just to have it documented that they have the skill
You can earn certificates at www.learnitanytime.com
This double click function of black haired arrow while taking up the sum of total sales is it accessible only to Excle 365 only or the normal one too?? Coz I'm not able to access it
This was recorded using Excel 365 so if you are using a different versions there may be some variations
@@LearnitTraining Ohh alright I think I'm not having the 365 version
is it certified like can i put it in my cv when it done?
how do you group worksheets in excel 365 online?
To group worksheets in Excel 365 online, you can follow these steps:
Right-click any worksheet tab.
Click Select All Sheets.
Hold down the Ctrl key and click the sheet tabs of interest one by one.
To group adjacent (consecutive) worksheets, click the first sheet tab, hold down the Shift key, and click the last sheet tab.
To remove a worksheet from the group, hold down Ctrl as you click the worksheet's tab.
Hi,
Can i follow along with Excel 2016?
We have Excel 2016! ruclips.net/video/tuk99Sgc6Fw/видео.html
@@LearnitTraining Okay thanks
great
Thanks!
Sal boshqacha misollar bilan tushuntira olasizmi?
Keyingi safar ko'proq misollar keltiramiz
How do i bookmark the page i am on without having to start from the beginning? I am already paying 1.99/month.
Hello Earthell Flowers! You can access the member only version of the video here: ruclips.net/video/eQrVXQW25KM/видео.html
Also you can make your own bookmarks by leaving the time stamp in the comments of the video.
Example below:
Search and Help 8:37
Is it just me or average function on 48:32 doesn't make sense regarding analysis?
How to dowload crack version? The free version is not allowing me to do stuff like add pictures,custom layout.
Please can you share the link
29:00
👍
2024 just discovered this
Hope it helps!
16:05
👍👍
Microphone is so bad :(
Noted!