8 Excel Features Every Office Worker Should Know
From Leila Gharani Ā· Ā· 11 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
8 simple Excel features most beginners miss. Each one replaces a manual task with a shortcut or a few clicks. š„ Download the practice file: https://pages.xelplus.com/overlooked-features-download?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-overlooked-features&utm_content=overlooked-features
š Go from Excel beginner to confident with Excel Essentials (500,000+ enrolled in our courses): https://link.xelplus.com/yt-excel-essentials-tips
Add or multiply a whole range at once with Paste Special. Pull initials out of text with Flash Fill (Ctrl+E). Find every formula cell with Go To Special, repeat formatting with F4, and add pop-up instructions to input cells. Fix #### with AutoFit, swap header formatting across a whole workbook, and email your file without leaving Excel.
ā Good to know: F4 on a laptop: if it doesn't repeat your action, press Fn+F4. Ctrl+Y does the same. Email button: if you use new Outlook for Windows, it may still open classic Outlook. Microsoft is rolling out support for new Outlook from November to December 2026. Until then, attach the file from inside new Outlook.
ā±ļø Chapters: 00:00 8 Excel features beginners miss 00:17 Paste Special: add values in bulk 01:38 Paste Special: multiply by 1,000 02:16 Flash Fill (Ctrl+E) to extract text 03:27 Go To Special: highlight formula cells 04:36 Go To Special: highlight input cells 05:43 F4: repeat your last action 06:46 Cell tips with Data Validation input messages 07:40 AutoFit all columns and fix #### 08:43 Find and Replace formatting 09:46 Why Find Format can miss some cells 10:50 Email a file straight from Excel
ā”ļø Join this channel: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
š Get one practical Excel tip each week in our newsletter: https://link.xelplus.com/yt-d-newsletter
š© Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani
#excel #exceltips #excelforbeginners