17 Amazing Excel Features Hiding In Plain Sight

Подписаться 569 тыс.

Просмотров 57 тыс.

0% 0

🔍 Ever felt like you're only scratching the surface with Excel? You’re not alone! Discover the hidden gems in Excel that will transform your workflow and skyrocket your productivity. From powerful data analysis tools to lesser-known shortcuts, these 17 amazing features are right at your fingertips, hiding in plain sight! DOWNLOAD THE WORKBOOK ► www.excelcampus.com/tips-shor...
🔗LINKS
🔎 Get free weekly Excel tips: www.excelcampus.com/newsletter/
💡 Free 60-minute Excel training session: www.excelcampus.com/blueprint
📖 Join Our Comprehensive Excel Training Program: www.excelcampus.com/elevate
Related Content:
Copy Dates & Fill Series of Numbers with the Fill Handle in Excel www.excelcampus.com/keyboard-...
00:00 Introduction
00:15 Right-click Tab Navigation
00:27 Sheet Number in Status Bar
00:41 Status Bar Calculations
01:02 Zoom to Fit Selection
01:20 Expand Formula Bar
01:37 Autofit Columns and Rows
02:17 Name Box Range Selection
02:48 Zoom Out to See Named Ranges
03:08 Select Objects Tool
03:57 Lock Drawing Mode
04:38 Edit Mode and F2 Shortcut
05:35 Fill Handle
06:01 Format Painter Lock Mode
06:36 Tiny Ribbon Buttons
06:57 Ctrl+Drag to Duplicate Sheets
07:19 Double-Click to Hide Ribbon
07:48 Keyboard Shortcuts in Screentips

Опубликовано:

6 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

@samsmythsenior811 7 дней назад

Hands down, this is the Excel tips video with the most and greatest tips in the short period of time. Nicely done!

@ExcelCampus 5 дней назад

Thanks for the feedback, Sam! 😀

@samsmythsenior811 4 дня назад

@@ExcelCampus Thanks to you for producing such informative quality.

@barttitulaerexcelbart9400 9 дней назад

Lock the drawing tool, and the selection : great tips!!

@rjbjajjjmj1 9 дней назад

Agreed; that was the one that had me saying, "I wish I'd known that before!"

@tomwelt1825 5 дней назад

Jon, I've been using Excel for decades, but I never realized you could double-click on the Format Painter to repeat use. What an awesome revelation. That example was my favorite. Keep up the great videos!

@ExcelCampus 5 дней назад

Thanks, Tom! 😀

@JHatLpool 9 дней назад

All tips are good and very useful. I like the tips at <a href="#" class="seekto" data-time="20">00:20</a> and <a href="#" class="seekto" data-time="35">00:35</a> (workbooks containing multiple sheets, moving between these sheets etc.).

@patrickschardt7724 День назад

The copy sheet shortcut is amazing

@judywilder7883 5 дней назад

Format painter lock mode was something I did not know! That will save some time for sure👏

@waynethompson5098 9 дней назад

Outstanding tips. Love the right-click on sheet arrows to obtain a list of sheet names for easy navigation.

@BeugsTheLegend 9 дней назад

My favorite was double clicking to hide the ribbon. I didn’t know that one and it will help tremendously.

@ajrawlings 9 дней назад

Did not know about the 'Lock Drawing Mode' - that will certainly help now! 🙂

@HandelMcHandel 9 дней назад

The select shapes tip was excellent- also the format painter double click - I knew this before but had forgotton it

@rrki 9 дней назад

All tips are really helpful. Great video, thanks a lot

@h.esther9400 9 дней назад

The tips about the status bar are cool seem really interesting but the best tip might be clicking to collapse the ribbon! 🎉

@keeney413 9 дней назад

your content is so freaking helpful

@Locomaid 6 дней назад

Wow. I learned half a dozen new things in one video! Thank you!

@ExcelCampus 5 дней назад

Great to hear that! 😀

@learningwithmaliha 4 дня назад

Nice tips, I like the lock drawing mode tip!

@nadermounir8228 6 дней назад

So many nice tips hard to choose which one is the most useful

@AMDSTT 13 часов назад

Thank you very much ❤

@mickeytee6533 8 дней назад

double click the format tool... great!!! very useful.

@nboisen 9 дней назад

Locking the drawing tool was a new one for me and one that will come in handy

@joshuamanampiu6489 8 дней назад

For me also the lock the drawing tool was outstanding. I discovered it also works in word! Great tip

@ExcelCampus 8 дней назад

Cool! I don't think I've ever tried it in Word. Also works in PowerPoint. Thanks for sharing! 🙌

@randyhaimila6476 8 дней назад

As always, great job John. I especially liked being able to add the sheet number to the status bar. 👍 Also, starting at <a href="#" class="seekto" data-time="138">2:18</a>, I like how we can select cells like that.

@rajeevgosavi4514 5 дней назад

Great video. Really useful tips in day to day working. Thanks John.

@ExcelCampus 5 дней назад

Thanks, Rajeev! 😀

@chrisklimantiris2520 9 дней назад

Thank You Jon.!!

@marlenemccullough1567 9 дней назад

I knew several of these short cuts which are super helpful; the F2 button for entering/editing a cell was new to me and will have to try that one. The other one was the fill handle, I have known about putting cursor in the bottom right corner and dragging but double clicking to auto fill/update the cells is very helpful. I will be forwarding this to staff in the office so they can learn new tricks as well, if they don't already know. I believe half the staff I have forwarded emails from you to them and they may already be on your email list. I really like the tips and tricks - although some of the more advanced tips are over my head - but at least the accounting staff can find them useful. Thank you Jon for all the great information.

@VedantKhare-wi7gc 9 дней назад

Really helpful tricks

@kapibara2440 4 дня назад

Good video, thank you 🎉

@stephenl5693 9 дней назад

It's always great to keep the brain refreshed and constantly learning little features/shortcuts 👍, thanks for the video!

@bretthyder5602 9 дней назад

Great tips!

@donfilibeck8414 9 дней назад

Super useful.

@harshanaweragama270 6 дней назад

Thank you.. You are one channel that I follow, and have helped me when I really did need some tips.. I rely not only on the RU-vid channel, but also a fan of your bog post

@ExcelCampus 5 дней назад

Wow! Appreciate that 😀

@user-dn5gd1rn9f 7 дней назад

Thank you very much! The select objects tip is my favorite- did not know that one!

@ashokp4536 9 дней назад

Thank you Jon for useful tips.

@nanasusie 7 дней назад

So many new tips. I like the right-click on sheet arrows to get the sheet list. I use an add-in to create an index page and usually use that, but this is quick. As always, great job!

@ExcelCampus 5 дней назад

Thanks for your feedback! 😀

@OlawaleMichael-qm4kf 9 дней назад

Great teacher. Thank you!

@BouncewithLife_1 9 дней назад

Thanks a lot Jon for such videos.

@chrism9037 9 дней назад

Excellent video thanks Jon!

@vinc.7765 9 дней назад

Very useful, Jon :D (davvero utile, Jon)

@bbotzong 9 дней назад

Great tips!!! Thanks.

@ConstanceHanscomb 9 дней назад

Great tips! I will be saving this video for future reference. Thanks!

@ExcelCampus 9 дней назад

Thanks Constance! 🙂

@matiasbunsterraby2176 9 дней назад

Thank you Jon. I lked the zooming into a certain range.

@josh_excel 3 дня назад

Good tips (new features?) I didn't know about.

@peterjones7673 9 дней назад

Fantastic tips Jon, I love tip one as I have several sheets with multiple workbooks and the quick look up will save me scrolling back and forth, thank you so much as all of these great tips will be so useful.

@ExcelCampus 9 дней назад

Happy to hear this. Thanks Peter! 🙌

@hagun6535 8 дней назад

The zoom out for named ranges is very helpful

@Darkslide820 8 дней назад

Great video

@MS-tm2yz 4 дня назад

Great tips, but as an old geezer, I`ll never remember them!

@junogunbiyi7750 9 дней назад

Thank you so much!

@sigmaschoolmodasa 3 дня назад

Cool and useful

@freezendog7 9 дней назад

Great video Jon, even for the more advanced user. I've learned some new tricks. That F2 edit / enter mode works a treat in the conditional formatting menu when you want to write a formula for the conditions. All the best!

@ExcelCampus 9 дней назад

Thanks! I’m happy to hear you learned something new. 😊

@lpanades 9 дней назад

Loved all.

@2bczar4u 9 дней назад

Hard to pick. I just plain love shortcuts. Collapsing the ribbon and using the Quick Access toolbar (for any 365 products) is the way I work.

@tibibara 6 дней назад

Lock Drawing Mode -> woww, thanks Jon! ;-)

@ExcelCampus 5 дней назад

You're welcome! 😀

@drsteele4749 9 дней назад

Very useful! Thanks, Jon. My tip - I like to put the QAT below the ribbon: the icons are clearer and coloured down there and you can fit many more of them.

@notesfromleisa-land 8 дней назад

I'm so reliant on my QAT (below the ribbon as you note which is so helpful), that when I have to help another on Excel, I find that I'm swimming through peanut butter to get to the needful things. We develop so much muscle memory in using our Excel tools.

@chuckpg31 8 дней назад

Locking format painter. Mind blown

@tedmoy 9 дней назад

My favorite feature was shortcut to copying a tab!

@neronjp9909 5 дней назад

thx so much, so helpful !

@ExcelCampus 5 дней назад

Glad it helped! 😀

@andyrobertson4096 8 дней назад

Top tip... Don't have too many sheets per workbook!

@josealvesferreira1683 7 дней назад

You are very, very good, I think this tips are very usefull. Thanks

@ExcelCampus 5 дней назад

Thanks, Jose! 😀

@Sickandtwisted1990 7 дней назад

F2 to switch between edit and enter mode is just what I’ve been looking for - always thought it wasn’t possible to go back to navigating by arrows after entering the initial formula 😂

@stevemiller2120 9 дней назад

I liked the one where you can lock the format painter

@notesfromleisa-land 8 дней назад

My favorite RU-vid hack: For all of the Excel tips and tricks that you know you won't remember, create a saved list call Jon's Excel Hacks and save the video for your future reference. Favorite? Like picking a favorite child. (1) Lock the drawing tool. (Though I don't draw much). (2) Double clicking on the Toolbar to collapse and restore. My all time favorite tip from you is your running totals in tables. It is a feature I use a lot, and your method is both simple and effective. My personal tip for those who work with tables extensively: lot, adding the table totals icon to the QAT. Also the column filter toggle shortcut is something I use frequently. It is a godsend for eliminating any filters from a table quickly from large tables.

@ExcelCampus 8 дней назад

Thanks so much for sharing and for your support! I love the Jon's Excel Hacks idea!! We'll think about how we can create something around that idea in the future. For anyone wondering about the running totals in Tables, here's a link to that video. Running Totals In Excel Tables - The Efficient Way ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PGlBfr5SeEA.html Thanks again! 🙌

@ahmedeid-bz8gd 7 дней назад

Amazing

@jackcurl2005 9 дней назад

Really like the double-click ribbon tabs to collapse and expand the ribbon.

@jhonjaramillo4649 2 дня назад

For the tip at the minutes <a href="#" class="seekto" data-time="444">7:24</a> can be done with ctrl + f1

@mirrorreflection3479 9 дней назад

Part 2 please

@sircorn4248 9 дней назад

A what feature is your favorite is like a what finger is your favorite. I like them all. ❤

@ExcelCampus 9 дней назад

😂😂 Haha!! True. It is hard to pick favorites with Excel.

@bankongdan 3 дня назад

Can you draw out a course outline in excel for data analytics training?

@404ErrorPage 9 дней назад

The Format Painter was a surprise. Previously I was using conditional formatting with formula =MOD(ROW(),2)=0 to make alternate colored rows

@JRT-z6r 9 дней назад

Drawing tools tips

@sledgehammer-productions 7 дней назад

Although I still don't like to use the mouse too much, a lot of the double click tips are worth incorporating. On a side note: I'm mousing left, so I'm used to translating 'right click' to 'left click' and vice versa. But better words would be "selection button" (my right) and "context button" (my left).

@agraharafamily5634 16 часов назад

Most of the features are known. However learn special feature with format paint double click. Thanks

@user-vb1rn6ox8n 9 дней назад

Select Objects! Lock drawing mode!

@samiabdullah5437 9 дней назад

I really enjoyed it. Please do something on linking cells and sheets like if I have a list of names, when ever I click on a name it takes me to his page or file.

@ExcelCampus 9 дней назад

Thanks! One way to achieve that is with a table of contents sheet. This is just a sheet with a list of sheet names and links to each sheet. We can use a macro to create the sheet. Here are a few videos that explain the setup. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pLTph31wyZY.htmlsi=K1Mf5-TSLveAEPbJ ru-vid.comD4eZZr9RqCg?si=VAr_TC6Eu_d4kGad There are other ways to do this, including linking to files instead of sheets. I'll add that to our list for future videos. Thanks!

@Digital-Dan 7 дней назад

In the late 1960's, a colleague and I at our university developed a programming language for use in our laboratory. By the time we were done, we had added so many bells and whistles to the language that there was no need to apologize when we chose to add another, overlapping or duplicating capability. We had nothing on Excel, which may even have more Easter Eggs and such than Word, which is really saying something. Archeologists will no doubt one day dig down and find that this program can even add a column of numbers. Who knew?

@billco1947 9 дней назад

auto column width

@mmaimmortals 9 дней назад

CNTRL D to content above, including formats and formulas. ALT A T to apply filter. AlT W F F to apply freeze pane. CNTRL C to copy, then Right Click V yo paste value only. Very fast.

@11prem 3 дня назад

I don't seem to get the "Sheet number in status bar" option when I right-click on the status bar. Even the lock drawing mode option isn't available in my version. I have excel version 2016.

@sophykeo9639 8 дней назад

Edit & F2

@williestevenson9538 9 дней назад

I use most of these but one I have been using lately is the status bar calculations, especially when the values I want to sum are not contiguous. Just Ctrl and select those you want evaluate, no need to write a formula to get a quick result.

@ExcelCampus 9 дней назад

Great tip with the Ctrl+select! Thanks Willie! 🙌

@BigSmokey3 9 дней назад

Unrelated to Excel, but you seem like a nice person. That is all.

@ExcelCampus 9 дней назад

😊 💚

@lewesmariner 9 дней назад

F2 Enter/Edit - explains why editing formulas sometimes goes awry!

@ExcelCampus 9 дней назад

Yes! I sometimes wish this feature wasn't so "hidden" because it can be very useful. I forgot to mention in the video that Enter/Edit modes also work in all popup windows where you are selecting ranges. Data validation, conditional formatting, named ranges, etc. These are often referred to as ref edit boxes.

@KnightsMultiMediaCapeTown 9 дней назад

I have used Excel from before Noah went into the ark and I am very much a keyboard jocky, mouses are for navigation, keyboards are for work. However I did learn 3 new things today. thanks

@notesfromleisa-land 8 дней назад

Hah...I still miss Lotus 123. I had spreadsheet PTSD when Microsoft won the software wars. (Amipro, I miss you too)

@ExcelCampus 8 дней назад

"Mouses are for navigation, keyboards are for work". Haha, love it! I'm sure there were mice on the ark, but never knew there were keyboards too. 😜 Happy to hear you learned some new things. Thanks!

@riteshvishwakarma9595 9 дней назад

❤❤

@md.aktheruzzaman2475 День назад

I want to pull down importrange data in below row in google sheet, but cell reference not change, how i can do it?

@md.aktheruzzaman2475 День назад

No one can help me?

@dheenadhayalan6183 4 дня назад

Hii what is the keyboard shortcut for see all sheets name

@ExcelCampus 4 дня назад

Nice question, Dheena! 😊 Try F6, Tab, Tab, Shift+F10. The F6 key selects the current sheet tab where it is listed at the bottom of the screen with all of the other sheet tabs. Tabbing twice will move the cursor to the add new sheet symbol, then to the sheet cursor direction symbol. Holding Shift and pressing F10 brings up the right-click menu for the selection, which in this case is a list of all the sheets. Enjoy! 🙂

@ExcelCampus 3 дня назад

To use this tip, you may have to drag the scroll bar to the left so that one of the sheets is at least partially hidden. If the scroll bar is not covering any of the sheets, the second Tab key press will not function in the desired manner, but the list of all sheet names will still be visible via the tabs at the bottom.

@DEMONSOUL01 9 дней назад

I have i5 6th gen and 8gb ram with 64bit operating system so blease let me which version is comparable and fast processing oo ms office 2021 , 32bit or 64bit??❤❤❤❤

@ExcelCampus 9 дней назад

64 bit is best if you are going to be using PowerPivot and the data model. It can handle more rows and will calc faster.

@ExcelCampus 9 дней назад

64 bit is best if you are going to be using PowerPivot and the data model. It can handle more rows and will calc faster.

@cruzinsweetsntreats 9 дней назад

Tip #1 doesn't work for Excel on mobile devices, unfortunately. 😢

@ExcelCampus 9 дней назад

Good point! I don’t believe there are any sheet navigation features like that on the mobile version. One workaround is to add a table of contents sheet to your workbook. You would need to create that sheet on the desktop version with either VBA or Office Scripts. I have a few videos that explain the setup in more detail. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pLTph31wyZY.htmlsi=K1Mf5-TSLveAEPbJ ru-vid.comD4eZZr9RqCg?si=VAr_TC6Eu_d4kGad I hope that helps. 🙂

@cruzinsweetsntreats 9 дней назад

@@ExcelCampusI've seen your tutorial, amongst a few others at the leading edge of M$ Office; just don't really use it for my travel / business delivery needs.

@byteseq 8 дней назад

I have no comment to leave

@publicspeaking4858 9 дней назад

Is it possible for you to reduce your speed of talking. It is difficult to understand your accent. Sorry if I am troubling you

@kate804 9 дней назад

Hi, you can go to your video settings by clicking the wheel cog settings icon, and from the playback option select one that is less than “1x” (the current speed). The video should then play slower and Jon’s speech a bit easier to hear and interpret. Hope that helps a bit :)

@thewatusi0 9 дней назад

Click the setting cog on the video controls and you can change the playback speed.

@ashokp4536 9 дней назад

Thank you kate804 and thewatusi0. I watch a lot of RU-vid but never new this feature.

@ExcelCampus 9 дней назад

Thanks for the feedback. It’s always a challenge to determine my pace of talking. I have had others say that I talk too slow and want to speed me up. Striking the perfect balance is probably impossible. 🤷‍♂️😊 As others have mentioned, you can use the playback speed controls on RU-vid. For this video I was trying to fit in a lot of tips in a short amount of time. In other videos, I will sometimes go into more detail depending on the topic. Thanks again for the feedback. 🙂