Skip to main content
AmigoFish

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.

Watch on YouTube

Not rated yet

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

Back to Leila Gharani Ā· Report a problem