Google Sheets vs Excel comparison - Business Scenario Comparison

Scenario Mode

👤 Your Role: You are a business analyst at a consulting firm.

📋 Request: Your manager wants a clear comparison of Google Sheets and Excel features based on company usage data.

📊 Data: You have data showing feature usage counts, user satisfaction ratings, and cost per user for both Google Sheets and Excel across different departments.

🎯 Deliverable: Create a summary report comparing Google Sheets and Excel on key metrics: total usage, average satisfaction, and total cost. Include formulas to calculate these metrics.

Sample Data

Department	Tool	Usage Count	Satisfaction Rating	Cost per User
Sales	Google Sheets	120	4.5	6
Sales	Excel	150	4.2	8
Marketing	Google Sheets	100	4.7	6
Marketing	Excel	130	4.0	8
Finance	Google Sheets	80	4.3	6
Finance	Excel	110	4.6	8
HR	Google Sheets	90	4.4	6
HR	Excel	95	4.1	8

1

Step 1: Filter data to show only Google Sheets rows.

=FILTER(B2:E9, B2:B9="Google Sheets")

Expected Result

Rows with Google Sheets data for all departments.

2

Step 2: Calculate total usage count for Google Sheets.

=SUMIF(B2:B9, "Google Sheets", C2:C9)

Expected Result

390

3

Step 3: Calculate average satisfaction rating for Google Sheets.

=AVERAGEIF(B2:B9, "Google Sheets", D2:D9)

Expected Result

4.475

4

Step 4: Calculate total cost for Google Sheets (Usage Count * Cost per User summed).

=SUMPRODUCT((B2:B9="Google Sheets")*C2:C9*E2:E9)

Expected Result

2340

5

Step 5: Repeat steps 1-4 for Excel data.

Total Usage: =SUMIF(B2:B9, "Excel", C2:C9) Average Satisfaction: =AVERAGEIF(B2:B9, "Excel", D2:D9) Total Cost: =SUMPRODUCT((B2:B9="Excel")*C2:C9*E2:E9)

Expected Result

Total Usage: 485 Average Satisfaction: 4.225 Total Cost: 3880

6

Step 6: Create a summary table with columns: Tool, Total Usage, Average Satisfaction, Total Cost.

Manually enter 'Google Sheets' and 'Excel' in Tool column. Use formulas from steps 2-5 to fill other columns.

Expected Result

Summary table: Google Sheets | 390 | 4.475 | 2340 Excel | 485 | 4.225 | 3880

Final Result

Tool          | Total Usage | Avg Satisfaction | Total Cost
----------------------------------------------------------
Google Sheets | 390         | 4.475            | 2340
Excel        | 485         | 4.225            | 3880

✓Excel has higher total usage and total cost than Google Sheets.

✓Google Sheets has a slightly higher average satisfaction rating.

✓Excel costs more per user but is used more across departments.

Bonus Challenge

Create a chart comparing total usage and average satisfaction side by side for both tools.

Show Hint

Use a combo chart with bars for usage and a line for satisfaction.