1) it’s easy to create tables, format them to create databases.

2) you can connect multiple tables with power Pivots. And use power queries to quickly do mass data manipulation.

3) pivot tables quickly help you analyze data.

4) it has a layers system just like PowerPoint so you can create pretty complex dashboards.

And that’s just the intermediate level stuff.

Comes with a lot of preset math tools to do forecasting and interesting calculations.

There is a video on youtube where someone created a cpu on excel that actually can compute stuff.

Reply to this note

Please Login to reply.

Discussion

I land in this camp as well. heavy powerbi user ... there are many situations where true ETL tools and SQL are better but for day to day it's tough to beat it as an all in one solution

Oh I agree. I once had to work with a data set of 15million+ rows and god knows how many columns.

Excel failed.

But I don’t think it was designed for something like this.

Agreed, but Excel is amazing, I think my only ding against it is that Microsoft is evil but what a tool

Wow had no idea