30 Awesome Excel Tips and Tricks for 2023

[@SimonSezIT]

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

[@mainul1444]

❤🎉

[@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 :-)

[@rajeevgosavi4514]

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

[@mariamagandi3777]

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.

[@mukthizcreation]

thanks for your excel skills exp tutorial

[@odessawilkinson456]

Your Snapshot is really great✅

[@arifuzzamansumon6865]

Thanks a lot.

[@SimonSezIT]

Most welcome!

[@s9144z]

thankyou so much for this video 🙏🙏🙏

[@SimonSezIT]

Most welcome 😊

[@BangabhabanClub]

excellent

[@SimonSezIT]

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 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@biglo813]

Maaaaaan this is so awesome! THANK YOU.

[@SimonSezIT]

Glad you like it! ;-)

[@SirKombabomba]

COOL TIPS=-Thanx

[@devpatel921]

Thank you

[@SimonSezIT]

You're welcome

[@emilyt9690]

Thanks!

[@SimonSezIT]

Thank you for appreciating our work and your contribution! 😊

[@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 .

[@alializadeh8195]

Thanks

[@goldendice2254]

Excellent Job . Thanks for sharing

[@SimonSezIT]

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

[@Goddibaba]

@@SimonSezIT no kidding

[@rajeevgosavi4514]

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

[@akshitshetty7504]

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

[@haroune711]

thanks so much for this useful video 😊

[@SimonSezIT]

Our pleasure 😊 We just published our 12-hour Excel course -> kzbin.info/www/bejne/eomyomSunq6UfJI

[@IsaHarb]

Are we able to print out these siles.

[@azalove3974]

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

[@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

[@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

[@Constructionskills11]

5 to 5

[@SimonSezIT]

Wow, thank you! 😃

[@musiliuloyaberry3229]

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.

[@monwabisibudaza8719]

can I please get a practice sheet?

[@SimonSezIT]

Apologies, there are no practice sheets included.

[@darlyspexa6010]

What is the cost of your tutorials?

[@SimonSezIT]

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

[@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]

Deb Ashby is the best instructor at Simon Sezit

[@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]

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.

[@daveh4208]

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]

Appreciate this feedback. Thanks for watching! 😃

[@ironjamesvane]

First setting doesn’t even exist anymore

[@MsKIDIST1]

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

[@CrackedTubeGamer]

No it doesnt.

[@พี่ปุ้ยเออาร์ไอที]

thank you

[@SimonSezIT]

Welcome!

[@ziaalkozai4389]

superb helpful video.thanks.