James thunderbolt
Member
Hi guys,
Could anyone share any resources they have found useful or areas that look at excel performance and speed. A large part of my work requires building complex models, ran against often huge data sets. I've always struggled with creating models that crunch numbers on such huge data sets in an efficient and speedy manner, often building monstrosities then end up crashing far too often and taking 10+ minutes just to run.
Would love to look at studying what causes excel to rack up size and run slowly, and how I can build formulas & macros that are more efficient, or more ideally look at templates, modeling infrastructures or philosophies for working with large data sets & building complex models
Any resources/tips would be much appreciated
Thanks
J
Could anyone share any resources they have found useful or areas that look at excel performance and speed. A large part of my work requires building complex models, ran against often huge data sets. I've always struggled with creating models that crunch numbers on such huge data sets in an efficient and speedy manner, often building monstrosities then end up crashing far too often and taking 10+ minutes just to run.
Would love to look at studying what causes excel to rack up size and run slowly, and how I can build formulas & macros that are more efficient, or more ideally look at templates, modeling infrastructures or philosophies for working with large data sets & building complex models
Any resources/tips would be much appreciated
Thanks
J