Academy

Iterative calculation and circular references in Excel // PerfectXL Academy

Iterative calculation, friend or foe?

Among the infinite number of settings in Excel, one innocent looking option fundamentally changes the way Excel calculates formula results. It goes by the name Iterative calculation.

Don't ignore Excel errors // PerfectXL Academy

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

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.

How to manage file versions in Excel // PerfectXL Academy

How to manage file versions

What is the latest version of your file and is the latest version even the right version? In this article we’ll share our best practices on how to manage file versions in Excel.