Articles tagged "Spreadsheets & databases"

How to use Google Sheets: A complete guide

Google Sheets is a free, cloud-based spreadsheet app that is great for collaboration. In this article, I'll show you how to use Google Sheets.

How to use conditional formatting in Excel

Make your Excel spreadsheet easier to digest with conditional formatting.

How to use Google Docs version history

With version history in Google Docs, you can review and restore previous versions of any document. Here's how.

How to use VLOOKUP in Google Sheets

Our guide to using VLOOKUP in Google Sheets will help you find the data you're looking for across multiple tables and sheets within the same document.

How to integrate Google Sheets with Shopify

Using Shopify and Google Sheets to manage your eCommerce store is critical for your business workflows, but they work even better together. Here are the most popular ways to connect them with Zapier.

How to integrate Google Sheets with Mailchimp

Sometimes the info you need to use in Mailchimp might be stuck in Google Sheets. Instead of manually transferring data, automate the entire process.

How to automatically add new Unbounce submissions to Google Sheets

You can track your form submissions in Unbounce. But if you need to easily share it or add it to an archive, you might want to store it in Google Sheets instead.

How to connect to a MySQL database

Learn how to connect to a database in MySQL with command options, MySQL Workbench, and Sequel Ace, plus how to get set up for the first time.

The 7 best Notion alternatives

I considered and tested dozens of Notion alternatives for all skill levels (and all levels of ambition), and these are your best options.

What is a CMMS? Uses and software tips

A CMMS, or computerized maintenance management system, is asset management software used to manage the availability and well-being of physical infrastructure.