If you’ve heard that Excel can only handle 1,047,576 rows… well, that’s not so true anymore. With Power Query, it’s now possible to work with millions of rows, building a fully reproducible extract-transform-load (ETL) process through your spreadsheet.
To add some humor to this seriously awesome development, I put together this “sigma grindset” meme video explaining:
To learn more about loading far more than ~1 million rows into Excel, check out these resources:
To get your team up and running with this tool, check out my one-day Excel Power Query workshop.
Leave a Reply