Excel!! Do we know it much?
November 07, 2022
Excel!! Do we know it much?
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft Excel
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.
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.
- Analysis
- Automation
- Data Handling
- 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
- Microsoft Excel should have around 50% of ROI
Microsoft Excel stacks up against them with better User Interface, this plays a more crucial role than any of the functionality that other software offers.
Its ability to have a lot of functions for handling day to day task and analyzing data and automating the task.
Microsoft Access can handle large amount of data sets, but it doesn't have that ease of interface.
Its ability to have a lot of functions for handling day to day task and analyzing data and automating the task.
Microsoft Access can handle large amount of data sets, but it doesn't have that ease of interface.
Do you think Microsoft Excel delivers good value for the price?
Yes
Are you happy with Microsoft Excel's feature set?
Yes
Did Microsoft Excel live up to sales and marketing promises?
Yes
Did implementation of Microsoft Excel go as expected?
Yes
Would you buy Microsoft Excel again?
Yes
Using Microsoft Excel
1000 - Microsoft excel can be used in any business functions practically possible.
In my organization each and every person is involved using Microsoft excel either directly or indirectly.
The Business functions include
1. Maintenance- Which involves submitting of maintenance report, collections of Data, inventory & material management.
2.Operation- Involves day to day Operation activities and reporting.
3. Accounting
4. Human Resource
In my organization each and every person is involved using Microsoft excel either directly or indirectly.
The Business functions include
1. Maintenance- Which involves submitting of maintenance report, collections of Data, inventory & material management.
2.Operation- Involves day to day Operation activities and reporting.
3. Accounting
4. Human Resource
200 - Mostly the people in the IT Team will help issues related to Microsoft Excel.
Skills required by them would be good communication to understand what the problem of the end user.
Also, an active listener would be a good add on.
Should have the admin access along with that they will require a basic IT and networking skills.
Skills required by them would be good communication to understand what the problem of the end user.
Also, an active listener would be a good add on.
Should have the admin access along with that they will require a basic IT and networking skills.
- Data Collection
- Data Integrity Validation
- Reporting
- To integrate it with Oracle JDE or SAP for Bulk data Upload
- For Automating Day to day task
Evaluating Microsoft Excel and Competitors
- Price
- Product Reputation
- Prior Experience with the Product
We will evaluate based on the size of the team and functionality that the software will bring to the employee that can be helpful for the organization.
As it comes with Office 365 package, so it becomes easier to rely on this software as compared to others which are providing same functionality
As it comes with Office 365 package, so it becomes easier to rely on this software as compared to others which are providing same functionality
Using Microsoft Excel
| Pros | Cons |
|---|---|
Like to use Easy to use Well integrated Consistent Quick to learn Convenient Feel confident using Familiar | Unnecessarily complex Requires technical support |
- Formulas
- Storing data in Table
- Conditional Formatting
- Dynamic arrays
- Macros
- Advanced functions
- VBA
- Pivot Table