Gemini's chatbot appears on the right-hand side of Sheets. Now, when you ask how to manipulate data, Gemini will respond with suggested formulas and step-by-step instructions about how to make the formulas work - and why the formulas fail when they do. Errors will be followed up with a guide for how to correct the issue, Google says. If multiple formulas can do the same thing, Gemini will explain the options to the user.
A waterfall chart in Google Sheets is an effective visualization tool, clarifying how positive and negative values contribute to overall results, starting each bar where the previous one ends.