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

How to Create a Custom Business Analytics Dashboard with Google Sheets

With a spreadsheet and some data integrations, you can build the custom dashboard of your dreams. Let's pull your spreadsheet skills together with the Google Analytics add-on for Google Sheets, and learn how to turn your spreadsheet into a data app.

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 Build a Smarter International Phone with Twilio in Just 15 Minutes

The phone app is one of the least smart parts of your phone. It’s still tied to one phone network, with a number from your local area, and likely costs per minute you talk, depending on where you’re calling and where you live.

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.

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.