17 Amazing Excel Features Hiding In Plain Sight
Рет қаралды 54,887
Күн бұрын🔍 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
@samsmythsenior811 6 күн бұрын
Hands down, this is the Excel tips video with the most and greatest tips in the short period of time. Nicely done!
@ExcelCampus 4 күн бұрын
Thanks for the feedback, Sam! 😀
@samsmythsenior811 3 күн бұрын
@@ExcelCampus Thanks to you for producing such informative quality.
@barttitulaerexcelbart9400 8 күн бұрын
Lock the drawing tool, and the selection : great tips!!
@rjbjajjjmj1 8 күн бұрын
Agreed; that was the one that had me saying, "I wish I'd known that before!"
@tomwelt1825 4 күн бұрын
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 4 күн бұрын
Thanks, Tom! 😀
@JHatLpool 8 күн бұрын
All tips are good and very useful. I like the tips at 00:20 and 00:35 (workbooks containing multiple sheets, moving between these sheets etc.).
@BeugsTheLegend 8 күн бұрын
My favorite was double clicking to hide the ribbon. I didn’t know that one and it will help tremendously.
@patrickschardt7724 6 сағат бұрын
The copy sheet shortcut is amazing
@waynethompson5098 8 күн бұрын
Outstanding tips. Love the right-click on sheet arrows to obtain a list of sheet names for easy navigation.
@judywilder7883 4 күн бұрын
Format painter lock mode was something I did not know! That will save some time for sure👏
@h.esther9400 8 күн бұрын
The tips about the status bar are cool seem really interesting but the best tip might be clicking to collapse the ribbon! 🎉
@HandelMcHandel 8 күн бұрын
The select shapes tip was excellent- also the format painter double click - I knew this before but had forgotton it
@ajrawlings 7 күн бұрын
Did not know about the 'Lock Drawing Mode' - that will certainly help now! 🙂
@learningwithmaliha 3 күн бұрын
Nice tips, I like the lock drawing mode tip!
@Locomaid 4 күн бұрын
Wow. I learned half a dozen new things in one video! Thank you!
@ExcelCampus 4 күн бұрын
Great to hear that! 😀
@rrki 8 күн бұрын
All tips are really helpful. Great video, thanks a lot
@randyhaimila6476 7 күн бұрын
As always, great job John. I especially liked being able to add the sheet number to the status bar. 👍 Also, starting at 2:18, I like how we can select cells like that.
@joshuamanampiu6489 7 күн бұрын
For me also the lock the drawing tool was outstanding. I discovered it also works in word! Great tip
@ExcelCampus 7 күн бұрын
Cool! I don't think I've ever tried it in Word. Also works in PowerPoint. Thanks for sharing! 🙌
@nadermounir8228 5 күн бұрын
So many nice tips hard to choose which one is the most useful
@rajeevgosavi4514 4 күн бұрын
Great video. Really useful tips in day to day working. Thanks John.
@ExcelCampus 4 күн бұрын
Thanks, Rajeev! 😀
@marlenemccullough1567 8 күн бұрын
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.
@harshanaweragama270 4 күн бұрын
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 KZfaq channel, but also a fan of your bog post
@ExcelCampus 4 күн бұрын
Wow! Appreciate that 😀
@mickeytee6533 7 күн бұрын
double click the format tool... great!!! very useful.
@keeney413 8 күн бұрын
your content is so freaking helpful
@nboisen 8 күн бұрын
Locking the drawing tool was a new one for me and one that will come in handy
@nanasusie 5 күн бұрын
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 4 күн бұрын
Thanks for your feedback! 😀
@peterjones7673 8 күн бұрын
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 8 күн бұрын
Happy to hear this. Thanks Peter! 🙌
@drsteele4749 8 күн бұрын
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 7 күн бұрын
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.
@ConstanceHanscomb 8 күн бұрын
Great tips! I will be saving this video for future reference. Thanks!
@ExcelCampus 8 күн бұрын
Thanks Constance! 🙂
@stephenl5693 8 күн бұрын
It's always great to keep the brain refreshed and constantly learning little features/shortcuts 👍, thanks for the video!
@freezendog7 8 күн бұрын
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 8 күн бұрын
Thanks! I’m happy to hear you learned something new. 😊
@kapibara2440 3 күн бұрын
Good video, thank you 🎉
@user-dn5gd1rn9f 6 күн бұрын
Thank you very much! The select objects tip is my favorite- did not know that one!
@notesfromleisa-land 7 күн бұрын
My favorite KZfaq 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 7 күн бұрын
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 kzfaq.info/get/bejne/hq2cdcmjmrnJdXU.html Thanks again! 🙌
@bretthyder5602 8 күн бұрын
Great tips!
@VedantKhare-wi7gc 8 күн бұрын
Really helpful tricks
@josh_excel 2 күн бұрын
Good tips (new features?) I didn't know about.
@chrisklimantiris2520 8 күн бұрын
Thank You Jon.!!
@2bczar4u 8 күн бұрын
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.
@donfilibeck8414 8 күн бұрын
Super useful.
@tibibara 5 күн бұрын
Lock Drawing Mode -> woww, thanks Jon! ;-)
@ExcelCampus 4 күн бұрын
You're welcome! 😀
@hagun6535 7 күн бұрын
The zoom out for named ranges is very helpful
@vinc.7765 8 күн бұрын
Very useful, Jon :D (davvero utile, Jon)
@MS-tm2yz 3 күн бұрын
Great tips, but as an old geezer, I`ll never remember them!
@josealvesferreira1683 6 күн бұрын
You are very, very good, I think this tips are very usefull. Thanks
@ExcelCampus 4 күн бұрын
Thanks, Jose! 😀
@jhonjaramillo4649 Күн бұрын
For the tip at the minutes 7:24 can be done with ctrl + f1
@Darkslide820 7 күн бұрын
Great video
@neronjp9909 4 күн бұрын
thx so much, so helpful !
@ExcelCampus 4 күн бұрын
Glad it helped! 😀
@tedmoy 8 күн бұрын
My favorite feature was shortcut to copying a tab!
@Sickandtwisted1990 5 күн бұрын
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 😂
@matiasbunsterraby2176 8 күн бұрын
Thank you Jon. I lked the zooming into a certain range.
@sigmaschoolmodasa 2 күн бұрын
Cool and useful
@andyrobertson4096 7 күн бұрын
Top tip... Don't have too many sheets per workbook!
@chuckpg31 7 күн бұрын
Locking format painter. Mind blown
@ashokp4536 8 күн бұрын
Thank you Jon for useful tips.
@BouncewithLife_1 8 күн бұрын
Thanks a lot Jon for such videos.
@OlawaleMichael-qm4kf 8 күн бұрын
Great teacher. Thank you!
@jackcurl2005 8 күн бұрын
Really like the double-click ribbon tabs to collapse and expand the ribbon.
@chrism9037 8 күн бұрын
Excellent video thanks Jon!
@sledgehammer-productions 6 күн бұрын
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).
@bbotzong 8 күн бұрын
Great tips!!! Thanks.
@stevemiller2120 8 күн бұрын
I liked the one where you can lock the format painter
@junogunbiyi7750 8 күн бұрын
Thank you so much!
@mmaimmortals 8 күн бұрын
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.
@404ErrorPage 8 күн бұрын
The Format Painter was a surprise. Previously I was using conditional formatting with formula =MOD(ROW(),2)=0 to make alternate colored rows
@samiabdullah5437 8 күн бұрын
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 8 күн бұрын
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. kzfaq.info/get/bejne/prKEo8tklt3dio0.htmlsi=K1Mf5-TSLveAEPbJ kzfaq.infoD4eZZr9RqCg?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!
@bankongdan 2 күн бұрын
Can you draw out a course outline in excel for data analytics training?
@sircorn4248 8 күн бұрын
A what feature is your favorite is like a what finger is your favorite. I like them all. ❤
@ExcelCampus 8 күн бұрын
😂😂 Haha!! True. It is hard to pick favorites with Excel.
@JRT-z6r 8 күн бұрын
Drawing tools tips
@lpanades 8 күн бұрын
Loved all.
@Digital-Dan 6 күн бұрын
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?
@ahmedeid-bz8gd 6 күн бұрын
Amazing
@mirrorreflection3479 8 күн бұрын
Part 2 please
@williestevenson9538 8 күн бұрын
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 8 күн бұрын
Great tip with the Ctrl+select! Thanks Willie! 🙌
@user-vb1rn6ox8n 8 күн бұрын
Select Objects! Lock drawing mode!
@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?
@11prem 2 күн бұрын
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.
@KnightsMultiMediaCapeTown 7 күн бұрын
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 7 күн бұрын
Hah...I still miss Lotus 123. I had spreadsheet PTSD when Microsoft won the software wars. (Amipro, I miss you too)
@ExcelCampus 7 күн бұрын
"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!
@lewesmariner 8 күн бұрын
F2 Enter/Edit - explains why editing formulas sometimes goes awry!
@ExcelCampus 8 күн бұрын
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.
@billco1947 8 күн бұрын
auto column width
@sophykeo9639 7 күн бұрын
Edit & F2
@BigSmokey3 8 күн бұрын
Unrelated to Excel, but you seem like a nice person. That is all.
@ExcelCampus 8 күн бұрын
😊 💚
@riteshvishwakarma9595 8 күн бұрын
❤❤
@DEMONSOUL01 8 күн бұрын
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 8 күн бұрын
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 8 күн бұрын
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.
@dheenadhayalan6183 3 күн бұрын
Hii what is the keyboard shortcut for see all sheets name
@ExcelCampus 3 күн бұрын
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 2 күн бұрын
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.
@cruzinsweetsntreats 8 күн бұрын
Tip #1 doesn't work for Excel on mobile devices, unfortunately. 😢
@ExcelCampus 8 күн бұрын
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. kzfaq.info/get/bejne/prKEo8tklt3dio0.htmlsi=K1Mf5-TSLveAEPbJ kzfaq.infoD4eZZr9RqCg?si=VAr_TC6Eu_d4kGad I hope that helps. 🙂
@cruzinsweetsntreats 8 күн бұрын
@@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 7 күн бұрын
I have no comment to leave
@publicspeaking4858 8 күн бұрын
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 8 күн бұрын
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 8 күн бұрын
Click the setting cog on the video controls and you can change the playback speed.
@ashokp4536 8 күн бұрын
Thank you kate804 and thewatusi0. I watch a lot of KZfaq but never new this feature.
@ExcelCampus 8 күн бұрын
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 KZfaq. 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. 🙂
@alexrosen8762 8 күн бұрын
Superuseful 👌 Honestly all of them were great
@ExcelCampus 8 күн бұрын
Thanks Alex! 🙂
超人夫妇
Рет қаралды 30 МЛН