Google Sheets is excellent for collaboration, but it lacks one of Excel’s most important modeling capabilities: What If analysis using Data Tables. In this guide, we explain how What If analysis works in practice, why data table–based sensitivity analysis matters, and the most practical way to run Excel-style one- and two-variable data table sensitivities directly in Google Sheets using a keyboard shortcut.