Articles tagged "Spreadsheets & databases"

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 build a KPI dashboard in Excel in 3 steps (with free templates)

Learn how to create a KPI dashboard in Excel or use one of our free dashboard templates for efficient business analytics and timely decision-making.

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

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.

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.

How to make a graph or chart in Google Sheets

Google Sheets makes it easy to create charts or graphs out of numbers in your spreadsheet. Here's a step-by-step guide on how to do it.

How to convert Google Sheets to Excel

Learn how to easily convert Google Sheets to Excel with our step-by-step guide. Boost your productivity and discover handy tips and automations with Zapier.