Uploaded December 2025 | Updated September 2026, 1 week ago
Unlock the Top Excel Essential Tips with this power-packed tutorial covering the most useful tools for modern spreadsheet users. Learn how to master everyday tasks like SUM, splitting and merging cells, locking data, inserting rows, sorting, adding hyperlinks and bullet points, plus advanced skills like copying visible cells, merging files, converting Excel to Word, and cleaning data with Power Query. Perfect for beginners and professionals who want faster workflows and smarter Excel habits.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - How to Use the SUM Function in Excel
00:07:26 - How to Split Cells in Excel
00:10:33 - How to Merge Cells in Excel
00:12:31 - How to Insert Multiple Rows in Excel
00:13:13 - How to Lock Cells in Excel
00:17:26 - How to Insert a Page Break in Excel
00:20:17 - How to Insert Hyperlinks in Excel
00:23:39 - How to Add Bullet Points in Excel
00:26:22 - How to Sort on Multiple Columns in Excel
00:31:43 - Copy Visible Cells Only When Filtering in Excel
00:36:25 - How to Merge Excel Files
00:43:30 - Convert Excel Spreadsheets to Word Documents
00:46:06 - How to Adjust Slicer Settings in Excel
00:55:08 - How to Clean Data in Excel with Power Query
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ simonsezit.com/courses
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 11,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🔥 For a full training experience, check out our FREE YouTube course: 👉 youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT
🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
Unlock the Top Excel Essential Tips with this power-packed tutorial covering the most useful tools for modern spreadsheet users. Learn how to master everyday tasks like SUM, splitting and merging cells, locking data, inserting rows, sorting, adding hyperlinks and bullet points, plus advanced skills like copying visible cells, merging files, converting Excel to Word, and cleaning data with Power Query. Perfect for beginners and professionals who want faster workflows and smarter Excel habits.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - How to Use the SUM Function in Excel
00:07:26 - How to Split Cells in Excel
00:10:33 - How to Merge Cells in Excel
00:12:31 - How to Insert Multiple Rows in Excel
00:13:13 - How to Lock Cells in Excel
00:17:26 - How to Insert a Page Break in Excel
00:20:17 - How to Insert Hyperlinks in Excel
00:23:39 - How to Add Bullet Points in Excel
00:26:22 - How to Sort on Multiple Columns in Excel
00:31:43 - Copy Visible Cells Only When Filtering in Excel
00:36:25 - How to Merge Excel Files
00:43:30 - Convert Excel Spreadsheets to Word Documents
00:46:06 - How to Adjust Slicer Settings in Excel
00:55:08 - How to Clean Data in Excel with Power Query
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ simonsezit.com/courses
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 11,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🔥 For a full training experience, check out our FREE YouTube course: 👉 youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT
🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
