A decade ago, Ben Collins quit his job as a corporate accountant and started teaching other people how to use spreadsheets more effectively. That move, terrifying as it seemed at the time, paid off brilliantly. Today Collins is the proprietor of an online spreadsheet training academy and the author of a weekly newsletter dedicated entirely to Google Sheets tips. Some 50,000 people subscribe.
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.