Excel GOTCHAS and Booby Traps 🧨⚠️ | How To Avoid and Overcome Them

In this video, we look at some common Excel traps that lay in plain sight and how you can avoid or overcome them. These 4 Excel GOTCHAS can catch out even seasoned professionals. Join me LIVE for a session on Excel traps and pitfalls on the 12th July 2022 in London. The event is FREE - https://www.meetup.com/london-excel-meetup-group/events/285995570/ Unfortunately, there are many areas of Excel where things that you wouldn't expect to happen, do happen. Being aware of these frailties and understanding how Excel functions can help to avoid many of these. This is the first video of a series on Excel GOTCHAS and pitfalls. Here are the timings of the video. 00:00 - Introduction 00:30 - Cell modes in Excel - Enter, Edit, Point and Ready 03:34 - Copying sheets in Excel 07:32 - Selecting a Table column 10:31 - Number formatting in a PivotTable Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1