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