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.


Mar 202017

G Suite (Formally Google Apps) and Gmail do not provide a very clear way to forward Emails, from a particular account, to more than one. In order to accomplish forwarding Emails to multiple recipients, in Gmail, you will need to create a filter.

To create a filter to forward Emails to multiple accounts:

  1. Access your Gmail web interface (mail.google.com) and find the little gear in the top right-hand corner and left click it.
  2.  Left click on settings
  3. Find the blue navigation items, across the top, and click on “Forwarding and PO/IMAP”
  4. Click on the Add a forwarding address button
  5. Enter in the Email address that you would like to forward the Emails to
  6. Google will send a verification Email, to the address chosen, so you will have to log into the account you added and click the link in the Email to verify the Email address.
  7. Repeat steps 4 through 6 for all Email addresses you are forwarding to
  8. Access the settings again, with steps 1 and 2, but this time select the “filters” navigation item
  9. Click the link to “Create a new filter”
  10.  In the To field, fill in the Email address of the account you are forwarding Emails for (this would be the account you are currently logged in with)
  11.  Select the Forward it to: and choose your first address to forward the Emails to. Don’t worry, we will add the rest momentarily
  12. Click the link “Create filter with this search” and you will be returned to the filters main screen
  13. Repeat steps 9 through 12 to add in all the other Email recipients and keep all the settings the same

That’s it, you can now test your configuration by sending an email to the account you created the forwarding rules to and ensure that each recipient receives a copy.

Jun 292016

Can you believe that not so long ago, there was a position called “Messenger” in public and private employment?

There is not much to the job description for a Messenger. As the name suggests, it means a person who exists in an organisation simply to send messages, letters or parcels from one point to another.

As it is a fairly low bar to jump, so application letters for a Messenger position was very common and easy to put together. It often starts like this: “Application for Messenger” and the rest is not worth reading.

Just an exercise, try typing “Application for Messenger” into your browser and see what comes up.

Google Search result for "Messenger"

Google Search result for “Messenger”

Very likely, it will reveal, not long-dead and poorly written application for employment for the position of a messenger.

It will rather show Facebook’s powerful “Messenger” app across various platforms, namely iOS, Android and Windows.

The point is this: the way we work and the tools we use for work have been completely disrupted and re-invented. The work types that used to exist are now extinct and out of living memory.

If you could project yourself into the future in view of the recent past, you will know that many positions advertised for recruitment today will soon not exist.

Those jobs, including a lot of clerical and other repetitive-type positions will go the way of the humble Messenger (ironically now replaced by other systems including Facebook’s Messenger).

By the way, if you don’t know Facebook Messenger and how it works you are missing out, but more about this shortly.

The old messenger position was occupied by a person who usually rides a bicycle or drives a car to deliver documents and official parcels from one organisation to another.

Well, that function will be “yak” in today’s tech-driven world when email and cloud-base services such as Google Apps can deliver instantly – and in a collaborative way.

Mark Zuckerberg has certainly gobbled up the most popular social network and messaging systems on the globe. They include Instagram, Messenger, WhatsApp, and the Facebook itself.

But Facebook’s stand-alone Messenger is truly powerful and stands out.

It is superior in all the services it offers:  extremely fast and free

Multi-media texting, voice and video calls, group video and voice calls, etc – all private.

HapaWeb Media thinks it is the most powerful and under-advertised messaging app on the planet.

In spite of this, the creators’ current position is that the App is only one percent done, and when it’s done, it could be the go-to-App for everything.

Facebook’s director of platform partnerships Julien Codorniou told Wired Magazine that Facebook is just getting started when it comes to Messenger.

“One day, there will be companies built on Messenger, and we are at the beginning of that ecosystem.”

Imagine that!

Given the revolution Facebook has brought to the world of Social Media, it won’t be long before Messenger is spoken of as the “ultimate” Messenger.

Meanwhile, the old clerical position of “Messenger” referenced in this article is possibly the last word you will read about it.

That position and function is dead, gone and buried!

Hopefully too, the power and strength of Facebook’s ultimate Messenger isn’t the first word you’ve heard about that App.


Jun 072016

When you eat your favourite food and it tastes so good, you just want to go for an extra bit, isn’t it? It is similar to the relationship many people developed with reputable newspapers in the past.

So historically, the phrase “Extra extra, Read All about It” was a reference to special editions of newspaper printed outside the normal publishing schedule.

And being “extra,” it carried sensational reports or information that arrived too late to be published in the usual edition. This may include disasters, results of judicial trials or some government decisions with wide-ranging effect.

Newspaper Vendors developed the culture of shouting “Extra extra, Read All about It” to attract readers to buy the extra print and get informed.


Newspapers are either dead or dying fast

But even as newspaper go the way of the dinosaurs, many, especially in developing countries around Africa may not realised that newspapers started dying many decades ago, thanks to technology.

In the early 1930s, Joseph Pulitzer said: “radio beats the newspaper extra in speed, accuracy, and public convenience.”

Today, the reality of that statement (or prediction) is more than true as Social Media components of the Internet enables news to spread faster than ever before.

Who wants to listen to radio constantly and endure the painful sounds of adverts when you can catch up with current affairs on Twitter, Facebook, etc. And if you missed the breaking news, you can always still read, listen or watch on Social Media on all kinds of devices.

What’s more – the smart mobile device in just about everyone’s hand has become a most power tool, more powerful than entire Libraries.

It is enormously powerful as a tool both for input and output functions. Think about that: “input and output functions”

Who ever thinks the printed newspaper business has a future is living in the past. Anyone in the publishing business with half a brain is already on the Internet, making their content either freely available or as a paid service.

To be fair, there might actually be some newspapers that print and distribute exclusively on paper because their environment dictates it. Such environment, if it exists, is a sad reality.

The paper-only publishing is a smooth path to extinction.

Please tell this “breaking news” to such Publishers and Investors, that “paper-only publishing is a smooth path to extinction.”

Newspapers are no longer the favourite destination for news and information – or current affairs. Millions are turning away from it.

Social Media

Alive and Well: Social Media

“Extra extra, Read All about It” is dead and about to be buried.

It was destroyed by Technology, and Technology is not going to jail.

Technology is free, and is roaming all around us. It has no fixed address, but you can find it anytime, anywhere.


Jun 012016

Social Media is really like sugar – once you taste it, you don’t want to spend a day without it. Relatively speaking, it is only a few short years ago when technology brought social media into the modern world, and yet it has become an irreplaceable medium of communication.

It was 2004, and young Mark Zuckerberg launched Facebook. Of course, there was the failed MySpace platform before that. Other successful and pervasive social media platforms now include Twitter, Google +, Instagram, etc.

Mark Zuckerberg

The face of Facebook – Mark Zuckerberg

You can also add WhatsApp, Viber and others to the list.

The revolution in communication brought by social media platforms is most potent among people under 25 years. This is because, for them, social media has existed for most of their life and using it is just the natural thing to do.

You can’t say the same for people over 30 years of age, but even then the penchant to use social media is equally strong. A study by Pew Research actually shows that the use of social media among adults in the years 2005 to 2015 grew exponentially.

The power of social media really lies in the fact that it is an extension of human interaction and expression.

At a very deep level, Edward Bulwer-Lytton’s timeless words, “the pen is mightier than the sword,” is a representation of the deeply human need to communicate every day about several different subjects. It shows that humans will communicate in some way, even at the peril of their lives. No one throughout history has been able to successfully stop human interactions through communications – whether in spoken or written form. The future will not be different.

Pew Research Data

Credit: Pew Research

Long gone are the days when there was often a long distance and time between the source of communication and its destination, especially in the written form.

Now all forms of communications – written, spoken and visual travel at literally the speed of light around the globe as well as reach billions instantly.  The sheer speed and reach of every single expression, whether lame or sublime, is mind-boggling.

The extraordinary power of social media is also evident in the fact that most government institutions around the world have been unable to promulgate reasonable rules to regulate it completely.

These include legislative bodies and regulatory institutions. In some cases, they have been simply too slow to respond, and in others, the actual speed of social media development simply makes it impossible to lay out rules that resonate with the real world use among millions of people.

The challenge experienced at governmental and institutional levels is also felt at personal level. Think about it this way: as an individual, do you have the experience of being trained on the appropriate use of social media before becoming a User? Could you possibly envision the transformation brought about by social media in just over a decade?

Many professionally-minded businesses that care about their reputation realise this, so they spend resources to engage communication strategists to help them get it right.

For most of us on a personal level, our experience was simply getting a new phone or tablet, getting online and signing up to the different media platforms – for free.

Over time, we posted billions of photos, videos and comments including views on a range of issues.

What was naturally lost on most of us was likely the effect and long-term consequences of our posts.

Besides all these, most of us have very little idea about the technical details underpinning the platform, such as where our posts are saved and how they are used by companies that manage the enormous amount of data with incomprehensible algorithms.

Eventually, it gets to the point – like now – when we wake up and ask ourselves, “what is the problem with social media?”

HapaWeb Media sees no problem with Social Media.

Or rather, the problem with social media is simply the challenge presented by our own human nature.

Most of us are generally not good at dealing with change, including using new tools of communication.

We frequently make mistakes with our communication. That is why we often look back and realise there are many things we have said or written that we wish we didn’t.

Apart from this, good judgement is also an issue. Often good judgment is only as common as common sense among many of us.

Social Media

Social Media – here to stay

Even when we are sure of the correctness and appropriateness of what we have said, written or communicated, it is possible that we are wrong or don’t have enough information to realise we are wrong.

On occasions when we may actually be 100% right, opinions and feelings of other well-meaning people might differ dramatically – and that inevitably creates its own conflict.

But Social media has most definitely come to stay. Like many other social and cultural challenges, it will take both personal and institutional intelligence to resolve inevitable conflicts as millions continue – as they should – to use it.

Twitter: @HapaWebMedia