Spreadsheet maintenance
External link
A constant is a set value that doesn’t change and that’s directly inserted into a cell. It’s not a formula and it’s not calculated by a formula.
The power of LAMBDA
Meet LAMBDA(). Enter the formula wrapped in a LAMBDA-function, place it in a defined name, and call upon the calculation from different places in your spreadsheet.
Good formatting in Excel
Microsoft has made it very easy to dress up your worksheets with all sorts of fill patterns, borders and other frills. The downside of this, however, is that many users format cells in an ad-hoc manner, creating messy spreadsheets.
Create & maintain good spreadsheets
To create and maintain consistently good spreadsheets, there are a number of Excel best practices which we’ll share with you in this article.
Don't ignore Excel errors
Take time to clean up Excel errors, because after a while, you won’t remember whether you left a mistake consciously or if there is something wrong with your spreadsheet.
Delete what you don't need
When you are working on a spreadsheet that will be shared with coworkers or clients in the future, make sure to deliver it clean and delete any distracting information.