Hints for the homework: 1. You can use a PIVOT Report to do this. Select your tracker data, insert a pivot table. Add date to row label area, amount & boxes to values. Here is a getting started with Pivots video - ruclips.net/video/aofsdpjvK7w/видео.html 2. Select the data. Go to Sort > Custom Sort in home ribbon. Apply two level sort 3. Go to the end of the data. In the next column type = and select amount column, press / and select boxes column. Next steps after this tutorial: 1) GET MORE BASICS - chandoo.org/wp/excel-basics/ 2) LEARN DATA ANALYSIS WITH EXCEL - ruclips.net/video/v2oNWja7M2E/видео.html
sir are u sure of last hint that u gave ....because i get value error using this ....while if i do it as =sum(table1[amount])/sum(table1[boxes]) it works instead of =table1[amount]/table1[boxes] what u have to say ????????????
Hey Chandoo, I am just become your fan. If i don't want to use pivot than is there any way to get totals by date? You made awesome videos and deserve million subscribers atleast.
Sir I have a huge problem to sit and listen to videos. But your pacing, your voice, the way you teach and everything has kept me focused. Thank you for the video. ❤
You are a gifted instructor, everything from your demeanor, your voice, your presentation, etc, is just so easy to follow and understand. Please continue the excel course, I learned more in 32 minutes than I have in the previous 10 videos I tried from other content creators. You rock…. Thank you Sir. MORE PLEASE….
Best excel class ever.. I just finished my crash course and really excited to finish all the videos from beginner to advance... Thank you so much for this
@Chandoo. Please continue this series. I hope you begin to cover more advanced aspects of EXCEL. This can include a more beginner to advanced tutorial using Power Pivot and also using EXCEL to compute Simple and Multiple Linear Regression.
I am battling to solve the quartile, I even tried using the quartile formula. Overall, I am really impressed with this course. Very helpful in my work environment.
This was really really helpful. The sub-total button didn't work until I converted table to range and I used it to get the amount and boxes. The sort button worked fine
Dear chandooo I have solved the homework, alsome video, Solve number 1 using pivot table, Puting the dates in rolls and amounts and boxes in the calculate session using sum 2. I used the sorting dialogue box to add two levels of sorting 3. I added a new column and calculated the amount per box by dividing the total amount by the number of boxes. I hope am correct
Thank you, Sir. This is going to make me dangerously more capable with my current evidence collecting, paternal tracking, and many other things to be managed.
Thank you so much Chandoo for this very useful session! It's really helpful, I'm going to watch and learn from your other videos! God bless you abundantly!
Chandoo You are the best man... the way you expound the concepts,seriously very clear and meticulous ....lots of love to you ...please keep up the great work. And a small request from my side can you please upload Business analyst course playlist that will be of great help to me Cheers:) Best wishes -Sathya💙
@Chandoo. Love your videos. Also a complete tutorial from Beginner to Advanced on how to prepare EXCEL Dashboards would be much appreciated. Your videos have helped me so much in learning to love and master EXCEL.
Thanks Sasitheran. I have recently done a masterclass on KPI dashboards. See it here (2+ hours) - ruclips.net/video/kU3SdT8couk/видео.html You can also join my online class for complete Excel training. Visit chandoo.org/wp/excel-school-program/ for that.
@Chandoo. There is a comment that copies my initial comment on your videos. Something sexual. I reported it but it appears to be still in the comments section. Just letting you know, that I didn’t write that comment😀
🙏 Thanks Sir God Bless You and Madam. Kindly make outdoor You n Madam videos on real-time project with important topic or concept , we all waiting to see both of you once again.
Please arrange your excel playlist from beginners to advance level one by one Iam confused which i should see first But your teaching method is beautiful
Hi Rahmatulla.. you can create such a playlist. I won't be doing it as I am not creating them in a sequence. Alternatively, you can join the Excel School program if you want to learn things in one place without distractions. Visit chandoo.org/wp/excel-school-program/
Hi thank you for the video sir, For homework questions I tried a pivot table to solve the first question Is it the correct approach? Q.1 calculate totals by each date - for amount and box columns
Thank you so much Sir your video is very helpfull for me. I want to be freelancing and there is too much data entry work. I learnt excel sheet for your videos
Thanks a million 😊 I have learnt a lot from this video, and looking forward to learn more and become Pro in Excel. 🤘 I have completed 2 homeworks, 1)Total of amounts and boxes by date. [ Pivot Table] 2) Amount per box. [ =([Amount]/[Boxes sold])] But not able to do the 3rd, i.e. Sort by date and amount. As, the dates and amounts are different, they can't be sorted at a time. Didn't find any option to do it. Please help me with this !
For q1 I used Sumif function Sumif(,,) .... Then drag this Q2. To do double sorting select entire dataset click on advance filter and then apply sorting on diff levels ) Q3.amount /boxes and drag the formula. Is my approach right for the h.w?
Chandoo rocks! I know because I teach Excel Basics and I learned a lot from him! Thanks, Chandoo!
💪😁🌴🤙
Hints for the homework:
1. You can use a PIVOT Report to do this. Select your tracker data, insert a pivot table. Add date to row label area, amount & boxes to values. Here is a getting started with Pivots video - ruclips.net/video/aofsdpjvK7w/видео.html
2. Select the data. Go to Sort > Custom Sort in home ribbon. Apply two level sort
3. Go to the end of the data. In the next column type = and select amount column, press / and select boxes column.
Next steps after this tutorial:
1) GET MORE BASICS - chandoo.org/wp/excel-basics/
2) LEARN DATA ANALYSIS WITH EXCEL - ruclips.net/video/v2oNWja7M2E/видео.html
sir are u sure of last hint that u gave ....because i get value error using this ....while if i do it as =sum(table1[amount])/sum(table1[boxes]) it works instead of =table1[amount]/table1[boxes]
what u have to say ????????????
Hey Chandoo, I am just become your fan.
If i don't want to use pivot than is there any way to get totals by date?
You made awesome videos and deserve million subscribers atleast.
@@savesoil8549 =[@Amount]/[@[Boxes Sold]]
How to do shorting?
Q2
@@luckygarg9315 use SUMIFS
Sir I have a huge problem to sit and listen to videos. But your pacing, your voice, the way you teach and everything has kept me focused. Thank you for the video. ❤
This is the best source to learn Excel. pls, continue this series. I have recently started watching your videos sir.
Thank you.
I have never seen a better ,more clear tutorial for Excel. Thank you for sharing your knowledge.
You are welcome!
You are a gifted instructor, everything from your demeanor, your voice, your presentation, etc, is just so easy to follow and understand. Please continue the excel course, I learned more in 32 minutes than I have in the previous 10 videos I tried from other content creators. You rock…. Thank you Sir. MORE PLEASE….
Wow, thank you!
"Just watched the very first video on your channel, and I absolutely loved it! I'm excited to see more!"
This video is 2yrs ago and it’s the BEST that has taught me so far! Thank you Chandoo🤗
I have not come across better teacher than you for teaching Excel skills. I am grateful to you Sir,
Thank you Chandoo,
You are the best Excel teacher I have listened to.
I am almost addicted to your Excel videos now.
Thank you
Thank you Daniel 😀
Best excel class ever.. I just finished my crash course and really excited to finish all the videos from beginner to advance... Thank you so much for this
hi, did you purchase the full course?
@Chandoo. Please continue this series. I hope you begin to cover more advanced aspects of EXCEL. This can include a more beginner to advanced tutorial using Power Pivot and also using EXCEL to compute Simple and Multiple Linear Regression.
This is the best Excel Beginners Video I have ever watched.
Please share the answers to your questions...This is the best tutorial I have ever gone thru..so please continue with the series !!
Thank you! I am 51 years old and I just got a job that requires me to use excel. This video totally got me started!
You got this!
Thanks Chandoo! Never hurts to review the basics. Always something new to learn :)) Thumbs up!!
YES!!!
I am battling to solve the quartile, I even tried using the quartile formula. Overall, I am really impressed with this course. Very helpful in my work environment.
Use excel percentile
By far , the Best place to Learn Excel...Thank you for sharing this knowledge. Blessings 🙏
One of the best channel in RUclips for Msexcel Tq sir
Thank you Sairam 😀
This is outstandingly beautiful. Thank you for taking your time to do this🙏
Hi Chandoo! I am new subscriber and already in love with your teachings method! Now,I feel that I am I right direction! Stay blessed!
This was really really helpful.
The sub-total button didn't work until I converted table to range and I used it to get the amount and boxes. The sort button worked fine
I loved the video, the way you delivered and made it. Just nailed it. So far you are the best teacher i found.❤
tysm .....i already recommended to my circle ....they r glad i did.....its so true there are no students only bad teachers 😅😅😅😅😅😅😅
Very helpful...I always recommend your channel to every excel learner.
Thanks Nirmal for the love and support. :)
You are really superb, highest teaching skills.So crystal clear concepts. Learning from basics to advance with ease.
Your teaching is completely excellent . Thank you
Homework 1: used Sumif() function
homework 2 : Sort option inside Data, selected multiple column to sort
homework 3: =amount/boxes sold
i have gone sparatly through each day by sum function (the hard way hahaha)
i used sumif after reading your comment it is better and practical
After sumif what to type?
Woah...i owe you my excel skills bro! The way you explained and the presentation is just so good and clear!! Very helpful
Dear chandooo I have solved the homework, alsome video,
Solve number 1 using pivot table, Puting the dates in rolls and amounts and boxes in the calculate session using sum
2. I used the sorting dialogue box to add two levels of sorting
3. I added a new column and calculated the amount per box by dividing the total amount by the number of boxes. I hope am correct
Thank you, Sir. This is going to make me dangerously more capable with my current evidence collecting, paternal tracking, and many other things to be managed.
Excellent!
Excellent video like always. Thank you!!
Thanks again!
Thank you so much Chandoo for this very useful session! It's really helpful, I'm going to watch and learn from your other videos! God bless you abundantly!
Dear Sir .....well explained looking forward to completing it, thanks for making it so simple ...
Thank you so much for this class! Best excel class I have ever taken!
🥳
Wow. so glad to hear that.
Thank you Chandoo I found a new inspiration to learn things by myself 🤗.
Thanks Chandoo, This is the best channel ever.
Chandoo You are the best man... the way you expound the concepts,seriously very clear and meticulous ....lots of love to you ...please keep up the great work.
And a small request from my side can you please upload Business analyst course playlist that will be of great help to me
Cheers:)
Best wishes
-Sathya💙
Thanks a lot sir, it really helps !
i am attend your screen first time, i am happy to attend this it is put more knowledge for me
Wow, this is actually fantastic. I have learned a lot today. Thank you Chandoo
@Chandoo. Love your videos. Also a complete tutorial from Beginner to Advanced on how to prepare EXCEL Dashboards would be much appreciated. Your videos have helped me so much in learning to love and master EXCEL.
Thanks Sasitheran. I have recently done a masterclass on KPI dashboards. See it here (2+ hours) - ruclips.net/video/kU3SdT8couk/видео.html
You can also join my online class for complete Excel training. Visit chandoo.org/wp/excel-school-program/ for that.
@Chandoo. There is a comment that copies my initial comment on your videos. Something sexual. I reported it but it appears to be still in the comments section. Just letting you know, that I didn’t write that comment😀
Definitely I will recommend this to my friends. Thank you sir .
chandoo sab ka bandhoo...You are amazing buddy
🙏 Thanks Sir
God Bless You and Madam.
Kindly make outdoor You n Madam videos on real-time project with important topic or concept , we all waiting to see both of you once again.
You are welcome Jagat. Thanks for your love and appreciation.
Please arrange your excel playlist from beginners to advance level one by one
Iam confused which i should see first
But your teaching method is beautiful
Hi Rahmatulla.. you can create such a playlist. I won't be doing it as I am not creating them in a sequence.
Alternatively, you can join the Excel School program if you want to learn things in one place without distractions.
Visit chandoo.org/wp/excel-school-program/
@@chandoo_ I have a problem in joining the class. It says the safari can't open the page. I really want to join your class man.
Awesome it has been great learning for all of us.
you have a very clear way of explanation I really like
Hi thank you for the video sir,
For homework questions I tried a pivot table to solve the first question
Is it the correct approach?
Q.1 calculate totals by each date - for amount and box columns
Instead use sumif
You have explained in a very good way
This is absolutely a very good video.
Hi Chandoo,
I am in love with the Tutorials, the way you simplify the formulas is amazing. Do you have any Discord where we can post our doubts?
Very informative sessions helps a lot to understand, keeps us focussed throughout the sessions
Thank you sir😊😊
Thank you so much Sir your video is very helpfull for me. I want to be freelancing and there is too much data entry work. I learnt excel sheet for your videos
Chandoo is the real deal .Thanks alot
Chandoo you are great… am glued to your channel.. am new to excel and hope to move up the scale soon…
Hi Chandoo dear many thanks i was thinking what is microsoft excel today i am learning from yours video really appriciated Waheed UK
Great bro, thanks for teaching, it's very useful for the employees who are working in an organization or in Offices , Thank you bro 💟
I cant explain chandoo how easily you explain the things in excel marvolus.
Sir ,I have watched your maximum videos . Here I request you . Please make video on "hands on peoject " how to use SQL and BI Tools.
Thank you! Excellent for beginners
Thank you Chandoo. This tutorial is so detailed.
Chandoo you are a Legend! Bless You
Awesome teaching. 💙
you are fabulous! A fantastic approach to explaining excel!
Wow, thank you!
Thank you, great beginners video
You are my favorite Teacher really Chandoo sir
Thanks Lakbay... :)
It's so easy to understand for a beginner like me .a keep it up 👍👍
Thanks a million 😊 I have learnt a lot from this video, and looking forward to learn more and become Pro in Excel. 🤘
I have completed 2 homeworks,
1)Total of amounts and boxes by date.
[ Pivot Table]
2) Amount per box.
[ =([Amount]/[Boxes sold])]
But not able to do the 3rd, i.e. Sort by date and amount.
As, the dates and amounts are different, they can't be sorted at a time. Didn't find any option to do it. Please help me with this !
In the ribbon, go to sort&filter->Custom sort, thereby adding a level you can do sorting to different columns
Thank you. The videos are very helpful.
thanks bro, I learned a lot from this video
Well articulated detail presentation .superb
Thanks for the great content!
Awesome content...I love the way you teach
Thanks Robert... :)
Sir thanks .I want this type of video a very long time. It's very helpfull for beginner.
Most welcome
I will follow you every way❤.
thanks dude ......im starting learning data analyst in your tutorial
All the best
You r the, great sir G. really appreciated
Thank you!
Hi Chandoo salute to ur wonderfull efforts....A masterpiece tutorial u hv initiated...
Amazing thanks alot❤
Best excel lecture
Nice sir 😀🙏
Thank Bhai it is really very helpful, and i really appreccite my friends for suggesting me tih channel.
This is impressive Chandoo
Thank you chandoo. your teaching is so easy to understand😉 .
Glad to hear that
Thank you sir
you're explanation was very nice, please upload more and more videos with tips and tricks.
Very helpful tutorial
For q1 I used Sumif function Sumif(,,) .... Then drag this
Q2. To do double sorting select entire dataset click on advance filter and then apply sorting on diff levels )
Q3.amount /boxes and drag the formula.
Is my approach right for the h.w?
You are the best sir
Well explained ❤
AMAZING SIR I LUB THE WAY U DELIVERING
amazing session thankyou sir...👍👍👍
Very helpful 🎉thanks a lot
really good. thank you
Very very useful video, thanks
Very nice nd controlled presentation.
amazing video!!!
new sub here..as im replicating what u do on the spread sheet im having trouble in formula and using the graph..thanks!
Thank you for this video
This is a powerful tutorial 👏👌
Glad it was helpful!