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