
10 Excel Things You Should NEVER Do and What to do Instead
Published at : October 03, 2021
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
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

excelmicrosoft excel