Articles tagged "Spreadsheets & databases"

6 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.

How to add leads from LinkedIn Ads to Google Sheets

If you want to more easily slice and dice your lead data or share it with other teams, you might want to drop it into a spreadsheet. Here's how to add new leads from LinkedIn to Google Sheets automatically as soon as they come in.

How to track Google Ads leads in a Google Sheet

Tracking your Google Ads data in a spreadsheet provides a structured, organized, and easily accessible snapshot of your campaign's performance. Here's how to do it automatically.

6 ways to automate MySQL

Here's how to easily turn MySQL into your single source of truth for data across your organization with automation.

What is ETL? (Extract, transform, load)

ETL is a data management process that consolidates, cleans, and moves data to a warehouse. This guide will explain how ETL works and explore common use cases.

How to DIY Google Sheets Kanban boards (or use one of these 6 templates)

To make a Google Sheets Kanban board: name columns, add a border, color-code the cells, create a card template, and edit to suit your workflow.

How to make a graph in Excel

Excel Online offers most of the features found in the desktop version of Excel, and that includes making charts and graphs. Here's how to make a chart or graph in Excel online.

How to add a checkbox in Google Sheets

Here's how to insert a checkbox in Google Sheets—plus, a few advanced tips to make your checkboxes do more than just check a box.

How to remove blank rows in Excel

Learn how to delete blank rows in Excel using the desktop app or online.

16 Google Sheets shortcuts to help you enter, organize, and interpret your data

Here are the keyboard shortcuts I use most to manage multiple spreadsheets, format data, and navigate the Google Sheets interface.