79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

314Tutorials

See the full list of Tutorials to learn from

An optical illusion in Google Sheets and how to fix it.
Let's figure out how a sheet is structured.

3

you might actually find something new and interesting about it. We're just changing the column width.

4

A few tips: Delete extra columns and rows to improve readability, change the colors and fonts to incorporate branding, and adjust the sheet to promote the Better Band Bureau podcast more.

5

Create a quick search dropdown to find keywords in any column.
We're gonna talk about some features that we're gonna be using that might be new to you, or, just remind you that we're gonna use them to make 'em very interesting and unique to, using dashboards.
how to create an auto-updating sales chart that displays the trailing 12 months of data in Google Sheets. The tutorial uses a sample dataset to demonstrate how to build a dynamic chart that updates automatically as new data is added.
Very quick interesting little keyboard shortcut where you might not even know it exists. Repeat what you're doing, over and over again.

12

Use Transpose() to create a web-based, Kanban style, list-making application inside your Google Sheet! Learn how to display tasks and to-do’s in vertical categories.
Curate a newsletter. Collect YouTube videos. Research competitors. All with this one line of javascript. Build your own web clipper. Use the Bookmarklet to clip web content to your Google Sheet. Clip text and links directly from the web to your Google Sheet with just a few clicks.
I walk you through everything you may encounter along the way of coding in Google Apps Script. Discover the challenges and pitfalls before you fail. If you’ve never coded before, I’m right there with you all the way.
A great way to manage your data if you have a small group of people who want to add data, but you want control over that data in the sheet. Give them the ability to comment on your data.
Create a pastel colored hunting game, just in time for Easter.

20

Displaying items 221-240 of 314 in total

Tags

Formulas