The tabs feature in Google Sheets is a great organizational tool, and it keeps thing neat and tidy. However, sometimes we need a summary spreadsheet, an at-a-glance overview of the data. Or perhaps it’s useful to see a single chart that updates as we add new information. In either case, the quickest solution is to use the =SUMIF function, and it’s easier than it initially appears.
As an example, let’s create a summarized list of the trucking suppliers we pay. First, add a new tab to the Google Sheet that records the column headers that match the information to summarize.
Psssst…I’m gonna’ share a secret with you, but whatever you do, don’t tell Google.
You see, back in August, the company made a big change to their Keyword Planner, the free go-to tool for SEO specialists everywhere — instead of showing an exact number of “Average Monthly Searches,” it now shows a range — a really broad range:
Do you record your thoughts in voice notes and then have someone transcribe them? Or, do you want to use voice recognition software, but find it too pricey? You can cut the time and money it takes to transcribe your words by using Google Docs’ voice typing tool.
To start, go up to the main menu of your document. Click on Tools.
Did you know that you can use Dropbox Paper to ‘productively stalk’ your colleagues? This goes way beyond the simple ‘read receipts’ in email that you might be used to seeing in your inbox.
Instead of attaching a document to an email, you just use Dropbox Paper to send a link to it instead. You can give people edit-level or comment-level permissions and you can also control whether to share your document with:
everyone at your organization (if your org is setup on Dropbox), or
Guess what? With your Google Apps account you can get a phone number for your business that rings on your cell phone, transcribe your voicemails, and then sends those transcriptions to your Gmail inbox.
You can even send free text messages and make cheap international calls. Here’s how:
But only if you turn on your email notifications….
I edit a publication on Medium, which means I spend an inordinate amount of time reading Medium. Which is pretty cool. What’s even cooler is finding an amazing story that fits NewCo Shift’s editorial voice and POV, then reaching out through Medium’s elegant platform to ask the author if we can run it in our publication. The author gets to reach a growing audience, Shift gets great writing, the audience gets a great read — Win Win Win!
But roughly 15–20% of the time I reach out to a new author, I get this: