Feedback
Thank you to the following people for their comments and suggestions, so far:
Patrick O'Beirne - @ExcelAnalytics - sysmod.com
I will be making changes based on this feedback.
6) Always remove unnecessary external links to prevent annoying popups.
FEEDBACK: This needs to have a link to a dedicated page, explaining how to check and remove these.
7) Remove circular references to improve stability.
FEEDBACK: This also needs a dedicated page explaining why you never need to use a circular reference.
And maybe mention Goal Seek and Scenario Manager
9) Move repeated formulas to their own cells.
FEEDBACK: This needs more examples
Not sure what 9.3 defeats 9.1 means
10) Use simple formulas that fit on one line, of the formula bar.
FEEDBACK: Are there any examples when you need to reference an entire row or column ?
15) Use embedded charts instead of chart sheets.
FEEDBACK: Need to find some good reasons to back this up.
16) Use cell styles to enforce consistent cell formatting.
FEEDBACK: Not sure about the number 20 ?
Need to try and explain what a reasonable number should be. Maybe some third party add-ins could help to find the magic number.
18) Use named ranges to refer to cells that are not close by.
FEEDBACK: This needs more examples
20) Use conditional formatting to automatically apply cell based formatting.
FEEDBACK: Only when needed, otherwise you get visual distraction.
26) Use the macro recorder to start exploring the power of VBA.
FEEDBACK: Followed up by a good course and a good book.
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext