50 things you didn't know Excel can DO 💡

Рет қаралды 258,611

Күн бұрын

💥 Get ready to be surprised and amazed.
👉 FREE Excel + Power BI tips newsletter - chandoo.org/wp/subscribe
Here are the 50 things you didn't know Excel can do.
0:00 - 50 Advanced Excel Tips & Tricks
0:34 - Duplicate file quickly
0:54 - Adding buttons to QAT
1:31 - Move QAT below
1:40 - Make your own list in Excel
2:39 - GPS in Excel
3:12 - Clipboard Tool
3:50 - Pin files to quickly access them
4:13 - Excel defaults to one sheet
4:45 - Change Excel color
5:14 - One shortcut to rule them all
5:53 - Top 10 filter
6:08 - Sort by more than one column
6:43 - Screenshots / screencaps in Excel
7:44 - Hide things with ;;;
8:34 - Rotate text in cells
8:49 - Select just numbers
9:22 - New line in a cell
9:42 - Find and highlight all matching values in one go
10:37 - Navigator (birds eye view of Excel workbook)
11:31 - Data from picture
12:52 - TAKE function (Excel 365)
13:32 - Edit formula ranges quickly
14:07 - Move help text away
14:19 - Unique function (Excel 365)
14:50 - Image in cell (Excel 365)
16:32 - Formulatext function
16:50 - Debug formulas with F9
17:26 - Formula result tooltip (Excel 365)
17:40 - Reverse formula with goalseek
18:26 - Excel.new for new files
19:07 - Recommended pivots
19:27 - Move pivot fields / row labels
19:40 - Hide the + buttons in pivot tables
19:54 - Multiple pivots with one click
20:30 - Slice those pivots
20:53 - Sort pivot table field list
21:12 - Distinct count in pivots
21:41 - Median in Pivots (with DAX)
22:25 - Set your own Pivot Table defaults
23:10 - Hide items in chart easily
23:33 - Filters & charts
24:02 - Dynamic chart titles
24:32 - Emoji 😍😅😻 in Charts
25:04 - Tiny charts with sparklines
26:09 - Images in charts 🖼
26:49 - Negative values in a different color chart
27:38 - Combo charts
28:16 - Adjust chart range with mouse
28:54 - Recommended charts
29:26 - 50 is a lot!!!
📺 MORE TIP COLLECTIONS
========================
Like this video? You are going to LOVE these videos too.
30 Advanced Excel Tips & Tricks - • Top 30 *Advanced* Exce... (300k+ views)
5 Amazing Conditional Formatting Tricks - • 5 Conditional Formatti... (140k views)
5 Advanced Tips on IF formula - • 5 Advanced Tips on how... (140k views)
10 things my boss was doing in Excel - • I saw my boss do these... (2.3 mn views, that is right, 2.3 mn!)
10 things you thought Excel couldn't do - • 10 things you thought ... (100k views)
10 Copy Paste Tricks - • 10 *SURPRISING* Copy P... (200k views)
Data Cleaning - 10 tips - • Data Cleaning in Excel... (300k views)
10 More Data Cleaning tricks - • Data cleaning in Excel... (450k views)
AI in Excel - 5 AWESOME Features - • 10x your productivity ... (380k views)
~
#excel #exceltips #doyouknow
~
Why can't Excel ever marry?
It is waiting for the exact MATCH() 🤣

Пікірлер: 173

@SanjuShresthaSsanjy 9 ай бұрын

Great tips Chandoo... I've one to share. At 10:16 we can tick "Match entire cell contents" option in the search box to limit our search to 600 or whatever value we want 😉

@chandoo_ 9 ай бұрын

That is a great suggestion. It occurred to me only after I finished the recording. 😀

@markus_aurelius_888 9 ай бұрын

Good call👍

@periwinkletinkle7371 9 ай бұрын

@@chandoo_what was the difference between count and distinct count? Thank you :)

@rtshort 8 ай бұрын

@@periwinkletinkle7371Count will count every instance added together. Distinct Count only counts things 1 time.

@sairasiddiqua3083 7 ай бұрын

😅😂😂😅😅

@beexcellent8428 9 ай бұрын

Wow, that was powerful! I thought I was a geek in Excel, but I am humbled with this tutorial. That was eye opening!

@senpai.5517 9 ай бұрын

Thank you, Chandoo! I learnt a lot from your video today, as usual, and each time I watch one of your videos, I am reminded about how little I know about these Excel tricks. Looking forward to more of these.👏

@Learning_to_Excel 8 ай бұрын

Love the video Chandoo! Particularly like the part about the Invert if Negative function, it's a great tool for improving the optics of you Excel Bar Chart!

@SanjayGore 8 ай бұрын

To watch your videos on excel have been a wonderful experience always. The way you explain the ideas is awesome. I never feel that I am learning instead it is always an entertainment without losing the aspect of learning. Great work indeed.

@kimbralenkaregina 8 ай бұрын

Mind blown ! Thank you for all those tips ! You made this video so fun that my colleagues sitting next beside me in the bus is starting to think I’m bizarre smiling over an excel sheet

@jinwang562 9 ай бұрын

The Median function in Pivot table is very helpful, of course along with other tips; thank you!

@alexrosen8762 9 ай бұрын

Excellent and a very useful tutorial 👌

@lakshmikanth9615 8 ай бұрын

Thank you @chandoo your tricks are super helpful❤

@rajendrasalvi6197 9 ай бұрын

Amazing and Helpful ❤

@Spreadsheets_Plus 7 ай бұрын

Thanks Chandoo. I really love this especially the custom sort function

@chrism9037 9 ай бұрын

Very useful Chandoo, this was great!

@deepakcitm 9 ай бұрын

Good examples and excel tricks 😊

@unnikrishnansanthosh 9 ай бұрын

superb one, thanks for sharing

@realaccount2000 8 ай бұрын

Great video, man! I found this to be very helpful!

@user-qf2on8vv3l 8 ай бұрын

You have really added value to my life with theses great knowledge acquired from from various teachings. God bless you.

@kirant96 9 ай бұрын

Thank you chandoo sir. Well spent half an hour.😀

@taizoondean689 9 ай бұрын

Thank you 🙏 sir .... sincerely appreciated 🙏.God bless you 😊

@yhharishadyar7843 9 ай бұрын

Very useful video thanks sir

@gregofthelake 8 ай бұрын

OMG! Tip 31 getting data from pictures is going to be such a time saver for me. I get so many e-mails with screenshots of data I have to put into Excel to work with. I didn't know this trick. Thanks for saving a bit of my sanity.

@TwinAna 9 ай бұрын

Great! Thank you so much! You are Blessed to Bless Others to "Become Awesome!"🤗🙏

@mallilkarjunyolabhavi9736 9 ай бұрын

It was a very interesting one, I loved it🎉

@SRCOMPUTEREDUCATION 9 ай бұрын

Your videos are always awesome

@yohannaagbanaji8012 9 ай бұрын

Awesome Mr Chandoo! But can you attached this data set for easy practice pls? It's beautiful presentation.

@Azhar_Khan383 9 ай бұрын

Amazing,mind blowing, excellent, awesome. Thanks Sir

@BRIGHTONWAMBURA 21 күн бұрын

And finally i recognize that your a really Chandoo

@rajgorantla6577 8 ай бұрын

Simple superb your video's more helpful and easy to understand, thanks

@YashKapta 9 ай бұрын

Thanks a lot Chandoo! So many years of your help has made me good with Excel.

@chandoo_ 9 ай бұрын

You are most welcome

@techkdeva8587 8 ай бұрын

Very Nice video, and very useful 🥰

@shark52277 9 ай бұрын

Chandoo is still the best!

@MuraliAnanthakrishnan 9 ай бұрын

Loved the "Like" and "Subscribe" pitch 🙂

@vipuljhaveri3884 9 ай бұрын

u r amzing like videos inside making learning a real joy thanks a lot for sharing your brilliance with all of us chandoo ji

@besttek109 7 ай бұрын

Those were useful tricks, i appreciate.

@DataAnalyticsFor21stcent-ik1dk 8 ай бұрын

Thank you, my teacher. I have learnt a lots under your tutelage

@iqtidarh 2 ай бұрын

Thanks Chandoo. I work on a lot of data and charts for reporting and I particularly liked that we can insert images and emojis in charts. Thank you.

@vetonzeqiri 9 ай бұрын

This dude is the god,u earned a sub!

@sohailarshad426 9 ай бұрын

thank you Sir , your easy and clear style makes it a pleasure to learn . I have a problem , I have Office 2021 , but could not locate Navigation pane in it , yes its not there in either the View tab or in any tab .. if its hidden somewhere ..can you help locate it ... again I have office 2021

@kacperbardecki3671 4 ай бұрын

Learned a lot, thank you!

@vinodlakshmanan3869 9 ай бұрын

Thanks for making this video GOAT 😎😎😎

@jesuscepedasantana2480 9 ай бұрын

Eres genial, saludos desde Venezuela

@coolbreeze1913 7 ай бұрын

Chandoo is very smart!

@ShayanAsim 8 ай бұрын

Chandoo, I enjoy your videos and I have subscribed too! Also, sending this video to my brother who might find loads of these things useful too.

@infaziqbal44 6 ай бұрын

Great video Chandoo!

@vikramveersingh9124 8 ай бұрын

2:14 use custom list

@Jeevaji14 9 ай бұрын

Chandoo is the best in the business ❤❤❤

@yashrsingh Ай бұрын

Thank you for sharing this video

@amalagovindasamy7233 9 ай бұрын

Happy Independence day. Its very useful one.

@bijaytanty8434 9 ай бұрын

Thanks 👍👍👍👍

@user-gd7wl2ix8t 4 ай бұрын

These are all great tips. I need this is written format for reference.

@sf9530 9 ай бұрын

Excellent video. I've learned so much from it. I didn't know about the formulatext function. I always have trouble when I try to copy a formula and make it a text format. The formulatext function works great. Thanks.✅

@chandoo_ 9 ай бұрын

Glad it was helpful!

@excel4acc 7 ай бұрын

Many thanks for these tricks

$@frachiar4444$

@frachiar4444 9 ай бұрын

About 39 (sort multiple key) I suggest a faster way: sort on reverse order. E.g. to order by Person and Sales, just order by Sales THEN by Person.

@chrisouellet2832 6 ай бұрын

Chandoo - I've always landed on your solutions for complex Excel tricks... you are one of the best! I should of hit that Subscribed a long time ago! -Done!

@danielleshelbourne220 9 ай бұрын

Oh WOW, #41 is sensational too! 🤩

@joseescobar9031 8 ай бұрын

🤓Thanks Chandoo

@danielleshelbourne220 9 ай бұрын

We have a winner! #22 🏆 👏 🥂 🍾

@PrinceDziwornu 8 ай бұрын

Just subscribed to your channel.

@ksvikas5 8 ай бұрын

your trick worked and now i m your subscriber 😅

@arvindr2101 9 ай бұрын

Happy Independence day. A Independence day gift; that was Superb, Racy and Very useful. Encapsulating features of Excel. Spending time after hectic months since April with year close and 1st Qtr Reporting; will catchup with your videos during the last couple of months. Many thanks to you sir.

@chandoo_ 9 ай бұрын

Happy Independance Day to you Arvind. I had lots of fun making this video and wanted it to be released on a special occasion.

@danielleshelbourne220 9 ай бұрын

OMG #45 is awesome! 🎉

@markus_aurelius_888 9 ай бұрын

I love when we go back to basics, it's the stuff which is v important and often forgotten

@chandoo_ 9 ай бұрын

😍 Thank you.

@jalaluddin8276 9 ай бұрын

Hi! Chandoo. Have been watcing your vidoes for quite sometime. I saw your funtions and formulae keenly as it gives me good understanding and learning from a good teacher. I was myself a teacher so I respect you very much. I am sruck here because my office 365 (purchased recently) does not possess the formulae such as ChooseCosl() nor Take(). what should i do. can you please help. Thanks a lot.

@preetshah3793 7 ай бұрын

Sir make a video on how to pick a chart according to data.

@ferdinandfernandez4939 6 ай бұрын

I'm subscriber, thanks for your lecture, it helps me to update my skills in excel with the updated new commands

@ExcelWithChris 9 ай бұрын

At your 6:40 you do a sub-sort. I discovered the other day if you do it from the right to the left, you can just click in your Sales column and click AtoZ and then click in the Sales Person column and click AtoZ. For some or other reason if you do it from the left, the one sort just replaces the previous, but in reverse, no need for the Sort Button and adding levels!!

@mramsch 2 ай бұрын

Well, sorting with multiple levels can always be done manually by sorting column by column in reverse order from the last to the first criterion, as the sorting in Excel always retains the current order of the other columns. So for example if you have columns Name County Age, if you want a sorted list of all counties and all persons of a county sorted by age (and then persons of same age should be in alphabetical order), sorting level 1 is County, sorting level 2 is Age, sorting level 3 is Name. Manually you can do that by 1st sorting column Name, then sort column Age, the sort column County (i.e. in reverse order of sorting level). Advantage of using the sort button and multiple levels is, that (e.g. after adding more data records) you can repeat this multi-level-sort with a single click on the (Filter) Reapply button: it also does repeat the sorting!

@sairamadaboina8257 6 ай бұрын

Thank you sir, you're explanation was good, please upload more and more videos of trending courses.

@kareemahmed5839 8 ай бұрын

Intelligent chando

@armaangudboi5064 7 ай бұрын

Sir thanks for this video I have learnd so many things thankyou 🎉

@nagarajuvamaraju9146 9 ай бұрын

Awsomw Chandoo ji.

@vaijayantigulve4883 9 ай бұрын

Subscribed....!! 😀 I thought I knew excel very well....!!!

@deborahkris3746 7 ай бұрын

This is really amazing

@vibhorsharma9930 9 ай бұрын

Excel is sooo vast 😮

@alializadeh8195 9 ай бұрын

Thanks

@yashrsingh Ай бұрын

For 18th trick we can type the name in top cell or copy the name in top cell. It help to create list in multiple row scenario.

@Gorman-84 Ай бұрын

GPS! Very funny. Great video as usual. Thank you. Loved the photo of you and Leila together at some conference.

@chandoo_ Ай бұрын

Glad you enjoyed it

@mahmoudmohsen8105 9 ай бұрын

NOOOOOOOOOOICE , Love it !

@himanshushekhar4332 9 ай бұрын

Nice

@techteam-pl6lj 7 ай бұрын

thank you chandu anna

@user-pz6yz5eg1c 5 ай бұрын

hey Chandoo Thanks For this awesome video, I have one question in the paste function (Clipboard tool, 3:15 min ) I am facing a problem here I have a lot of columns that I need to copy as you copied particular chocolate here the same way, but the problem is that the clipboard only takes 24 values and my column name count is 49 so how can I do that

@surojeetdey57 8 ай бұрын

Thank you sir for sharing such informative tricks in Excel, Your videos helped me a lot, I created projects in Excel and mysql, but I can't showcase my skills on LinkedIn, I struggled to create portfolio of my projects, sir if you guide us to create effective portfolio and suggest some tools and websites then it would be great full for me and other folks as well who can't create portfolio as like me. Sir, with all due respect, can you create a dedicated video on this topic? Thank you Signnigoff.

@jonasoliveira9366 9 ай бұрын

Please do one like this for Power Query!

@thinkerboom8465 8 ай бұрын

How to do add calculate pivot table using formula sumproduct?

@mayuronce 8 ай бұрын

చందు గారు తెలుగులో మరిన్ని వీడియోస్ చేయండి plz

@foodcity9875 7 ай бұрын

You always Amazing ❤

@vv9730 9 ай бұрын

NICE...1:50..ANY OPTION TO SHOW CURRECTLY AVAILABLE CUSTOMS LISTS INSTEAD OF EVEN TYPING FIRST FEW ITEMS,SO THAT ONE MAY READILY CHOOSE AMONGST THE LISTS OPTIONS...??

@gurvindersingharora5301 9 ай бұрын

Sir, How can we present L6M, Ly3M, Fiscal Year, Mat, l2M FY Sales in pivot table in excel report. I have an interview scheduled on 24 August. Please Make a Video of this! I need your help!

@mahendrachauda3094 9 ай бұрын

Hi Chandoo, can you plz guide me to enable the get data from the picture option in office 365, I tried to get this option but it is not visible.

@indian35556 8 ай бұрын

Great

@m.ssharma535 9 ай бұрын

Hi Chandoo. First question after binge watching your videos over the weekend. Please take a look. I have developed a stock value calculator that has 6000 stocks. I have 6 methods and created a dashboard for summary. But I want to get the results for 40 stocks (can get ticker in text file) and it should be printed to another excel tab or PDF. I can just print one row or two rows of summary for each ticket (no need of fancy dashboard). Meaning -I need to run the excel dashboard (or file) repeatedly 40 times (40 stock tickers with 2 inputs -ticker and market price) and get the valuation summary. What is the trick to do ? Kindly suggest a method. I think I can do this in Python by accessing Excel repeatedly. But do not want to go there yet. How do do in excel is the question.

@chandoo_ 9 ай бұрын

Thanks for the love. You can use VBA for this sort of thing. Just maintain the 40 ticker codes in a list and set one at a time to the input cell using VBA loop. Then copy the portion you want to another file. When done, save the new file as PDF.

@surajbhardwaj428 8 ай бұрын

Hi Sir your 50 Excel Tips is Amazing... But I have Subscribed your Channel and comes under the 24% subscriber list..😀😀

@sufimudi4524 9 ай бұрын

To see report by country- if the show report filter pages are not active, how we can fix it?

@baachikutikela1178 9 ай бұрын

Bro nice

@murtuzalal 9 ай бұрын

I would like to know if I get a bank statement in excel with 2 to 3 rows with 1 amount in Debit or Credit how to bring in 1 row.

@augustodemattos 2 ай бұрын

Amazing!!! Thank you so much!!! You definitely made our lives easier!!! #excellovers

@Andi-sj7po 9 ай бұрын

About tips 33 : if you check box on match case it will only select 600 values

@user-pz6yz5eg1c 5 ай бұрын

@vidhiagrawal3746 9 ай бұрын

Hi chandoo I am a chartered accountant by profession. I love your videos and had learnt so much from your channel. But nowadays thanks to AI i had lost all the interest on learning new skills and has fall into a pit hole where everyday all I think of is I will lose my job soon. With so many course's out there and so much of misinformation, it would be great if you can come out with a course for people like us.

@chandoo_ 9 ай бұрын

Thanks Vidhi for your comments. I know this can be concerning but AI still has a long way to go. So, focus on things you can control and enjoy most. I do have a few videos on how to harness AI to do your work well. As the technology evolves I will add more information and resources on this. Stay calm my friend.

@gijapi 6 ай бұрын

this is really great/ On a lighter note, remembering all the 50 and recollecting the right one at the right time is a challenge 🙂

@chandoo_ 6 ай бұрын

Thank you. Of course, that is why you can rewatch the video sometime later to cement the ideas.

@keithmason1485 9 ай бұрын

The Alt key shortcut is something that I'm always confused as to why nobody does this in their Excel videos. After you use it a few times it becomes really easy to use and get things done quickly.

@T5AGamerz 8 ай бұрын

Alt a + v + v use this for data validation