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.

Tired of wasting time choosing colors manually in Google Sheets? Learn how to use the Google Sheets fill color shortcut with SheetWhiz to color, organize, and customize your data faster, all with a single keystroke.

Tired of clunky menus? Discover the fastest way to insert and delete rows & columns, without memorizing confusing shortcuts.