From the course: Excel Business Intelligence: Power Query
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
The best thing to happen to Excel in 20 years - Microsoft Excel Tutorial
From the course: Excel Business Intelligence: Power Query
The best thing to happen to Excel in 20 years
- [Instructor] All right, so there's a quote by this guy named Bill Jelen. He's known as Mr. Excel. He's an Excel MVP and one of the leaders in the field. And what he said was that Power Query and Power Pivot were the best thing to happen to Excel in 20 years. And I couldn't agree more. So let's talk through why that's the case and review some of the key benefits to these business intelligence tools. So, first and foremost, we can now import and analyze millions, tens of millions, even hundreds of millions of rows of data directly in Excel from virtually anywhere. So that alone is a pretty huge game-changer. Second, we can quickly build models to blend and analyze data across sources. So no longer do we need to actually mash them together with cell formulas like V Lookup or Index and Match. We can easily create relationships to analyze holistic performance across an entire data model. Third, we can now create fully automated data shaping and loading procedures with no VBA and no…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.