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

10 things you should never do in Excel. Download the Excel file here: https://www.myonlinetraininghub.com/10-common-excel-mistakes-to-avoid

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

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

View my comprehensive courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/