But this was just the first step by Microsoft to bring the power of Data Analysis to the Excel User.Ģ013 saw the launch of Power Query and Power View. In 2010 I hailed PowerPivot as the most powerful feature of Excel. This Excel tool is awesome, and anyone can learn to use it. If you know how to use pivot tables, they you are half way there. Data is stored in a data model and not the spreadsheet and give you massive compression. Complex calculations can be carried out across different tables of data with ease. Equipped with its own language know as DAX (Data Analysis Expressions), Power Pivot can slice and dice data like never before. In 2010 Microsoft introduced Power Pivot as the first power tool. They can carry out complex calculations on data that without Pivot tables you would need to know complex array formula. They allow slicing and dicing of a data table so you can analyse and report within a matter of minutes. Once, Pivot Tables were once hailed as the most powerful feature of Excel. With the ability to create sustainable models and templates effecently. Every few years we see a new and improved version adding more and more capabilities.Įxcel is no longer just a tool for totting and cross totting but a powerful business intelligence tool equipped to handle masses of data on the fly. Excel has come a long way since it was released. It offers massive flexibility, speed and is as accurate and reliable as the users.īut to this day, some Excel users never go beyond the basic totting and cross totting of rows and columns. For years now Accountants and bookkeepers around the globe have used Excel as their Spreadsheet tool of choice.
0 kommentar(er)
