I saw my boss do these 10 things in Excel!

I saw my boss do these 10 things in Excel!

Chandoo

1 год назад

2,617,270 Просмотров

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 - https://youtu.be/k_ugshJ4wIw
Combine files with this trick - https://youtu.be/SGzegma9bdY
Combine tables with this trick - https://youtu.be/Tw7_YYQWx48
10 Copy Paste tricks in Excel - https://youtu.be/uQoRef0L5Yw
10 Data Cleaning tricks in Excel - https://youtu.be/SNVjndgWBlw
10 Formatting tricks in Excel - https://youtu.be/2pn47abZCWU

Want more? Why not join my Excel School program? As the REDBULL says, it will give you WINGS!!!
Soar here - https://chandoo.org/wp/excel-school-program/

~

CONNECT WITH ME 🔗

📺 2nd channel (in Telugu) - https://www.youtube.com/channel/UCuaf89M0Lt5pmXzaUssXHvw
📷 Instagram (for tips & behind scenes) - https://www.instagram.com/chandoo.xlsx/
🐥 Twitter (fresh updates) - https://twitter.com/r1c1
🌐 Website (1000+ articles, files) - https://chandoo.org/wp/
💡 Classes - https://chandoo.org/wp/excel-school-program/

~

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

Тэги:

#chandoo #chandoo.org #Excel #spreadsheets #microsoft_excel #excel_tips_and_tricks #Excel_tips #I_saw_my_boss_do_this #I_saw_my_boss_do_this_in_Excel #ISMBDTIE
Ссылки и html тэги не поддерживаются


Комментарии:

Abdulkadir T724
Abdulkadir T724 - 06.11.2023 11:36

hey, can you give us the data you used in the video so we can practice the steps

Ответить
Rumman Iqbal
Rumman Iqbal - 04.11.2023 12:27

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

Ответить
Seetha D
Seetha D - 31.10.2023 18:53

Hi sir I m your new subscriber

Ответить
Jack King
Jack King - 25.10.2023 23:32

To master excel...there should be degree in excel

Ответить
Tahir Waseem
Tahir Waseem - 23.10.2023 04:28

Good

Ответить
XLLearner
XLLearner - 17.10.2023 22:23

Great video. Easy to folow

Ответить
Nadia Hakime
Nadia Hakime - 15.10.2023 13:04

i have never loved a channel as much as I have loved chandoo's

Ответить
fangio92
fangio92 - 12.10.2023 09:39

don' format a whole row or column, that increases the size of the file, a lot.

Ответить
CIL
CIL - 09.10.2023 02:11

Anyone know why his sequence function doesn't populate when I enter it on Excel?

Ответить
Kim Chi
Kim Chi - 07.10.2023 03:53

Love this & would enjoy more like it! 👏

Ответить
AP FORMS
AP FORMS - 05.10.2023 22:54

If bosses are this much dumb, how they became bosses bro? 😅😅😅😅

Ответить
Scidix Reiznov
Scidix Reiznov - 29.09.2023 19:39

Ok indian. You're smart😊

Ответить
K. J. Botmang
K. J. Botmang - 28.09.2023 21:15

you're funny, and smart.

Ответить
AppOdell's MULTIMEDIA
AppOdell's MULTIMEDIA - 28.09.2023 16:57

I love this Thank you Sir

Ответить
AppOdell's MULTIMEDIA
AppOdell's MULTIMEDIA - 28.09.2023 16:57

I love this Thank you Sir

Ответить
D Chal
D Chal - 28.09.2023 04:44

Can you make video how to add gmail phone contacts to Excel address book? Saw the format to look normal to Excel address book

Ответить
Surbhi Priya
Surbhi Priya - 27.09.2023 07:50

Woderful, please share video for vlookup also.

Ответить
Marissa Ponpon
Marissa Ponpon - 24.09.2023 09:39

Thanks

Ответить
Marissa Ponpon
Marissa Ponpon - 24.09.2023 09:39

Amazing

Ответить
UDAY KUMAR
UDAY KUMAR - 19.09.2023 00:58

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

Ответить
aperson2020
aperson2020 - 16.09.2023 21:55

Why is he he the boss 🤣🤣🤣🤣

Ответить
va L
va L - 16.09.2023 12:02

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

Ответить
Osigwe Emmanuella uchechi
Osigwe Emmanuella uchechi - 16.09.2023 01:20

the insert with blank rows didnt work for me. Any help?

Ответить
Shreysanthu
Shreysanthu - 15.09.2023 23:43

My pivot table is not refreshing with newly added data .. please advise sir

Ответить
Shreysanthu
Shreysanthu - 15.09.2023 23:37

You are my boss now

Ответить
Urbansumo
Urbansumo - 14.09.2023 17:00

Awesome video thank you!

Ответить
Shingles_png
Shingles_png - 14.09.2023 10:31

1. Sequence
2. Conditional formatting

Ответить
SATENDRA KUMAR
SATENDRA KUMAR - 11.09.2023 16:02

Super 👍👍👍❤❤❤

Ответить
Truth Seeker
Truth Seeker - 11.09.2023 15:03

Excellent video. Yes I would like to see more videos like this.

Ответить
sahiti devata
sahiti devata - 10.09.2023 11:36

Hi,how can I contact you, please provide any mail or contact number

Ответить
Mostasin Maruf
Mostasin Maruf - 10.09.2023 11:33

I am a big fan of you.

Ответить
Sameer
Sameer - 09.09.2023 20:35

Boss : Calls chandoo for 1 on 1 session.
Chandoo : Giving boss 8 minutes of Tricks and tips of excel class.

Chandoo rocks....

Ответить
Gamerz HotShots
Gamerz HotShots - 09.09.2023 16:46

Thank you Chandoo Sir.

Ответить
hahahuhu
hahahuhu - 08.09.2023 20:40

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

Ответить
Greg Lozano
Greg Lozano - 08.09.2023 11:28

Makes me wish I could have the opportunity to be Chando’s boss so that I can learn. 😂

Ответить
A O
A O - 08.09.2023 02:22

Can you please create an interactive content on graph, charts e.t.c with Excel ?!

Ответить
Wood Ed
Wood Ed - 05.09.2023 12:29

your boss should have fired you for stalking him

Ответить
Clement Hlathswayo
Clement Hlathswayo - 04.09.2023 15:14

Impressive 👌🏽 😊

Ответить
panda4247
panda4247 - 02.09.2023 23:53

the first one is so wrong...
when the boss wanted to add rows for emails... the solution is not to add the rows like that.... the correct solution is not to add any rows at all, but write the emails in another COLUMN.
because how the hell would you do things like sorting, filtering, etc, if the names and emails were in separate rows in the same column....

Ответить
Michael Agyemang
Michael Agyemang - 02.09.2023 16:01

I have a list of customers and their credit. I want the payment they make in the credit cell and then that same cell will display only the remainder after I press enter.

Kindly help me with such a formula

Ответить
Leonila Bayon
Leonila Bayon - 31.08.2023 08:13

thank you sir it is really vey informative

Ответить
Mehmet Refik GUNEY
Mehmet Refik GUNEY - 31.08.2023 06:23

good job.thk

Ответить
Troy Bingham
Troy Bingham - 29.08.2023 23:41

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

Ответить
NJOROGE ANTHONY
NJOROGE ANTHONY - 29.08.2023 08:10

Even the name is fitting, Ratatouille of excel

Ответить
NJOROGE ANTHONY
NJOROGE ANTHONY - 29.08.2023 08:08

😂😂😂😂😂freaking dude is so funny....the other day this....that....etc..oh man😂😂😂😂😂

Ответить
NJOROGE ANTHONY
NJOROGE ANTHONY - 29.08.2023 08:06

Funny dude 😂❤

Ответить
ShadowLynxV
ShadowLynxV - 29.08.2023 01:48

Hah. Ive got Blacks (Range of 5). But five columns or rows.

Ответить
Vighnesh Tamse
Vighnesh Tamse - 28.08.2023 22:06

Can you please make a video on how to apply a formatting of one chart on other charts? It would really be very kind of you. Thanks in advance.

Ответить
Bitcoin_NL
Bitcoin_NL - 26.08.2023 23:39

Your boss must be really stupid 😂

Ответить
Vishal Mistry
Vishal Mistry - 26.08.2023 20:56

How to find all of these formula when i am not currently using them? I may forget this and just do manual work.

Ответить