top of page
bobs logo.png

PORTFOLIO

Selection of articles & websites.

Sheetgo

4/29/22

How to do a mail merge from Google Docs

A step-by-step guide on how to create a mail merge in Google Docs and send personalized emails to multiple recipients automatically.

Sheetgo

4/28/22

How to use Google Sheets ARRAYFORMULA

Use Google Sheets ARRAYFORMULA to output an entire range of cells. Learn how to save time and create more efficient spreadsheets.

Layer

4/13/22

Combine Multiple CSV Files into One Excel File (Multiple Methods)

If you have data in several CSV files you can merge them into one file in Excel. Here's how to combine multiple CSV files in Excel.

Sheetgo

4/13/22

How to send an email to multiple recipients individually

Looking for tips on how to send an email to multiple recipients? We provide a step-by-step guide on sending emails to multiple recipients individually.

Layer

4/12/22

How to Track Changes in Google Sheets

There are several ways to track changes in Google Sheets to make collaboration in your team even easier. Here's how to track changes in Google Sheets.

Layer

4/11/22

Excel Co-authoring & Collaboration (Complete Guide)

Excel Co-Authoring allows team members to collaborate on the same Excel file simultaneously. Here's how to achieve the best results with Excel Co-authoring.

Layer

4/7/22

How to Compare Two Excel Files for Differences

There are a variety of methods to compare Excel files or sheets and identify differences. Here's how to compare two Excel files or sheets.

Sheetgo

4/7/22

Import filtered data from Excel to Google Sheets

Import filtered data from Excel to Google Sheets and create automated connections between your files to reflect all changes made immediately.

Layer

4/3/22

How to Create and Use a Pivot Table in Google Sheets

Pivot tables can help you summarize large data sets in spreadsheets. Here's how to create a pivot table in Google Sheets.

Sheetgo

4/1/22

How to solve the 10 million cell limit in Google Sheets

In this article, you learn how to solve the Google Sheets cell limit by splitting and consolidating larger sheets into smaller ones.

Layer

3/31/22

How to Sign an Excel Document

There are multiple ways to insert a signature in Excel, either visible or invisible (e. g. digitally). Here's how to sign an excel document.

Sheetgo

3/31/22

How to use the FV formula in Google Sheets

The FV formula in Google Sheets calculates the future value of your investment, taking into account the periodic payment amount and the interest rate.

bottom of page