Register now or log in to join your professional community.
Well...
There are a lot of common mistakes when "professionals" use Excel.
Some tips to get a clean sheet:
1) NEVER use Pivot.
2) Try to use not more than3 colors for indication and always use the same3 colors (Input, Output, Title)
3) Try to increase your performance (use lookup/index for vlookup / make your formulas as dynamic as possible, etc.)
4) Think your sheet through. Make it consitence. It should always calculate from the last sheet to the first sheet. Do not go back and forth. Make a clean understandable calculation
5) If you build reports, etc. make sure that the sheet is built in a fashion that the dumbest possible user can understand it at first sight and cannot manipulate it.
6) always make sure that your VBA-code is secure. This is your knowledge. Don't let someone steal it without you knowing it.
What types of data you organize daily ?
