If you've never felt that Excel knows much more than you can squeeze out of it, just think about the fact that even in this brilliant program, the number of rows and columns is finite. Like the desire to understand the ever-expanding universe, the need to be able to handle more and more data in an ever-more transparent way so that the output information obtained from it can be easily shown to laypeople. Just like when, with the help of a giant telescope, they show you the universe and the planets, stars, and constellations located in it in a specific way.
So there is the tool that collects the data, there is the interface that makes it visible, and there are the scientists who, with the help of science, place it in an appropriate system for the purpose of understanding.
Power Query makes it possible to access seemingly endless tables consisting of millions of data, the sources of which can be files (XLS, CSV), various databases (SQL, SAP, AZURE), or even web portals. Since Excel has a finite capacity, it transforms and concatenates the incoming data before writing it to Excel, so that only the data necessary for the given task arrives in the Workbook. With this, the data is collected.
All of this is useless if we can't show what we have. We can use Power Map and Power View to visualize, visualize, and interpret data for ourselves and others.
And here comes the science! When a simple report is no longer enough, because more complex analysis is needed, Power Pivot helps us analyze the data stored in the Excel data model. Among other things, creating relationships between tables, adding formulas and performance indicators, arranging fields in a hierarchy, and creating perspectives are also not a problem using Power Pivot. If you can handle simpler reports well, you are already halfway to the knowledge necessary for implementation. Don't stop!
These are the add-ons that can take us to horizons where we no longer feel the narrow limitations that often keep us grounded in Excel. We almost feel like gravity is lifted and the sky is the limit.