Although we rarely need to use subscript and superscript in Google Sheets, there might be some special situations where you might need to include them. We see the option to add a subscript / superscript in Google Docs and Google Slides, so it might come as a surprise to many that Google Sheets has not […]
Sometimes you’re using Google Sheets not to collect your own information, but to collect information from others. At that point, you need something called validation. Validation ensures that the data that’s entered is correct. For instance, if you’re filling out a survey, and you need to make sure that the names are entered properly. Validation […]
Watch – Radar Chart Google Sheets Video Tutorial Google Sheets radar charts are an effective tool for visualizing data sets to compare and contrast. A radar chart will provide the end-user with a quick, clear picture of the top KPIs. Why Use a Google Sheets Radar Chart? As the business world continues to evolve […]
It is no surprise that Google Sheets is great at storing data. Google Sheets is also well equipped with easily created charts and graphs, providing a visual representation of the data. These charts are easily made, edited, and customized. However, many users may not know how to use these charts, so this tutorial will discuss […]
The MMULT function in Google Sheets provides a really easy way to perform matrix multiplication. In this tutorial we will discuss how matrix multiplication works and how the MMULT function can help you get it done quickly and easily. We will also take a look at a use-case to understand how useful the MMULT […]
What is Google Sheets for if not charts and graphs? Charts and graphs are what make Google Sheets so readable. Charts are a form of visual data. While Google Sheets can keep data in columns, rows, and cells, that data isn’t always easy to read at a glance. By using charts like the Pareto […]
An easily solved question that often arises is can Google Sheets copy a row to another sheet? The answer is yes! And, it’s a really simple process. Copying a row is something that you might do if you entered information into the wrong section of a sheet — or if you just needed to duplicate […]
Bubble Charts are a special type of chart that’s generally used to display multiple dimensions of data. In Google Sheets and Microsoft Excel, there’s a special “Chart” function that includes Bubble Charts. It’s not hard to create a Bubble Chart in Google Sheets, but it can be hard to properly format your data for it. […]
How to Set Print Area in Google Sheets – Video tutorial: Setting the print area in Google Sheets is an important part of transferring spreadsheet information in an office. An incorrectly configured Google Sheets print area can result in poorly located page breaks and wasted paper. If you’re coming over from Microsoft Excel, you might […]
How to Make a Line Graph in Google Sheets – Video tutorial: Nothing conveys and represents data as clearly as a line graph. From statistics to evolving data, line graphs are a sure way to record and monitor informational changes accurately. With the use of line graphs, trends clearly appear, allowing individuals and companies alike […]
Watch Video – How to use Google Sheets’ Split Text to Columns tool Are you wondering how to use Google Sheets’ split text to columns tool? The answer is simple, you can quickly split the contents of a cell (or a range of cells) into columns, using the Split Text to Columns feature. This is […]
Google Sheets features a built-in time formatting tool that makes converting between 12-hour time and military time, also known as 24-hour time, a breeze. This tutorial covers how to use the built-in time conversion tool in Google Sheets. It may be particularly useful if you have an existing workbook that has times stored as 12-hour […]
Enjoy our custom-made Google Sheets templates for free via email access
