Jenna I. is a tech and entertainment expert with a B.S. in Information & Computer Science and MCITP certification. She writes for Udemy, The Gamer, and SVG.
Browse all posts and insights written by Jenna Inouye.
Here’s what you need to know about the NPER function in Google Sheets. It’s mainly used to determine the number of payment periods until a debt is paid off. The function assumes a constant interest rate, static payment, and no additional principal additions (aside from interest). Because of that, the Google Sheets NPER function is […]
Everyone has a video or two on YouTube that they would like to keep forever. But while the streaming platform may make it easy to share and play YouTube videos, it doesn’t have a built-in feature for downloading them. You might have to be creative if you want to know how to download YouTube videos […]
![Using Google Sheets as a Database 101 [Free Template]](https://productivityspot.com/wp-content/uploads/2021/11/pasted-image-0-3-1024x582.png)
Google Sheets is traditionally used as a spreadsheet program, but using Google Sheets as a database is also a possibility. When you use Google Sheets as a database, you can perform more advanced queries and calculations. You can also manipulate the data in another system altogether. Spreadsheets can do a lot. But there may come a […]
Our Top 3 Recommended Dropbox Alternative Cloud Storage Providers: Sync is the best alternative all around. MEGA offers the best free plan at 20 GB. In comparison, Dropbox only gives you 2 GB for free. Google Drive is the best choice if you already use other Google products, such as Gmail or Google Docs. From working remotely to juggling […]
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 […]
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. […]
Google Sheets is used for everything from personal budget planning to professionally prepared company spreadsheets. To that end, Google Sheets includes some advanced financial functions — including the ability to calculate Net Present Value (NPV). Net Present Value is a concept that’s used to determine the profitability of things like capital expenditures and investments. With […]
Let’s discuss the GOOGLEFINANCE function in Google Sheets. It’s an incredibly powerful tool, and I use it often. Follow along to learn how to use GOOGLEFINANCE. Below, I’ll discuss the function’s use for pulling lie stock quotes into a spreadsheet. I will also include step-by-step instructions on how to use the GOOGLE finance function with […]
In the past, collaborating with other people could be incredibly frustrating. You’d open a document and there would be changes everywhere — deletions, additions, and modifications. You wouldn’t know what had been edited and why. You may have even lost data forever. Today, there’s a simple solution: learning how to track changes in Google […]
Spreadsheets tend to contain sensitive information. While your Google Sheet could just be used for scheduling, it’s more likely to be used for budget meetings, income/expense statements, and employee hours. When a spreadsheet is used for something confidential — something that contains personal information, financial information, or intellectual property — it has to be secured […]
Enjoy our custom-made Google Sheets templates for free via email access
