Excel Tips and Tricks

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step tutorial, learn the best 11 Microsoft Excel Tips and Tricks that are sure to make your work easier and more efficient. As a few examples, with these hacks, you can move columns with just a simple drag and drop, sum up all the values with just a simple shortcut key, and pick out just the information you want from a column.
👋 Additional resources
- Sample workbook to follow along: 1drv.ms/x/s!AmxrofZZlZ-whN9Vt...
- Full course on formulas and functions in Microsoft Excel: • Excel Formulas and Fun...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⌚ Timestamps
0:00 Introduction
0:34 Drag and drop to move columns
2:38 Auto sum with ALT + =
4:01 Calculations with paste special
5:52 Unique count
7:06 Complicated functions
8:45 Custom lists
10:34 Named ranges
12:33 Status bar metrics
13:39 Flash fill
15:00 CTRL + Enter
17:27 Quick access toolbar
18:57 Wrap up
📃 Watch related playlists
- Playlist with all my videos on Microsoft Excel: • ❎ How to use Excel
🚩 Connect with me on social
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🙏 Request How To Tutorial Videos
forms.gle/BDrTNUoxheEoMLGt5
🔔 Subscribe to my KZbin channel
kzbin.info?...
🎬 Want to watch again? Navigate back to my KZbin channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert #microsoftambassador

[@KevinStratvert]

🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

[@anubhavtrivedi1283]

Please make a free course I need

[@chookfeather]

Hi Kevin..I have Excel through Office365 at work. In a previous version I could set up a workbook as view only but allow it to be edited with a password. Is that set up still available? Where is it? I used to right click the workbook and select options to do it previously

[@ellykamps4790]

In Nederlands svp

[@texasseastar]

Just when you think you're an Excel whiz, Kevin shows you that you're just a beginner and have been doing things the hard way. I can make use of MOST of these tips - thank you so much! Already bookmarked the video for future reference.

[@bettyjimmo631]

Super stoked to learn new tips and tricks, especially from you, Kevin. Love your clear and concise explanations and examples. You are on the top of my favorites👍😎👏

[@cassioalexan]

Wow! So much new tips I didn't know before! This is certainly a video in which I'll have to stop-and-play to write down every instruction listed. Thanks for sharing, Kevin!

[@avoiceinthevoid]

Thanks Kevin. I found your channel quite recently and use Excel everyday for various projects, so it is great to learn some new methods and functions that I can use with them.

[@pgcsec]

First two minutes amazing - thank you so much for taking time to leave these great tips.

[@hippopotomonstro3713]

The trick to be able to copy values from formulas in the same cells as the formulas is so elegant and brilliant, congrats and many thanks!

[@maryb.6446]

Thank you so much for this video! The Flash fill tip literally blew my mind! It will save us so much time. Can't wait to share this with my team at work. Thanks a million.

[@yan5699]

Learned at least 5 new tricks today. Thanks Kevin!!!!

[@irokosuemmanuel5493]

You're amazing. I don't have the right words to describe you. Your videos are exclusively my learning tools on excel

[@theedspage]

Right click columns, quick access toolbar, and flash fill are ones I look forward to using. Thank you, Kevin!

[@stevehenry9826]

Excellent tips Kevin! Thank you!

[@Jompa10]

I absolutely love your videos! I so needed to learn these things. I love these shortcuts and tools

[@factor1i]

Always something new to learn from you, Kevin... 👍🏽

[@KevinStratvert]

More to come!

[@michaelmaganzo1934]

Always learning new tricks. Thanks @kevin stratvert. The GOAT

[@sunnydharwal89]

I love the videos Mr Kevin. I learned a lot about excel. Lots of love and blesses to you! 🙂

[@bejai1962]

Flash Fill and Alt+= are game changers for me!!!

[@maxtrenck8511]

Thank you for a most informative video. I cannot wait to put some of these into use. 👍🏼

[@KevinStratvert]

Have fun!

[@scottdyke7488]

Thank you SOOO much! These are helpful. I use Excel everyday, so these will help me get my results faster and I can get to my next project!

[@DarkDudesAI]

Kevin, you're an all-rounder in Microsoft!

[@KevinStratvert]

😁

[@pouncer84]

These were so cool. Now to remember them. Thank you.

[@user-yb4xf8gd6l]

Que suerte que existis! Kevin sos el #1. All tricks were new for me!

[@officetricks6303]

Excellent compilation for the tips and tricks in Excel, picked up some handy ones which i can use at my day to day work.

[@graceyim2941]

Wow, having indigestion. So many tips. I think I need to watch it 1000 times to get it this time. Thank you Kevin.

[@livingstonemainya1568]

Thanks Kevin. You are my excel saviour

[@vijayarjunwadkar]

Cool tips Kevin, Thank you! Did learn few new tricks, so keep them coming! 😊👍

[@KevinStratvert]

Many more to come, Vijay! I had to cut a bunch of good ones from this video to keep this to a reasonable length for KZbin.

[@olenakurdel8860]

Thank you for tips!!!

[@HeatherMajors]

Kevin, this is a well organized video with many helpful tips. As always thank you so much for the effort and time you put into these.

[@KevinStratvert]

Of course, thanks for the note, Heather!

[@SavageGothamChess]

That intro was awesome! It's a great way to hook the viewers till the end.

[@KevinStratvert]

Glad you noticed 😁👍

[@ElPetoChan]

Pure Gold Info, thanks!!!!!!

[@remeshsathyadevan]

Thank you for providing such useful tips

[@MichelleCubas]

Well done. I've had difficulty in the past. You've distilled it down where I get it!😀

[@fezzsmusic]

Great video, keep them coming, always learning atleast 1 new trick from every upload.

[@raniafareh2492]

You have great quality videos that are very useful. I just subscribed to watch more. You are doing a great job. Thank you so much!

[@projektexcel7402]

Very useful, thank you! I need to use these tricks at my work and projects!

[@gabeclements]

you helped me out a lot by creating this video. Thank you so much

[@MK-ni6gs]

Very very, nice. Learned a lot of new features, thank you for your excellent vids!

[@emilyannvelilla8437]

Mind blown 🤯…Kevin you know too much :) …fantastic video!

[@1youngmo1]

Thank you for sharing. Your Awesome!

[@stephencatanzaro310]

Thanks Kevin great video great tips,

[@mohnishbisen6171]

Thank You Kevin for bring such helpful stuff and I am expecting more new videos...Keep it up

[@hazemhammad2684]

thank you kevin and you company

[@surjaa.c]

Wow! I only knew 1 or 2 of these so I'm really glad to learn the other ones 😀

[@IdrisAlOmani]

Great tips. Many thanks

[@malamute4793]

You are a good man, a wise man, a smart man, a family man

[@MK-ni6gs]

Very nice, as always!

[@anujgupta3847]

Excellent information...!!!

[@sameh1180]

As always, fascinating

[@shelleylee9154]

You are so awesome! Thanks so much for making this video

[@hbizmoneyladder]

Kevin you the best!

[@bethhentges]

Yes I learned some new tricks. Thanks.

[@anyandeveryistaken]

LOVE IT KEVIN.

[@RichardGetzPhotography]

Great tips, thanks

[@alonaisrael]

thank you. You are the best!

[@hayat_soft_skills]

Cool . Thanks!😊

[@fidojps7522]

Your videos have taught me so much. Great Job

[@KevinStratvert]

Glad to hear it!

[@2023Red]

Again, super stuff.

[@charlesdemott]

Thank you!

[@julitacastro17]

Wow! This is very helpful😍

[@humanityfirst2549]

Thank you Kevin, S.

[@asthetic11144]

Very worth full tricks.

[@peggylouie7624]

Thanks for the tips!

[@KevinStratvert]

You bet!

[@praveenvasudevannair]

Super Kevin Learnt few new things 🙂

[@newmandoss]

Super, unique value & count are really Good, which I spend in copying into another sheet and remove duplicate

[@omegamc_1263]

Hey I'm actually a new subscriber and im glad to see your KZbin channel is doing well, friend

[@majed9911]

Kevin is a good guy

[@Jeff-yy5fe]

Kevin=MS ninja!

[@elivne]

thank you :)

[@hadasmiszelowski5186]

just came across your excel videos do you have any videos or can recommend ones on how to create a personal budget and one to track your finances for tax season for a novice excel user I think in Australia our taxes info would be a bit different to yours in terms of data to collect and submit just after some basic tutorials or templates to get my head around how to do both of these thank you Keven 🙂

[@munir715]

v nice sharing

[@donatusdikenikehiagwu1364]

Thanks

[@syedjafarullah6986]

good idea

[@CPATuttle]

thank you

[@iqthion]

Amazing. I think myself decent at excel. But I dont know most of this haha thank you.

[@peterodesola5056]

thanks

[@BeulahWellington]

Thank you so much, Kevin. I have been learning a lot from you. Can you show me a shortcut to unhide a row of hidden cells? I have a group of hidden rows and I want to unhide them individually from top to bottom. I would really appreciate your help. Thank you.

[@KevinStratvert]

Click in the top left corner of the cells and rows and then right click and select unhide. That’ll show all rows and columns in two clicks.

[@BeulahWellington]

@@KevinStratvert Thank you for your quick response, Kevin. I really appreciate it.

[@prokorshopal4865]

0:00 - Hi Kevin. 👋 19:32 - Definitely 536th thumbs up from me to the imposing video. 👍 Cheers.

[@KevinStratvert]

Thanks 👍

[@siddharthmurarka6477]

Need your help qnd guidance on how to crate a work flow in task and link it to folder in drive and email of gmail

[@Testee]

Nice video Kevin! A question: Custom lists used to be saved in our local machine registry instead of being saved in the excel file, so when you share the file, the order stayed but the other person in another machine couldn't use the custom list to order. Is it still the same way as of today? It's a really neat feature but this limitation seems so odd.

[@KevinStratvert]

That’s my understanding, the custom list is only on your local PC and doesn’t follow the Excel sheet if you share it.

[@Testee]

@@KevinStratvert That would be a really nice feature to be added to future updates.

[@ComputerClass360]

love from 🇮🇳 India

[@surendrakumar-sr7rs]

Good

[@edgypatch]

Nice

[@travelwell6049]

I have found flashfill useful to do a column with email addresses for people in my company when I have only their names. It can then be used for mail merge.

[@KevinStratvert]

Love it!

[@sonerguney3225]

Super

[@tracyrankin1293]

Can you do a video on Nested IF formulas and Switch Functions? I find your videos so helpful and easy to follow.

[@Forensic1Man]

Kevin, Very nice presentation using the full potential of Excel and now I need some snicker-doodle cookies for lunch. One difficulty I have with Excel is joining many different Excel files for tax season. For my customers I have a separate Excel invoice. All invoices are formatted exactly the same. How can I search all the Excel files and get the total amount billed for the year? I currently have to open up each invoice, then type in the invoice amount into another separate Excel file. It takes all day!! Do you have any ideas?

[@KevinStratvert]

You can point to cells in other workbooks e.g., in a cell, as an example, type in ='C:\Users\Kevin\[WorkbookName.xlsx]WorkSheetName'!$A$2... you can use these references in a formula like sum to add up the total across all the invoices. If your invoice numbers simply increment up, you can bulk create the references. To manage all the links, you can click on Data and then Edit Links. That'll show you all references to other workbooks. Hope that helps!

[@user-kx6qq6sp5d]

Kevin, I tried to move my taskbar several times, but it doesn't work. I even tried to move it to left and right and that does work either. Has Microsoft deleted this feature?

[@user-kc2qu1fm3e]

Hi .. I help in Merging .. I have two workbooks..each workbook has two tabs... each tab has two set of data(one set row 1-100 other set 105 to 205) how to combine them .

[@seanmemory4089]

Can you give a value to a cell without the number appearing in the cell. For example the cell has a drop down yes or no, Yes is 20% and no is 0%. Then have a cell at the end that calculates the total percentage

[@ashwinisg7012]

Hello. I have created a macro in my personal workbook but when I saved it(macro enabled) in a shared path my teammates are unable to run the macro and there is no VBA found in their system. Please help me to fix this

[@atifusmani1409]

Thank you @Kavin! I like to know that what do you for zooming the screen?

[@KevinStratvert]

I adjust the display scaling, so things appear larger and then key frames in DaVinci Resolve for zooming in and out.

[@atifusmani1409]

@@KevinStratvert thanks for responding. Please make a video on it, whenever you get time. I like that feature a lot.

[@KevinStratvert]

Here’s a video I did on it a while back: How to Zoom In & Out on Screen Recording kzbin.info/www/bejne/jWncdJWKoaeVZqs

[@atifusmani1409]

@@KevinStratvert thank you so much!

[@FaZeRome]

Great video first comment!!!

[@nazmulhaque592]

Thanks sir

[@graceyim2941]

Dear Kevin, I inherited a large size Excel file from someone. How can I start another Excel file with the same header? Thanks.

[@Jaimadurga190]

Hi Kevin, could you make a video on Audio recording and editing softwares for pc and Android? Especially how to remove background noise from audio. Please I could think of noone better than you to ask this.

[@KevinStratvert]

One of my favorite apps is Audacity. Here's a video I did on it: kzbin.info/www/bejne/r6utY4mvjtCgl6M There's an effect called noise reduction that will eliminate background noise. Let me know if this helps.

[@Sandroider]

Hmm flash fill with shortcut ctrl + E not working, but from the ribbon it works?

[@alexocs]

how to add hyperlink to checkbox selection?

[@kigwa1126]

love bit

[@warsamesultan]

Can you automove rows with just a click ? If not how can we do it?

[@MoTwoHi]

Aloha Kevin...Love your videos. I have a question....I have a simple multiplication formula in my spreadsheet/worksheet, but the answer does not display correctly. The formula is 3.38 hours multiplied by $18.27 the answer displayed is $61.66. The correct amount should be $61.75, a. 24-cent difference. This makes a difference in employees' paychecks. How can I correct this? If the time and a half 2.25 hrs multiplied by 1.50 = 3.38 x $18.27 the answer is $61.66, this appears to be those that do not have a perfect quarter-hour decimal [.25; .50; .75]. Would appreciate any help or suggestions. Mahalo

[@MoTwoHi]

Kevin, I discovered the problem. I did the Evaluate Formula and found the problem, the 2.25 x 1.50 = 3.375 x $18.27 = $61.66.