10 Million Rows of Data in Excel?

I believe it's important that business users of Excel understand what it's truly capable of.

Only then can they make informed decision about if/where to invest in new software, what staff training is required and how the business can be more efficient.

It's capable of dramatically more powerful things than most users are aware of.

Modern Excel

The term Modern Excel generally refers to the Power Query and Power Pivot functionality of Excel, but I like to think of it as everything that's happened to Excel in the last 10 years, including Tables, new formulas, and cool features such as 3D Maps.

If you haven't seen this 3D Map video that I created using just Excel then check it out https://www.dhirubhai.net/pulse/build-3d-maps-videos-excel-wyn-hopkins/

The video below aims to just raise that awareness bar a little higher, plus flags an important concept when it comes to loading data into Power Pivot.

That concept is one of only importing the columns of data you need, especially those with a high level of uniqueness such as time, or database ID keys etc. These bloat your model and slow things down. The golden rule when building a Power Pivot model is only bring in what you know you need. It's pretty easy to include extra data later when you discover you need it

Wyn

Excel MVP & Director at Access Analytic

accessanalytic.com.au | blog | Power Pivot | Power Query | Power BI