Academy

The PerfectXL Academy is a knowledge base with articles on various topics related to Excel. Here, you will find everything you want to know and learn about Excel, from a simple glossary to detailed instructions. Are you missing any topics? We’d love to hear your suggestions!

COUNTIF functie in Excel

COUNTIF

The COUNTIF function in Excel counts the number of cells that meet certain criteria within a specific range.

Principles for good Excel use // PerfectXL 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 in Excel // PerfectXL Academy

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 in Excel // PerfectXL Academy

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 // PerfectXL Academy

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.