I used Excel from the time it became available in 1985, and retired 3 years ago. I grinned through this entire video because I've used these methods so often they became second nature. Alas, I don't get to use it anymore [and I loved it] but will check out your other videos anyway. Am sharing with a former coworker who I taught a few of these to. Boy I miss using this program....I'll just watch you when I need a dose of Excel fun because that's how I looked at it - using it was an absolute blast. Thanks for sharing, very well done!!!!!
This guy is way above what I can do in Excel. Respect. For finding a number above a certain value, I simply highlight the column and hit Sort. At the value needed, I highlight in ascending or descending order. This is an awesome video by a true expert. Excel is far more powerful than most of us understand. Thanks!
💥 EPISODE #2 is now out - Watch it here - ruclips.net/video/DMxQsjF3yJY/видео.html Who wants episode 3 of this? 🙋♂🙋♀ Like and comment with your suggestions.
Great video on so many levels! Perfect pace! Perfectly clear! Easy to follow! Humour is great (not over done, not under done)! You sir, are a genius and a great communicator! Keep them coming!
Conditional formatting slows down the excel sheet by a lot when you are working on huge data. Instead, if you want to delete use "Remove Duplicate". If you want to know the duplicates then add a column next to the data and use "Countif" condition. Wherever there are duplicates you will get the count more than 1. This way the excel file will not add unwanted size and lag the file.
I like the "remove duplicate option", but disagree on CF. Unless you apply CF over 100,000s of rows, it shouldn't slow the file down. If anything, the COUNTIF() trick might actually be slower than CF.
If you don't have Excel 365 (or 2021) you won't be able to use the SEQUENCE function to generate the numbers 1-100. Instead, you can use this formula: =ROW(1:100)
As far as i know you dont even need any formula to do that. Just fill like 3 rows with numbers in the sequence you want (like 1,2,3) select all of them and drag it down like a formula. Excel automatically tried to predict your sequence and gives you the numbers.
Absolutely LOVED the fact that I was learning this to impress the boss. Put me in the PERFECT mindset to absorb the information and put it to use. Thank you!!!
This was very helpful!! Thank you!! Would you please provide another video on pivot tables with a little more detail on how to use them but for VERY new Excel beginners.
Super Chandoo.....Simple and very effective...even the presentation is awesome...All I need to know simple techniques like these to manage our daily business needs..I am Kishore working in a Pharma Sales & Marketing ,no computer literacy but able to see benefits from videos such as these...thanks once again 👏
Hi Chandoo, as always, your videos are simply amazing. Love the boss vs. you videos as it's a form of storytelling rather than the usual way of demonstrating the features.
I am following Chandoo dilligently around year and a half now, and I can note that the content growth is amazing and inspiring since i am learning a lot myself. The adjastability to consumer needs is up to date, easy to follow, adjuatable to feedback. Me vs Boss trend is greatly done, the format is nice, i would suggest since this is a tik tok 🫰 format to try to reduce the length as much as possible, not necessarily in minutes (i would suggest 4-5min top) and just divide the content to include up to 3 ideas in one video. For example I would cut this video in formatting tips, and adding blank rows,2nd one for reports pivot tables and adjusting charts in another sheet and a third one for dates in excel or the sequence formula. This is my pov as the new generation wants everything in seconds and i think thats the target audience for this series. Lots of 💕
Thanks Tina for that comment. I am always experimenting with content format, length and topic coverage. My analytics tells me that 5-10 minutes is the sweet spot. Shorter videos can't cover anything in depth or breadth. Earlier I tried 3 tips in 3 minutes video, but the response is nowhere near as good as what this video got. As always, I am running the do → learn → change a bit → do again cycle.
@@Dyanosis not necessary if for an example infinite set of them are duplicate in functionality with a finite set of them and the remaining functionally is bound to a finite set.
Watch this space: casual joke in youtube comment leads to 2022 Fields Medal winning theorem of infinite numbers and at a more practically useful level removes Excel row liimit problem.
Holy moly, this is great. Such small things we do on a daily basis can surely add up but with these excellent tips my work has become quicker, easier and less stress on my fingers. Another priceless tutorial. Thank you, sir!
OMG I learned something really new today! Thank you so much. I am taking classes in BA but the lectures are so dull. I was thinking it was me who has a problem but watching this video proved that learning can be very interesting.
There is an alternative for SEQUENCE. Just fill in the first two cells, select both cells and drag (lower right corner of the selection) down. Excel automatically will fill in with increments choosen by the two cells. This works even with months by name (Jan, Feb .... filling in Mar, Apr ...). Btw. don't mess up numbers and strings. Allways use strings for identifiers, accounts, telephone numbers. You never sum up telephone numbers.
I was once in the same situation. That was 18 years ago. Don't give up, try learning something new everyday. Excel is a powerful tool but more often than not it is underestimated.
Perfect presentation. Your boss should be really excited having you around correcting him! Quick question: how do you apply the multile "Worksheet selection" tip on printing? As a novice I am, I set up each WS in the plot preview seperately. Thanks and keep it up :)
This was kinda.... genius!!!!!!! Such a clever way to teach - an entertaining way to set a relatable scenario from which to contextualise the benefit of the more advanced technique and then see in real time with meaningful examples how to actually do it better. 👏🤝 I'm genuinely so impressed (I mean I am that guy who loves a good excel shortcut for no particular reason anyways, but still - awesome) First video of yours I've watched. Think I'm gonna have to sub lol.
I loved this video, you came up in my recommends and i dont know why however,…. Litereally i do need help learning excel. So here is some questions. I do volunteering as a secretary/treasurer for a very small non profit group. How in excel can I input the expenses and income from donations for the balance sheet, in a way that excel does the math? So every time i have an additional item(s) added to a category i dont have to re-add everything by hand, just the program does it so i can input it into my balance sheet by category for our meetings? Oooh hey does excel have the ability to even create the printable document in category form? As in for income we have things like fundraising, grant 1, grant 2, grant 3 (we list them by source) donations, membership dues, entry fees etc and expenses we have categories like merch costs for the fundraising items we sell, coffee tea, lunches, judges, prizes, bursaries etc. we are a small organization that does a competition every year so we have categories, and some categories can have 44 items all added up together (competitor entries and then prize moneys paid out) . So on the balance sheet i want to just have the totals by category listed (like entry fees, or prize money paid out as a total) but i need the master breakdown of the whole category items for accounting oversight reasons. Like all the receipts etc. can excel do that? I am not a tech savvy person just doing volunteer work and hoping to make life easier and more accurate. Loved this video, very helpful and the way you described each thing with humour kept me awake. Otherwise i’d have glazed over and fell asleep 1 minute in. This was awesome! Thank you. :)
Haha I like this video man. Just started as a data analytics consultant for a logistics company that is stuck in the past doing everything as manually as possible. Even little tips like this will improve their efficiency 10x
I just found this channel, it's very awesome, i need excel material... thank you, this is very useful for me and also other people who are learning Excel. Thank you...
Oh, I thought this format was a joke 🤣 There really IS a boss 😂 Well, don't feel silly, boss. I graduated and I still didn't know any of these either🤣😂🤣😂 Very good video 👍🏻 This is going in my favorites!
OMG! I was doing that country pivot thing like your boss just yesterday. I need to complete the task. I'll definitely use the pivot option your showed.
Always looking for more shortcuts! Thx. Great for bosses and non bosses, because some bosses hire you for what they don’t know how to do. Unfortunately that can also mean they think their “boss-dome” means these skills are beneath them. Know your worth ❤
Listen, you are beyond awesome, thank you so much for these lessons. I'm continuously striving to enhance my Excel proficiency...and I am getting to a very exciting level now
I used Excel from the time it became available in 1985, and retired 3 years ago. I grinned through this entire video because I've used these methods so often they became second nature. Alas, I don't get to use it anymore [and I loved it] but will check out your other videos anyway. Am sharing with a former coworker who I taught a few of these to. Boy I miss using this program....I'll just watch you when I need a dose of Excel fun because that's how I looked at it - using it was an absolute blast. Thanks for sharing, very well done!!!!!
This guy is way above what I can do in Excel. Respect. For finding a number above a certain value, I simply highlight the column and hit Sort. At the value needed, I highlight in ascending or descending order. This is an awesome video by a true expert. Excel is far more powerful than most of us understand. Thanks!
💥 EPISODE #2 is now out - Watch it here - ruclips.net/video/DMxQsjF3yJY/видео.html
Who wants episode 3 of this? 🙋♂🙋♀ Like and comment with your suggestions.
love the shortcuts makes life simple. I want more.
i do
Please!!! ;D
ASAP sir
This actually suits current scenario.
I love how you combine 10 different examples in one video. Thank you for being user friendly 😀
I liked the way your covered realistic problems - boss v/s Chandoo. It gives fair comparison and absorb the learning.
Yes, some of the things your "boss" was doing...these are the same way I was doing it 🤔🙃. This video is very helpful, thank you.
Yes me too
Great video on so many levels! Perfect pace! Perfectly clear! Easy to follow! Humour is great (not over done, not under done)! You sir, are a genius and a great communicator! Keep them coming!
Liked these quick and useful tips! Won't mind seeing more of "Boss v/s Me" videos, but we know that Chandoo in himself is "Excel Boss"! 😁
Conditional formatting slows down the excel sheet by a lot when you are working on huge data. Instead, if you want to delete use "Remove Duplicate". If you want to know the duplicates then add a column next to the data and use "Countif" condition. Wherever there are duplicates you will get the count more than 1. This way the excel file will not add unwanted size and lag the file.
I like the "remove duplicate option", but disagree on CF. Unless you apply CF over 100,000s of rows, it shouldn't slow the file down. If anything, the COUNTIF() trick might actually be slower than CF.
I'm a fan of vlookup. For everything. Might be bulky (extra columns) but it works.
If you don't have Excel 365 (or 2021) you won't be able to use the SEQUENCE function to generate the numbers 1-100.
Instead, you can use this formula:
=ROW(1:100)
If you don't have Excel 365, get it!
Good one there Meni.
I also suggest using the Home > Fill > Series option to make large groups of numbers if needed in a hurry.
Good to know, thanks!
@@chandoo_
"To each his own"
I prefer one simple formula to a lengthy process: too many clicks and too much typing....
As far as i know you dont even need any formula to do that. Just fill like 3 rows with numbers in the sequence you want (like 1,2,3) select all of them and drag it down like a formula. Excel automatically tried to predict your sequence and gives you the numbers.
Absolutely LOVED the fact that I was learning this to impress the boss. Put me in the PERFECT mindset to absorb the information and put it to use. Thank you!!!
This was very helpful!! Thank you!! Would you please provide another video on pivot tables with a little more detail on how to use them but for VERY new Excel beginners.
it's more for shortcuts, not startup course imo
Super Chandoo.....Simple and very effective...even the presentation is awesome...All I need to know simple techniques like these to manage our daily business needs..I am Kishore working in a Pharma Sales & Marketing ,no computer literacy but able to see benefits from videos such as these...thanks once again 👏
I love your boss. He is doing all the work, mine would give me all of those tasks.
This video is outstanding. Thank you for the information and the humor. Great job.
Thank you! And i love your sense of humor!
Hi Chandoo, as always, your videos are simply amazing. Love the boss vs. you videos as it's a form of storytelling rather than the usual way of demonstrating the features.
Great
10 years later, and this is still something this old guy needs! Thanks Mike!!
Thanks, Sir! Exceptionally informative as always... and YES..., definitely looking forward to more of your videos in this "Boss v/s Me" format.
This is such a good way of teaching this.
0:17 you can also select all the rows by clicking Shift+Ctrl+Down arrow and Shift+Space
The approach you’ve chosen to present your material is brilliant!
I love this type of my boss presentation, real life situation examples especially as an analyst wanting to show your worth to the team.
I am a boss and I am not this awesome in Excel. I certainly wish you were in my team😀.
Awesome tips and excellent narration ❤️😁👏👏👏
You have the experience & he has the skill. This team would be formidable 👍
Wow, Junior is more talented than Boss, we do want such more videos Sir, you are God of Excel ,🙌🏻
I am following Chandoo dilligently around year and a half now, and I can note that the content growth is amazing and inspiring since i am learning a lot myself. The adjastability to consumer needs is up to date, easy to follow, adjuatable to feedback. Me vs Boss trend is greatly done, the format is nice, i would suggest since this is a tik tok 🫰 format to try to reduce the length as much as possible, not necessarily in minutes (i would suggest 4-5min top) and just divide the content to include up to 3 ideas in one video. For example I would cut this video in formatting tips, and adding blank rows,2nd one for reports pivot tables and adjusting charts in another sheet and a third one for dates in excel or the sequence formula. This is my pov as the new generation wants everything in seconds and i think thats the target audience for this series. Lots of 💕
Thanks Tina for that comment. I am always experimenting with content format, length and topic coverage. My analytics tells me that 5-10 minutes is the sweet spot. Shorter videos can't cover anything in depth or breadth. Earlier I tried 3 tips in 3 minutes video, but the response is nowhere near as good as what this video got. As always, I am running the do → learn → change a bit → do again cycle.
OMG! I love your approach. Narrative based, humorous and straight to the point! BRAVO!
Legend has it that there is an uncountably infinite number of formulas and shortcuts in Excel for doing countably many things.
If you have an uncountable amount of things, then you'd be able to do an uncountable amount of things.......................
@@Dyanosis not necessary if for an example infinite set of them are duplicate in functionality with a finite set of them and the remaining functionally is bound to a finite set.
@@sinnamanhiphop very clever reply.
Watch this space: casual joke in youtube comment leads to 2022 Fields Medal winning theorem of infinite numbers and at a more practically useful level removes Excel row liimit problem.
like a m*n matrix where n>m , infinitely many solutions.
I don't have a boss now, as I'm retired. But I would LOVE some more Boss videos - you ARE the Excel Boss!! 👍👍👍
Wonderful tutorial! So entertaining and really awesome shortcuts. Thank you!
Thanks for the video! Would definitely like to see more of these videos
Chandoo saves the day 😎 This was the best!
Holy moly, this is great. Such small things we do on a daily basis can surely add up but with these excellent tips my work has become quicker, easier and less stress on my fingers. Another priceless tutorial. Thank you, sir!
You're so welcome!
OMG I learned something really new today! Thank you so much. I am taking classes in BA but the lectures are so dull. I was thinking it was me who has a problem but watching this video proved that learning can be very interesting.
OMG...I think I am a similar boss. Thank you very much. The way you presented "You vs the Boss" is a great way to show these formulas. 👏
There is an alternative for SEQUENCE. Just fill in the first two cells, select both cells and drag (lower right corner of the selection) down. Excel automatically will fill in with increments choosen by the two cells. This works even with months by name (Jan, Feb .... filling in Mar, Apr ...).
Btw. don't mess up numbers and strings. Allways use strings for identifiers, accounts, telephone numbers. You never sum up telephone numbers.
I'm unable to understand, would you please elaborate
Awsome... Thanku for the tip
it was exciting to watch. I hope you do more videos related to boss vs employee.
This is absolutely fantastic.!! Able to get exactly what is needed for those quick fixes
Keep more like this coming!!!!!!!!!!
These are super useful, amazingly simple tips and tricks as always :)
Thanks Soumitra for the love and super 😍
Great tips. I'm pleased that I knew many of them but there were several tips new to me. Your examples were clear and you got directly to the point!
Great solutions for simple tasks. Thank you Chandoo for a nice, useful and humorous presentation.
I really like these videos Chandoo. They are very helpful, easy to follow and not too long.
Great vid !! I am a complete newbie to excel , and I have always felt very intimidated by it. Look forward to learning , thanks!!
I was once in the same situation. That was 18 years ago. Don't give up, try learning something new everyday. Excel is a powerful tool but more often than not it is underestimated.
Best Excel video EVER! Thank you for sharing 🙌🏽
Super vidéo ! Bravo pour les mises en situation réalistes 👍👍👍
Your website first and now RUclips channel has been a blessing for me
You always amaze us with very nice tips and an interesting way to memorize them
😊
Awesome tips and tricks. Bring on more. Thanks.
You have a fantastic sense of humour and your Excel skills are top notch! I will definitely be using these in the future! Thank you for this video.
Thank you Chandoo
The "show report filter pages" is mindblowing and the user case is on point, such a relatable common problem with great solution!
Perfect presentation. Your boss should be really excited having you around correcting him!
Quick question: how do you apply the multile "Worksheet selection" tip on printing? As a novice I am, I set up each WS in the plot preview seperately. Thanks and keep it up :)
Thanks a lot!!! Definitely the simplest and efficient way to become an excel expert , i used to read articles but that's it!
This was kinda.... genius!!!!!!!
Such a clever way to teach - an entertaining way to set a relatable scenario from which to contextualise the benefit of the more advanced technique and then see in real time with meaningful examples how to actually do it better. 👏🤝 I'm genuinely so impressed (I mean I am that guy who loves a good excel shortcut for no particular reason anyways, but still - awesome) First video of yours I've watched. Think I'm gonna have to sub lol.
These are very helpful for day to day excel workings. Analyse Pivot Table One was awesome👍🏻👌🏻
Mind blown Chandoo. Never studied Excel, but about to head into a role all your tips will be useful for. Time to level up.
I appreciate the simplicity of all of this
This was super creative and a great approach. Looking forward to Part 2
Thank you so much for showing new tricks! This videos format is wonderful! Please make more.
Legend has it His boss has resigned after watching this video 😂
😂😂
Thanks chandoo... it is indeed helpful.... please continue posting Boss videos
You are master of Excel , as always your videos are very helpful
I've been following you for many years and have learned a great deal. Thank You
Sensational video. Well done and very informative.
I loved this video, you came up in my recommends and i dont know why however,…. Litereally i do need help learning excel. So here is some questions.
I do volunteering as a secretary/treasurer for a very small non profit group.
How in excel can I input the expenses and income from donations for the balance sheet, in a way that excel does the math?
So every time i have an additional item(s) added to a category i dont have to re-add everything by hand, just the program does it so i can input it into my balance sheet by category for our meetings?
Oooh hey does excel have the ability to even create the printable document in category form? As in for income we have things like fundraising, grant 1, grant 2, grant 3 (we list them by source) donations, membership dues, entry fees etc and expenses we have categories like merch costs for the fundraising items we sell, coffee tea, lunches, judges, prizes, bursaries etc.
we are a small organization that does a competition every year so we have categories, and some categories can have 44 items all added up together (competitor entries and then prize moneys paid out) . So on the balance sheet i want to just have the totals by category listed (like entry fees, or prize money paid out as a total) but i need the master breakdown of the whole category items for accounting oversight reasons. Like all the receipts etc. can excel do that?
I am not a tech savvy person just doing volunteer work and hoping to make life easier and more accurate.
Loved this video, very helpful and the way you described each thing with humour kept me awake. Otherwise i’d have glazed over and fell asleep 1 minute in. This was awesome! Thank you. :)
The show filters report option on the pivot table is a game changer for me!! Thanks!!!
Thank you for the humor and great teaching!!
I'd like to watch more of this,... truly informative.
Haha I like this video man. Just started as a data analytics consultant for a logistics company that is stuck in the past doing everything as manually as possible. Even little tips like this will improve their efficiency 10x
Awesome video gentlemen. The comparing two lists for duplicate values is one I'll definitely use. Much appreciated.
Thanks! So glad that I found this AWESOME video. Absolutely amazing, quick and easy instruction. Thanks!!
I just found this channel, it's very awesome, i need excel material...
thank you, this is very useful for me and also other people who are learning Excel.
Thank you...
Good presentation of alternatives for using Excel. Thanks.
Very supportive. Thank you for your initiative
thank you for a simple wording and for your way of teaching.
These are powerful tips and tricks. This will make my Excel escapades flourish.
Oh those bosses, we wouldn't learn so much without therir nonsense... thank you for sharing your knowledge!!
Thanks really helpful approach!
Funny too. Keep posting more time savers.
Subscribed immediately after watching the video. 👏🏻👏🏻👏🏻 Thank you so much ❤️
Welcome!!
Chandoo, you are doing God's work. Thank you.
Oh, I thought this format was a joke 🤣 There really IS a boss 😂 Well, don't feel silly, boss. I graduated and I still didn't know any of these either🤣😂🤣😂 Very good video 👍🏻 This is going in my favorites!
OMG! I've used Excel for ages, but never really learnt it properly, thanks for the great tips!! :)
May God give you all the blessings in this world. What a saviour this guy is.
Super useful, definitely would like to see more boss vids
OMG! I was doing that country pivot thing like your boss just yesterday. I need to complete the task. I'll definitely use the pivot option your showed.
Yes Chandoo I used to watch your vids years ago learnt a lot.. I totally love the new approach.. the Boss VS THE TRUE BOSS AKA YOU CHANDU LOVE ❤️ IT
I appreciate that!
I learned new tricks in the "I saw my boss do these 10 things in Excel!". I'd like to see more. Thank you, Pat
That was fun to watch and lots of great tips. Thanks!
Thank God, you finally disclosed whom you referred to as the Boss. All this time, i was thinking who is this smarter guy in my Office... : )
A thousand thank you, sir. 😊 I could learn a lot from you.
Great video. Please share more like this, love the humor to break up a long day!
Excellent tips! Rarely use Excel, but always good to know efficient techniques for when I do.
I enjoyed 😀😀😀 the video very much and learned some important tips of MS Excel. Great 👍
Awesome!!! I was trying to learn new things but don’t want to go through schooling for this. This will help me. A lot at work.
Your videos are a big inspiration! just started out my own youtube (from my experience as a data analyst) All the best!
Best of luck!
Excellent.. your videos r so to the point and helpful.appreciate your ideas
Just subscribed to your channel. Very informative.
Excellent and straight to the point video. Love it. Thank you. You got my like and subscribe.
I’m… I’m… speechless 😶 Thank you for solving a major problem for me …in seconds! 🙇🏻♀️🙇🏻♀️
Always looking for more shortcuts! Thx. Great for bosses and non bosses, because some bosses hire you for what they don’t know how to do. Unfortunately that can also mean they think their “boss-dome” means these skills are beneath them. Know your worth ❤
Thanks....for the wonderful session
Listen, you are beyond awesome, thank you so much for these lessons. I'm continuously striving to enhance my Excel proficiency...and I am getting to a very exciting level now
Thanks for the love Nokukhanya. 😍