Jun 082017

Sorting through rows and rows of data in a spreadsheet can be overwhelming. That’s why today, we’re rolling out new features in Sheets that make it even easier for you to visualize and share your data, and find insights your teams can act on.

Ask and you shall receive → Sheets can build charts for you

Explore in Sheets, powered by machine intelligence, helps teams gain insights from data, instantly. Simply ask questions—in words, not formulas—to quickly analyze your data. For example, you can ask “what is the distribution of products sold?” or “what are average sales on Sundays?” and Explore will help you find the answers.

Now, we’re using the same powerful technology in Explore to make visualizing data even more effortless. If you don’t see the chart you need, just ask. Instead of manually building charts, ask Explore to do it by typing in “histogram of 2017 customer ratings” or “bar chart for ice cream sales.” Less time spent building charts means more time acting on new insights.

Instantly sync your data from Sheets → Docs or Slides

Whether you’re preparing a client presentation or sharing sales forecasts, keeping data up-to-date can be time-consuming, especially if you need to update charts or tables in multiple sources. This is why we made it easier to programmatically update charts in Docs and Slides last year.

Now, we’re making it simple to keep tables updated, too. Just copy and paste data from Sheets to Docs or Slides and tap the “update” button to sync your data.

Even more Sheets updates

We’re constantly looking for ways to improve our customers’ experience in Sheets. Based on your feedback, we’re rolling out more updates today to help teams get work done faster:

  • Keyboard shortcuts: Change default shortcuts in your browser to the same spreadsheet shortcuts you’re already used to. For example, delete a row quickly by using “Ctrl+-.”
  • Upgraded printing experience: Preview Sheet data in today’s new print interface. Adjust margins, select scale and alignment options or repeat frozen rows and columns before you print your work.
  • Powerful new chart editing experience: Create and edit charts in a new, improved sidebar. Choose from custom colors in charts or add additional trendlines to model data. You can also create more chart types, like 3D charts. This is now also available for iPhones and iPads.
  • More spreadsheet functions: We added new functions to help you find insights, bringing the total function count in Sheets to more than 400. Try “SORTN,” a function unique to Sheets, which can show you the top three orders or best-performing months in a sales record spreadsheet. Sheets also supports statistical functions like “GAMMADIST,” “F.TEST” and “CHISQ.INV.RT.”
  • Increased support for charts in the Sheets API: Use the API to programmatically generate most charts with support for dozens of new operations.

These new features in Sheets are rolling out starting today. Learn how Sheets can help you find valuable insights.

One last thing—so that we can focus our efforts on the improvements to charts outlined above, we’re also deprecating one of the lesser-used chart types: the Motion chart. Beginning in July 2017, you will no longer be able to insert or create Motion charts, and, in September 2017, you will no longer be able to edit them.

No earlier than December 2017, any Motion charts still in Sheets will become static images and no longer update when their corresponding data changes.

Source: https://gsuiteupdates.googleblog.com/2017/06/charts-in-sheets-updates_1.html

Jun 062017

Improve collaboration, increase user mobility and cut IT costs.

The Google Cloud Team has released a video that shows in a glance how companies get value back on using the Gsuite for business.

In this 5-minute video, Forrester analysts discuss current trends in cloud collaboration tools and crunch the ROI numbers for G Suite. Learn how G Suite could deliver an ROI of 304% in three years by:

  • Increasing the efficiency of employee collaboration
  • Allowing users to work from anywhere on any device
  • Reducing on-site servers and telephony services

Ready for IT that pays its own way? Click here to view video.


Jun 022017

Google has announced that Jamboard, their cloud-based, collaborative whiteboard, is available for purchase in the United States.

You can purchase Jamboard for $4,999 USD, which includes 2 styluses, an eraser and a wall mount. We’re also running a promotion—if you order on or before September 30, 2017, you’ll receive $300 off of the annual management and support fee, as well as a discount on the optional rolling stand.

Keep in mind that a G Suite plan is required to use Jamboard so that you can access files from Drive, use them in your brainstorms and come back to your work later. Also, we’re teaming up with BenQ to handle fulfillment, delivery and support. Click here to view the full story from their site.

Source: https://gsuiteupdates.googleblog.com

May 312017

Files are shared with others for collaboration and execution of projects. When you do not want those you shared the files with to access the document any longer, you had to remove the person or change the access settings.

You do not have to worry about that any longer. You can actually set expiry dates for things in your drive that you share with others. Click here to watch a video on how to do this.

Apr 212017

Yesterday (Thursday, April 20) G Suite administrators from the nations companies, came together at the Google office, at Cedi House Financial Center to share ideas, learn of some of the recent updates of interest in G Suite and to arm themselves with industry best practices.

They appreciated first hand how recent additions to G Suite  such as Team Drive, Collaborative Inbox etc can ease administration as well as increase productivity for their users.  Some Security checks on ensuring G Suites continues to authenticate emails against spam and spoofing were some of the highlights.

Some of the prudent features for smoother running of businesses such as Calendar and Resource Sharing  came to the fore with highly intriguing insights and participation. Not to mention tips on doing email scheduling, and maintaining healthy mailbox size.

All in all it was knowledge sharing, networking and increased confidence for G Suite Admins.

Be on the lookout for the next G Suite Events by Hapaweb Solutions, Google Certified G Suite and G Suite for Education Partners.


Aug 272015

An earlier post consider  How to create a SPF record for a domain that uses Google Apps to prevent email spam and fraud. Another way to prevent spammers from sending emails from your address is by setting DKIM authentication—a slightly more involved process, though quite similar to SPF.Google recommends that you add DKIM authentication for each of your domains.

The first step in setting up DKIM authentication with Google Apps (which is detailed here by Google) is to log in to your Apps account.

Click Apps > Google Apps > Gmail

Scroll down to where it says “Authenticate email”

From the drop down list (assuming you have more than one domain associated with your account), choose the domain name for which you want to generate a new record. Then in the large gray box below, click the “Generate new record” link. A popup will ask you to choose a “prefix selector”, but just accept the default (“google”) option and click the “Generate” button.

You will now see a lot of information appear in the gray box that was empty before:


This strange looking information will help machines out on the internet to verify that any emails @ your domain name were actually sent by you.

You now need to update the DNS records for your domain. That’s a fancy way of saying that you need to make this DKIM information available on the internet.

How you set up DNS records will depend on your web hosting service, so you may have to contact your web host to get details about that. (Google has some general guidelines here.) If you are using CPanel, you can implement the following steps.

Firstly, for each domain that you have associated with your Apps account, log in to your CPanel account and choose the “Advanced DNS Zone Editor” option.


You’ll then see a small form something like this:


Into the “Name” field, paste google._domainkey.

In the “TTL” (meaning “time to live”) field, you can basically type any number, but a common one to use is “14400”. (This just tells computers around the world how long—that is, how many seconds—to store this information before checking that it is still current.)

From the drop down list, choose “TXT”.

In the “Address” field, paste the remainder of the DKIM record.


Now click the “Add Record” button, and you’re done with CPanel.

The last step is to return to your Apps account and turn on authentication. If you still have the original DKIM record page open, simply click “Start Authentication” at the bottom of the page.


Otherwise, once again click Advanced Tools and click the “Set up email authentication (DKIM)” link again, and choose the domain for which you just changed the DNS record. The page will indicate the status of the domain key for that domain.

Click “Start authentication”. It may take a while for the authentication process to be completed. It can sometimes take a day or two for your DNS records to be updated around the world, so if you get an error message, perhaps take a break and come back to this authentication step a little later.

And that’s it! Your emails are now more likely to reach their destination now, because they will be officially “signed” by your domain name. And spammers won’t be able to send out emails pretending to be you.

Another way to prevent spammers from sending emails from your address is by adding an SPF record to your domain—a slightly simpler process, but which has the same basic effect.

Jul 272015

About SPF Record

An SPF record is a type of Domain Name Service (DNS) record that identifies which mail servers are permitted to send email on behalf of your domain. It is as easy to adding as MX or A records in your DNS zone.

Why It Is Important?

Today, nearly all abusive e-mail messages carry fake sender addresses. Spammers send email from their mail servers but with your ‘domain’ as the sending email. The victims whose addresses are being abused often suffer from the consequences, because their reputation gets diminished and they have to disclaim liability for the abuse or waste their time sorting out misdirected bounce messages.

The purpose of an SPF record is to prevent spammers from sending messages with forged ‘From Addresses’ at your domain. Recipients can refer to the SPF record to determine whether a message purporting to be from your domain comes from an authorized mail server.

Setting SPF Record for Google Apps

How you set up DNS records will depend on your web hosting service, so you may have to contact your web host to get details about that. (Google has some general guidelines here.) If you are using CPanel, you can implement the following steps.

Login to your CPanel account and choose the “Advanced DNS Zone Editor” option.


You’ll then see a small form something like this:


Into the “Name” field, paste your domain name, followed by a dot. E.g.mysite.com..

In the “TTL” (meaning “time to live”) field, you can basically type any number, but a common one to use is “14400”. (This just tells computers around the world how long—that is, how many seconds—to store this information before checking that it is still current.)

From the drop down list, choose “TXT”.

Into the “Address” field, paste v=spf1 include:_spf.google.com ~all

You will end up with something like this:


Now click the “Add Record” button, and you’re done! You have now added an SPF record for your domain.

Jul 112015
On Friday 10 July 2015, Hapaweb Solutions, a Google Apps partner in Ghana in collaboration with the Google Apps for Work  Ghana team  organised a series of 2 hour trainings for Google Apps administrators in Accra.  Participants were from a number of companies in Ghana including Star Assurance, First Atlantic Bank , Groupe Nduom, Citi FM, Ghana Football Association, JCS Investments Limited, Wolley Group, Delata,
Active Business Solutions Limited and Liberty Capital Holdings Ltd.

The trainings was  led by Albert Opoku and Gideon Brefo, both certified Google Apps for Work Administrators from Hapaaweb Solutions . The training focused on the Google Apps admin console and covered the following:

  • Creating a group that can be used as a shared mailbox for a group of users, Q & A Forums, and distribution lists
  • Creating and using organizational units to manage users, groups, and security settings
  • Managing domain and organization level settings for Google Apps services
  • Using Google Apps Mobile Management to manage Android and Google Sync devices


May 062015

Usually you may want to trial out Google apps for work or Google apps for education before switching over fully. (Google offers a free 30 days trial for Google apps for work for 10 accounts . You can contact us if you want us to help you set up Google Apps for your domain).

During the period of trying out Google apps, you will most likely have to set up a dual delivery or split delivery to ensure you are receiving emails in both your current mail service as well as throught Google Apps.

This tutorial focuses on setting up email aliases (mail forwarders) for cPanel (Webmail) users. This is actually part of the five step process involved in setting up Google Apps on your domain, the steps are :

1. Sign up for Google apps for work (you can contact us to help you do this for FREE)

2. Verify your domain – view this tutorial on how to verify your domain on cPanel.

3. Add up to 10 user accounts on Google Apps

4. Create domain aliases (actually its mail forwarders) for the users (up to 10) – this is what this tutorial handles. If you want to create mail forwarders for just a few emails then you should rather follow this tutorial – how to create single email forwarders on cPanel

5. Configure your MX record to enable dual delivery – view this tutorial on how to do this on cPanel

I assume you have completed steps 1, 2 and 3 above. Every account you create in Google apps has a default alias,  the email alias address for each user@your_domain.com is user@your_domain.com.test-google-a.com for example, the domain alias for albert@hapaweb .com is albert@hapaweb.com.test-google-a.com. You will now have to add these alises to their corresponding accounts in cPanel. Follow the steps below to do this.

STEP 1: Create a csv file with the list of emails addresses and the corresponding Google apps aliases as shown below


STEP 2: Log into your domain’s hosting cPanel via your-domain-name.com/cpanel and click on Import Addresses/Forwarders



STEP 3: Select Forwarders.



STEP 4: Click on the Choose File button and upload your csv.file . Then click on Next to complete the process.