Nope, Google sheets DOES NOT do everything that excel can do.
In my case, I wanted to see the graph of my total wealth overtime.
In Excel its extremely simple.
- make a new sheet with a pivot chart, filter out pot-to-pot transactions, and show running average on the chart.
In Google sheets it took way too many steps and sheets because pivot table in sheets don’t have a cumulative sum.
- Make a copy of the automated sheet and in the copied sheet add column that caclulates cumulative/running sum
- make another sheet of pivot table and filter out pot-to-pot transactions
- add a column in front of pivot table that calculates the running/cumulative sum of pivot table
- make a chart from this pivot table while including that additional column
This is one thing, I want more lines and more types of charts and more analytics now. There are many types of charts in excel but not many in sheets and not easy to do either.