The PerfectXL Blog
for better Excel

Whether you want to learn about heroes of the Excel community, the newest tips and tricks, or you want to stay in tune with what PerfectXL is doing, you’ve come to the right place!

XLOOKUP: The debate is over.

XLOOKUP is the newest lookup function in Excel. The real question for any serious user is… why should you use XLOOKUP?

Keep your inspectors happy with good & reliable Excel models

Excel is, without a doubt, the most user friendly program in the world for making calculations and that is why you will find Excel models in almost every organization. Nearly a billion people worldwide use Excel; in private situations, with small companies, large companies and with many governmental organizations.

Learning on the job

Many of you want to get better at Excel, but you can’t find the time to follow a course. Or the exact opposite, you have time to follow a course, but you’re afraid that you’ll forget what you learned in a matter of weeks because you aren’t going to apply the learnings right away. In either case we would advise you to follow a course when it’s busy, not when you have a ton of free time!

Oz Du Soleil: Bringing joy and excitement to Excel

Oz du Soleil, an Excel MVP, is a true Excel hero and easily worthy of wearing his underpants on the outside of his pants… a true superhero in the Excel communities. His superpower is bringing charisma, storytelling, and flare to Microsoft Excel. From videos, to training, to presentations, he continues to bring a sense of excitement to something that many find dull. I got the chance to call him and ask him some questions relating to his interactions with the wider Excel community.

Patrick O'Beirne on EuSpRIG and the Excel community

Excel hero Patrick O’Beirne is chairman of EuSpRIG, and one of the main collectors of the infamous Excel horror stories.

Leave these 9 Excel frustrations behind!

Be honest with yourself, how much time does it take you to spit through an Excel file? The opportunities in Excel are endless but this comes with a downside. PerfectXL has the solution.