Рет қаралды 587,364
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: www.myonlinetraininghub.com/1...
LINKS TO SOLUTIONS
- Fix non-tabular data with Power Query: www.myonlinetraininghub.com/p...
- Fix dates formatted as text: www.myonlinetraininghub.com/f...
- Use Power Query to get data instead of External Links: • How to easily automate...
- OFFSET function for dynamic SUM ranges: www.myonlinetraininghub.com/e...
🎓 LEARN MORE: view my comprehensive courses: 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: / 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: www.myonlinetraininghub.com/e...
⏲ 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