3 ms·
Absolutely! For power-users of Excel, this article reads as "the reason we don't use Excel is because we don't understand how to use it". For those who aren't
by Closi 5y ago
Absolutely! For power-users of Excel, this article reads as "the reason we don't use Excel is because we don't understand how to use it".
For those who aren't as familiar with Excel, all the functionality the author is describing as missing in Excel is actually built into it out of the box - as a feature called Get & Transform (or 'PowerQuery'). You can load in a CSV, manipulate it, do batch processing, and all the steps are visible, editable, resequencable and deletable (showing you the M code behind it!).
You can even handle hundreds of millions of records this way.
For those who want to learn, I would wholeheartedly recommend this book: https://www.amazon.co.uk/Power-Pivot-Bi-Excel-2010-2016/dp/1615470395 https://www.amazon.co.uk/Power-Pivot-Bi-Excel-2010-2016/dp/1...
- pjmlp 5y agoI think it comes from Excel hate and thinking Google sheets are good enough. Many people to this day aren't even aware cells can be named like proper variable names.
- sitrucp 5y agoSecond using Get & Transform (or 'PowerQuery'). Note it is also Power BI's data integration functionality. (Though was recently disappointed to learn it is not available on Mac.) While I use wide range of data integration and visualization tools, Excel/Power Query with pivot tables & charts is often my go-to for quick data analysis or exploration. Recently used it to retrieve Our World in Data Github hosted csv file data into an Excel file and then click refresh to get most recent data: https://009co.com/?p=1491 https://009co.com/?p=1491