The ‘Google’ Archives
Posted August 18, 2016 by

How to Set or Change Gmail Signature

gmail

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, […]

Category Android, Google, Internet

Posted August 1, 2016 by

How to Clear Google Activity

Delete Google Searches and Other Activities

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.

Category Apps, Google, Internet

Posted June 24, 2016 by

How to Change Graph Colors in Google Sheets

Google Sheets Graph change pie chart colors

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 […]

Category Google Sheets

Posted June 16, 2016 by

How to Highlight Cells Containing Specific Text in Google Sheets

Google Sheets

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 […]

Category Google Sheets

Posted June 8, 2016 by

How to Protect Cells in Google Sheets

Google Sheets

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 […]

Category Google Sheets

Posted May 22, 2016 by

How to Format Non-Blank Cells in Google Sheets

Google Sheets

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 […]

Category Google Sheets

Posted May 14, 2016 by

How to Use Google Sheets DMAX Function

Google Sheets

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.

Posted May 12, 2016 by

How to Use Google Sheets Filter Function

Google Sheets

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 […]

Category Google Sheets

Posted May 11, 2016 by

How to Use Google Sheets Unique Function

Google Sheets

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 […]

Category Google Sheets

Posted April 19, 2016 by

How to Add YouTube Videos to a Playlist Automatically

youtube-logo-1920

If you always save your uploaded videos into different playlists, you can follow custom rules to configure YouTube to add videos to playlists automatically. This feature can save you a lot of time, and your videos are always organized.

Category Google, Internet