To add - Numbers formulas being essentially objects rather than text slow me down a lot. I use excel instead of calculator all the time because it’s so fast and easy to quickly enter and edit a formula and to run what-if scenarios. In Numbers, it just takes longer.
But my least favorite part of Numbers is filtering. I am so used to creating complex filters on the fly with just a couple of clicks in Excel. In Numbers I have to open a side panel and define a filter, and every time I want to change the filter I have to define again. In Excel I just click on the dropdown arrow on the column header and select whatever values I want included, it takes significantly less time.
I have a personal finance tracking spreadsheet with a “Register” sheet dedicated to all of my transactions. I use Mint to sync with all of my banks and c/c accounts, then once a month export all transactions to CSV and add them to the Register. I have several levels of categories that I use for budgeting and to track spending. That includes tracking essential vs discretionary spending, and I have a couple levels for both.
I can use the years of accumulated data to track, analyze, and forecast my spending and budget any way I want. How much did we spend on cars in the last three years ? How much did we spend on a particular car ? How much of our discretionary spending we can eliminated with little impact on our QOL (Discr3) ? How much of that is related to kids ?
I tried to move it over to Numbers when I bought my Mac, because it looks so much prettier and because I like having different tables on one sheet. But I gave up after a few months, the filtering alone was just too much effort and resulted in too many saved filters.
yeah Numbers is not a "Power" tool and I think Apple purposefully keeps it that way for the average person. IF they add power tools it won't be the friendly spreadsheet app that it is.