Creating a drop down list in Google Sheets using data validation is pretty simple. When a cell has data validation applied to it, people who use your spreadsheet will be able to select a value for the cell based on a list that you create. You can refer to the content selected in other cells, […]
An email signature, which often appears at the end of an email message, contains information such as the sender’s name, contact information, website addresses, etc. This information can be set once and attached automatically to your email messages when you send them. While it is a useful feature, it is not turned on by default. However, […]
Google keeps a record of all your activity. This includes your searches, browsing history, and other actions that require Google products such as YouTube searches. You can individually delete items, delete by Google product, or delete all the activity on your Google account. This tutorial explains how to clear Google activity using your web browser.
Google Sheets makes creating basic graphs easy. In fact, it suggests graphs for you when you highlight tables of data. You will find that the interface of Google Sheets is different from Excel, and Google Sheets also does not have as many in-depth options as Excel. However, you can still create visually impactful graphs with […]
Google Sheets has a built-in conditional formatting tool that allows you to set rules that will pick out cells that meet your criteria and format them according to your specifications. You can use conditional formatting to format Non-Blank Cells, values above or below thresholds you set, or even custom formulas. In this tutorial, I will walk you […]
Google Sheets allows you to protect cells or sheets so that certain users cannot edit them. This is a great tool to use if you have a spreadsheet that is used by many people and you want to prevent them from accidentally deleting or typing over complicated formulas or valuable data. Use the steps in this […]
I recently worked on a spreadsheet with a table that was populated using the filter function. This meant that I did not know how many rows would be included in my table: It would dynamically update as the source data changed. I wanted to apply some formatting to the table so that it would look better […]
You can use Google Sheets DMAX function to find the maximum value in a range based on some criteria. For example, if you have a table of data with outstanding payments you are owed from each of your clients, you can use DMAX to find the oldest of the outstanding payments for each client.
I was working in Google Sheets creating a dashboard that summarized data in another sheet. Specifically, I was trying to make a table that showed a list of each client that owed money. I tried to do this with a pivot table, but for some mysterious reason, pivot tables in Google Sheets do not automatically […]
The Unique function in Google Sheets makes it simple to create a list of only unique values from another list. One of the most useful aspects of the Unique function is that you type the formula into one cell, and it will fill in the cells beneath it with all the unique values in the […]