Articles tagged "Spreadsheets & databases"

How to create Google Calendar events from a Google Sheets spreadsheet

Google Calendar events keep you and your team organized and on track. But creating events on Google Calendar can be tedious when you do it repeatedly. Not to mention, manually entering dates and times can make for human error and inaccurate calendars.

14 data visualization examples to captivate your audience

Data visualization turns mundane statistics into visually appealing assets. Check out 14 data visualization examples to guide your efforts.

How to create a pivot table in Excel

Spreadsheets are great for cataloging large pools of data, but it takes a feature like pivot tables to really draw conclusions from the data.

Zapier Tables: Store, move, and take action on your data automatically

Say goodbye to spreadsheet workarounds and say hello to Zapier Tables, the automation-first database solution that lets you store, edit, move, and track your data flow.

How to make a flowchart in Excel (with template)

Flowcharts can help you brainstorm, visualize workflows, and solve problems. Learn how to make a flowchart in Excel.

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 calculate time differences in Excel

Learn how to calculate time differences in Excel with our comprehensive, step-by-step tutorials for everything from basic formulas to advanced calculations.

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.

How to use Zapier to automate Notion

While Notion is perfect for app minimalists and anyone who prefers a ton of customization options, users have struggled to get information from other apps into their Notion workspace.  Not anymore: Zapier's Notion integration is finally here! 

8 Notion tips and tricks for a more powerful workspace

Notion is a widely versatile tool, where the whole is greater than the sum of its parts. These Notion tips can help you get the most out of it.