Articles tagged "Spreadsheets & databases"

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 Use Google Apps Script

Here, we cover the basics of Apps Script and how you can start using it—even if you're not a developer or have only limited JavaScript experience.

Write Faster with Spreadsheets: 10 Shortcuts for Composing Outlines, Research, HTML Tables and More

If numbers are involved, a spreadsheet's the tool for the job. But spreadsheets can also be used for so much more: storing contacts, compiling research, organizing outlines, and more.

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

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.