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.

Want more? Why not join my Excel School program? As the REDBULL says, it will give you WINGS!!!

~

CONNECT WITH ME 🔗

~

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

[koalasez]

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

[canirmalchoudhary]

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

[Iherditday]

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

[neilreid]

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!

[chandoo_]

Who wants episode 3 of this? 🙋‍♂🙋‍♀ Like and comment with your suggestions.

[meniporat]

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)

[healthysocieties]

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!

[keithdutch]

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

[YouMcLeaf]

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

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

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

[NieZuSpaet]

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

[tarunkumargoel]

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

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

[noordinarytv]

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

[jrsands]

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

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

[ahmeddiab]

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

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

[kishoregosukondab]

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