Introduction:

This post will be the first in a series of post on using Google Docs and its new interface.  As I’ve written about on several different posts including ones on collaboration, integration, and usability, Google Docs is one of the leading cloud based office productivity suites on the market.

It offers many features and strengths over its competitors, including fast processing times, sharing and collaboration capabilities, and a large base of existing users.  This introductory guide will provide an overview of the user interface for new users of Google Docs

Accessing Google Docs:

In order to unlock the power of Google Docs, you must first have set up a Google Account (unless you already have one).  You can set up an account by going to www.google.com and clicking on “sign in” in the upper right hand corner.  Google will then ask for information and an account will be set up for you.  This account will allow you to not only access Google Docs but will also allow you to access the numerous other Google products that they have.

Once you have an account set up, you can go to docs.google.com to start using your new Google Docs account.   When you arrive at the Google Docs homepage you will see a screen that looks similar to the one shown in the image below.

Google Docs Main Interface

Navigating the User Interface:

I really like the user interface.  It is clean, intuitive and easy to navigate around.  For user that have used Google Docs in the past but have not used it recently the interface probably looks different.  Google recently conducted an overhaul of all their services’ interfaces to become more uniform.

Moving around the user interface is intuitive and easy to learn.   In the main body of the interface are the files that have stored in your account. The main interface is housed within the traditional Google interface with the search box located at the top and the Google ribbon included at the very top of the screen.  In the screenshot above, you can see that I have two files in my Google Docs cloud storage, one spreadsheet and one document.

On the left hand side of the user interface are two red buttons – one that allows you to create a new file (CREATE) within Google Docs and an upload button that allows the user to upload other external files (like Microsoft Office files, Adobe PDF files, or image files).  I’ve had good success with uploading different file types.

Google Docs using a file management system that is based on tags and collections.  It does not use a traditional folder style file structure like that used by Microsoft or other software companies.   This can take some getting used to but for long time Google users or users that have Gmail accounts, it shouldn’t be much a problem. The file filters are shown on the left hand side of the screen.  Google Docs allows you to filter by owner, starred items, or by user-defined collections.

In the upper right hand corner above the main body there are two other buttons – the ‘Sort’ button and the ‘Settings’ button (that looks like a gadget or bolt.)   The ‘Sort’ button allows the user to sort files by priority, time, size, and owner.  The “Settings” button allows the user to change things like the display and time settings.

Productivity Programs of Google Docs:

The Google Docs suite consists of the following programs:

- Document
- Presentation
- Spreadsheet
- Form
- Table
- Drawing

The mostly wide used of the programs; Documents, Presentations, and Spreadsheets, provide intuitive interfaces and resemble that of other office desktop and web-based suites, (such as Microsoft Office, Zoho Office Suite, or OpenOffice).  The other programs; Forms, Tables, and Drawings are powerful tools that provide users with other useful functionality that can be integrated within the other programs.

Below is a screenshot of what a Google Docs spreadsheet looks like.   I will be providing more detailed posts on how to use each of the Programs of Google Docs.

Google Docs Spreadsheet

Google Docs Spreadsheet

Sharing Capabilities:

One of the great strengths of Google Docs is its sharing capabilities.  Since Google Docs is a cloud-based SaaS program, it is a naturally strong program for sharing and collaborating on the web.  Each of the programs within Google Docs allows the owner of the document to share the spreadsheet with other users.

Google Docs Sharing Window

Google Docs Sharing Window

Google Docs allows 3 sharing settings; 1) Public on the Web, 2) Anyone with the Link, and 3) Private.  ”Public on the Web” allows for the most openness as anyone can search and find documents with this setting.  ”Anyone with Link” allows additional control over who can view the documents by not allowing it to be searchable over the web.  ”Private” allows the most control – only those users that the owner has granted permission to use are allowed to view or edit the document.

Google Docs Sharing Options

Google Docs Sharing Options

In Conclusion:

Setting up a Google Docs account is easy to do and provides a powerful and free office suite.  For long-time Google users, the transition to using Google Docs should be simple and easy.  For long-term Microsoft Office users, there may be a little bit more of a learning curve due to the unique file management structure and different user interface.

Overall, I find Google Docs to be a powerful tool that everyone should look into.  I’m quite impressed with it sharing options and responsiveness. Although Google Docs is not the only cloud-based office productivity suite on the market, it is one of the leaders.

Stay tuned for additional posts on how to use the programs within the Google Docs suite!

For more information, visit the following posts:

Comparing Cloud-Based spreadsheets
Comparing Cloud-Based word processors
Collaborating with Google Docs

Introduction:
Microsoft recently announced a series of enhancements to SkyDrive, their web-based cloud file storage service.   This is another step in the right direction for Microsoft as they try to gain market share in the cloud-based file storage and web applications arena. Some of the recent improvements announced include:

Better sharing capabilities:
This is one area that was always a little clunky for SkyDrive.  Before, you were forced to place the files you wish to share within a folder that was “shared” and open for public viewing.   In addition, it was difficult for users to share files with other people who were outside of the Microsoft ecosystem.

With the new improvements, both of these issues are addressed by allowing files to be shared individually from any folder (instead of only from a “shared” folder) and with other users through several different methods (email, links, and social networks).  As stated on their blog, Microsoft is hoping to create a more “app-centric” experience.

More User Friendly File Management
File management in SkyDrive has not been their strong point.  In comparison to other cloud-based services like Google DocsBox, and Zoho, the SkyDrive user interface has been underwhelming.    These most recent updates hope to address some of those issues.

Some of the added file management functionality include:

  • The ability to change file and folder names inline
  • Move, delete and download multiple files
  • Move and Copy folders and files more easily
  • The addition of right-click functionality for photos and documents
  • Faster creation of Office Web Apps files.

Enhanced User Experience
In addition to the improvements to sharing and file management, Microsoft also made some additional changes to increase the overall speed and user experience for SkyDrive.  Some of the other improvements include:

  • Better browser support for FireFox, Chrome, and Safari
  • Ability to read other file types (PDF, RAW, etc.)
  • Enhanced photo editing

In Conclusion
All of these improvements I think show that Microsoft recognizes that the future is in the cloud.  Even with these improvements, I still think they have a way to go to catch up with other services like Box and Google.

The good news for them is that cloud-based file storage is still in its infancy and they stand to grab a huge market share of enterprise users who currently use products like SharePoint and Office.  As businesses slowly move to the cloud, Microsoft will be in a position to gather a large portion of those customers that wish to keep continuity in their products.

We’ll be watching to see where SkyDrive end up in the cloud computing race.

-TW

Box, the file content management and file storage service, recently announced on their blog that they will be changing its domain extension from ‘.net’ to ‘.com’.  They stated that the reason for the change was to that the company “..needed a trusted and updated, enterprise-worthy domain”.This appears to be another step in the evolution of Box from a small start-up to a major player in the cloud computing and file content management industry.  In my opinion, Box has done an excellent job distinguishing themselves from others in the marketplace by offering a great brand and a great product.   There are several cloud-based file services on the market, including services like DropBox and SugarSync, but Box has been able to distinguish themselves as a niche product that offers more than just file storage and syncing files across multiple devices.

When I first heard about the change, I was a little bit concerned that the links that I have shared using the ‘.net’ address would not work.  After testing several of my linked files it doesn’t appear that there are any problems.   Based on some of the comments from the blog post, it sounds like some users IT departments may need to change some of their firewall settings so that the new domain does not get blocked.

Overview
There are several options for storing you files on the cloud and syncing them across multiple computers – how do you know which one is best for you?

Below is a summary of seven popular file storage and syncing services. I’ve compared 7 popular storage services against four categories; amount of free storage, ability to sync across multiple computers/devices, ability to sync user defined folders, and if it offers a mobile application through Android or the iPhone.

Services with Most Features
As I have discussed in a previous post, I still believe that SugarSync offers the best value for a cloud-based file storage and syncing service.  They offer several features that I find advantageous over the others, including 5GB of free storage, a mobile application, and a very nice interface for syncing files across multiple device.

I recently starting using Windows Live Mesh and was impressed with Microsoft’s offering.  They offer a full 5 GB of free storage that can be synced across multiple computers.  I found the syncing to be fast and efficient.   Setting up user defined folders was a little bit of hassle, but works well once the set up was complete.

The Market Leaders
I’ve discussed both DropBox and Box.net previously on this site.  Both of these are great options and are market leaders.  DropBox offers slightly less storage with their free version and also does not have the ability to select custom folders, but still is a very popular choice.  Box.net actually integrates a lot of enhanced features, making it more of a Content Management System.  They offer a lot of collaboration features which several of the other services do not offer.

The 2GB Storage Group
ZumoDrive
, Syncplicity, and SpiderOak round out the other services that I reviewed.  Each of these are very similar in functionality, offer 2GB of free storage, and have the ability to sync across multiple computers.  If you are looking for a free service, I like SugarSync over these because of the larger amount of free storage.

Summary
With dozens and dozens of file storage systems on the market today, it can be very difficult to find the service that meets your needs.   If you are looking for a decent amount of storage, with the ability to sync across multiple devices I would recommend trying out some of the services I have discussed here.

I’ve recently been playing around with the file sharing site Ge.tt and have been quite impressed. Unlike many of the other file sharing sites out there, Ge.tt offers a simple user interface, a process that allows to share files quickly, and the ability to create multiple storage locations with separate URL links.

In addition, some of the other capabilities that I think distinguish from other file sharing sites include:

- Sharing capabilities through Twitter, Facebook, and email

- Ability to create what Ge.tt calls “Shares”, which are essentially separate storage locations with unique URL address.

- Automatic shortened URL links for “Shares”

One of the other cool features about Ge.tt is that you don’t have to be registered to use the service.  It reminds me a bit of the former file sharing/collaboration site Drop.io, which unfortunately no longer exists since it was bought by Facebook.  It’s not quite as open as Drop.io was, but it does have some similar features.

You also have the option to register, which offer you some additional functionality.    It currently offers 3 GB of storage for registered users.

Overall, I’m really impressed with the Ge.tt file sharing service.  I think its biggest strength is its simplicity and ease of use.   I will definitely be incorporating this service into my file sharing and storage toolbox.

-TW

One of the very useful features of Google Docs is the ability to effortlessly share files and collaborate in real-time.  In my tests,  I feel that Google Docs offers the best functionality for sharing.   Microsoft Skydrive has only limited sharing abilities and Zoho Office only has the ability to share with other Zoho users.  Google Docs offers sharing and collaboration with both registered and unregistered users which is a plus.  With Google Docs you have three sharing options available 1) Public, 2) Anyone with Link, and 3) Private.

The “Anyone with Link” option is provides the user with a the link that can be sent out to all other collaborators regardless of whether or not they are registered or not.  Under this configuration, each  user has a different color scheme is labeled with a name like “anonymous9001″.  To setup the “Anyone with link” option, a file must be created and then the  ”File>Share” menu option must be chosen. Under the “Who has Access” box, the top line allows you to change the classification.  After you have changed the status, a URL link appears at the top. This link is what you will send to everyone that you wish to collaborate with.

The “Private” option requires a google account and then lists the people’s names that are editing.  The only difference between the “Private” and the “Anyone With Link” option is the naming convention for the collaboration colors.  Instead of showing up as “anonymous_xxx”, the user will show up as their Google account name.  The “Public” Option allows anyone to view the document, but does not allow anyone to edit it.

Overall, I feel that Google offers a great collaboration product.   Its sharing features offer superior flexibility for those wishing to collaborate.

-TW

Overview:
One of the great things about the Zoho Office Suite is its ability to implement VBA macros into spreadsheets. Zoho is an web-based SaaS office productivity application that includes a full range of capabilities. In an older post, I conducted a review of the popular web-based spreadsheets and I concluded that Zoho (along with Google Docs) offered the best range of capabilities.

One of the things I really liked about the Zoho spreadsheet application was its ability to import and create macros that are compatible with Microsoft’s Visual Basic for Applications (VBA) programming language. For seasoned veterans of Microsoft Excel, this is a nice feature that allows the users to use previously written macros and apply their VBA programming language knowledge into online Zoho spreadsheets.

In order to try out the Zoho VBA macros, I built a very simple spreadsheet calculator that takes the input of two numbers and give the user a choice to apply simple mathematical functions (Add, subtract, Multiply, Divide) to the number and returns a results. The image below shows the final product. 

 Writing the VBA Macros:
The first step in creating the simple calculator was to write the actual macros. To access the VBA editor window, you select the Macros>VBA editor menu item from the menu bar.

After selecting the VBA editor, you then have a blank slate to start writing your macros. On the left side of the window are the spreadsheets objects and the right side has the text editor where the code is written. For those that are familiar with VBA, the Zoho VBA editor basically looks like a stripped down version of the VBA code editor you can find in Microsoft Office products.

For this tool, I chose to keep it simple by placing the sub routines with the mathematical functions in “ThisWorkbook” object. You could have also placed them either in the “Sheet” or “Macro Module” option. I created four separate sub-routines, one each for the different mathematical functions. I tied the input and return values to specific ranges on the spreadsheets (ranges B3 and B4 for input, B7 for return value). The coding is very similar to Microsoft VBA, so I had no problems putting it together.

Adding Functionality with Buttons:
The last step I took was to create additional user functionality through the use of buttons. Buttons add a better user experience. Zoho has an option to add buttons to your spreadsheet very easily. To create a button within Zoho, click on the ‘+’ icon on the main toolbar. You will then have the option to Insert a button into the spreadsheet.

Once you have inserted the button (or in the case of the simple calculator spreadsheet – 4 buttons), you can the resize, edit the label, and move them where you want. The last step in completing the spreadsheet is to tie the VBA macros that were written to the buttons. This will trigger the button to execute the appropriate macro for the desired function.

In Conclusion:
For users of Microsoft Excel VBA users, Zoho offers some nice abilities to port over your simple VBA macros. At this point, I belive that Zoho is the only online spreadsheet that allows a user to include VBA macros within their spreadsheets. Google Docs using their own javascript-like language and the other online spreadsheets don’t have this capability.

I have never really used Google Voice and Video Chat before, but I recently played around with it when I noticed that it was embedded within Gmail.  Google Voice and Video chat is VoiP service offered by Google that is similar to services like Skype.

There are several cool things about Google Voice and Video Chat, including:

  • Ability to make PC to PC calls within Gmail, or iGoogle
  • Your own phone number selected from a pool of numbers in your area code
  • Support for voicemail, conference calls, and call forwarding
  • Supported on both PCs and mobile devices
  • Video calling support (similar to Skype)
The item I like best about Google Voice and Video Chat is the ability to make free outbound calls to domestic landlines and mobile phones.   For some of the other big players, like Skype, domestic calls to landlines and mobile phones still have fees attached to them (still low though).

Using Google Voice within Gmail is very easy.   On the left hand side, under the ‘Mail’ group is the ‘Chat’ group.   Under the ‘Chat’ Group, there is an option called ‘Call phone’ (as shown on the left).

When you click on the ‘Call phone’ option, a another window will pop up with a ten buttons resembling a phone. (shown below)  This is the access point to making your free phone calls.  You must make sure that you have downloaded the Google Voice and Video Chat plug-in.

To make a phone call, simply dial in the number you wish and start talking once somebody answers.   Calls are free for national calls originating in the United States.  For calls destined to international locations, minutes can be purchased from the Google Voice website by clicking on the dollar amount button.

For more information, Wikipedia’s Google Voice entry has more information.   I have not tried using Google Voice on mobile devices, like smartphones or web-enabled digital devices (like the iPod Touch), but I do believe functionality exists for mobile devices.

Google Voice and Video Chat is another great option to add to your toolbox to keep communication costs low.   Please comment if you have more information.

-TW


A big part of maintaining a blog is keeping up with technology news as much as possible.  Since I only work on this blog part-time, I have to be efficient with my intake of technology related news.   As a result, I try to follow blogs, Twitter feeds, and RSS feeds of only a select few resources that I feel give me the best news without overwhelming me with information.

Below is a list of my favorite news related technology blogs that I follow through my RSS feeds (via Google Reader)

GigaOM - Great blog for general tech news.  Covers all the basics with emphasis on Cloud Computing, Mobile, and Social Media, as well as other things like Cleantech and other technology related infrastructure.

Mashable – One of the most popular technology blogs on the web.  Its content is very extensive and covers a very wide range of topics, including Business, Techs and Gadget, Social Media, and Mobile.   If I have any complaint about Mashable, it is that the material and number of posts are so extensive that it is difficult to keep up with all of the news.

ReadWriteWeb - This is probably my favorite of the three.  I personally think that it covers a slightly narrower range of technical news, which I like.  It does cover some of the business aspects of technical startups, but mainly focuses on general technology news around cloud computing, enterprise computing, and mobile computing.

In addition to the above blogs, I also follow several other tech news feeds via Twitter, including; GizmodoeWeekengadgetTechcrunchAllTouchTablet, and Wired.  All of these are good, but I find that once you start following several of these, you start to see a lot of redundancy.

Another great source for staying up to date with the latest technology news is through the software company blogs. You do have to be careful with company blogs because they are obviously biased towards their own products.  With that said, I have been impressed with the way that many companies have used social media to inform existing and future customers.

I like to stay on top of several company’s news through their blogs and YouTube channels.  Some of the company blogs and YouTube channels I follow include; Box.netSugarSyncGoogle,Salesforce.comZohoMicrosoft, and Apple.

For this post, I have mainly focused on the large technology news resources. For every large blog, there are several small blogs (such as this one) that provide a wealth of great information.   I would encourage everyone to keep an eye out for these also.  Oftentimes they focus on a niche subject (e.g. Java programming or VBA scripting) and can be very valuable.

Please comment or email if you have other good sources for technology related news and training.

-TW

Follow

Get every new post delivered to your Inbox.

Join 54 other followers