13 Excel Top Tips and Tricks to Save You Time

✅Download the free demo file and follow along here

This tutorial offers curated Microsoft Excel tips and tricks, empowering you with the knowledge to streamline your workflow, eliminate errors, and achieve efficiency. Unlock time-saving Excel techniques like copy worksheets, utilize forms for data entry efficiency, and enforce accuracy with data validation.

Discover new formulas, eliminate wasteful printing with efficient row wrapping, handle errors adeptly for meaningful spreadsheets, and so much more! Dive into the latest features and best practices to maximize your spreadsheet potential.

📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! Timestamps:

00:00:00 - Simon Sez IT Intro
00:00:05 - Course Introduction
00:03:54 - Custom Formatting Large Numbers Incorrectly
00:09:24 - Hard-Coding Values in Cells
00:12:06 - Copying Worksheets the Slow Way
00:13:10 - Hiding Columns and Rows
00:15:55 - Copying and Pasting Data from the Web
00:21:18 - Slow Data Entry
00:24:03 - Not Controlling Data Input
00:28:56 - Not Knowing Useful Shortcuts
00:32:44 - Wasting Paper when Printing
00:37:00 - Manually Creating Multiple Pivot Tables
00:44:54 - Not Handling Spreadsheet Errors
00:49:26 - Combining Data in One Column
00:52:31 - Conclusion

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[SimonSezIT]

✅Download the free demo file and follow along here

[ashrafsaid]

Thanks Simon team and thanks Deborah. I really adore your way of teaching.

[joshuamanampiu]

Good stuff. Thank you for the reminder on good excel habits

[Jojongonda-jc]

Could there be someone answering questions of the subscribers, or your fans?

[tmar]

I like your tips and tricks. Could you perhaps add some color around your pointer to make it easier to follow particularly around the ribbon area?

[MrGeoffb]

some of these are not relevant for Excel for Mac, for example copy data from the web or slow data entry. I haven't continued past this given relevancy of these areas so was wondering if there is a similar tutorial covering Mac version of excel