Microsoft Excel Rocks!
May 04, 2022
Microsoft Excel Rocks!
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft Excel
We use Microsoft Excel for data analysis, financial analysis, and to generate graphs for Board reports. We use pivot tables a lot to produce needed results for data reporting and also for payroll and benefits tracking for our various funding sources.
- Formulas
- Pivot Tables
- Subtotals
- Sorting and Filtering
- Sort feature does not work if there are blank rows; very frustrating
- Sometimes pivot tables don't update with refresh; have to delete the entire table and redo.
- Our pivot tables for payroll and benefits have allowed me to identify exact costs by employee from multiple funding sources. This allows me to budget accurately and monitor expenses more exactly.
- I use the charts and graphs as part of the financial report for our Board, which displays the financial data in an easy to understand format for Board members who do not have a strong financial background.
- We export a lot of reports from other software programs into Microsoft Excel so we can perform data analysis to find answers to help make informed decisions.
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?
I wasn't involved with the selection/purchase process
Did implementation of Microsoft Excel go as expected?
I wasn't involved with the implementation phase
Would you buy Microsoft Excel again?
Yes
Using Microsoft Excel
40 - fiscal, compliance, call center, HR, administration
2 - Our IT consultant is Microsoft certified. A lot of questions are able to be resolved by other coworkers or looking up answers on the internet.
- data analysis
- sorting and filtering data
- subtotaling data
- pivot tables
- Analysis of payroll and benefits
- Visual representation of financial data for Board members
- Account reconciliations (general ledger, PTO, etc.)
- multi-year analysis of data