Find the Google Sheet formula you’re after to solve your problem, with these examples. Click the link to read the post. Posts without active links are in the works and coming soon. Have a specific question? Drop me a line here. General questions > How do I zoom in or out in Google Sheets? Date … Continue reading Formula Examples
A tutorial on creating waterfall charts in Google Sheets, first using formulas and then, second, using Apps Script. The key trick is to create a stacked column chart and set the base column values to be transparent.
An exploration of animated data visualizations, with an example chart built with the Google Visualization API connected to data in a Google Sheet.
A close look at the Google Data Studio business dashboard reporting tool. In this post I look at 6 techniques to master for creating dashboard reports using this tool, including filtering and calculated fields.
An introduction to Google’s new business intelligence dashboard tool: Data Studio, including first impressions, a quick-fire tutorial and a video walk-through.