Articles tagged "Spreadsheets & databases"

How to use Excel: A beginner's guide

Here's everything you need to know to create and use spreadsheets in Microsoft Excel.

How to use conditional formatting in Excel

Make your Excel spreadsheet easier to digest with conditional formatting.

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 connect Google Sheets to WordPress

Discover how to set up a Google Sheets WordPress integration so you can easily connect these two essential tools.

7 ways to automate Smartsheet with Zapier

Get your business-critical tools to cooperate by automating them. Here's how to connect Smartsheet with the other apps in your tech stack with Zapier.

5 ways to automate your database apps with Zapier

Databases centralize and organize important information, but maintaining them can be a chore. Use automation to keep everything on track.

How to find records in Google Sheets, Excel, and across apps

A LOOKUP guide for databases, spreadsheets, and across apps

Connect Facebook Lead Ads to Google Sheets

Connect Facebook Lead Ads to Google Sheets and automatically create a leads database.

How to add a dropdown list in Google Sheets

Dropdown lists enable data consistency, categorization, and organization by limiting input options. Here's how to add a dropdown list in Google Sheets.