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'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.
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.
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 learned 😌 💯 Excel starting in 2004 at Wake Technical Community College 😅A Mandatory Excel Project is required 👌 👍 in 🇳🇬 👌 every science and 🤓 mathematics course 😉 🎉❤
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
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.
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.
@@LearnitTraining Hi, Joe! I tried to make changes in several sheets, first by grouping them. And holding ctrl key but it didn’t work(((( Do you know why?
Hello Earthell Flowers! You can access the member only version of the video here: th-cam.com/video/eQrVXQW25KM/w-d-xo.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 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
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.
completed in 3days very much enjoyable and engaging and learnt a lot thank you.
You're very welcome!
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!
Greatest video ever shot in the history of mankind .
We think so too!
These videos are very useful if you don't use the programs every day. They are always a good refresher.
Thanks!
Incredible video! Thanks for the help!
Glad it helped!
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!
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
The tutorial was so profound and interesting....
Can't wait for the intermediate tutorial...
Glad you liked it!
You explained it so simply and repeated instructions which was SO helpful. THANK YOU SO MUCH
You are so welcome!
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!
Big thanks. so useful.
Glad it was helpful!
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!
Best trainer tht i ever have
Thank you for the kind words!`
The best video!!😊👌🏼
Thanks!
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!
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!
Thank you for making this vedios. This is very helpful my job. Again ..thank you so much.
You're very welcome!
Thank you so kindly, Joe. This video has helped me so greatly.
You are 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 🏫 👨🏫 🚸 🎒 🏫 👩🏫 🚸 🎒 🏫 🤓 😎 🆒️
The best excel beginners course
Really got a lot out of this course, Joe! Thanks
Glad it was helpful!
so detailed, I loved it. I feel like a pro for beginners
Glad it was helpful!
Very easy to learn from Joe
We hope all our instructors are easy to learn from!
This tutorial was very explanatory and helpful.
Glad it was helpful!
Thank you so much for your informative and excellent presentation.
You are very welcome!
Thank you for fantastic courses that I can comprehend!
You're very welcome!
This has helped me greatly, thank you!
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
WoW....Very Helpful Tute....Thanks.
You are very welcome!
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.
tysm for this amazing Tutorial!
Happy to help!
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.
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.
Wow that was so helpful thanks brother
No problem 👍
Thanks!
Thank you so much for your support! It helps us continue to make new videos for everyone each Friday!
This is wow.
It kept me awake till 3am 😂
Thanks so much Joe
Glad you enjoyed it!
Thank you, i got new knowledge here
Glad to hear that
Completed this tutorial and I really Like it.
Thanks!
great
Thanks!
Thank you🙏🏼💙
You are so welcome
This guy seems to be head over heels in love with Excel... Quite a lunatic!
Excel is great!
Really helpful
👍💯
Excellent, I'm enjoying this lesson
Glad to hear that!
So helpful. Thanks alot
You are welcome!
So helpful, thank u buddy! Keep it up!
Thanks, will do!
THis has been very helpful ,Thanks
You are very welcome!
Content is awesome Thank you so much
Glad you enjoy it!
Hi,
Can i follow along with Excel 2016?
We have Excel 2016! th-cam.com/video/tuk99Sgc6Fw/w-d-xo.html
@@LearnitTraining Okay thanks
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: th-cam.com/play/PLoyECfvEFOjbdwpIOtm_8PFzB_CPAD2_H.html&si=bbWKVzXXMRlnvOiJ
Thank u a lot that really helped me✨
You are very welcome!
Thank you.
You're welcome!
Can I learn spreadsheet basics for “pages” on Mac with this video?
Yes
Sure can!
@@LearnitTraining awesome, thank you 🙏
@@ramsyrama thanks for your reply…👍
Thank you so much!! I wish i know your channel earlier.
You are very welcome!
Excellent Training!! Thank You!
You're very welcome!
Is it just me or average function on 48:32 doesn't make sense regarding analysis?
I didn’t lie in my resume and yet I’m here 😅thank you for your videos. Great 🫶🏽👍
You’re welcome 😊
@@LearnitTraining Hi, Joe!
I tried to make changes in several sheets, first by grouping them. And holding ctrl key but it didn’t work((((
Do you know why?
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: th-cam.com/video/eQrVXQW25KM/w-d-xo.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
16:05
👍👍
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
does anyone here like kfc?
cuz i do
and.....
KFC is great~!
u actually teach well but you are lowkey making me sleep you speak tooooooooooooo wlow xD
🤟
🙌🙌🙌🙌🙌
Really helpful
Glad it helped