30 Awesome Excel Tips and Tricks for 2023

Рет қаралды 340,837

Күн бұрын

We combine 30 Excel tutorials into one step-by-step Microsoft Excel training tutorial for beginners. This Excel tips and tricks are ideal for beginners, but also for intermediate Excel users. Use these tutorials for maximize your productivity!
📝 Table of Contents/Timestamps
0:10 How to Use Excel Dark Mode
3:00 Using the Accounting Number Format Excel
7:55 How to Split Cells in Excel
11:29 How to Group Worksheets in Excel
14:01 How to Add Error Bars in Excel
18:07 How to Indent in Excel
21:38 Excel Format Painter - How to Use it
26:12 How to Insert Checkboxes in Excel
34:37 How to Fix the Spill Error in Excel
38:37 How to Lock Cells in Excel
43:37 How to Record a Macro in Excel
50:07 How to Delete a Named Range in Excel
54:19 How to Insert a Page Break in Excel
57:32 How to Fix Missing Scrollbar in Excel
1:01:04 How to Insert a Heat Map in Excel
1:04:47 How to Fix the Name Error in Excel
1:10:01 How to Move Rows & Columns in Excel
1:14:23 How to Remove Spaces in Excel
1:17:57 How to Add Bullet Points in Excel
1:21:03 How to Make a Pie Chart in Excel
1:24:16 Freeze Rows in Excel
1:26:31 How to Convert Microsoft Excel to Word
1:30:04 How to Stop Excel rom Rounding
1:33:02 How to Calculate SUBTOTAL in Excel
1:37:09 How to Create an Excel Slicer
1:40:08 How to Graph a Function in Excel
1:44:08 How to Convert Text to Number in Excel
1:48:12 How to Copy Visible Cells Only
1:53:29 How to add a Secondary Axis in Excel
1:56:44 How to Select Non-Adjacent Cells in Excel
🌍 Get unlimited training with Simon Sez IT’s 170+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a a free 30 day trial to our complete training library of 9,200+ video ⏩ www.simonsezit.com/ssit-first...
Looking for Excel tricks or Excel tutoring? Check out our Excel 2021 tutorials for intermediate users playlist here:
👉 • Excel 2021 Tutorials f...
🔥Check out our FREE 300+ hour training course playlist here 👉
• Simon Sez IT Long Trai...
🚀 Level up your Excel skills with free training here 👉 • Microsoft Excel Tips a... & here 👉 • Microsoft Excel Traini...
& Pivot Table training here 👉 • How to Use Pivot Table...
💻Watch additional popular Microsoft Office tutorials from Simon Sez IT:
✅ Excel 2021 tutorials for intermediate users playlist here:👉 • Excel 2021 Tutorials f...
✅ Ultimate Microsoft Office Course (12-Hour Course for Beginners):👉 • Microsoft Office Tutor...
✅Learn PivotTables in 1 Hour (Excel Crash Course)👉 • Pivot Table Tutorial -...
💬Stay in touch!
✅SimonSezIT.com: 👉www.SimonSezIT.com/
✅StreamSkill.com: 👉StreamSkill.com/
✅KZfaq Channel: 👉 / simonsezittraining
✅LinkedIn: 👉 / simon-sez-it
Please 🔔SUBSCRIBE 👉 kzfaq.info...
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)
#SimonSezIT #Excel

Пікірлер: 61

@SimonSezIT Жыл бұрын

🚀 Boost your Excel skills with these free Excel playlists 👉🏼 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉🏼 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉🏼kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u 🔥Check out our FREE 300+ hour training course playlist here ➡ kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@mainul1444 11 ай бұрын

❤🎉

@Goddibaba Жыл бұрын

For someone who suffered from Computer vision syndrome last month, that dark mode technique is a helper. Thank you.

@SimonSezIT Жыл бұрын

Glad it was helpful :-)

@ziaalkozai4389 Жыл бұрын

superb helpful video.thanks.

@rajeevgosavi4514 Жыл бұрын

Brilliant and very informative. Would appreciate to receive link to download spreadsheets.

@alializadeh8195 Жыл бұрын

Thanks

@SirKombabomba Жыл бұрын

COOL TIPS=-Thanx

@mukthizcreation Жыл бұрын

thanks for your excel skills exp tutorial

@devpatel921 Жыл бұрын

Thank you

@SimonSezIT Жыл бұрын

You're welcome

@haroune711 Жыл бұрын

thanks so much for this useful video 😊

@SimonSezIT Жыл бұрын

Our pleasure 😊 We just published our 12-hour Excel course -> kzfaq.info/get/bejne/er5_pJSpzq_FdmQ.html

@odessawilkinson456 Жыл бұрын

Your Snapshot is really great✅

@goldendice2254 Жыл бұрын

Excellent Job . Thanks for sharing

@SimonSezIT Жыл бұрын

Thanks for watching! We'll have another set of 10 tips coming soon :-)

@Goddibaba Жыл бұрын

@@SimonSezIT no kidding

@biglo813 Жыл бұрын

Maaaaaan this is so awesome! THANK YOU.

@SimonSezIT Жыл бұрын

Glad you like it! ;-)

@arifuzzamansumon6865 10 ай бұрын

Thanks a lot.

@SimonSezIT 10 ай бұрын

Most welcome!

@s9144z Жыл бұрын

thankyou so much for this video 🙏🙏🙏

@SimonSezIT Жыл бұрын

Most welcome 😊

@emilyt9690 Жыл бұрын

Thanks!

@SimonSezIT Жыл бұрын

Thank you for appreciating our work and your contribution! 😊

@BangabhabanClub 6 ай бұрын

excellent

@SimonSezIT 6 ай бұрын

Thank you so much for your kind words! We're glad you enjoyed the video.🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!

@user-vw4ji7hi5y Жыл бұрын

thank you

@SimonSezIT Жыл бұрын

Welcome!

@mariamagandi3777 6 ай бұрын

Thank you for sharing these great tips and tricks. Really useful. Please can you share the formula for the % of tasks completed? I don't know if I'm missing something. I'm not satisfied with the % I'm getting. Once again, thank you all.

@Constructionskills11 Жыл бұрын

5 to 5

@SimonSezIT Жыл бұрын

Wow, thank you! 😃

@JStephs1950 Жыл бұрын

For text extraction of 1st and last names, once you have the first name, you can extract the last name using TRIM(SUBSTITUTE(FirstLastNameCell,FirstNameCell,"")). This replaces the first name with nothing, leaving the last name, and then trims off any extra spaces at the ends of the result. Trim() can also be used in to removed extraneous spaces fomr around the first name .

@akshitshetty7504 Жыл бұрын

Hi, can you tell me how copy to formula to another sheet without changing the cell reference from the first sheet?

@rajeevgosavi4514 8 ай бұрын

Please provide a link to download practice sheets to follow along.

@azalove3974 6 ай бұрын

what if I would like to split a cell to the first, middle and last name?

@user-zl8ug6py1f Жыл бұрын

Are we able to print out these siles.

@shyamadasgupta9423 Жыл бұрын

What to do if I don't want to remove VLOOKUP formula but I need to read the long multi-line text in some cell? If i click that cell, instead of displaying the text in the formula bar, it shows the VLOOKUP formula. I want an option where I can temporarily view/read the results in the formula bar without hiding/protecting/copy pasting the worksheet/cells

@borstenpinsel Жыл бұрын

Go to the formula input on top and press F9. Excel will calculate the entire formula and temporarily display the result

@tarunaggarwal194 Жыл бұрын

Can't we get the practice file?

@azizurrehman6296 Жыл бұрын

Hello sir...i am from Pakistan i am regularly watching your videos. I am facing a problem in excel I have PDF files in Urdu (Arabic) like so i want to convert these files into excel file. I used Power query but it doesn't work for me

@musiliuloyaberry3229 3 ай бұрын

I try the bar dark mode not working on my pc

@GirishMalur Жыл бұрын

can you please share the exercise file for the this tips. "30 Awesome Excel Tips and Tricks for 2023".

@SimonSezIT Жыл бұрын

Apologies Girish, there are no exercise files for these tutorials.

@darlyspexa6010 Жыл бұрын

What is the cost of your tutorials?

@SimonSezIT Жыл бұрын

You can check out our different subscription types from our site ➡️www.simonsezit.com/signup/

@monwabisibudaza8719 Жыл бұрын

can I please get a practice sheet?

@SimonSezIT Жыл бұрын

Apologies, there are no practice sheets included.

@ironjamesvane Жыл бұрын

Never seen anyone move a mouse around so fast in my life. they should quit their day job and become a pc gamer.

@nastykitten8970 3 ай бұрын

You can do it too. It’s in the mouse setting. In that setting you can change how fast your cursor moves relative to the speed of your physical mouse.

@michaelaudioh4659 Жыл бұрын

I didn't understand the insert checkbox part of this video. The tutor was too fast and I lost track of the lesson

@marksandsmith6778 Жыл бұрын

try slowing down the play speed (!)

@lilysita6767 11 ай бұрын

Deb Ashby is the best instructor at Simon Sezit

@daveh4208 14 күн бұрын

Next time you do one of these, don't go crazy with spinning the mouse all over the screen. Started about the 27 minute mark.

@SimonSezIT 4 күн бұрын

Appreciate this feedback. Thanks for watching! 😃

@MsKIDIST1 Жыл бұрын

IT SHOULD WARN THAT THE FORST FIX DELETES ALLLLL YOUR SHARED PHOTOS!!!

@CrackedTubeGamer 6 ай бұрын

No it doesnt.

@ironjamesvane Жыл бұрын

First setting doesn’t even exist anymore

@brendadolloff7313 Жыл бұрын

Wayyyyyyy too fast! I like Excel and use it daily, but these are presented too fast, in my opinion.

@SimonSezIT Жыл бұрын

You can decrease the video speed in the settings.