5 Excel Secrets You'll Be Embarrassed You Didn't Know

🔗LINKS

Related Content:

✅ Writing Formulas Made Easy With Shortcuts For Xlookup And Vlookup
✅ Power Query: Why/When Should You Use It?
✅ Why You Should Avoid Formulas for Summary Reports & Dashboards
✅ How to Enable the Developer Tab in Excel for Windows
✅ How to Create a Personal Macro Workbook in Excel and Why You Need It (Part 1 of 4)

00:00 Introduction
00:25 Writing Formulas
03:22 Find Matches
05:53 Combine Files
09:00 Summary Reports
12:30 Automating Common Tasks

[ExcelCampus]

Secret #5 seems to be the most popular. Question for you... Are there any time consuming Excel tasks that you'd like to automate with a macro?

Leave a comment and let us know. 👇🏼

I'm working on another video on the macro recorder and want to include examples that would be helpful for you. So, your idea or question could be featured in the video.

[ryan]

Crtl Shift End instead of down arrow was new for me. Thanks Jon!

[LindieKotze]

Very helpful! Compliments on how you present. So easy to follow. Appreciate the effort you put in

[rexbk]

Ctrl+Shift+End is a new thing for me. Thanks

[JohnAdair-kj]

When I have a select enough rows that I can no longer see my formula, then my favorite way to keep that range selected and "scroll" back up to the formula is while that to just hit Ctrl + Backspace. It's fabulous!

[dianebucciero]

The power query to combine files contained in a folder I found this feature on the web a couple days ago, so still new to me, your video just cleared up a sticking point and added more detail. SO simple and will save me so much time and frustration! I will be watching more of your tutorials! Thank you.

[JanBolhuis]

Thank you for this one. Although I know a lot of shortcuts, I always find it interesting to watch these kind of videos. For just 17 minutes, I learned one new shortcut/trick - Ctrl Shift End - in case of blanks. An amzing one. Thank you. It will save me more than 17 minutes in the future :)

[philhersh]

Awesome! Double clicking on the fill handle was something I learned from your video. Super useful.

[johnfox]

As always
You always speak and describe things so well and at just the right pace for me.
There's never any time wasting or 'padding' with you, that's why you're always my go to for excel.
Thank you so much for sharing.
Regards

John
(Inverurie, Scotland)

[Adam_K_W]

Great work as always Jon. At my company, personal macro workbooks have been banned/locked out by IT Security. So far, a workaround is to convert that same workbook to an Excel Add-in and then set it to load on start up. I've got my own personal ribbon with icons linked to the functions in that Add-In and also custom icons on the Excel shortcut dropdown list so i can get to them either way. If you put together a video on the Add-In approach for personal macros, I'm sure it would be popular.

[EJRyder]

I use a very similar header row macro for my work that includes the filename (=CELL("filename", A2) when it is printed out so that I can find the file using the printed output. It is useful to have a blank row below the header if you use arrays with CurrentRegion.

[JudahPeters-mh]

Great excel tutorials. I have learnt a lot. The most important was the macro. This will save me a lot of time and make my work super easy. Thank you so much Jon.

[JHatLpool]

Really nice demonstrations and descriptions here. MS Excel is so powerful now.

[amithbsbs]

Shift control end is new for me when there are multiple blanks in column and used to do manually. Now i am pro after watching

[DavidWinchell]

I sure wish I had found you much earlier, but I'm glad to have found you now. Thanks!!😀

[less_thanONEmin]

oh my, i was searching for a day and this is the best video

[keithM]

Thanks for the shortcuts, Jon! They’ll be really helpful at work. I’m having trouble with Excel though—it’s asking for a product key. Does anyone have any idea where I can get one?

[cnav]

Creating a macro to insert and identically format a top row on multiple sheets is probably not necessary for most spreadsheet users. A different approach is to group a contiguous set of sheets by holding the Shift key, selecting the first sheet's tab and the last sheet's tab. All grouped sheet tabs will indicate that they are in active use. On an active sheet, insert the new first row and apply the desired formatting to the row. Entered text, etc. will be repeated on all grouped sheets.
Note that an operation on a grouped sheet might be repeated on all sheets of the group if the operation is valid for all grouped sheets.

[HandelMcHandel]

5 for the price of one - one day only! Thanks Jon!

[veronicagonzales]

for my current job, i am most interested in Combing Files. I need to watch it again. thank U