I saw my boss do these 10 things in Excel!

At awesome chocolates, we have a boss who is not so good with Excel. So, the other day, I caught him doing this... and I had to show him a better option.
⏱ In this video:
=============
0:00 - He was adding blanks rows like this
0:32 - He was adding tracking numbers like this
1:26 - He was getting "dates" like this
2:07 - He was checking duplicates like this
2:45 - He was comparing two lists like this
3:26 - He was doing something UNBELIEVABLE
3:38 - He was setting up monthly sheets like this
4:28 - He was checking values like this
5:27 - He was making pivots like this
6:10 - He was adjusting charts like this
6:54 - He was combining data like this
😎 Be a BOSS with Excel with these videos
===================================
Don't be silly. Up your Excel game and impress the boss today. Check out these quick videos and learn something new.
Combine sheets with this trick - • AWESOME Excel trick to...
Combine files with this trick - • Powerful trick to comb...
Combine tables with this trick - • How to connect two tab...
10 Copy Paste tricks in Excel - • 10 *SURPRISING* Copy P...
10 Data Cleaning tricks in Excel - • Data cleaning in Excel...
10 Formatting tricks in Excel - • 10 Excel formatting tr...
Want more? Why not join my Excel School program? As the REDBULL says, it will give you WINGS!!!
Soar here - chandoo.org/wp/excel-school-p...
~
CONNECT WITH ME 🔗
📺 2nd channel (in Telugu) - / @data_with_chandoo
📷 Instagram (for tips & behind scenes) - / chandoo.xlsx
🐥 Twitter (fresh updates) - / r1c1
🌐 Website (1000+ articles, files) - chandoo.org/wp/
💡 Classes - chandoo.org/wp/excel-school-p...
~
No, I don't really have an identical twin as my boss.
I am my own boss as I work for myself.
Also, Jo is my boss as I married her.
#BosswithExcel

[@koalasez1200]

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!!!!!

[@canirmalchoudhary8173]

I liked the way your covered realistic problems - boss v/s Chandoo. It gives fair comparison and absorb the learning.

[@BenDC85]

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.

[@Rr77184]

Yes me too

[@Iherdit2day]

I love how you combine 10 different examples in one video. Thank you for being user friendly 😀

[@neilreid2298]

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!

[@YouMcLeaf]

Legend has it that there is an uncountably infinite number of formulas and shortcuts in Excel for doing countably many things.

[@Dyanosis]

If you have an uncountable amount of things, then you'd be able to do an uncountable amount of things.......................

[@sinnaman-dj-atrain]

@@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.

[@rodbenson219]

@@sinnaman-dj-atrain very clever reply.

[@tombowcutt4908]

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.

[@Leo-gb1mo]

like a m*n matrix where n>m , infinitely many solutions.

[@meniporat3527]

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)

[@RenierWessels]

If you don't have Excel 365, get it!

[@chandoo_]

Good one there Meni. I also suggest using the Home > Fill > Series option to make large groups of numbers if needed in a hurry.

[@skimpylemon8034]

Good to know, thanks!

[@meniporat3527]

@@chandoo_ "To each his own" I prefer one simple formula to a lengthy process: too many clicks and too much typing....

[@JuiceExMachina]

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.

[@keithdutch5295]

10 years later, and this is still something this old guy needs! Thanks Mike!!

[@healthysocieties6221]

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!

[@vijayarjunwadkar]

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"! 😁

[@cynthiahoz3948]

Chandoo saves the day 😎 This was the best!

[@noordinarytv4384]

I love your boss. He is doing all the work, mine would give me all of those tasks.

[@sushilpintoprajwal]

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.

[@chandoo_]

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.

[@juliab8992]

I'm a fan of vlookup. For everything. Might be bulky (extra columns) but it works.

[@NameLikeTheAudi]

I love this type of my boss presentation, real life situation examples especially as an analyst wanting to show your worth to the team.

[@hsudhindra]

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 ❤️😁👏👏👏

[@sp-tj9ye]

You have the experience & he has the skill. This team would be formidable 👍

[@mariafitzpatrick4596]

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.

[@renedegroot830]

it's more for shortcuts, not startup course imo

[@tarunkumargoel6737]

Thanks, Sir! Exceptionally informative as always... and YES..., definitely looking forward to more of your videos in this "Boss v/s Me" format.

[@AmanKhajanchi]

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.

[@anandsbaragali8468]

Great

[@jrsands]

The approach you’ve chosen to present your material is brilliant!

[@Hoodat_Whatzit]

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!

[@ahmeddiab305]

You always amaze us with very nice tips and an interesting way to memorize them 😊

[@NieZuSpaet]

Wonderful tutorial! So entertaining and really awesome shortcuts. Thank you!

[@SurendranNambiath]

I don't have a boss now, as I'm retired. But I would LOVE some more Boss videos - you ARE the Excel Boss!! 👍👍👍

[@kristieedwards4169]

Mind blown Chandoo. Never studied Excel, but about to head into a role all your tips will be useful for. Time to level up.

[@studymate8469]

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.

[@ManikandanRaju]

0:17 you can also select all the rows by clicking Shift+Ctrl+Down arrow and Shift+Space

[@peterlarsen4809]

I really like these videos Chandoo. They are very helpful, easy to follow and not too long.

[@antoniasalas4458]

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!

[@chandoo_]

You're so welcome!

[@jameswright4640]

This video is outstanding. Thank you for the information and the humor. Great job.

[@kishoregosukondab2743]

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 👏

[@Seftehandle]

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 💕

[@chandoo_]

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.

[@FutureCommentary1]

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.

[@gingerjones3034]

The show filters report option on the pivot table is a game changer for me!! Thanks!!!

[@adamkhan7234]

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.

[@sbatsia]

Great solutions for simple tasks. Thank you Chandoo for a nice, useful and humorous presentation.

[@720jsh]

This is absolutely fantastic.!! Able to get exactly what is needed for those quick fixes Keep more like this coming!!!!!!!!!!

[@justfelicia6671]

OMG! I love your approach. Narrative based, humorous and straight to the point! BRAVO!

[@vinaykumar-sl2ix]

it was exciting to watch. I hope you do more videos related to boss vs employee.

[@erenatis]

This was super creative and a great approach. Looking forward to Part 2

[@BakaEcchan]

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!

[@Devrat1]

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... : )

[@dragonjad]

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.

[@senpai.5517]

Thank you! I learnt some new tricks today. Looking forward to more of the boss vs. me videos. ❤

[@ApoorvaDixit1488]

These are very helpful for day to day excel workings. Analyse Pivot Table One was awesome👍🏻👌🏻

[@YashKapta]

Your website first and now KZbin channel has been a blessing for me

[@ewell7763]

Great vid !! I am a complete newbie to excel , and I have always felt very intimidated by it. Look forward to learning , thanks!!

[@alfredferreira]

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.

[@dkalambokis78]

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 :)

[@NuncNuncNuncNunc]

Excellent tips! Rarely use Excel, but always good to know efficient techniques for when I do.

[@troybingham6426]

Awesome video gentlemen. The comparing two lists for duplicate values is one I'll definitely use. Much appreciated.

[@omissj4]

These are super useful, amazingly simple tips and tricks as always :)

[@chandoo_]

Thanks Soumitra for the love and super 😍

[@sagarpatil1646]

Wow, Junior is more talented than Boss, we do want such more videos Sir, you are God of Excel ,🙌🏻

[@CH-zu7fn]

Thank you so much for showing new tricks! This videos format is wonderful! Please make more.

[@vramarathnam]

Very supportive. Thank you for your initiative

[@gailroraback2906]

This was great!!! I've made some of those same chart and your tips will save me so much time!

[@wayneedmondson1065]

Fun and informative. I vote yes for episode 2. Thumbs up!

[@PatrickOLeary-ed7nh]

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

[@rummaniqbal3255]

Legend has it His boss has resigned after watching this video 😂

[@rkalle66]

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.

[@ghulamhusnain4548]

I'm unable to understand, would you please elaborate

[@aleenaamir4355]

Awsome... Thanku for the tip

[@annebolduc6395]

Super vidéo ! Bravo pour les mises en situation réalistes 👍👍👍

[@EaZyElroy]

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

[@seditiouswalrus]

Great work, love your teaching style extremely effective.

[@SRCOMPUTEREDUCATION]

You are master of Excel , as always your videos are very helpful

[@AjayPrashar]

I enjoy all the video formats you create but this one is especially good. Excellent work. I have been using Excel since it's first release and, still, all this content was new to me. -Ajay

[@Stewalebeth]

The squeaks made my dog mental 😂

[@abel9]

Thanks a lot!!! Definitely the simplest and efficient way to become an excel expert , i used to read articles but that's it!

[@chandoo_]

💥 EPISODE #2 is now out - Watch it here - kzbin.info/www/bejne/en7bgqage5isgLs Who wants episode 3 of this? 🙋‍♂🙋‍♀ Like and comment with your suggestions.

[@rossd6416]

love the shortcuts makes life simple. I want more.

[@amaudoekong5988]

i do

[@MrMelquize]

Please!!! ;D

[@vidhinara6403]

ASAP sir

[@100DaysExile]

This actually suits current scenario.

[@northcoaster]

I've been following you for many years and have learned a great deal. Thank You

[@Zsfoodexperiments]

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.

[@bigdogbob845]

Excel is such an amazing program. I used it years ago to estimate major, multi-million dollar projects for a company I worked for in the 1990's

[@Peter-wg2nz]

I like the way you trick your boss to do your work.

[@MrRanjithm1]

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. 👏

[@primeval7504]

I appreciate the simplicity of all of this

[@mahapappan9304]

Awesome tips and tricks. Bring on more. Thanks.

[@CarinaParry]

OMG! I've used Excel for ages, but never really learnt it properly, thanks for the great tips!! :)

[@deec.3904]

Thank you for the humor and great teaching!!

[@Silverstar257]

Please make more videos of beginner friendly tips like this. Thank you, Chandoo!

[@IceColdProfessional]

These are powerful tips and tricks. This will make my Excel escapades flourish.

[@diannedrechsler4792]

Super useful, definitely would like to see more boss vids

[@davidslobod5726]

That was fun to watch and lots of great tips. Thanks!

[@rrijsdijk]

Thank you! And i love your sense of humor!

[@debbiel1228]

Thanks! So glad that I found this AWESOME video. Absolutely amazing, quick and easy instruction. Thanks!!

[@samuellewa8891]

I'd like to watch more of this,... truly informative.

[@ibugurudyah]

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...

[@PFG888]

Thanks for the video! Would definitely like to see more of these videos

[@what_s_up]

A thousand thank you, sir. 😊 I could learn a lot from you.

[@ksw4tq1]

Best Excel video EVER! Thank you for sharing 🙌🏽

[@zishansheikh6537]

I love your videos, man. There are a few things in the video where I really use to struggle. Please make more such videos. Thanks.

[@geethasundaram8217]

Thanks chandoo... it is indeed helpful.... please continue posting Boss videos

[@ahlawi1000]

Your boss is literally what we do all of us

[@m2m1992]

More of this Boss vs Chandoo videos pls!! Super helpful (and funny at the same time :p)

[@mohammedabdulwasay4641]

Thanks....for the wonderful session

[@vaL-kv6uy]

Thanks really helpful approach! Funny too. Keep posting more time savers.

[@rjs6251]

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 ❤

[@colmwhateveryoulike3240]

This is such a good way of teaching this.

[@victoriahill7218]

Loved your video. Subbed. Love the subtle humour! Cool way to learn. Thanks

[@ishowyoumyfood]

I needed to know how to do at least 5 of these within the last week. Instant like and subscribe. Thank you.

[@chandoo_]

Glad I could help!

[@sekharispassion]

Thank you for the tricks. Learned few most important and useful. ex: chart format and alignment, Sequence with text formula.

[@nokukhanyamagudulela2470]

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

[@chandoo_]

Thanks for the love Nokukhanya. 😍

[@UDAYKUMAR-il9ni]

thank you for a simple wording and for your way of teaching.

[@kawanjelitadisnakkan6610]

Your boss is must be me. Thanks for your excel work-saver tips!! :)

[@artrayus3]

I loved this. Clicked on it randomly. I learned some and was entertained at the same time. It was very concise. Well done.