Articles tagged "Spreadsheets & databases"

Mission Control for Your Content: How to Use Spreadsheets for Your Editorial Calendar

Spreadsheets are infinitely flexible. That's why they're the original killer app—they can manage anything from a corporation's finances to your personal budget. And they're great for text, too. Your next editorial calendar could be in a spreadsheet.

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 Automatically Generate Charts and Reports in Google Sheets and Docs

You've gathered data, perhaps stats about your latest marketing campaign or your sales data from last year. You need to figure out the trends, whip up some charts, and turn them into a report or presentation.

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.

How to Automatically Clean Up Spreadsheet Data with OpenRefine

Ever had to manually edit dusty, messy, years-old information from some obsolete software? I once worked for a company that stored paperwork offsite for 60 years. Materials were indexed in a document table.

Excel Macros Tutorial: How to Record and Create Your Own Excel Macros

Spreadsheets are infinitely flexible—especially in Excel, one of the most powerful spreadsheet apps. Most people use only a small percentage of their seemingly countless possibilities, however.

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 automation decreased Lucidchart's QA checks by 30%

Collaboration across teams ought to be business as usual. But if you've ever worked at a company that's undergone rapid growth, you know communication can break down almost as quickly as new employees are hired.

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.

How youthSpark Created an Automated System Without Developers

A leading innovator in the battle against human trafficking, Georgia's youthSpark transforms the lives of youths at risk for exploitation and abuse.