4 Essential Excel Settings You Need to Review NOW!
ฝัง
- เผยแพร่เมื่อ 4 มิ.ย. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
This video reveals 6 crucial settings you should tweak now for a smoother Excel journey. Perfect for anyone looking to enhance their productivity and ease of use in Excel.
👉 Key Highlights:
▪️ Control Cell Movement on Enter: Learn how to stay in the same cell after pressing Enter, ideal for frequent formula users.
▪️ AutoCorrect for Long Phrases: Save time by setting up auto-completion for commonly used long texts like company names.
▪️ Custom Lists for Quick Filling: Discover how to create and use custom lists for repeated elements like months or departments, applicable across all workbooks.
▪️ Preferred Pivot Table Layout: Set a default layout for pivot tables to avoid constant adjustments, including style and column width settings.
▪️ Streamlined Startup: Adjust Excel's startup settings to suit your workflow - skip the start screen and dive straight into a new workbook.
▪️ Preserve Leading Zeros: Stay ahead with a new beta feature that maintains leading zeros in numbers, crucial for product codes or phone numbers.
🌍 My Online Courses ► www.xelplus.com/courses/
00:00 Change These Excel Settings Now!
00:18 What Happens on Enter
01:46 Long Phrases with AutoCorrect
03:05 Custom Lists
05:03 Pivot Table Settings
07:21 Startup Settings
08:17 Keep Leading Zeros
09:47 Wrap Up
⯆ Link to the blog post: www.xelplus.com/excel-setting...
🎬 LINKS to related videos:
7 Things You're Doing WRONG in Excel: • 7 Things You're Doing ...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #exceltips #office365
![[Full Episode] MasterChef Junior Thailand มาสเตอร์เชฟ จูเนียร์ ประเทศไทย Season 3 Episode 1](http://i.ytimg.com/vi/Qs5zdBqLn_8/mqdefault.jpg)
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
We all know that you are amazing when it comes to excel and stuff, but I want to tell you, your humor is top tier also.
😅
I’ve been using excel since 1992. I still keep finding new things from your videos. Keep up the great work. I need to make your Chanel mandatory at work
Loved the pivot table advice
Same!
My favorite!
Custom List is Really Helpful. Thanks for sharing Leila, and your voice is so sweet to hear.
Something you didn't mention with autocorrect is that the entries you add here apply for all Office programs not just Excel - which I find really useful.
Or in reverse, if you don't want shit to autocorrect your _also_ need to do this in ever single office app to shut off autocorrect. Shit is so annoying.
I was going to say this too. So if you create an AutoCorrect entry in another Office app it will be in Excel too! Sharing is caring!
The beauty of this video is that I already knew most of the features, but I couldn't even imagine how to upgrade my work with them!!! Just genius!!!! Thanks 😊😊
You're very welcome!
LOVE the Pivot table setting!!! Thankyou for showing this
Absolutely love these tips. So simple and make those repetitive steps so much more efficient
I like 05:03 Pivot Table Settings the most. Really useful way of saving a bit of time if you're using pivot tables often!
I agree 💯. Thank you Leila.
Yes you are right
I only wish you could also specify the default number format for the values.
@@RonDavidowicz True.
this is one of those things that i've always said to myself "i'll google that after this piece of work" and always forget once i've finished the task 😄
It would be nearly impossible to find a more impressive and knowledgeable personality on TH-cam, thank you so much for the skill in which you bring the information forward.
I couldn't agree more
So glad to have stopped by to learn about the Pivot Table Settings. Building a dozen or more Pivot Tables daily and all those [groan] annoying changes from the default wasted a lot of time over the years. No more!
Thanks Leila! 👍
Glad it was helpful, Steve!
All of them are so useful :pivot (not adjusting, tabular remove buttons) , all these anoying time wasters even the excel startup skrin. Great vid L
Thanks for watching, Tina!
Thank you so much. I guess many of us were happy to learn new trick with pivot table style;) And now you can clearly hear a sigh of relief
Jeez, you just cannot help but learn with Leila!!!, so smooth and to the point.
Girl, you are just too good at what you do. I just started watching your videos and I "liked" this video before I even watched it lol.
Thank you so much!!
Thanks! The setting with "Enter" and open screen is really helpful! Really simple settings, but probably most powerful ones!
Great to hear!
The Pivot Table setting adjustment is SO helpful! I always set up my pivot tables like you did and I had no idea I could change those settings! Thank you!
Thank you! I love the view of 'recent workbooks' when I open the Excel app. I'll keep this default setting.
this is so helpful, especially about leading zeros. been figuring out how to retain the zeros on my report control numbers, now i know. thanks so much.
Can't wait for the leading zero's option to be released!! This one has been needed for a very long time!! :) Love all your videos... they are so helpful and easy to learn from!! You are my "go to" when I'm stuck with anything! Thank you for sharing!
Thank you Leila !
I found the Lists & PIVOT quite good.
I so appreciate your videos, Leila. Thank you so much🌹
You are so welcome!
Great Leila, All the functions are very helpful for day to day excel workings. Thanks.
You're so amazing. Your excel tips actually changed my life
Helpful Video, Thank you, Leila.
Pivot table settings really useful! Thank you for sharing!
Thanks for the Pivot Table tip. So valuable
Love the one for pivot tables. Such a time saver!
This was totally new! Thanks Leila! 😊
Excellent suggestions, thank you very much. I will use the pivot table options setting immediately!
I just find you useful. I just started learning Excel because of my job and your short precise lessons are perfect. Thank you so much!✌️
Pivot Table setting are really helpful!
بهترین استاد اکسل دنیا (ممنون از دروس مفید شما)
The pivot tables settings will really be helpful for me. Than you!
Thank You!!! I knew there had to be a way to change the default for Pivot Tables! Your suggestions were exactly what I needed!
Beautiful video, thanks!!
Thanks Leila! Especially for the auto correction tips!
You're so welcome, Steven!
Pivot default info was very helpful. Sometimes it's the small things that make a difference to people's work lives. I have subscribed now, and feel like I have my personal productivity coach, Leila sitting with me as I work. Thank you.
OMG! Default formats for pivot tables will save me lots of frustration! Thank you for highlighting this!
all are good tips. I found pivot table and leading zero is extremely helpful. Thanks .
Thanks, Leila. The pivot tip is definitely going to save some time.
Another tour of Leila's Excel Mansion ... opening doors to rooms that I never knew even existed.
PS
At the 10 minute mark " ... thank you for being here ...".
No ... thank YOU for being here ... otherwise I wouldn't be here ... 😍
I'm honored, Chris!
Big thumbs up for the pivot table defaults tips! Thanks for sharing Leila!
Thanks for the thumbs up, Steve!
Hi Leila. I like the option of changing what happens when pressing 'Enter'. I can see that being useful on projects when developing and testing formulas. Thanks for posting. Cheers from Cincinnati, USA
I used Ctrl+Enter to stay within the cell but this tip is super handy. Thanks Leila, as always
I enjoy your teaching Leila, you are amazing 👏
Hi Leila, Good day to you ! Always your tips and all about excel information very useful and save the time. Thanks a ton.
The pivot table settings are extremely helpful! Thank you, Leila!
Glad it was helpful!
Precise and clear
I really liked the configuration of the dynamic tables, so I can save effort and time, thank you very much and greetings from Mx
Wow! Custom lists are amazing, Thank you 😊
Thank you for the educative & useful video.
Thank you!!!! I work with product codes all day long and the "Keep Leading Zeros" is a godsend.
Just changed my pivot table settings. So excited about this. Thanks!
Fantastic!
Very helpful. Thanks.
Thank you. It’s very helpful to save time!
Glad it helped!
Thank you for all the useful videos.
The pivot tables setting is amazing. I did exactly the same things as you do every time I use pivot table. I no longer have to now.
Thanks you for these tips. You are a great presenter also.
Can't wait for the last Excel setting to paste including leading zeros to come to my excel! Thanks for the fantastic videos!!
Thanks.Leila, I love the custom list.. nice tricks as always.. ❤️ hope you make videos on advanced with multiple xlookup example... Thanks for this, it helps us a lot learning new things again..
The last one is the most useful for me ☺️, thank you
I love all the default Settings... Thanks Leila, big fan of yours... just waiting for the leading zero option in my excel...I love the Pivot setting and its very useful for me :)
I Love the way you nailed it in all your videos. Thankkkkkkkkkkkkkkkkkkkkkk You Sooooooooooooooooooooooooooooooooooo Much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Really helpful...simply Awesome!
Great tips!!! I especially like the pivot table tips
Leading zero's tip is so helpful!
i love your presentations, thanks for sharing.
Thanks Leila for good tip. You look great.
The PivTbl configuration was an eye-opener to me. Thank you.
My pleasure, James!
The default pivot table formatting tip has changed my working life!
Definitely, very useful tips . ❤❤
Amazing! Thank you for letting us learn alot from you....
Leila. you are superb "custom list was great"
I really like the custom lists. Didn't realise it before, thanks!
As usual truly amazed with your Excel Tips ... Thanks a lot
Most welcome!
This was useful.
thank you
Thank you for your effort, its useful
The Pivot tip and the custom list are the best... It's going to save a lot of my time... Thank you...
Glad to help!
Awesome job as always Leila.. Always find something or other better from your videos.
Loooove the PivotTable default setting...been annoyed by it for so long! Thank you Leila!!
Same here :) Glad it was helpful, Samantha!
Thank you Leila. I will use at least 4 of these tips to expedite my routine work.
Happy to hear that, Neema!
Really useful way of saving a bit of time
Leila you are just amazing..
Great work..😍
All of these are good suggestions, Leila!
The first one I have configured myself for quite a long time already (keep the cell selected).
I combine that with the fact that I have unchecked the automatic fill down of the column formula in an Excel Table (I decide on that manually - and I do get a useful icon for that every time the occasion presents itself).
Great! Thanks for sharing the table config. I never thought of turning that off.
Thanks Leila so much for the great tips. They are very useful. I like tips No.1, No. 4 and No.5 the most.
Glad it was helpful, Ana!
Great! I loved the way you teach. I really appreciate your hardwork.
Custom lists was a game changer
Thx for this quality content!
Thanks, Leila....very good...
Pivot table setting is just 🔥🔥 you can’t guess how many years of my life I’ve been wasting with this so far 😭 Leila you are a gem ❤️❤️
The pivot table is awesome, save my time from now on, Thank you soooo much. Also the position post ENTER.
Glad it was helpful!
Great tips. Thanks Leila.
I'm going to activate the 5th right now. It is very annoying to have to always choose the blank workbook.
Another that I think is very useful is, in Advanced, the one that allows the editing of cells. I don't like to edit cells when I double-click. I'd rather go the reference that's made there. It is very usefull to review files and immediately go to the sheet or analisys that I want to see!
I look forward for another video of you 💚
Good video on setting I’m going to use it on my pivot table thanks
Thanks a lot for you tips, these are awesome, and your English is very easy to understand, I'm from Chile with the intermediate level english, and I can understand all your comments. Bless
Thanks for the Pivot Table default, wish I knew this previously would of save insane amounts of time
Leila, you have become my guru!
Very good! Thanks Leila!
Any chance to add "enter action" to a button in the Quick bar?
Amazing..thank you.