Excel!! Do we know it much?
Use Cases and Deployment Scope
My job is to handle data from the Site, validate and integrate the data correctly, and then update the same into a database like Oracle or SAP for further activities.
With the built-in functions and access to VBA, the task is automated, which eases our daily activity, and anyone can do analysis error-free.
Pros
- Analysis
- Automation
- Data Handling
Cons
- Pivot Charts Should be improved
- Conditional formatting should be optimized (should not use large space)
- VBA should have a proper code editor inbuilt
- Should have options to work for large datasets
Return on Investment
- Microsoft Excel should have around 50% of ROI
Alternatives Considered
Microsoft Access and Google Sheets
Other Software Used
Google Sheets, Microsoft Access



