Excel is one of the most widely use software in the world. It can not only be used for its simple spreadsheet capabilities, but it can be used for Automation and for Business Intelligence. Using the programming language built into Excel i.e. Visual Basic for Applications (VBA), you can do advanced automation for your normal Excel Applications. You can build forms, you can automate calculations, you can validate and what not.

More advanced uses of Excel can be for Data Analysis using the Excel Pivot Table (EPT) and the Excel OLAP Pivot Table (EOPT). In EPT the data is read into Excel and then you can create a Pivot Table for a full adhoc experience of reporting. In an EOPT, Excel connects to SQL Server Analysis Services. In such a scenario Excel does not read in the data within excel and can therefore report data of any size.

The standard Excel has a limitation of about 1 million rows of data. But if your data size is bigger you can always use the Power Pivot Add-in for Excel to store in more than 100 million rows if you so wish.

Excel also has numerous add ins for doing Data Analysis, and it can also be used to call Azure Machine Learning Web Services to do predictive analysis.

Combining all the above tools, Excel has become an extremely powerful data analysis tool.

Prosys has done extensive work using Excel. Please contact us for further details.