Google Sheets for a more collaborative spreadsheet
Rating: 9 out of 10
IncentivizedUse Cases and Deployment Scope
Google Sheets allows my team to work collaboratively together, without needed to send multitudes of emails and spreadsheets back and forth. We use Sheets as trackers, for calculations and formulas and data warehouses. The functionality allows multiple people to work on the document or access information at the same time. With features that rival other spreadsheet software, I find Sheets the most user-friendly and easy to use.
Pros
- Data filtering
- Filtering
- Pivot tables
Cons
- vlook up
- download/export function
Likelihood to Recommend
I would recommend this to a teammate or colleague who needs a spreadsheet with more collaborative capabilities than mathematical/formula-type capabilities. We use Sheets to track vaccination bonuses and the pivot functionality to ensure no employee is over paid a bonus. It allows multiple teammates across the country to enter data at the same time and then allows me to audit and confirm the data before payroll processing.