Getting Comfortable With The Basics

Docs

Google Sheets Formula Tips & Techniques

18 Google Sheets Formula Tips & Techniques You Should Know – By Benbenlcollins.com6 min
How many of these Google Sheets Formula Tips & Techniques do you know?


The 7 Most Useful Google Sheets Formulas – By Aja Frostblog.hubspot.com7 min
Lately, the best part of my day has been figuring out the cool new things I can do in Google Sheets — which, yes, definitely means I need to get out more, but also means I can share my favorite formulas with you.


SUMIFS in Google Sheets to sum cells with multiple criteria (AND / OR logic) – By Svetlana Cheushevaablebits.com10 min
The tutorial shows how to use the SUMIFS function in Google Spreadsheets to sum cells with multiple criteria. You will find a handful of real-life SUMIFS formula examples with AND as wells as OR criteria.

Changing how Google Drive and Google Photos work together

Changing how Google Drive and Google Photos work together – By blog.google2 min
Many of you store your photos and videos on both Google Drive and Google Photos, which keeps them safe and easy to access. We’ve heard feedback that the connection between these services is confusing, so next month, we’re making some changes to simplify the experience across Drive and Photos.


Autosync for Google Drive can replace the outgoing Photos sync functionality – By Manuel Vonauandroidpolice.com3 min
Google recently announced that the link between Drive and Photos is going away in July, saying that many users find it confusing. Thus, the company leaves us without a simple solution to see our backed up images right in Drive. Thankfully, as is so often the case, there's a third-party app that can do a similar job for us. Autosync for Google Drive could fill in the gap for some users going forward, although it comes with its own limitations.


How to back up your Google Photos – By Barbara Krasnofftheverge.com3 min

So now that automatic synchronization between Google Photos and Google Drive is going away, how can you be sure that your photos and videos are being backed up safely?


Google to disconnect Drive from Photos: How to keep your photos in sync – By Clifford Colbycnet.com2 min

If you store all your Google-related document and files — including photos — automatically in Google Drive, take note: Starting July 10, Google will uncouple Google Photos from Google Drive, and the two storage services will not automatically keep each other's photos in sync. With the change, you will be able to choose where and how you store your photos and videos, but if you're used to finding all your photos in Google Photos and in Google Drive — automatically synced in both places — you'll need to decide how to manage your photos before Google turns off syncing next month.

– Guide to Google Sheets a reliable data source

The ultimate guide to Google Sheets as a reliable data source – Keep calm and use lots of data validation

I occasionally need to grant a non-technical colleague the ability to input information into our data warehouse on an ad-hoc basis. For example, our customer service team at Milk Bar maintains a list of special wedding cakeorders in Google Sheets that we need to collect data from for downstream calculations.

Things Google Sheets Can Do Tips & Tricks

21 Awesome Things Google Sheets Can Do Tips & Tricks by Benjamin Mangold

I love Google Sheets. It has a clean interface, it’s easy to collaborate with people and it integrates with other Google products that I use every day (like Google Analytics and Google Data Studio). It’s really easy to start using Google Sheets, but did you know it offers some great ways to get even more our of your data?

Useful Google Sheets Formulas

The 7 Most Useful Google Sheets Formulas By Aja Frost, blog.hubspot.com

Lately, the best part of my day has been figuring out the cool new things I can do in Google Sheets — which, yes, definitely means I need to get out more, but also means I can share my favorite formulas with you.


How to Automate Google Sheets With Macros By Brady Gavin, www.howtogeek.com

Google Sheets lets you automate repetitive tasks with macros, and you can then bind them to keyboard shortcuts to execute them quickly. They work using Google Apps Script to capture your actions for later use.

How to Protect Cells From Editing in Google Sheets

How to Protect Cells From Editing in Google Sheets – By Brady Gavin, www.howtogeek.com

Protecting individual cells in Google Sheets is a great way to prevent data in your spreadsheet from getting changed—accidentally or intentionally—by anyone viewing the sheet. Fortunately, Sheets provides a handy tool to protects people from altering cells in your document.

– How to Turn Any Android Smartphone into a Google Pixel

How to Turn Any Android Smartphone into a Google Pixel – By Brendan Hesse, lifehacker.com

Android’s flexibility means manufacturers can build their own versions of the OS to suit their hardware, but there’s an elegance to the stock Android experience found on Google’s devices—one that other Android smartphones can’t match.

Images in Google Docs

Images in Google Docs By Marshall Gunnell, www.howtogeek.com

Adding borders around your images is a good way to give them a little extra flair. Google Docs has a set of built-in features for adding borders and, while they’re not as sophisticated as the options offered in something like Office, they do the job.

Google Account – Google Basics: Video

Google Basics Part 6 – Google Chrome By Dottotech, www.youtube.com  VIDEO

Google Chrome is the glue that holds the whole Google Eco-System together.

 


Google Basics Part 5: Google Photos – By Dottotech, www.youtube.com  VIDEO

Google Photos has become the go-to photo storage and sharing app for many of us, for good reason!


Google Drive – Google Basics Part 4 – By Dottotech, www.youtube.com  VIDEO

Google Drive, serves not one but 2 masters: Online storage and file sharing Productivity and collaboration applications


Google Basic Part 3: Google Calendar – By Dottotech, www.youtube.com  VIDEO

Google Calendar is one of the most valuable members of Google's ecosystem. It can form the centre of your productivity system!


How to Use Gmail – Google Basics Part 2 By Dottotech, www.youtube.com Video

Discover how you can use Gmail like a pro. I'll show you everything you need to do to set up your Gmail account and then share the most important Gmail features.


Google Account – Google Basics – Part 1 – By Dottotech, www.youtube.com  VIDEO

Let's go over the Google Basics! In this video, you'll learn how to set up your Google account, what to expect from your Google account and what benefits you get from joining the Google ecosystem.

Resources: –


 

– How to Use Google Docs Offline

How to Use Google Docs Offline By Brady Gavin, www.howtogeek.com

Google Docs is great, but because it typically requires an internet connection to use, getting things done when you’re offline can be challenging. If you’re using Google Chrome, an official extension named Google Docs Offline changes that.

The Best Google Docs Add-Ons​

The Best Google Docs Add-Ons​ – By Brady Gavin, www.howtogeek.com

Google Docs add-ons work similarly to how a browser extension works. They are a third-party app that you install to Google Docs to gain additional features. Some add-ons increase productivity (like proofreading tools) and some add more extensive capabilities (like allowing teachers to integrate grades into students papers). Here’s how to install them and some of our favorites.

How to Use Google Docs

How to Use Google Docs – By Maude Campbell, www.popularmechanics.com

Let’s face it, not everyone uses Microsoft Word anymore. What you really need to know is just how to create a document. Google Docs, released in 2006, is free to use, web-based, and not only for text documents; you can create slideshows and spreadsheets, too. Here's how to use it. 


How to Control Margins in Google Docs – By Brady Gavin, www.howtogeek.com

Margins in a document are the white space that surrounds the text in your file. They appear at the top, bottom, left, and right sides. While the default margins are fine most of the time, sometimes you’ll need to change them. Here’s how.

How to Manage Google Drive Settings

How to Manage Google Drive Settings – By James T. Cains, www.dummies.com

Google Drive itself has only a few settings to keep track of, but they can make your experience a little easier. To manage the main Google Drive settings, log in to Google Drive, click the Settings icon (it looks like a gear) at the top right corner, and choose Settings. 


How to Import an Excel Document into Google Sheets – By Brady Gavin, www.howtogeek.com

Did someone send you an Excel document, but you don’t have Excel? Giving up on Microsoft Office and making the change to Google Drive? No problem; Google Sheets lets you import your Excel files. And while it might not support some of the same features and effects of an Excel document, it works pretty well.

Create a Table of Contents in Google Docs

How to Create a Table of Contents in Google Docs – By Brady Gavin, www.howtogeek.com

Adding a table of contents to your document is a useful way to show readers each topic/chapter listed inside your file. When you create a table of contents in Google Docs, it automatically generates one and adds links that jump to each section they reference when clicked, allowing for quick access to specific parts of your document.

Google Drive’s New Backup Feature Reminded Me I Have No Backup Plan

Google Drive's New Backup Feature Reminded Me I Have No Backup Plan – By Patrick Lucas Austin, lifehacker.com

If you don’t have an offsite cloud storage plan (and you really should), Google’s newest update to its cloud storage service Google Drive is ready to fix your gaping data backup hole by letting you pick which folders on your device you’d like to back up to Google Drive instead of forcing you to put the files into a single Google Drive folder. It’s called Backup & Sync.

Import a Word Document into Google Docs

How to Import a Word Document into Google Docs – By Brady Gavin, www.howtogeek.com

Someone send you a Word document, but you don’t have Word? Giving up on Word and making the change to Google Docs? No problem; Google Docs lets you easily import Word documents. And while it might not support some of the more advanced features and formatting of some Word documents, it works pretty well.

What is Google One and how does Google Drive work?

What is Google One and how does Google Drive work? By Maggie Tillman, www.pocket-lint.com

Google has reduced the cost of Google Drive and is promising to add some really neat features to the online storage service.

Drive has been around for years now but has changed relatively little since launch; it lets you upload files, create files, share files, etc. However, Google recently switched up the service's pricing plans, giving them their very own brand (Google One), and it's bundling some nice-to-haves like live expert support and subscriber perks. Here's what you need to know about Google Drive and Google One.

How to See Recent Changes to Your Google Docs, Sheets, or Slides File

How to See Recent Changes to Your Google Docs, Sheets, or Slides File By Brady Gavin, www.howtogeek.com

The Google Suite offers you a handy way to view all the changes that have occurred in a file on Google Docs, Sheets, or Slides. This is extremely useful when you’ve made lots of changes to a file or are working as part of a team and need to track the changes made to a shared file. Here’s how you can view the recent changes to your Google Docs File.

Things you didn’t know Google Docs could do

25 incredibly useful things you didn’t know Google Docs could do by fastcompany.com

When you’re working in a word processor, every second you save matters. And while Google Docs may seem simple on the surface, it’s practically overflowing with out-of-sight options that can help you get more done with less effort.

The best part? They’re all already there and just waiting to be embraced. All you have to do is find them—and then remember to put them to use. Here’s a head start.

– Grammarly, an online grammar checking too

Grammarly Review: Is Grammarly Worth All The Hype? by bloggingocean.com

Do you make a lot of grammatical and punctuation errors? Don't worry; you are not the only one to face this problem.

Grammarly, an online grammar checking tool, claims to make writing a lot easier by proofreading your content in real time as you type. Off late, it is gaining a lot of popularity and is being used and recommended by many people.


Grammarly – Advanced grammar and spell checker for iPad and Mac by michaelkummer.com

Grammarly is an advanced grammar and spell checker for iOS and the Mac. It helps me to write better copy at work and in my capacity as a blogger. If you write as much as I do, I would highly recommend to check it out.

Google Drive Can Help Power Your WordPress Business

25 Ways Google Drive Can Help Power Your WordPress Business by elegantthemes.com

Google Drive has saved my life (professionally, at least) on any number of occasions. I know that some people are wary of services like Google Drive or iCloud for fear of being locked into a single company’s ecosystem (or walled garden, as they’re usually referred to), but there are a lot of benefits to using Google Drive if you’re running a WordPress business. We use it here at Elegant Themes, and it makes putting things into your hands so much easier.

Google redesigns Drive to look more like the new Gmail

Google redesigns Drive to look more like the new Gmail by engadget.com

Google has given Drive a surprise makeover with elements that make it look more like the new Gmail. The redesign doesn't come with new features, but when you get it, you'll notice that The Big G has changed the Drive interface background from gray to white for a cleaner look. Its boxes and icons now also have much rounded corners and look a bit taller than before, and Drive's logo now has a more prominent place on the top left corner of the interface.

Google One is a new cloud storage service

Google One is a new cloud storage service with perks by androidandme.com

Google is not a stranger to cloud services, and the company has just unveiled a brand new offering for storage.

The new service is called Google One, with storage options ranging from 100GB to 30TB. The 100GB option will be priced at $1.99 per month, the 200GB will cost $2.99 per month, and the 2TB option will go for $9.99 per month.

Tech News by Topic