Google Docs, one of the more popular office suites, offers the usual work-based programs, including their version of MS Excel: Google Spreadsheet. Most would agree that a spreadsheet program is something that all managers couldn’t live without, yet few have truly mastered such programs due to the relative complexity of some functions. We’re here to help make Spreadsheet a bit easier with some interesting tips.

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.

It used to be that when companies conducted interviews it was the only chance for both the candidate and the company to get to know each other. With the prevalence of social media, companies have now been given a way to find out more than they ever need to know about their potential employees. Some have taken this research to the extreme leaving job hunters unhappy.

News agencies have been carrying stories about companies that have been asking job applicants for their Facebook logins and passwords before or during an interview. This is a slightly unsettling trend when observed from the job interviewee viewpoint.

It’s become a common practice of employers to look at the social profiles of potential employees to get to know the job seeker on a more personal level. Users have responded by ensuring that their profiles are private, much to the chagrin of would-be snoopers. So what have companies done? Some have started asking potential employees for access to their social media usernames and passwords. This new practice has the masses wondering, “Is this legal and am I protected?”

Currently there are no laws (in the US) that state that it’s illegal for employers to ask employees, potential or otherwise, for their social network usernames and passwords. There are however lawmakers in California, Maryland and Illinois who have introduced legislation that will bar companies from asking for account information. But this is by no means law yet.

Facebook has weighed in on this as well, “This practice [asking for passwords] undermines the privacy expectations and the security of both the user and the user’s friends. It also potentially exposes the employer who seeks this access to unanticipated legal liability.”

What Facebook means by this is that if a company does check into a potential employee, sees they are part of a protected group e.g., LGBT, and does not hire a person on those grounds the company could face claims of discrimination. Beyond that, Facebook also pointed out that giving out or soliciting passwords to your or another user’s account is a breach of Facebook’s Statement of Rights and Responsibilities.

According to most articles, this is a fiasco. But if you look at it from an HR point of view, you want to know that the person sitting across from you really is who they say they are. You are protecting your interests as much as the interviewee is protecting their privacy. Short of asking people for their passwords there are five legal actions you can take to find out more about an interviewee.

• Basic Internet search: Your results may return hits for other people with the same name. To get around this, narrow the search by adding an email address, phone number or address.
• Facebook: It’s perfectly fine to use Facebook to search for a job seeker’s profile and do a little social snooping. Don’t forget, there are other social media sites out there, LinkedIn is a particularly good source for discovering a person’s work history. A big boon of Linkedin is that users tend to be free with their work related information on this site.
• Conduct background checks: It’s a good idea to conduct checks, especially if you work with money or other high value items. If you don’t have time to conduct checks, there are companies that will conduct checks for you. It’s important to be aware of the law regarding background checks in your region.
• Ask for, and check references: Companies just don’t do this anymore. It only takes a few minutes to call or email each reference provided. If you call the referrers and ask the right questions, you could learn a lot more about the applicant this way.
• Prepare ahead of time: We are all busy, but it’s important that you look over a resume before the interview. Pay close attention to employment history and take note of gaps in employment or short stints (less than one year) at companies.

You will be able to find just as much information about a person by using legal means to research as compared with asking for their social media accounts. If you would like to learn more about Facebook or other social media sites let us know.

One of last year’s most popular devices is the tablet. Many smartphone and computer manufacturers have released tablets running the Android OS. The Android OS has many useful features including an openness not found on other devices. If you have an Android tablet, you have no doubt heard the term “root” and have probably been wondering if this affects your tablet.

Before you root your tablet it’s beneficial to know the pros and cons associated with it.

What is Rooting?
When you buy an Android tablet, it will have limitations placed on the OS by the maker of the tablet to prevent inexperienced users from inadvertently ruining their device. What rooting does is give users access to the basic or “root” level of the tablet, in other words it removes all restrictions placed on the OS. If you’ve heard the term “jailbreaking” for Apple’s products, rooting is akin to that.

Benefits to Rooting
There are a number of upsides to rooting your Android tablet. Some of the most positive features are:

• Access to More Applications. If you root your tablet, you’ll have access to a wide variety of apps not available to unrooted tablets. If you go to the Google Play store, and type in Root you’ll see a list of apps that are only available to rooted tablets. Some of the most useful include ones that allow you to do a full backup of your system or change your layout.
• Improved Performance. When you root your tablet, you’ll be able to control its performance. This includes being able to make it open and close apps faster or decrease processor speed which will increase battery life.
• Latest Version of OS. Companies that create tablets and devices that use the Android OS are notorious for taking a long time to update the OS. Case in point: Google released Android 4.0 in December 2011 and some devices still haven’t been upgraded. If you root your tablet, you’ll be able to update your device to the newest version of the Android OS by using a ROM – the most basic level of software that allows your Android device to operate. ROMs are akin to drivers used by computers.

Drawbacks to Rooting
There are some drawbacks to rooting that you should be aware of. The first issue is that if you do root your tablet, the warranty will be voided. If the manufacturer finds that you’ve rooted your device, they could refuse to fix it, forcing you to go to less than reputable dealers.

The second problem is that if rooting is carried out incorrectly you run the risk of “bricking” or “bootlooping” your device. Bricking is when your tablet’s software glitches causing the tablet to stop working, making it about as useful as a brick. Bootlooping is similar to bricking, however your phone will boot up, turn off, boot up and turn off in an endless cycle.

The final downside to rooting is security. There has been an increasing number of malware apps designed specifically for Android devices. If you have a rooted tablet and download apps not from Google Play, there’s a higher chance that the app you download will be infected.

Should I Root?
With both powerful benefits and potentially nasty problems, the question is, “Should you root your tablet?” The answer is a bit ambiguous in that it really depends on what type of user you are. Advanced users who want to micromanage their device will be able to do just that if they root, while users who are happy with their tablet will not see much of a difference.

If you do choose to root your tablet, search the Internet for guides on how to root your device and carefully follow the instructions. Should you like to learn more about rooting, or Android tablets please drop us a line, we’re more than happy to hear from you.

One of the most advantageous technological tools available to companies is server virtualization. Who doesn’t want to get rid of physical servers while at the same time make their organization more efficient? Virtualization has become mainstream for large and medium companies, and now it’s time for small businesses to virtualize.

There are five distinct reasons why you should virtualize your small business systems.

Increased Server Efficiency
The main reason to virtualize servers is to centralize computing resources while making them more efficient. With virtualization you can take multiple applications and put them onto one physical server that’s set up to run multiple virtual servers. This means fewer machines commanding less physical space, operating with a higher level of efficiency and a reduction in your capital expenses.

Improved Disaster Recovery
Disaster Recovery – returning business functions to a normal state after a disaster – is an important issue for all companies. If a fire destroys your building and servers with it, you face months of rebuilding and an unpredictable amount of lost profit. With virtualization, you can store your servers and data away from the building and be operational in another location in a short time.

Test Security and Patches
Server virtualization provides the IT department with a virtual environment to test security updates and patches before they are applied to the machines in the organization. If done correctly, your IT department can apply the updates in the virtual environment, observe and fix the problems, then apply to the physical equipment. This results in less downtime when security or update related problems occur.

Reduced Power and Maintenance Costs
When you run fewer servers there are multiple cost savings. Any company who has servers can attest to the cost of powering, cooling and maintaining multiple servers. The costs add up over time, but with virtualization you’ll be running fewer servers which means lower power consumption, cooling and maintenance costs. The decrease in machines also allows the IT department to focus on core business functions rather than spending time on maintenance.

Opportunity for Growth
With proper implementation, virtualization can give you the infrastructure you need to support continued growth, without the need to invest in new technology. A business set up to capitalize on this will definitely see a distinct competitive advantage emerge.

If you have any questions regarding server virtualization or other types of virtualization we’re only a phone call or email away.

Stage 2 is coming, and the focus of the electronic medical record (EMR) community is shifting from the capture, to the exchange of health information. According to one industry insider, when it comes to true interoperability, here are 10 things your EMR may need:

1. Single sign-on (SSO). Applications tend to proliferate, and if you don’t allow people to switch between these applications using a common login and password, users will get frustrated and give up.
2. Context transitions. As applications grow, and you need to integrate them into an EMR, SSO won’t be enough, because you’ll still lose the “active patient or task” being performed. You’ll also need to provide for the transition of context between applications.
3. Widget publishing. EHRs often have hundreds of functions, and if some are exportable or publishable as widgets, they become much easier to integrate into new user interfaces in the future.
4. Widget consumption. EMRs will become more like containers of cross-application functionality than innate functionality, so consuming widgets will be a basic requirement.
5. Mash-ups. EMRs should allow access to their content through the content management interoperability services (CMIS) standard, thereby allowing users to unlock content they have in various health records.
6. Customizable dashboards. EMRs should provide dashboards that can be tailored by organization, user role, or even user.
7. Interactive Voice Response (IVR). IVR, which allows an EMR to interact with users through phones and other voice systems, such as Skype, will improve collaboration with patients and other physicians who aren’t at a computer.
8. Voice recognition. This will help users conduct EMR tasks more efficiently.
9. Natural language understanding. Because most EMR data is entered by humans, an EMR must integrate with systems that can convert the spoken word or typed text to structured data.
10. Customizable data import and export. A good EMR must allow customizable importing and exporting of simple lists in common formats, such as Excel, CSV and XML.

Details about these tips, and an additional two not discussed above, can be found here.

The success of your IT depends on a strategic plan that defines your practice’s needs and looks to optimize your workflow. Ideally this plan will focus on both the patient and staff experience. Here are five considerations that can help get you started.

1. Improve the patient experience. Many healthcare practitioners consider the patient experience a major challenge, yet don’t give much thought to how IT can improve it. Consider what you can do electronically to support patients, whether they’re in your facility or not. Electronic forms? Email and text message reminders and confirmations? Kiosks?
2. Consider best practices. Technology can help you get to know your patients better. The Web, for example, can be used as a first point of engagement. Ask a few questions of visitors, then tailor your responses to their needs. A patient interested in a first consultation would receive different information than one preparing for his or her first round of cancer treatment.
3. Don’t forget the staff! Your staff needs successful workflows to interact effectively with patients. Common errors are multiple devices and different logins. Keep in mind how clinicians work to develop efficiencies. Your staff needs to be able to provide clinical care without being tied to a PC.
4. Use social media. Social media often isn’t included in IT planning, as it’s usually more of a marketing consideration. Without thinking about how it will be used, it will become difficult for patients and staff to have a singular experience. Your IT department needs to work with other departments to develop a social media plan that will yield a consistent presentation to the end user.
5. Use integrative planning. Typically, IT does its strategic planning in isolation. Ideally though, IT would plan with other departments. This “integrative planning” allows for a consistent plan supported by all parts of the practice.

Technology has advanced at a rapid pace over the past 30 years, with many devices moving from physical systems to digital versions, including one of the most useful: the telephone. While the use of landlines is still prevalent among some businesses, many have started to turn to the digital version, Voice over Internet Protocol, or VoIP.

VoIP has become the main backbone of voice communication for a growing majority of companies, offering numerous benefits including potentially large cost savings, and decreased maintenance costs. When it was first introduced, the technology needed to run a VoIP system was expensive, limiting it to MNCs and other large organizations. However, over the past few years, the technology has come down in price and is now available for next to nothing, allowing SMEs to make the switch to VoIP. If your company is thinking of ringing the changes, there are some necessary requirements you should meet before you migrate.

Foundation A solid foundation for VoIP is key, as without a good foundation you’ll find that network speed and call quality are poor during heavy use. Most SMEs aim for a VoIP system that can handle around 10 employees on the phone at any given time. Before you start the integration, you should track your current call volume by keeping a note of the number of calls in and out, while paying close attention to call volume during peak hours and days.

You should also investigate the speed and stability of your current Internet connection. While a fast DSL or cable connection is good for browsing, it may not be robust enough to handle VoIP communications, which need a connection that is both quick and stable. Look at your downstream (traffic into your network) and upstream (traffic out of your network) connection speed during a time when the network is experiencing heavy data use. Anything over 1.5 Mbps in both directions should be enough to handle the majority of VoIP systems. Most Internet service providers offer a connection speed well above that, but it’s important to check it out first.

Framing When you have a solid foundation that will support your needs, the next step is building the frame for VoIP. You should determine exactly what’s required from your new system. Some good questions to ask include: Am I going to need to make international calls? How many VoIP connections am I going to need? Am I going to want to make video calls? What’s my budget?

Once you’ve determined your needs you can move on to picking equipment. If you’re a business that typically sticks to local, and some long distance calls, you shouldn’t require much in the way of equipment. The vast majority of companies use a device called a media gateway that allows normal phones to interface with an Internet connection - essentially turning a regular phone into a VoIP phone. If you’re a business that would like to take advantage of the more advanced features of VoIP, like portability, you’ll need more state-of-the-art equipment.

The final issue you need to address is security. On its own, VoIP is not the most secure of connections, as it’s open to all the same types of security breaches that computers and networks can fall prey to. To combat this, many good VoIP service providers will have security measures in place to protect VoIP calls on their network. On your end, it also helps to keep your Internet security up-to-date and conduct regular system scans.

Once you’ve addressed the internal requirements it’s time to start looking for a VoIP service provider. Take your time, shop around, ask competitors and other businesses what service they use. One question to ask a prospective provider is if they will be able to migrate your current number onto their system? While most can switch over your existing numbers, it can take a while, depending on your location and local legislation. So be sure to check if the provider can migrate your numbers and how long it will take.

From there, you should be ready to switch over to VoIP. If you’re still unsure of the process, there are consultants available who can help with the preparation, selection and integration. Good luck, and if you need more information about VoIP, we are here to help you.

Business continuity planning – an important consideration companies have been looking into, and adopting in increasing numbers. It’s vital that businesses can operate in any condition and that they won’t be affected by disasters. One of the steps in implementing a successful protection strategy involves working out whether to use software or templates.

The decision between templates and software can be a tough one to make, as whichever one you choose, you’ll be using and relying on for a long time. To help you we’ve covered some pros and cons on both choices:

Using Software
If you choose to go with a software program, you will be walked through the whole process allowing you to develop a useable plan. Another benefit of using software is that you’ll be able to develop reports if needs be.

The drawbacks of using software include cost, inflexibility and learning time. For the most part, business continuity planning software is not cheap, and at times can be inflexible due to limits within the program. If you have a niche need, the software may not cover it. In addition, as with mastering any program, the learning curve can be quite steep.

In general, using software would be advantageous for companies that have a bigger budget for the development of a continuity plan. Software is also a good bet if you don’t have staff who are experts in continuity planning, or if you operate in an industry where a continuity plan is necessary, e.g., companies working with healthcare insurance, or manufacturing companies that have introduced ISO 9000.

Using Templates
If you feel that your company is not ready for software you can use templates to help you develop your plan. These solutions are mostly written plans that you adapt to meet your business needs. They’re useful if you’re just starting to do continuity planning, as they provide a normally solid foundation, and are generally a lot cheaper than software.

A limitation to using templates is that they can be a little too basic at times, and may not meet your needs. Granted, most plans will follow a basic structure and your developer will need to adapt some steps for your relevant region and industry.

As each industry is different, it’s hard to make a recommendation on what type of planning style companies should take. We recommend you take your time, do your due diligence and weigh out what’s best for your business. No matter which method you choose to go ahead with, ensure that it’s easy to implement, and that you’ll be able to teach your staff how to run the plan.

If you feel really lost or are not sure what to do, talking to professional consultants could go a long way in helping you develop a plan. If you’d like to learn more about business continuity planning please contact us – we are happy to help.

Peer-to-peer networking (P2P) and cloud storage services have both been hot topics in the news lately. Whether it’s about the seizure of servers or security threats, both have been causing businesses problems with regards to recoverability and security of data. Does your company use P2P or cloud storage? If so, there are a number of things you should be aware of.

With the seizure of a number of cloud storage and sharing websites, including Megaupload, and the seemingly omnipresent malware in P2P files and the shaky security in relation to P2P networks, businesses have had their hands full staying secure. Do you know what your options are when it comes to data security?

Cloud Services Knowhow
The recent seizure of Megaupload’s files and servers by the US Government caught many people and businesses unprepared. While Megaupload’s main purpose was file sharing, it was found that a large number of organizations were using their services to store files. If you had files stored on Megaupload, the chances of getting the files back are non-existent.

It needs to be pointed out that many cloud services don’t guarantee that files stored on the service will be recoverable in the event of a crash, or disruption in service, e.g., a government seizing servers. If you read the user agreements of a number of major cloud services, they all have clauses stating that if data stored on their service is lost for any reason, it’s gone forever, and the hosts can’t be held liable for losses.

Risks of P2P
With high speed Internet widely available at low prices, P2P file sharing has become incredibly popular, it’s almost uncommon to find someone who has never used a P2P service. If you or your employees use P2P at your office, there are a number of potential security threats you should be aware of:

• The unknown share: If you put a file in a folder that is shared on a P2P network, it’ll be shared with all other people connected to that folder and almost anyone can access it. This is normally done by mistake, i.e., not looking where the file will be saved when you save it. There’s also malware out there that will move files into a shared folder which the developer of the malware can find and upload with ease and without the user knowing it is happening.
• Open network: Typically P2P works on open networks: users give and share. What this means is that when using P2P on a poorly configured network, the whole network could be unsecure, allowing for access to other computers connected to the network.
• Untracked data: If you share a document with another person, and they then share it with others, there is potentially, an unlimited amount of people that can get the data. If you want to take it back, it can be impossible to do so, even if the original document is deleted.
• Storage hijacking: There’s news of malware that has been developed with the purpose of downloading illegal material onto your hard drive. This could pose a problem if the data is found, as you will be liable.

What Should I do?
With regards to cloud services, as with anything that comes with a contract, the first thing you should do is gain an understanding of it by utilizing reading material such as blogs, news articles and Wikis. It’s a pain in the neck, but it’ll help you understand the boundaries of the program and your responsibilities. Remember that if you go to court to get files back from a company, and it becomes known that you didn’t read the agreement, you’ll probably end up losing that case.

Second, it’s not recommended to keep single copies of data on one cloud service. Chances are high that in your business, you store your data and backups in a place separate from the computer. This makes sense with the cloud as well – keep your data with a number of different cloud services. If it’s important enough, have physical backups of what you put in the cloud.

For P2P networks there are also a number of steps you can take to protect the data on your network:

• The most obvious one is to ban employees from using any file sharing services outside of your network.
• If you do allow file sharing, it’s a good idea to establish and strictly enforce a protocol for this. You should also set which users are allowed to share files, and what files are appropriate to share. Be sure that all staff are aware of your policy and the measures that will be taken in the event of any deviations.
• Develop a system to classify documents by whether or not they can be shared, and who they can be shared with.
• If you work in an office where you need to share files, but don’t want to use a P2P network or the cloud, and are unsure of other solutions out there, don’t worry. There are companies that specialize in document sharing solutions that should be able to provide you with assistance.

The most important thing is that whatever the situation is, you take action to try to solve the problem while frequently revisiting the actions to ensure that they are working. If you’d like to learn more about document sharing over the cloud, or via P2P networks, give us a buzz. We’re more than happy to help.

Mac vs. PC – it’s the debate of a generation. In recent years, Mac has been gaining support, with an increasing number of companies opting to integrate Macs into their operating environment. This can be scary to some users as it means learning a brand new system. But we’re here to help with some useful tips on keyboard shortcuts that will make life easier.

When you first switch to OS X it can take a while to figure out the shortcuts, or to even find out if there is a shortcut for what you need, not to mention the confusing symbols used to indicate key strokes. Here’s a list of the most common shortcuts.

Symbols
If you’ve looked online for shortcuts, you have undoubtedly seen a number of potentially confusing symbols before the letter or number – these are actually keys to press. The most commonly used symbols are:

• ⌘ Command. It’s found beside the spacebar on most Mac keyboards. If you’re using a keyboard that isn’t supplied by Apple, the Windows button should also work.
• ∧ Control.
• ⌥ Option. On Windows based keyboards, Alt will do the same thing.
• ⇧ Shift.
• FN Function. It’s found under F13 on most desktop keyboards, or in the bottom left of most laptop keyboards.

Finder Shortcuts
The Finder is Mac OS X’s file system. It includes your desktop and all the folders on it. If you’re unsure whether you’re on the Finder or not, look at the top left of your screen beside the Apple icon. It will say Finder if you’re on it.

• ⌘+A Selects all files. To deselect simply left-click on empty space that’s not highlighted. To deselect one item simply hold ⌘ and click on the folder/file you don’t want to be selected.
• ⌘+I Retrieves information on a folder or file including name, size, creation date, etc.
• ⇧+⌘+N Creates a new folder in the window currently open. If you’re on the desktop, a new file will be created there.
• ⇧+⌘+Q Logs out. If you want to log out without waiting press ⌥+⇧+⌘+Q.
• ⌘+Delete If you press this after you’ve selected something, your selection will be moved to the trash. To empty the trash hit ⇧+⌘+Delete.
• ⇧+⌘+A Opens the Applications folder

Shortcuts for Applications and General
These shortcuts will work in most applications, and will generally work on all other non-applications, including the Finder.

• ⌘+C Copies your selection.
• ⌘+Z Cuts your selection.
• ⌘+V Pastes what you’ve just copied or cut.
• ⌘+Z Undoes your last action.
• ⌘+H Hides the program you currently have open. The program won’t close, it’ll just be hidden, and can be opened again by clicking on its icon in the dock.
• ⌘+M Minimizes the window currently open.
• ⌘+TAB You will cycle to the other applications you have open. If you hold down ⌘, while pressing TAB, you’ll see the icons for open programs.
• ⇧+⌘+4 Selects a screenshot. When you press these keys, you’ll be able to drag and select a screenshot. You’ll hear a camera lens click when you let go indicating the picture has been taken, and the file will be on your desktop.
• ⇧+⌘+3 Takes a screenshot of the whole screen.
• ⌘+S Saves the document you have open.
• ⌘+F Searches within the window currently open.
• ⌥+⌘+ESCAPE Force quit. This is the same thing as Control + Alt + Delete on Windows.

These are the most useful keyboard shortcuts, but there are many more out there. If you would like to know more shortcuts, or more about the Mac OS X, please let us know – we’re happy to help.