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!
Document your work
What separates the great spreadsheets from the rest, is documentation. Documentation will help future users of the spreadsheets to really understand your work.
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
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.
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.