What is Google Tables and What is it For?

Google Tables: Between Spreadsheets and Databases
Google Tables is a product that originated in Area 120. No, Area 120 is not a place in the Nevada desert where aliens are studied. It’s the name for Google’s in-house incubator.

Tables was launched in September 2020. It can be viewed as a middle ground between spreadsheet software and database software.

Visually, Tables has rows of data, just like a spreadsheet. Functionally, it acts a lot more like a database than a spreadsheet app such as Google Sheets.

[Read more…]

How to Add a Text Box in Google Docs

According to Wikipedia, “a typical text box is a rectangle of any size, possibly with a border that separates the text box from the rest of the interface.”


In a document, as on a web page, a text box is used to emphasize or decorate text to make the text stand out from the rest of the document — like this.

 
Here are three ways to add a text box to a Google Doc.

[Read more…]

How to Create and Use a Dropdown List in Google Sheets

By default, entries into unlocked cells in Google Sheets care freeform. You and any editors you share a Sheet with can type or paste any numbers, letters or symbols into an unlocked cell.

Even images can be entered into Google Sheets cells.

This is one of the aspects of spreadsheets that makes them different from database applications — a lack of rigor.

But it is possible to enforce the entry of only certain values in Google Sheets cells with by creating an in-cell dropdown list.

[Read more…]

How To Create a Google Account Without Gmail

Many people have a need for a free Google Account. However, they don’t want or need a Gmail address. This includes longtime users of a personal email service from Microsoft, Yahoo, AOL, Comcast and others.

Just a few of the reasons you may want to create a Google Account (without Gmail) are:

[Read more…]

Google TV vs Apple TV: Which Is Better?

With the ongoing move from cable TV to streaming, many people are trying to decide which device to connect to their TV—Apple TV or Chromecast with Google TV (think of Chromecast as the hardware and Google TV as the software).

In a business environment, it’s important for employees and visitors to be able to wirelessly display a presentation on on a big screen in a meeting room.

[Read more…]

Google Drive Videos: 6 Business Use Cases

Drag & Drop Video to Google Drive

If your organization uses Google Workspace, you may have discovered that when you upload a video to Google Drive, it’s not simply a stored file—the video can be played inline.

What’s more, Google Drive uses the YouTube engine to play uploaded videos. When playing a Google Drive video, the interface has the appearance of a slimmed down version of the YouTube player.

[Read more…]

Tip: Use Google Workspace to Keep Control of Online Google Services

Control of Google ServicesIn many businesses, the marketing department signs up for a variety of Google services. These services include:

Companies that are not using Google Workspace need to set up access to these Google services via an individual (consumer) Google account. This is usually a Gmail account, but it is also possible to sign up for an individual Google account using a business email address.

[Read more…]

Consumer Google Meet vs. Business Google Meet

Online Consumer vs Business Meeting
The consumer (a.k.a. individual) version of Google Meet is free to anyone with a gmail.com email address. The consumer version generally has the same host and attendee experience as the business version of Google Meet, which is included in Google Workspace.

However, there are some important differences between the free, consumer version of Google Meet and the business versions of Meet.

[Read more…]

How to Use Google Sheets as a Free RSS Reader

Google Sheets RSS ReaderGoogle Sheets can be used as a free RSS (and Atom) reader.

The Sheets IMPORTFEED function allows you to create a self-updating repository of blog & news article content that you can easily share with your social media followers.

In this post, we’ll explain how this works. We’ll show you how to create Google Sheets formulas for one-click social sharing of blog posts and articles on Twitter, LinkedIn and Facebook.

[Read more…]

Google Voice For Business: Cloud Phone System For Google Workspace

Google Voice for BusinessesGoogle Voice for business is a cloud-based business telephone system that has features such as auto attendant, call transfer, voicemail and one-button calling among users.

This “cloud telephony for Google Workspace” offering may be disruptive to the entire business telephony industry.

Why? Because Google has a service that competes directly with popular business VoIP (Voice over Internet Protocol) providers like Vonage, RingCentral, 8×8 and Ooma. These vendors all offer an alternative to traditional landline service.

[Read more…]

Google Docs Preferences: Should You Change Default Settings?

Google Docs General PreferencesGoogle Docs provides a lot of flexibility in terms of user preferences.

Some of the preferences are very useful when enabled. Others can be plain annoying.

However, utility is in the eye of the beholder. One person’s annoyance may be another’s productivity booster.

The following is a list the current options in the General tab (under Tools > Preferences), along with our preferences. Of course, your mileage may vary.

[Read more…]

How to Create a Marketing Dashboard (For Free) With Your Google Account

Marketing DashboardWith the help of four Google components, two of which are included with Google Workspace and Google Workspace Essentials, you as a marketer can create a free marketing dashboard. This can also be done with a Google account, even if your company is not using WorkSpace.

Once you’ve created a dashboard, you can easily share it with anyone within your organization. All they will need is their Google Workspace login to access the dashboard.

You can optionally share the dashboard outside of your organization with someone who has a Google Workspace or Google account.

The needed Google components are:

[Read more…]

What is Google Workspace Essentials and Who is it For?

EssentialsGoogle launched Google Workspace Essentials in May of 2020.

What is Google Workspace Essentials?

Essentials can be viewed as a slimmed down version of Google Workspace. It includes Google Docs, Sheets, Slides, Meet, Sites, Forms and Keep. It does not host your email and it is not your users’ calendar system. Essentials does not include Google Drawings, My Maps or Jamboard.

Who is Essentials for?

[Read more…]

Multiple Domains and Your Google Workspace Account

Internet DomainsThere are a number of reasons an organization may want to have multiple domains associated with their Google Workspace account.

First, we’ll look at some of the reasons for having multiple domains. We will then provide instructions for how to associate additional domains with your Google Workspace account.

[Read more…]

Scheduling Vendor x.ai Reports That Google Meet is #2

Google Meet SchedulingThe AI-driven meeting scheduling vendor x.ai reported in a March 18, 2020 blog post that Google Meet is being used in 24.83% of all video conference meetings scheduled using their app.

Zoom is being used in 69.13% of meetings. That means all other online meeting platforms among x.ai’s customers account for only 6.04%.

Keep in mind that Zoom meetings can be hosted by anyone, regardless of what office suite or email client they’re using. Google Meet is specific to Google Workspace.

[Read more…]

Software Tools For a Distributed Workforce

Updated: May 22, 2020

Globally Distributed Workforce

Long before current events changed where and how many of us work, Matt Matt Mullenweg, cofounder of WordPress had developed a 100% distributed workforce at his company Automattic.

Automattic is “distributed first.” The idea of a geographically disperse workforce was a foundational one. Nearly 800 employees work in 67 different countries.

In the following video, Matt provides a number of tips for building what he calls “a distributed capability.” These include:

  • Document everything
  • Always leave a trail (so others can pick up where you left off)
  • Move communications online
  • Find the right [software] tools
  • Create productive face to face time
  • Help people create their own working space

[Read more…]

This site includes affiliate links to Google.com and associate links to Amazon.com. As an Amazon Associate, I earn from qualifying purchases.

Gmail™, Google Workspace™, Google Sheets™ , Google Docs™ , Google Slides™ , Google Meet™ , Google Drive™, and Google Sites™ are trademarks of Google LLC