Articles tagged "Spreadsheets & databases"

A Pest Control Service Created an MVP With No Coding

When lightning strikes and you have an irresistible idea, you don't want to wait to launch it. You want to create a minimum viable product (MVP) and deliver it to your audience now.

The BlackTies: Making magic with automation

Running a successful business is magic in its own right. But managing leads and updating spreadsheets wasn't the kind of magic The BlackTies, a Sydney magician group, wanted to be doing.

How Zapier helped turn this roofing company into a million-dollar business

There's a point in the life cycle of every contracting business when you reach a plateau. It happened to me and my roofing business not long ago.

Steal This Workflow: How to Save Hours Every Week with Webhooks

You’ve seen them hiding in your app’s settings, promising to send notifications, sync data, and connect to other software you use. Webhooks. They’re the mysterious extra in so many apps.

How to Automate Google Sheets With Macros—No Coding Required

Far too often, it goes like this: You download data from your apps—your PayPal transaction data, say, or an exported email list from your old newsletter app—and open it in a spreadsheet.

How to Import Data into Google Sheets

Google Sheets is a powerful online spreadsheet, but what if your data currently lives in another app like Microsoft Excel or in a different format like CSV or TXT? Here's how to import your data into Google Sheets.

6 Google Sheets functions that do more than math

Functions are what make spreadsheets powerful. Most Google Sheets users know you about the functions for basic calculations—SUM, AVERAGE, COUNT, that sort of thing. But Google Sheets functions can do so much more than math.

How to Download Your Data from Google Sheets

Maybe you need to plug your data into desktop software without Google Sheets integration. Maybe you need to share your data with someone who doesn't use Google Sheets. Or maybe you just want an offline copy of your spreadsheet for future reference.

In defense of making spreadsheets for fun

In August, I made a spreadsheet that simulates live baseball games. It was a desperate attempt to grab hold of some semblance of control over the disaster roulette that is this year. It was an act of blind curiosity, a one-time thing.

How SheEO uses automation in their quest to create a $1 billion fund to support women-run businesses

Vicki Saunders is a successful serial entrepreneur, and she knows all too well the biases against women that are built into venture systems. Women receive 2.2% of available funding, Vicki shared with us.