Leila Gharani | Important Excel Settings You Need to Review NOW! @LeilaGharani | Uploaded August 2022 | Updated October 2024, 1 hour ago.
Join 400,000+ professionals in our courses here π link.xelplus.com/yt-d-all-courses
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-settings-cheat
π 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 βΊ 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: youtu.be/cnCvn6CmP2k
β‘οΈ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
π©Letβs connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/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
Join 400,000+ professionals in our courses here π link.xelplus.com/yt-d-all-courses
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-settings-cheat
π 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 βΊ 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: youtu.be/cnCvn6CmP2k
β‘οΈ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
π©Letβs connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/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