top of page
bobs logo.png

PORTFOLIO

Selection of articles & websites.

Layer

9/4/22

Data Analysis in Google Sheets (Tips and Examples)

Google Sheets offers plenty of Data Analysis features that we can use to make sense of large data sets. Here’s how to do Data Analysis in Google Sheets.

Layer

8/25/22

How to Get Data from BigQuery to Google Sheets

If you’d like to move data from BigQuery to Google Sheets and vice versa, we got you. Here’s everything you need to know about BigQuery and Google Sheets.

Layer

8/24/22

How to Find the Slope in Google Sheets

The SLOPE function is an important tool in financial analysis. Here’s how to find the slope in Google Sheets with a chart or by using the SLOPE function.

Layer

8/18/22

How to Import Data from Another Google Sheet

If you’d like to import data from one sheet to another, you can achieve this in a number of ways. Here’s how to import data from another Google Sheet.

Layer

8/16/22

How to Use IMPORTXML in Google Sheets (Examples)

Google offers multiple options to import data from external sources. Here’s how to use IMPORTXML to import structured data from a URL into Google Sheets.

Layer

8/11/22

How to Use Google Forms to Collect Data

Google Forms is a powerful and easy-to-use tool that lets you gather responses from people. Here's how to collect a variety of data in Google Sheets.

Layer

8/10/22

How to Use Google Sheets' Filter View Without Affecting Other Users

With Google filter view, you can filter data in a shared Google Sheets file without it affecting other users. Here’s how to use Google Sheets filter view.

Layer

8/9/22

How to use IMPORTHTML in Google Sheets

Google offers multiple options to import data from external sources. Here’s how to use IMPORTHTML to import tables and lists from a website into Google Sheets.

Layer

8/4/22

Google Sheets Amortization Schedule (Easy Guide)

An amortization schedule helps to determine how your monthly payments affect your loan cost. Here’s how to create an amortization schedule in Google Sheets.

Layer

8/2/22

Google Sheets’ IMPORTDATA

Google offers multiple options to import data from external sources. Here’s how to use IMPORTDATA to import .csv and .tsv files from a URL into Google Sheets.

Layer

7/27/22

How to Save & Export Google Sheets to CSV

CSV is one of the most common file types for data reports out there. Here’s how to export google sheets files to CSV in a few simple steps.

Sheetgo

7/27/22

How to transfer data from one sheet to another in Excel

Learn how to transfer data from one sheet to another in Excel automatically. Transfer, filter, merge and split data without copy-pasting.

bottom of page