What determines the performance of Excel in terms of hardware?

Question

excel

Hello, I need help understanding the issue, namely:

What are the hardware features of the PC:

- CPU architecture, number of cores, frequency per core, etc.;
- RAM parameters, latency, frequency, rank, etc.;
- other features (SSD, chipset, etc.) that

most affect the performance of Excel applications (basic optimized formula calculations, Power Query, Power Pivot, etc.).
If we take as a basis the idea that all formulas are optimal, and the load depends only on a large amount of data.

Is there any information on what exactly you need to pay attention to, where is the bottleneck for Excel subsystems, which is worth expanding so as not to spend hundreds of thousands of oil on assembling a megamonster with excess resources that will idle + power consumption.
It is clear that for more loaded databases and calculations, we can turn, for example, to the R or Python languages, within the framework of data science, but for now I want to understand the issue of Excel's computing potential and what affects it in terms of hardware, without CUDA.

I would be very grateful for a detailed answer or a direction in which it is worth digging, what synthetic tests of processors to look at (and is it only a matter of the processor?) I

use Excel as part of Office 2019 Pro.

At the moment, a laptop based on i7 4700HQ (4 cores, 8 threads in boost up to 3.4), 8 GB DDR3 RAM, the entire system and programs, database files on the same disk (SSD).
Before that, there was a desktop based on Ryzen 1700 (8/16), 16 GB of RAM, SSD ... it worked a little faster.