Google Drive is an efficient, practical, and free way to share, save, and synchronize files on the web. Google Drive is your personal drive in the cloud that allows you to create folders and save documents, spreadsheets, and presentations. Google Drive has three user types: owners, editors, and viewers. Each user type has a different […]

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

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

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

Google Forms is a useful tool for collecting information from a large group of people. You can use the forms you create to make contact lists, send out surveys, manage registrations, and more. Like all Google Docs, multiple people can edit your form at the same time before sending it out. This tutorial assumes that you have […]

Google Sheets is a free alternative to Microsoft Excel that has a mobile and web version. Sheets does not have the full functionality of Excel, but it works well with the touch interface of a mobile phone. Although I would not use Sheets to manage large datasets or do any serious computation, it has the […]

Google Sheets is a free alternative to Microsoft Excel that has a mobile and web version. Sheets does not have the full range of capabilities of Excel, but it works well with the touch interface of a mobile phone. Although I would not use Sheets to manage large datasets or do any serious computation, it […]

I love the versatility of spreadsheets. I use them at work, at home, and even for keeping score when I play games. Google Sheets is a free alternative to Microsoft Excel that has a mobile and web version. Sheets does not have the full functionality of Excel, but it works well with the touch interface […]