Professor Excel

Performance of XLOOKUP: How fast is the new XLOOKUP vs. VLOOKUP?

We’ve explored the basics of XLOOKUP, discovered a wide range of advanced use cases for XLOOKUP and the advantages towards VLOOKUP and INDEX/MATCH. What we have not talked about so far is the performance of XLOOKUP. Especially for larger Excel models with possibly hundreds of thousands of functions to calculate, performance is a major concern. Let’s see how XLOOKUP performs vs. VLOOKUP and INDEX/MATCH!

[…]

study, file, size, file size, reduce, excel, workbook, compress

Study: What Really Helps to Reduce the File Size of Your Excel Workbook

You’ve just finished your work and want to send your file to your boss. He is waiting for it. But instead of sending the email, you just receive and error: The file size is too large. This is the moment you tell yourself not to panic. And actually there is no reason to panic. There are many ways to reduce the file size of your Excel workbook.

[…]