Articles tagged "Spreadsheets & databases"

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

Airtable vs. Trello: Which should you use? [2025]

I spent time tinkering with both of these apps, and here, I'll walk you through the differences—and how to know which one is right for you.

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.

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.

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.

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 enter a formula without a function in Excel

Learn how to enter a formula without using a function in Excel, as well as when you might do this and some pro tips for making the process more efficient.

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.

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!