⯆ Download the practice file: https://pages.xelplus.com/overlooked-features-download
? Get the Excel Essentials training ? https://link.xelplus.com/yt-excel-essentials-tips
Level up your Excel basics with 8 features most beginners miss. In this video you’ll learn how to add numbers with Paste Special, clean text with Flash Fill, spot formulas fast, repeat actions with F4, add helpful input tips, fix #### with AutoFit, replace formatting in bulk, and email a workbook straight from Excel. Clear steps, real examples, and keyboard shortcuts you can use today.
What you’ll learn
– Paste Special for quick add, multiply, subtract, divide
– Flash Fill to extract or standardize text
– Go To Special to highlight formulas vs inputs
– F4 to repeat your last action
– Data Validation input messages for on-cell tips
– AutoFit columns and rows to fix ####
– Find and Replace formatting across a workbook
– Send as email attachment from the Quick Access Toolbar
? Our Courses
? 400,000+ enrolled in our courses. Join them ? https://link.xelplus.com/yt-d-all-courses
? More tutorials:
Excel Tutorial for Beginners | How to Use Excel: https://youtu.be/0tdlR1rBwkM
Excel Pivot Table EXPLAINED in 10 Minutes: https://youtu.be/UsdedFoTA68
? Subscribe to “Between the Sheets” newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter
Timestamps
00:00 8 Excel features that make everything easier
00:17 Paste Special for calculations
02:16 Flash Fill for text cleanup
03:27 Go To Special, find formulas and input cells
05:46 F4, repeat last action
06:46 Data Validation input messages
07:41 AutoFit columns and rows
08:43 Find and Replace formatting
10:50 Send as email attachment from Excel
11:24 Wrap up
➡️ Join this channel to get access to perks:
https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
?☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
? Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
? RESOURCES I recommend: https://www.xelplus.com/resources/
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
?Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.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
