The best business practice for Excel
If you are working for more than 10 minutes on any one process in Excel, YOU ARE WASTING YOUR TIME!? Don’t spend another wasted minute trying to copy and paste something, don’t drag and drop cell values from one spot to another… just don’t do it!
I was working on a process that was requiring a bunch of manual moving, copying, and pasting and my little mental timer went off.? I stopped the way I was doing it and realized that I had 700 rows on 6 other sheets to do.? There was no way I was going to burn 4 hours on this process.? I didn’t have the time and I knew I’d end up making mistakes.? So I mentally “stepped back” and built a set of formulas that I could copy down (using variables and row numbers – it was really quite cool).? I was able to get the whole workbook done, confident that I didn’t have any manual errors, and felt like I just robbed Father Time!
Do you have any rules that you follow to keep you from wasting time?