92 Google Sheet Tutorials

Reviewing an existing sheet called "mortgage calculator for Google sheets" I point out the really nice "back to dashboard" button. This seems like a minor point but ends up improving the user interface, and user experience. Users tend to get lost in sheets with tabs, and providing another path to a sheet you know your users will want to go to, is great. At the end of the video I point out that you probably want to provide more outputs than inputs. Meaning that if someone puts in a few numbers, they get out of it a few years of statistics, or calculations in this case. Calculators are cool, but generators are even better. Calculators have a tendency to have more inputs than outputs. You're trying to get to one magical result. But a spreadsheet can be so much more powerful and show many more outputs if you do those calculations,. Especially here for a mortgage, you can show a range of calculations in addition to a single calculation.

Learn about the strategy and concept of the SpreadsheetApp. Understand rows, columns, and cells better.

• Bullet points and numbering help to organize information in a logical and easy-to-follow way
• They make it easier to scan and find important information quickly
• They can help to emphasize key points and make them stand out from the rest of the data 
• They make your spreadsheet look more visually appealing and professional

I would not think that I would enjoy sales tax calculators, no one enjoys sales tax calculators, but when it's in a Google sheet, it's really exciting.

Take your email marketing to the next level with our Google Sheet Campaign Stats Calculator. Analyze open rates, click-throughs, and conversions, and make data-driven decisions to improve your campaigns. Build a sheet from scratch. We're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.

Build from scratch a calculator to figure out podcast advertising rates.

this is gonna be fun because we get to create a calculator with Apps Script.

This lesson will get you started on your first trigger. It’s the first real spreadsheet automation you can do. Fun stuff!

One of the things to learn: We can only have one onEdit() in our entire spreadsheet file. I’ll also walk you through on how you can use Event and Logger to get cool information.

Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.

Use arrayformula to deal with Google form entries on a sheet. Even as they keep getting added.

I have no idea what to do as a user, so let's make it better.

Create the Apps Script to create a new sheet from some data inside your sheet. Script included in the sheet below.

Dive deeper into the world of variables. Learn what variables do. Learn how to assign information to variables.

Learn how Dot Notation allows you to go deeper into the functions.

Learn the importance of camel case. Camel Case is a simple technique that involves capitalizing the first letter of each word in a text string, except for the first word. This creates a consistent and easily readable format for text that may be used in formulas, labels, or other applications.