Academy
Principles for good Excel use
Excel modelling must be taken seriously, Excel is used too widely to be seen as just a flexible sheet. The models created are legitimate pieces of software and need to be simple, correct, and maintainable. Learn from our basic principles!
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.
How to find external links in Excel
What happens when Excel can’t find your external source anymore? What happens when you get broken links?
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.
Constant
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.