10 Excel Things You Should NEVER Do and What to do Instead

Video Description

Bad Excel habits are easy to pick up when you learn on the job, but they can make you inefficient. These are the 10 worst habits I see, but thankfully they're easily avoided. 🔻 DOWNLOAD the Excel file here: https://www.myonlinetraininghub.com/10-common-excel-mistakes-to-avoid LINKS TO SOLUTIONS - Fix non-tabular data with Power Query: https://www.myonlinetraininghub.com/power-query-unpivot-scenarios - Fix dates formatted as text: https://www.myonlinetraininghub.com/fixing-excel-dates-formatted-text - Use Power Query to get data instead of External Links: https://www.youtube.com/watch?v=L4BuUzccLpo - OFFSET function for dynamic SUM ranges: https://www.myonlinetraininghub.com/excel-offset-function-explained 🎓 LEARN MORE: view my comprehensive courses: https://www.myonlinetraininghub.com/ 🔔 SUBSCRIBE if you’d like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all! 🧟‍♀️ CONNECT with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum ⏲ TIMESTAMPS 0:00 Introduction 0:12 Merge & Center Cells 1:49 Non-tabular Data 3:21 Dates Formatted as Text 4:26 External Links 5:40 Formatting Ranges 7:07 Formatting to Encode Data 8:10 Formatting Colours 8:33 Cells Containing Multiple Records 9:13 Cells Omitted from SUM Formulas 10:34 Old .xls File Types