If you ask business owners and managers about one piece of software they can’t live without, most will reply with the office suite. Who could live without the ability to create documents, presentations and spreadsheets? Among the numerous suites available, Google Docs offers some great features including a versatile spreadsheet program. Do you use Google Docs Spreadsheet in your office?
Spreadsheet is simple and straightforward, but sometimes it appears to be a little too plain. There are however a large amount of incredibly useful features hidden away. Here are a few:
=GoogleFinance: This function provides you with practical options including the ability to convert currency and track stocks. The standard formula is =GoogleFinance(“Symbol”, “Attribute”) Where Symbol is the stock symbol and Attribute is what you would like to follow e.g., price.
You can also use this function for currency rates and conversions. If you want to know what the current exchange rate is between the Canadian Dollar and the US Dollar put: =GoogleFinance(“CADUSD”) to get the current exchange rate. Like stocks, this will be updated whenever the exchange rate changes. For a full list of =GoogleFinance functions check out this page.
Translate a cell: From time to time you may get a spreadsheet that contains more than one language. Usually you would have to send it back to the author for translation, which could take more time than anticipated. Did you know that you can get Google to translate a cell from one language to another? In an empty cell enter: =GoogleTranslate(CELL, “Source Language”, “ Target Language”) Where: CELL is the cell you want to translate; Source Language is the language the cell is currently in; Target language is the language you’d like to translate into. For the languages you have to use the two letter ISO 639-2 language codes.
Split a Cell: If you want to create a table that has the days of the week in columns you can easily do so. In the first cell enter: =Split(“Monday Tuesday Wednesday Thursday Friday Saturday Sunday”, “ “) Spreadsheet will automatically put the days into separate columns. To spread data out in a row enter: =transpose(Split(“Monday Tuesday Wednesday Thursday Friday Saturday Sunday”, “ “)). Be sure to have spaces between the data you want in different cells, and a space between the quotation marks at the end of the function.
Concatenate: This function acts as the opposite of =Split. If you have data in a number of cells you want to bring together e.g., data in cells A2, A5, A6, B7, enter =concatenate(A2, A5, A6, B7) The data will be put into one cell.
There are many more handy functions out there that will make your life easier and take some of the work out of spreadsheet creation. If you have any questions regarding Spreadsheet, Google Docs or other Google Apps please let us know, we are happy to help.

With the increasing severity of natural disasters in recent years, many larger companies have started to develop and implement a continuity plan to ensure that they can still conduct business, no matter what happens. Businesses in the process of developing a plan will eventually need to decide if they want to use software or templates?
In the past five years, there has been a significant rise in the sharing of files and information between computer users. Many businesses have also taken to sharing files using cloud services and peer-to-peer (P2P) networks, allowing users to share files with each other over the Internet. This brings about a number of issues, both with file recoverability and overall security.
Smartphones have been a part of our personal lives for a while now. It’s no surprise then that we are starting to also use them for business purposes. In fact, many of us already check our work email on our personal device. As smartphones become more powerful and popular, employees are wanting to “Bring Your Own Device” (BYOD). Is your company prepared for this?
Google is well known for their practical apps, the most famous one obviously being Gmail. A few months ago Google updated their look, with the whole Google platform receiving a makeover. The change took users by surprise, bringing about mixed reviews. Google gave the users who didn’t like the change some respite, allowing them to stick with the old look.
Many of us have had the pleasure of working with the Windows Operating System, more specifically, Windows 7. From time-to-time there is a problem and something stops working. When this does happen, our normal response is to hit CTRL-ALT-DELETE; restart the computer, losing what we were working on, and try to start from where we left off.
An ever increasing number of businesses are starting to adopt the cloud and all its related programs as the main way to do business. One of the leading cloud integration companies is Google. With many Google Apps, users can collaborate on projects in real time allowing for a more dynamic approach to document creation. Google’s social networking program, G+, is now widely used by businesses as well. One feature, Hangout, can be a great way for multiple users to participate on projects. A recent update to Hangout has made it even easier to work together. Read on to learn how.
It’s hard to find someone who isn’t using social media in some way, or at the very least isn’t aware of its existence. Companies are becoming wise to this and are starting to utilize social media tools to build their brand, or bring in new customers. If your company does not use any form of social media, it may be time to look into getting your business out there.
For employees developing Java applications, there are a number of ways they can go about it. In the past, many had to first develop a framework, then develop the applications around it. This changed when VMWare released the Spring Framework. The Spring Framework was recently updated, read on to learn more.
Many companies have turned to the Internet as a way to build their brand, reach out to, and connect with customers. This means having a presence where customers are looking. When a customer wants to find out about a business, it is highly likely that the first place they go is Google. One of the most powerful apps businesses can use to get their name out there is Google Places. Are you using Google Places with your business?


