Articles tagged "Spreadsheets & databases"

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

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.

Collecting complex data? Here's how to automate it with Zapier

Whenever you need to handle complex information, such as payment information or signatures, a data collection tool will get the job done better than traditional form builders.

4 automated workflows for your business analytics tools

Without data, you have to rely on gut instinct or anecdotal evidence when making decisions. That's not the best way to grow your business.

Spreadsheets aren't databases—stop using them like one

Sometimes a spreadsheet isn't enough. Sure, they're quick to create, but they have limits—and those limits have consequences.

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

How a team of volunteers is working to restore wealth to Black communities

When Justin Samuels saw the incredible community reaction to the civil injustices going on across the U.S., he was inspired. But when he tried to take action, he felt like something was missing.

How a one-woman nonprofit scaled to deliver thousands of meals to people in need

At the beginning of the pandemic, Rhiannon Menn was feeling helpless. She was looking for a way to support the families in her community while still following stay-at-home orders and keeping her family safe.