prosys prosys prosys prosys prosys prosys
  • Home
  • Services
    • Portfolio of Services
    • Report Categories
    • Report Types
    • Delivery Model
    • Solution Scale
    • Solution Location
  • Technology
    • Microsoft BI
    • Power BI Solutions
    • Azure BI Solution
    • “R” Solution
    • Azure ML Solution
    • Asp.Net Solution
    • Microsoft SQL Server
    • Excel Automation
    • Microsoft Access
  • Success Stories
  • Careers
  • Downloads & Links
  • Power BI Proof of Concept
  • About Us
    • Prosys in Brief
    • Vision & Mission
    • Values
    • Prosys Organization
    • Prosys Team
    • Associations
    • Contact-Us
  • Home
  • Services
    • Portfolio of Services
    • Report Categories
    • Report Types
    • Delivery Model
    • Solution Scale
    • Solution Location
  • Technology
    • Microsoft BI
    • Power BI Solutions
    • Azure BI Solution
    • “R” Solution
    • Azure ML Solution
    • Asp.Net Solution
    • Microsoft SQL Server
    • Excel Automation
    • Microsoft Access
  • Success Stories
  • Careers
  • Downloads & Links
  • Power BI Proof of Concept
  • About Us
    • Prosys in Brief
    • Vision & Mission
    • Values
    • Prosys Organization
    • Prosys Team
    • Associations
    • Contact-Us
Loading...
  • Microsoft Excel
    Automation

03-08-Excel Automation prosysin 2018-06-28T15:04:24+00:00

Excel Automation

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.

Business Enquiries

Prosys Infotech Private Limited.
401C, 4th Floor, Mantri Alpine,
S. No. 268, Bavdhan Budruk,
Above Crystal Honda Showroom
Pune 411021, India
Office: +919130001652/1653
Sanjay : +919422034643
sanjay@prosysinfotech.com
Rajeev : +919422031214
rajeev@prosysinfotech.com

prosys

Our Location

© Copyright 2018 Prosys Infotech Private Limited, India | All Rights Reserved.
LinkedinTwitterGoogle+Facebook