Split Names Into Two Columns In Google Sheets

Split Names Into Two Columns In Google Sheets

Have you ever had a spreadsheet containing a list of names and needed to split them into separate columns for first and last names? You usually would have to write (…) Read more

How to do a VLookup in Google Sheets

The VLookup function in Google Sheets is used to find whether a value exists in multiple ranges. This tool has limitless uses for sorting through and making sense of large (…) Read more

Protect Sheets and Cell Ranges

When sharing a spreadsheet you often have to worry about which cells will be modified by viewers. If you only want them to be able to edit select cells in (…) Read more

Automate your Office Super Bowl Pool with Google Sheets

Automate your Office Super Bowl Pool with Google Sheets

The office Super Bowl Box Pool is just around the corner. You know, the one where you put names in a 10×10 square grid and use the last digit of (…) Read more

6 things From Excel That You Didn’t Know You Could Do In Google Sheets

When Google Sheets was first released, many felt it was lacking the deep functionality and analytical capabilities available in Excel. In fact, some businesses that moved to Google Apps would (…) Read more

Pull Stock Market Data into Google Sheets

Pull Stock Market Data into Google Sheets

Researching specific stocks and pulling accurate up to date information can be tedious. Google Sheets cuts out a lot of the busy work and allows you to get the data (…) Read more

Quick Sum in Google Spreadsheets

Quick Sum in Google Spreadsheets

If you’ve spent any time in Google Spreadsheets, you know formulas are your best bet for calculating data. If you want to get quick insight on your Spreadsheet without using (…) Read more

The Gooru’s Top 10 of 2014

The Gooru’s Top 10 of 2014

We’ve spent the past few weeks analyzing every part of The Gooru website, learning more and more about what content you love so we can continue to bring it to (…) Read more

Docs, Sheets and Slides coming to the Apps Launcher

Docs, Sheets and Slides coming to the Apps Launcher

In true Google style, an update to the Apps Launcher for Google products will roll out to consumers before it makes its way to Google Apps customers. Starting in January, (…) Read more

Sparklines in Google Sheets

Sparklines in Google Sheets

Charts in Google Sheets are really useful when you want to visualize data sets with context and descriptions along with them. But if you just want a quick look at (…) Read more