How To Run A Report On All Groups And Their Members

How To Run A Report On All Groups And Their Members

Try BetterCloud for Google Apps Free for 30 Days —–> Audit Your Google Groups It is no secret that the number of groups in a domain can get out of (…) Read more

How To Make The Perfect Budget In Google Sheets

College students managing spending habits and corporations tracking their marketing expenses. They all need to make budgets. Creating an in-depth and illustrative budget may not seem possible using Google Sheets (…) Read more

How To Turn Any Data Set Into A Heat Map

How To Turn Any Data Set Into A Heat Map

In order to visualize trends within large sets of data, you usually have to create a chart or graph. Google’s recent update to conditional formatting in Google Sheets eliminates that (…) Read more

Turn A Spreadsheet Into A Lie Detector Test With This Formula

Turn A Spreadsheet Into A Lie Detector Test With This Formula

Spreadsheets are well known for their remarkable ability to calculate and analyze data sets. With this hidden feature, Sheets will also become your go to tool for fact checking. By (…) Read more

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