7 Excel Time Hacks Everyone Should Know | Learn Excel the FAST Way!

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

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

50% 1

Download practice Excel files: www.excel-university.com/90rm...
🔥 Are you trying to learn Microsoft Excel on RU-vid? That's the slow way... Learn Excel the FAST way, find out how here 👉 www.excel-university.com/yt
In this video, check out these seven Excel time hacks from Excel University that will help you work smarter, not harder. From keyboard shortcuts to hidden features, we'll show you how to speed up your workflow and get more accomplished in less time. Microsoft Excel hack number 7 is a power hack that uses all the other hacks in combination so be sure to watch until the end!
Subscribe here 👉 ru-vid.com... and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!
Watch VLOOKUP Hacks Playlist here • VLOOKUP Hacks Series
Watch VLOOKUP vs SUMIFS Playlist here • VLOOKUP vs SUMIFS Series
Watch Dynamic Arrays playlist here • Dynamic Arrays Series
Watch Treasure Maps playlist here • Treasure Maps Series
Watch Slow to Fast playlist here • Slow to Fast Series

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

20 июн 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@ahmedelkettani8626 8 месяцев назад

Thank you Heisenberg!

@nayakravi905 5 месяцев назад

😂

@phandongexcel 3 месяца назад

www.youtube.com/@phandongexcel . I like this video ❤❤❤❤❤❤❤

@stopdrinkingleftskoolaid6510 8 месяцев назад

First time viewer here. I just subscribed and “liked” based on this one video alone. I’m hoping your other videos are just as incredible because I usually don’t subscribe anywhere until I’ve seen several videos from any site. Thank you so much for this. I’ve been using excel (home use) for decades and I didn’t know 80% of what I learned here today. 😊

@ExcelU 8 месяцев назад

Welcome aboard ... and thanks for your kind note :)

@moneymarosx 9 месяцев назад

I knew some of these, but wow, you showed so many new ways for each of the tools. Excellent content.

@jacqueshollands5630 7 месяцев назад

This is one of the better, if not the best, videos on time-saving in Excel. I consider myself an advanced user, but never knew about the Alt = function, particularly when you have two tables next to each other.

@ExcelU 7 месяцев назад

Thank you so much for your kind note, I sincerely appreciate it :)

@alansorin1702 6 месяцев назад

I have been using Excel for over 30 years. I can teach Excel for the average user. I learned several things from this video. Everything was explained simply!!

@Bynggo 2 месяца назад

Wow. Thank you. Everyone is going to think I’m brilliant now. Off to play with Excel. Thank you for making work fun.

@michellehart5919 3 месяца назад

MIND BLOWN! Thank you so much!

@johnk7267 Год назад

Wow these are phenomenal, Jeff! Thanks for sharing.

@wayneyadams 8 месяцев назад

The amount of time, work, and aggravation you saved me is absolutely amazing!

@alvinuy6628 6 месяцев назад

Love the simplicity and pace. Appreciate learning time saving hacks #4 to 7. Thank you very much.

@paulbork7647 8 месяцев назад

Very nice. Each of your hacks taught me something I can use often. I appreciate you and your sharing your knowledge!

@JIMediaPA 22 дня назад

Thank you for the tips. Still getting back up to the speed on Excel. These are great.

@Excel510 7 месяцев назад

This has been a great experience for me as a beginner, you make it so straight forward, thank you.

@digitalcollaborationtools3371 Месяц назад

Amazing tips. Thanks for this.

@martinbecklen6486 8 месяцев назад

Phenomenal clarity. Such practical information. Thank you , Jeff.

@dennisdekkertube 9 месяцев назад

thank you, very clear instructions and right pace. Keep it up

@maheshreddy2762 7 месяцев назад

One of the best I saw on RU-vid in this year, 2023. Thank you for wonderful tips

@Madmun357 8 месяцев назад

I kept saying WOW every hack. Pretty cool information. Thanks.

@JevVan 3 месяца назад

best set of tips I've seen maybe EVER. I can't tell you how many of these things I've been doing manually for the last couple of years! Thank you!

@UlfatSahil 3 дня назад

I use to 3 or 4 tricks but this is best way to do, faster and combining multiple tricks, really cool and perfect.

@DanielLamarche 8 месяцев назад

As an Excel instructor, I just love to see the faces of the participants when I give a cool demonstration of Flash Fill. Priceless!!!!! BTW the shortcut for Flashfill is Ctrl+E

@robertcurtis6209 8 месяцев назад

Thanks for the shortcut

@mymatemartin 4 месяца назад

Same. I've been training excel for 25 years and still get a buzz from the Lights On moment you see in students faces. 😊

@warrennalty6599 14 часов назад

Keep in mind that flash fill is static. If the data changes, the flash fill result does not. If it is likely that the data could change, then a formula or even power query when you have a large or complex situation may be better.

@alemarengo 2 месяца назад

One of the best video I’ve seen in months; few hints but super useful! Thanks

@Gorman-84 6 месяцев назад

That was awesome. Thanks. Subscribed.

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

Love your teaching style

@deanonova 9 месяцев назад

Dude your are awesome. Short and sweet to the point

@ExcelOffTheGrid Год назад

Great video Jeff - lots of useful tricks. ⭐️⭐️⭐️⭐️⭐️

@ExcelU Год назад

Thanks Mark ... appreciate it :)

@lauradilaurenzio2098 2 месяца назад

Pretty new to excel but loved the video and will be watching for more. Thanks a bunch

@geomatrix5452 4 месяца назад

Jeff, All I can say is WOW! This video was fantastic! I've been "dabbling" with excel for a number of years but never knew most of what you just did! Thank you so so much for doing this video! These tips are PRICELESS! 👍👍👍

24 дня назад

The word hack has been hacked. Useful commands to know. Thanks for posting.

@mohsinawan3594 Год назад

Loved the last trick. Have seen it for rearranging columns too.

@ExcelU Год назад

Thanks ... !!

@SoonThieu 2 месяца назад

Your teaching technic is awesome...easy to follow-up and very valuable tips...You are MASTER... Thanks a Million,

@lindapalma5083 2 месяца назад

Brilliant!!! Thank you! Omg

@giangluong8185 8 месяцев назад

Kind of extension of already known. Perfect. Thanks so much ❤.

@ExcelU 8 месяцев назад

You're welcome 😊

@sheilajulian4202 Год назад

Mind blown! Thanks!

@ExcelU Год назад

Thanks :)

@Cecil_X 8 месяцев назад

3 minutes into the video and you saved me a ton of time. Thanks.

@ExcelU 8 месяцев назад

So glad I could help!

@musiconly5976 3 месяца назад

You’re simply amazing 🎉

@smody121 3 месяца назад

As someone who works as a research analyst in Finance, a lot of these are certainly "time savers" but when you're building models and spreadsheets for the real world, error avoidance and clean scaling potential are incredibly important factors that need to be considered when analyzing data. So while it's great you can save time here and there, I would caution people to actually take the long way, prioritizing those factors instead of building your spreadsheet sub-optimally because they conform to some of the available shortcuts. I'm sure that was clear as mud.

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

Where would you suggest to start. I’m new at this

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

@sharonjackson494 best way to learn is to do. Build a spreadsheet. Use as many shortcuts as you can think of. Do it again with another spreadsheet. Rinse and repeat. Unplug your mouse for hard mode, but it's worth it. 90% of the time there will be a keyboard shortcut that you need to Google and learn how to do. That's a decent start, should take weeks if not months to get fluent. Then you can layer on ideas around optimizing the spreadsheet size etc

@tahirwaseem8684 4 месяца назад

Great Job solve my problem Thank you

@johnmosheim 10 месяцев назад

The best Excel post I’ve seen recently.

@audreyvanderlinde4311 8 месяцев назад

Nice! Thanks!

@mihaslokovix 9 месяцев назад

i learn something new. thanks.

@user-ix4tb8so4h 8 месяцев назад

Excellent Video. 6 out of 7 items were new to me a strong excel user

@gstevens62 6 месяцев назад

This is the best video on Excel time saving tips I've ever watched! Thanks! I liked it so much I subscribed to your channel!

@ZRBBL 8 месяцев назад

I almost went with each hack, but then, something new came out, and... until the end! 😁😁

@user-qo3sk7dj7w 6 месяцев назад

I really enjoy your Excel how to videos. Thought I was pretty knowledgeable but I've learned tons from you!

@ExcelU 6 месяцев назад

Thank you!

@PaulEBrownbill Год назад

Great video, thanks good tips and tricks Paul

@ExcelU Год назад

No problem 👍

@lizdvine2548 6 месяцев назад

Been using Excel for many years. Always love me a good shortcut. You have provided us, without the rambling, several NEEDED quick fills that so many can use. LOVE your site, easy to understand, wonderful information. Keep up the great work!

@ExcelU 6 месяцев назад

Thanks for your kind note ... and welcome!!

@tamerelfaramawy2614 8 месяцев назад

Absolutely helping and valuable tricks.

@ExcelU 8 месяцев назад

Glad to hear I can help!

@FoxzLady 7 месяцев назад

OMG!! THANKS!🎉

@ryzlot 2 месяца назад

EXCELlent video - great hints jr

@cynthiaamara2679 Год назад

Awesome Video Jeff Thanks!!!

@ExcelU Год назад

You are welcome!

@davidg3594 5 месяцев назад

This was good. This was really good!

@alexandermayerkirstein 2 месяца назад

These tips are hand picked gems, zero to hero ways to do hard things quick and easy. Everyone that watches this should think hard before watching without leaving a like. Top of the line tips on being an Excel genius or at least look like one. Come on, when a video deserves, it feels soooo good to hit the like button. Look within for whether to hit the like button. The truth is in there.

@MrWebon 5 месяцев назад

Great lesson. Pivot tables solve almost all of this with just drag and drop, but it’s always great to know this for data cleanup

@ExcelU 5 месяцев назад

Absolutely!

@forgivingcomputers 8 месяцев назад

I have used Lotus 1-2-3, Borland's Quattro Pro, Symphony, and Excel. I thought I was pretty good at it, but now I realize I have been doing things the hard way. These hacks are even better than keyboard shortcuts.

@ExcelU 7 месяцев назад

So glad to help!

@manojdushmantha5426 Год назад

It is really helpful. Thank you

@ExcelU Год назад

Glad it was helpful :)

@therealjeffg Год назад

U da man Jeff!! Thanks for those hacks

@ExcelU Год назад

Thanks … hope they help save a bit of time :)

@WOS1962 6 месяцев назад

More than great 💯👍 follow you from Syria 🌷💐

@carolinaforbes5020 5 месяцев назад

very helpful..thanks so much..keep it up,sir !

@ExcelU 4 месяца назад

So nice of you

@sean7891233 6 месяцев назад

Wow awesome stuff! Thanks a ton Heisenberg, stay awesome ❤

@ExcelU 6 месяцев назад

Thank you!

@PR-nf5ot 9 дней назад

Thank you so much so helpful! One question how to calculate -log 10 in excel?

@Ivo1980 6 месяцев назад

Great tips. Well brought and very informative. I liked 👍, hit subscribe 🔔and am now going to see what other great video's you have posted. Keep it up, as you've just made my life a bit easier.

@berkeleyfuller-lewis3442 5 месяцев назад

You are a superb teacher. Great pace, great visuals. I've been using Excel (and before that, Visi-Calc and Lotus) -- but didn't know ANY of this. Whee!

@ExcelU 5 месяцев назад

Thanks for your kind note :)

@xezebo 8 месяцев назад

that's absolutely excelent !!!

@ExcelU 8 месяцев назад

Many thanks!

@Tamaresque 4 месяца назад

I just learned more in 22 minutes than I learned in 22 years while figuring it all out by myself!!! P.S. This ADHD person appreciates the rapidity with which you present. This is one of the very few videos I haven't had to speed up to 1.25x, 1.5x or sometimes even 2x in order to stay focussed.

@jameshewitt13 7 месяцев назад

Thanks for sharing.

@ExcelU 7 месяцев назад

You bet

@abgafur 23 дня назад

Very good

@Bhavik_Khatri Год назад

Very useful tips.

@ExcelU Год назад

Thank you!

@Teach206 4 месяца назад

Brilliant

@robertcurtis6209 8 месяцев назад

Great video, thanks a lot!

@ExcelU 7 месяцев назад

You are welcome!

@sunnindawg Месяц назад

Cool!

@thurabhilmy6184 4 месяца назад

Rock star you are 🎉

@muhammadeilyas 8 месяцев назад

Wow ! u r 💯 !

@ccda.international 4 месяца назад

Darn, you saved me a lot of time😎

@joulsw3739 5 месяцев назад

Great video!

@ExcelU 5 месяцев назад

Thanks for the visit

@tapanasarawala1370 8 месяцев назад

Very nice Sir, Thank you.

@ExcelU 8 месяцев назад

So nice of you ... thanks :)

@AndreFouche 8 месяцев назад

Articulate and well presented - Thanks! New subscriber!

@ExcelU 8 месяцев назад

Welcome aboard!

@greentom9189 Месяц назад

EXCELlent!

@centugurdag7776 7 месяцев назад

further more can you advise what to do if you dont have dedicated "=" but only as shift 0 to use that awesome alt = function

@user-in5jc2gg2l 7 месяцев назад

Amazing!

@ExcelU 7 месяцев назад

Thanks!

@ChrissyNigaud-po3ll 5 месяцев назад

The case that allows you to transpose must be the pivot table. Would it be after using SQL to obtain the main n then use that n factor in order to get the desirable outcome? one thing is hard to learn here in Linked in is that we know the tips and tricks but we can't imagine what and when scenario we can use it! Thanks for the interesting clip!

@AaronD711 8 месяцев назад

A+! The best information on YT by far.

@ExcelU 8 месяцев назад

Wow, thanks!

@yayaalim2643 Месяц назад

I have an assessment in the morning on excel......I sooooo very nervous 😓

@phandongexcel 3 месяца назад

I like this video ❤❤❤❤❤

@sunillokwani7588 8 месяцев назад

I really liked ur style of coaching

@ExcelU 8 месяцев назад

Thanks for your kind note :)

@mikes2147 7 месяцев назад

I don't usually comment, but, this is great. Great job!

@ExcelU 7 месяцев назад

Thank you :)

@canirmalchoudhary8173 8 месяцев назад

Auto Outline is amazing

@markperrah186 3 месяца назад

Jeff soo good to see your face. It would seem we were both bitten by the programming bug in Basic programming class summer school jr, high at Walker. I have fallen in love with Excel VBA and see your passion for excel is mutual.

@ExcelU 3 месяца назад

Mark ... is it really you ... wow!!! I'd love to catch up. Let's connect on LinkedIn or something!

@miamited69 5 месяцев назад

Great tips. I am looking to increase my skills and am wondering what aspect is most in demand, BI, dashboarding, etc.

@ExcelU 5 месяцев назад

Hi Ted! Thanks for your kind note! As far as which Excel skills are most in demand, I'm not sure which would be most beneficial as it sorta depends on your role/company. But, to generalize, I'd recommend a solid foundation of functions and formulas, PivotTables, Power Query, and Power Pivot. These Excel skills would be beneficial to many Excel users.

@miamited69 5 месяцев назад

@@ExcelU Thank you.

@centugurdag7776 7 месяцев назад

hi great content , thank you but could not download exercise file, there is a kind of blocking at your web site

@DanielLamarche 8 месяцев назад

Shortcut for Filter is Ctrl + Shift + L. It can also be used to clear a filter by quickly press Ctrl + Shift + L twice. BTW this video is a perl!!!!

@andrevdw747 Месяц назад

Wauw, I thought that I mastered excel already. Well I didn’t 😂. Thanks!

@The1Gujjar 9 месяцев назад

Mr. JEFF you are Walter White of the Excel 😅

@jjholiman Год назад

are you frickin kidding me? these are life changing.😂😂😆😃🤣

@ExcelU Год назад

Thank you :)

@miall69 Год назад

Hello Jeff. Is there a chance to get the practice workbook? Thank you.

@ExcelU Год назад

Thanks for the comment, I created a download page for all 7 files (zipped) here: www.excel-university.com/90rmbamnng0 I also added the link in the video description for future viewers :) Thanks Jeff

@miall69 Год назад

@@ExcelU Thank you very much Jeff.

@brucemcfarlane 4 месяца назад

In Hack 4 where you can use fill series-drag with right click-paste as values only; I realise this is really great for converting formulas instantly to values, but do you have a solid hack for converting text to values? I’m not sure why but often the recommended routes don’t work - eg add a 1 in a cell, copy, select the “text” you want as numbers - paste special value & multiply. Still not numbers aargh.

@sedicirich 7 месяцев назад

God I searched for a function to sum above for multiple columns. Alt=, damn! Great vid

@lynettecolvin8085 4 месяца назад

These are great hacks but I'm having trouble with the equivalent keys on a Mac. I tried Alt+= (which should be Opt+= on a Mac) but it didn't work. Any suggestions? Thanks!

@ExcelU 4 месяца назад

Although I don't have a copy of Excel for Mac here that I can confirm, I believe it may be: ⌘⇧T