gerant.blogg.se

Microsoft power tools for data analysis
Microsoft power tools for data analysis








In 2010 Microsoft introduced Power Pivot as the first power tool.

microsoft power tools for data analysis

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.

microsoft power tools for data analysis

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.

microsoft power tools for data analysis

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.










Microsoft power tools for data analysis