I live in Excel. This video was basic. I was hoping for more sophisticated instruction. But from reading the comments, it’s clear I need to learn a data analysis language.
I think Python and Julia are popular for this purpose, Python much more so.
You will probably want to use one of the “notebook” environments that make your Python easier to use interactively and display graphs and the like. Jupiter is the one I know but there are others too.
In terms of popularity I'd say Python>R>Julia
R might be closest in syntax to how excel works, especially with the ifelse functions. R also has dplyr, which is unmatched in how it makes data manipulation easy and streamlined
You will probably want to use one of the “notebook” environments that make your Python easier to use interactively and display graphs and the like. Jupiter is the one I know but there are others too.