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/
Видео 10 Excel Things You Should NEVER Do and What to do Instead канала MyOnlineTrainingHub
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/
Видео 10 Excel Things You Should NEVER Do and What to do Instead канала MyOnlineTrainingHub
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How to easily automate boring Excel tasks with Power Query!](https://i.ytimg.com/vi/L4BuUzccLpo/default.jpg)
![7 Things You're Doing WRONG in Excel](https://i.ytimg.com/vi/cnCvn6CmP2k/default.jpg)
![10 Amazing (Less Known) Excel Tricks You Should Know](https://i.ytimg.com/vi/KdTSjdUSANw/default.jpg)
![Excel LAMBDA Function](https://i.ytimg.com/vi/Ayc7QOadBa4/default.jpg)
![How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)](https://i.ytimg.com/vi/4c0CLUER6nw/default.jpg)
![Secrets to Building Excel Dashboards in Under 15 Minutes!](https://i.ytimg.com/vi/9p6tWCHbtPQ/default.jpg)
![](https://i.ytimg.com/vi/T5sPA170S_A/default.jpg)
![Power BI vs Excel Dashboards - And the winner is...](https://i.ytimg.com/vi/0nAQ7gPO_6Y/default.jpg)
![Excel Keyboard Shortcuts used by Pros](https://i.ytimg.com/vi/4xanM8XD058/default.jpg)
![Excel Database Functions - BETTER than SUMIFS, COUNTIFS etc.!](https://i.ytimg.com/vi/rbDHQm6CDRc/default.jpg)
![10 awesome things you can do in Excel - WITHOUT any formulas or pivots](https://i.ytimg.com/vi/W1QhTQCasb4/default.jpg)
![How Power Query Will Change the Way You Use Excel](https://i.ytimg.com/vi/6lBqYInBldk/default.jpg)
![I asked 6 Excel experts to share their *BEST* tips & tricks 👌](https://i.ytimg.com/vi/nOIEeUHyye0/default.jpg)
![Don't Use Excel Filters! Use This Incredible Excel Formula Instead ...](https://i.ytimg.com/vi/Qi1nfN5F8F4/default.jpg)
![5 Dashboard Design Tips - COMMON MISTAKES to avoid!](https://i.ytimg.com/vi/MXfkmt-5dmc/default.jpg)
![Excel XLOOKUP Function Definitive Guide](https://i.ytimg.com/vi/2ViMm-wuM3U/default.jpg)
![AWESOME Excel trick to combine data from multiple sheets](https://i.ytimg.com/vi/k_ugshJ4wIw/default.jpg)
![Excel PivotTables Made Easy - And Why Things Go Wrong!](https://i.ytimg.com/vi/vQlFiLUaw4k/default.jpg)
![Excel Tutorial for Beginners | Excel Made Easy](https://i.ytimg.com/vi/0tdlR1rBwkM/default.jpg)
![50 Ultimate Excel Tips and Tricks for 2020](https://i.ytimg.com/vi/FXs3WG7M-qk/default.jpg)