Important Excel Settings You Need to Review NOW!

Подписаться 2,6 млн

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

50% 1

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.
⬇️ Download the Essential Excel Settings Cheat Sheet 👉 pages.xelplus.com/excel-setti...
👉 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 Preferences 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
🎬 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

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

25 июн 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Download the Essential Excel Settings Cheat Sheet 👉 pages.xelplus.com/excel-settings-cheat

@fantasytrain42 Год назад

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

@KV21A Год назад

Custom List is Really Helpful. Thanks for sharing Leila, and your voice is so sweet to hear.

@BartJanicki Год назад

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.

@user-ks8dr7ch8t 11 месяцев назад

😅

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

@chh8860 Год назад

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 ... 😍

@LeilaGharani Год назад

I'm honored, Chris!

@kimwhidby3858 Год назад

Loved the pivot table advice

@Freemarkets1236 Год назад

Same!

@LeilaGharani Год назад

My favorite!

@tirukkovalikarthik8438 Год назад

Custom lists was a game changer

@mpugliano Год назад

It would be nearly impossible to find a more impressive and knowledgeable personality on RU-vid, thank you so much for the skill in which you bring the information forward.

@fahadpalladium2 Год назад

I couldn't agree more

@deanngilliver3374 Год назад

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!

@thenewdataguy Год назад

Thanks! The setting with "Enter" and open screen is really helpful! Really simple settings, but probably most powerful ones!

@LeilaGharani Год назад

Great to hear!

@paulinemurray8835 Год назад

Absolutely love these tips. So simple and make those repetitive steps so much more efficient

@e.bmijaresmarquez323 4 месяца назад

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 😊😊

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

You're very welcome!

@steves6557 Год назад

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! 👍

@LeilaGharani Год назад

Glad it was helpful, Steve!

@fuzzylon Год назад

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.

@j.ballsdeep420 Год назад

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.

@bencodykirk Год назад

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!

@andrewcharlesmoss Год назад

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!

@rajesh300982 Год назад

I agree 💯. Thank you Leila.

@SamirHabib Год назад

Yes you are right

@RonDavidowicz Год назад

I only wish you could also specify the default number format for the values.

@LeilaGharani Год назад

@@RonDavidowicz True.

@lilpinkiy Год назад

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 😄

@sunphyre42 Год назад

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!

@maymangundayao Год назад

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.

@jollyjuln1054 Год назад

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

@grantpepper1647 Год назад

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.

@craftpassion1812 Год назад

LOVE the Pivot table setting!!! Thankyou for showing this

@John-bn4pq Месяц назад

Thank you! I love the view of 'recent workbooks' when I open the Excel app. I'll keep this default setting.

@averaguilar Год назад

Jeez, you just cannot help but learn with Leila!!!, so smooth and to the point.

@shayemoore Год назад

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.

@LeilaGharani Год назад

Thank you so much!!

@zolzin561 Год назад

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!✌️

@silverlicious2086 Год назад

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

@tomrichardson7297 Год назад

Thank You!!! I knew there had to be a way to change the default for Pivot Tables! Your suggestions were exactly what I needed!

@rajeevgosavi4514 Год назад

Great Leila, All the functions are very helpful for day to day excel workings. Thanks.

@2012worship Год назад

Pivot table settings really useful! Thank you for sharing!

@Elbranto1 Год назад

Excellent suggestions, thank you very much. I will use the pivot table options setting immediately!

@rufaiabeeblahi7452 Год назад

You're so amazing. Your excel tips actually changed my life

@abdulsaidmkamara7305 Год назад

Thank you Leila ! I found the Lists & PIVOT quite good.

@shivanisrivastava5667 Год назад

This was totally new! Thanks Leila! 😊

@davidperez438 Год назад

Beautiful video, thanks!!

@datasimplify Год назад

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 💚

@berchu4577 Год назад

Helpful Video, Thank you, Leila.

@saritad8606 Год назад

Thanks for the Pivot Table tip. So valuable

@diosdadoatendido9418 Год назад

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

@naseebkhaan6487 Год назад

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

@dsbra1944 Год назад

Love the one for pivot tables. Such a time saver!

@thinkleclt Год назад

Leila I love your videos and your story. I’ve been doing excel for over 25 years and I still usually learn something from your videos. On changing the default behavior of keys like enter. That to me can be dicey. Might make your workstation fit better but then usually any other persons computer you’re on the setting is the other way. Just a thought BUT the great thing about your videos, you are t telling people they have to, just showing the option

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

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

@Stepford Год назад

Big thumbs up for the pivot table defaults tips! Thanks for sharing Leila!

@LeilaGharani Год назад

Thanks for the thumbs up, Steve!

@sushantachoudhury7021 Год назад

Thanks, Leila. The pivot tip is definitely going to save some time.

@marybatiancila5984 Год назад

Precise and clear

@sodbuster4411 Год назад

Very helpful. Thanks.

@dazzarg5 Год назад

Wow! Custom lists are amazing, Thank you 😊

@jesusangel1999 Год назад

Brilliant as usual!!

@brianpeterson5008 Год назад

Pivot Table setting are really helpful!

@larryklonowski7913 Год назад

Great tips!!! I especially like the pivot table tips

@djsennhauser Год назад

OMG! Default formats for pivot tables will save me lots of frustration! Thank you for highlighting this!

@justgettinon Год назад

Can't wait for the last Excel setting to paste including leading zeros to come to my excel! Thanks for the fantastic videos!!

@steventezcan689 Год назад

Thanks Leila! Especially for the auto correction tips!

@LeilaGharani Год назад

You're so welcome, Steven!

@henrypraise4873 Год назад

Really helpful...simply Awesome!

@SFUZIMOTO Год назад

Thank you for all the useful videos.

@AP-eb8hd Год назад

Awesome job as always Leila.. Always find something or other better from your videos.

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

I so appreciate your videos, Leila. Thank you so much🌹

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

You are so welcome!

@wilsonmoscoso4620 Год назад

Leila, you are the best!!!!!

@user-cd8nq2ro8n Год назад

i love your presentations, thanks for sharing.

@sairamvasa9504 Год назад

Awesome tips Leila as always.

@asimali5820 Год назад

Amazing! Thank you for letting us learn alot from you....

@melantha1982 Год назад

Amazing..thank you.

@carryon2197 Год назад

Thank you for the educative & useful video.

@PhillipAmthor Год назад

Thx for this quality content!

@The_Ol_Bizzaroo Год назад

Just changed my pivot table settings. So excited about this. Thanks!

@LeilaGharani Год назад

Fantastic!

@danieloghenebrorhie2590 Год назад

This was useful. thank you

@thiagarajanneelamegam8640 Год назад

Hi Leila, Good day to you ! Always your tips and all about excel information very useful and save the time. Thanks a ton.

@RA-rh5lb Год назад

all are good tips. I found pivot table and leading zero is extremely helpful. Thanks .

@abrahamj2600 Год назад

The pivot table settings are extremely helpful! Thank you, Leila!

@LeilaGharani Год назад

Glad it was helpful!

@mcwahaab Год назад

I used Ctrl+Enter to stay within the cell but this tip is super handy. Thanks Leila, as always

@agustinvimar3907 Год назад

I really liked the configuration of the dynamic tables, so I can save effort and time, thank you very much and greetings from Mx

@jabirkottiary Год назад

Definitely, very useful tips . ❤❤

@SyedMuzammilMahasanShahi Год назад

Thanks for the share.

@vasanths7027 Год назад

I Love the way you nailed it in all your videos. Thankkkkkkkkkkkkkkkkkkkkkk You Sooooooooooooooooooooooooooooooooooo Much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

@simonraju3555 Год назад

Thank you for your effort, its useful

@christinejean9134 Год назад

The pivot tables settings will really be helpful for me. Than you!

@SashaHouseOfFashion Год назад

Brilliant..thanks for helping

@canirmalchoudhary8173 Год назад

Amazing options

@MrFredy65 Год назад

Thanks, Leila....very good...

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

I really like the custom lists. Didn't realise it before, thanks!

@ajs11201 Год назад

I agree with the many comments about the Pivot Table settings. That will be enormously helpful. I make a lot of pivot tables, and each and every time, I need to deselect the autoformatting. Changing the global default will be fantastic!

@LeilaGharani Год назад

Definitely was much awaited!

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

I enjoy your teaching Leila, you are amazing 👏

@vijayarjunwadkar Год назад

Thank you Leila for 4 + 2 Tips! All very useful and I particularly liked the Pivot Table one. It's going to save so much effort and time! It's always worth the wait for Thursday with Leila! 🙂

@LeilaGharani Год назад

I couldn't wait for that pivot table setting 😊 Always a pleasure seeing your comments popping up, Vijay!

@rosemaryng7994 Год назад

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.

@MrVijay20vijay Год назад

Pivot table setting was the best!!

@levelfrederic111 Год назад

Thank you Leila

@samantharezek4495 Год назад

Loooove the PivotTable default setting...been annoyed by it for so long! Thank you Leila!!

@LeilaGharani Год назад

Same here :) Glad it was helpful, Samantha!

@BorisDK1 Год назад

Very good! Thanks Leila!

@BorisDK1 Год назад

Any chance to add "enter action" to a button in the Quick bar?

@GeertDelmulle Год назад

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).

@LeilaGharani Год назад

Great! Thanks for sharing the table config. I never thought of turning that off.