One of the most useful business tools, no matter what industry you operate in, is the office suite. While there are a wide variety of choices available, the market is dominated by Microsoft Office. In the past year Microsoft has turned its eye from producing office software for the desktop to producing office solutions based around the cloud.

Microsoft’s cloud based office suite for businesses is called Microsoft Office 365. Office 365 includes Word, Excel, PowerPoint, Outlook and OneNote – and Microsoft Server products e.g., Lync 2010 and SharePoint Server. All programs are accessed via a Web browser, offering users the ability to access the programs from the office, home or anywhere in between.

On March 14, 2012 Microsoft held a press conference announcing that the price of Office 365 subscriptions will be reduced by up to 20%. This decrease will apply to all new and renewing direct customers.

The price cut is a great advantage to many potential customers as it makes Office 365 more competitive with other cloud based office solutions such as Google Apps. This is also beneficial as many businesses already use the desktop versions of Microsoft Office. If they switch to Office 365, employees will be comfortable with the cloud version, as the software is exactly the same as the desktop version.

It’s the perfect time to look into Office 365 and see what it can bring to your organization. If you’d like to learn more about Microsoft Office 365 or other products from Microsoft, we are your go-to experts and will be more than happy to help.

Macs running OS X are often touted as the most secure machines. While OS X is definitely more secure than other operating systems, it may not be as secure as owners think. A new trojan that takes advantage of a security flaw in OS X has been discovered, and it’s a doozy. This has the potential to be a security nightmare.

If you mention “OS X” and “virus” in the same sentence, you’ll get some weird looks from Mac users. Traditionally viruses and trojans on OS X were near non-existent, but there’s a Mac specific trojan, codenamed Flashback, that has affected more than 600,000 computers. This is big news as it shows that machines running OS X may not be as secure as first thought.

Many Mac owners are unsure of what exactly the Flashback trojan is, what it does and how to ensure they’re not infected. We’re here to help clarify the situation.

What is a Trojan and What Does Flashback Do?
In general terms, a trojan is a piece of malicious software that infects a computer and gives control of part, or the whole computer to hackers. The Flashback trojan takes advantage of an OS X Java vulnerability and infects computers by tricking them into downloading a fake Java update.

When the program is installed, Flashback will download and install the main trojan code without the need for permission from the administrator. From there it proceeds to hijack your browser, redirect search queries to websites developed by hackers, and then take advantage of pay-per-click advertising.

Why Should I be Worried?
While this version hijacks your browser, there are far more sinister things it could do. As this trojan acts as a downloader, there’s nothing stopping the developers from updating the malware to steal passwords, banking information and other confidential information.

How do I Ensure My Mac is Clean?
Apple has released an update for machines running OS X 10.6 and later. The first step you should take is to update your computer to patch the vulnerability. To update your Mac:

1. Press the Apple logo, located in the top right hand of your screen.
2. Select Software Update…
3. Press Install and Restart.

While the patch will prevent Flashback from working, it won’t delete the program if you’ve been infected. The Internet security company F-Secure has developed a script that scans your computer and removes Flashback if found. Once you have downloaded the script, open and run it. The script will search your computer and place the infected files in an encrypted ZIP folder labeled Flashback_quarantine.zip.

Flashback has infected a higher number of Macs than any other trojan to date and goes to show that Macs also have security flaws. This also serves as a reminder that you should have a virus scanner and security program running on your Mac. If you have any questions regarding the security of your Mac or other devices, please don’t hesitate to contact us. We are here to help keep your machines secure.

Android has become one of the most popular operating systems used by tablets. Its openness and customizability have attracted masses of businesses who have grown tired of using devices with restriction. While there are still limitations with Android tablets, they can be circumvented by rooting.

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.

Does your company use cloud storage services or peer-to-peer (P2P) networks for the storage and sharing of data? Many businesses are now using both these services in an effort to make work less complicated. But did you know that there are potential issues in relation to recoverability and security of data?

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.

A good presentation can be the difference between success and failure. The key questions while creating presentations are: do they reach the target audience, and are they effective? Unfortunately, the majority of the time the answer is no.

Here are a few tips that can help anyone improve their presentations.

Simplify and minimize
The best presentations are simple and minimal, often shifting focus from the presentation to the presenter. Minimal presentations follow the 6-6-6 rule. There should be no more than: 6 bullet points per slide, 6 words per bullet and 6 slides full of words in a row. Being visual creatures, you should encourage your employees to create slides with engaging and related visuals. A caveat: be sure that you have the rights to use the images.

A great rule taught in business schools across the country is: KISS (Keep It Simple, Stupid). Refrain from using confusing words, jargon, uncommon acronyms and irrelevant information. Keep it short, sweet, and to the point. Following these rules will help engage the audience and hold their attention for a longer period of time.

Be consistent
“Consistency is key” – a saying often used but rarely followed in the creation of PowerPoint presentations. You should ensure that grammar and spelling are all consistent, and errors are minimal, if existent at all. Have another employee or manager review it for errors and inconsistencies.

For the slides, use the same background and font throughout. The easiest way to ensure this is by using a template. A word of warning: don’t use templates that are heavily animated because they can cause significant distractions, and don’t choose backgrounds that are similar in color to your font. The best slides have a light color for a background with a darker font for your text.

Summarize
The goal of most presentations is to build interest and inform or update the audience. In fact, the majority of audiences just want a short summary so they can develop their own questions to ask after the presentation, or at a later meeting.

When creating the presentation, be sure to keep the audience in mind. If a presentation is being made to IT managers, chances are it does not need to have advanced financial spreadsheets. If you are presenting on a topic that has lots of graphs, extra information, or appendices, put the most important information in the presentation and the rest in a handout. This will keep the audience’s attention on the presenter, not the slides.

Practice, preview, review
Practice makes perfect. In an ideal world there would be hours and hours to practice and tweak a presentation. Normally, that’s not true. Schedule at least a comparable amount of time the day before a presentation for a dry run. Always review the presentation with your team and ask them for feedback. This will help encourage employees to keep improving and developing themselves.

For more tips and tricks on giving presentations using Microsoft PowerPoint and other Microsoft products, please contact us.

No matter what industry you are in, the size or location of your company, chances are high that you spend the majority of your day in front of the computer. The one major downside to this is that you could injure yourself, resulting in lost time and the need for physical therapy. Do you know what the most common computer work related injuries are and how to minimize them?

The majority of injuries sustained while working with computers are not instantaneous, they happen over time. The most common form of computer related injury is the Repetitive Strain Injury, also known as RSI. Soft tissue, muscles, tendons, nerves and ligaments are all susceptible to RSI. With proper maintenance and knowledge, almost all RSIs can be prevented. If left unchecked, an RSI could lead to lost time and possibly irreparable damage.

Eye Strain
Eye strain happens when you have overexerted your eyes. The most common symptoms include:

• pain around the eyes,
• dry eyes,
• fatigue,
• photophobia (sensitivity to light) and
• blurred vision.

Often, severe eye strain will also cause pain or tension in the neck and shoulders. The most common causes of eye strain are poor workspace layout and sub-par lighting conditions.

The good news is that in most cases, eye strain won’t lead to permanent vision complaints, but if left unchecked it could cause productivity problems. The easiest way to prevent eye strain is to work in a space with lighting that is neither too strong or weak, and have a light source that does not create glare. It is equally important to take short breaks from the monitor. Follow the 20-20-20 rule: every 20 minutes, look at something (not another monitor) 20 feet away for 20 seconds.

Posture Related
There are a number of related injuries to your posture, including: back pain, neck pain and headaches. These injuries typically come from bad posture, combined with sitting for an extended amount of time. It may not seem like you can injure yourself by sitting in a chair all day, but your muscles are not designed to stay in the same position for such a long period of time, and doing so can result in muscle pain. Poor posture at work can also lead to an increased chance of a herniated disc, commonly called a “slipped disc”.

There are a number of things you can do to minimize posture related injuries.

• Adopt a proper posture. Have a chair that pushes the small of your back out, as this will promote a more natural spinal position. Try not to cross your feet, as comfortable as it is, as doing so puts pressure on your lower back.
• Get up and move around every 20 minutes to half hour.
• Stretch. Move your joints through their normal range of motion.
• If you have kinks or muscle pain, gently massage the area with a kneading motion.
• Get up. There is a rising trend of using a standing workstation – this could be another option.

Arm Related
The most common type of injury to the arm is the well-known Carpal tunnel syndrome (CTS). This mainly happens in two places: the wrist and the elbow. CTS occurs when the median nerve (one of the main nerves) is compressed. CTS in the wrist is the most common RSI, and can be a costly injury. The median nerve also passes through the elbow. If compression occurs there, it can result in an injury commonly called “tennis elbow”. Symptoms include: numbness of the hand and arm, pain and weakness in grasping.

There are a number of things you can do to prevent CTS:

• Keep your mouse and keyboard close together.
• Type and hold the mouse gently.
• Remove your hands from the mouse and keyboard when not using them.
• Take frequent breaks to move your wrists and elbows through their natural range of motion. Be careful to not over extend.

With a combination of breaks, ergonomic workplaces, and other preventative measures you and your staff will see fewer injuries and higher productivity.

One issue that causes headaches for business owners and managers is cybercrime. While it is beneficial for all businesses to be aware of the major trends, there are a number of threats that will affect small businesses more than others.

Here are several current cybercrime trends of which SMBs should be aware.

Mobile Malware
Smartphones are becoming ever more popular, and with this popularity has come an exploding number of apps. Malware developers have been picking up on this during the past few years and there have been an expanding number of apps dedicated to attacking your phone or mobile platform. The most common type of malware on mobile devices is spyware, followed by SMS Trojans. SMS Trojans run in the background of some applications, and make international calls or text messages from the developers’ services causing huge phone bills. The final form of malware targets online payment apps on the phone.

One of the main reasons this form of malware has become so popular is due to the openness of some markets, such as the Android Market. The owners of the app markets are working to track down and get rid of the guilty apps on their marketplaces, but you still need to remain vigilant. while installing apps. Look at the developer of the app – how many times has it been downloaded? Maybe double check the app’s integrity online before installing and double check the app on the internet.

Open-Source Malware Kits
A common thing malware developers do is write code for malware and then sell it to interested buyers. But a rising trend is that developers are writing malware that is open-source—any person can download and change it. The worrying thing is, many developers of already powerful malware have been releasing open-source versions of their software. This means that there will be an increase in the number of malware attacks out there, as devious developers can easily come up with more elaborate hacks.

Banking Trojans
Along with the open-source malware kits, there has been an increase in the number of banking trojans—aimed at stealing account information and passwords. While these trojans have been a threat ever since banks first started offering online banking, they have become popular again as people and businesses are starting to move their online banking onto mobile devices, and the trojan software is easily accessible. This makes mobile banking apps an easy target.

With cybercrime on the increase, now is a good time to review your security, ensure its up to date and remind employees of your mobile device policy. If you don’t have a policy in place, or feel that your security is inadequate, give us a call, we are happy to help you. Remember: with good security and knowledge, there is no reason you should fall victim to cyber theft.

Microsoft Excel has become a critical tool for business. It’s safe to say that we all know the basics of Excel and are comfortable with what Excel can do. However, one thing that makes people uncomfortable with Excel is the confusing error messages.

While most of us are comfortable with Excel, there are many times when we have had an error pop up that is more or less confusing. Let’s face it, when we see “!#%&” characters many of us are at a loss. Here are some of the most common errors you come across in Excel, what they mean, and how to fix them.

#######
This is one of the most common errors, with the # sign filling the cell. This error means that you have entered data in the cell that is longer than the cell’s size. For example, 1234567890 will show up as ##### if that column is not wide enough to fit all those numbers. This error will also show up when you have formatted a negative number as a date.

To fix this error, simply re-size the column (A, B, C, etc.) by clicking the edge of the column and dragging to the right to make larger. Or check to see if you have a negative number that is formatted as a date, and if so format the cell as a negative number instead..

?Name#
This error means you have have an error in the formula or range. For example, =counif(!6:B99, “Y”) In this case, “counif” should be “countif”. Also, the “!6” should be a column letter and 6 (i.e., B6).

To fix this error, click on the cell with the error, and look at the formula in the formula bar, usually located above the spreadsheet, and correct the formula like this: =COUNTIF(A6:B99, “Y”)

#REF!
If you have a formula that refers to other cells in the spreadsheet, and then you change one of those cells to data that does not compute in your formula, you will get the #REF! error. For example, if your formula for C6 is: =SUM(A1:A5, B1:B5, C1:C5) and you delete B1, you will get #REF! in C6.

The easiest fix to this is to hit: CTRL+Z, or Undo under Edit. If you made the error a long time ago and Undo does not work, then make sure all cells referenced in the formula contain valid information.

Circular Reference
You get this error when you have entered a formula that includes the cell where you have entered the formula. For example, the formula =SUM(A2:A5) is entered into A5. Excel is essentially telling you that it is chasing its own tail, and can’t catch it.

The easiest way to fix this error is to simply click on the original cell, and remove the reference to the cell that the formula is entered in.

The Little Green Triangle in the Cell
If you see a little green triangle in the top left corner of a cell, Excel is telling you there is an error with the formula. This is useful if you aren’t sure about what the error means. If you click on the arrow, you will get an ! with Trace Error. Click this, and Excel will give you a drop-down menu with options.

What if I Can’t Find the Error?
If you are having trouble locating the error, or do not want to spend time searching for the error in a long formula, click the Formula tab and the arrow beside Error Checking. You can click either Trace Error or Circular Reference and Excel will point out the error, or provide the cell name with the error. From there, select the cell and look at the formula or data entered to determine the problem.

One of the most popular technical trends in the past few years is the increasing amount of tablet computers on the market. With the development and application of mobile OSs like Android for tablets, they have been able to fill the mobile phone – PC gap. The Android OS has its own app market, with a ton of great apps for all users including businesses. Some of the most useful apps are the notes programs.

There are many ways businesses can use the tablet, one of the best is as a platform to record notes. This goes even further in that many notes programs do much more than just record notes. A quick search of the Android Marketplace for “Notes” returns over 1000 apps, but which are the best? Here are a few popular programs:

Evernote
Evernote is one of the most comprehensive note programs out there. You can sync between your computers, phones, even your browser. This app allows and encourages you to go beyond just taking simple notes. You can tag locations, attach pictures and lists, and even post notes on Facebook. The simple layout and integration with other platforms makes this app one of the best choices for your Android Tablet.

Catch Notes
With similar features to Evernote, Catch Notes is another great note program. There are a number of features that are great for businesses that set this app apart:

• You can record voice memos.
• You can share notes for collaboration with other employees.
• Notes can be separated, so you can have both personal and business notes on the same program.

This is a good program for businesses that like to have a collaborative environment and the ability to add voice recordings to your notes.

Classic Notes Lite
This app is, at first glance, very simple. Your notes are listed in chronological order, with the last edited at the top. But delve a little deeper and you will come across a ton of features ranging from the ability to sketch, quickly look up conversions, and even send to Google Docs. This app is good for users who want both a simple notes app, and an app with many extra features.

OneNote
OneNote is Microsoft’s mobile note app. Developed as part of the Microsoft Office suite, and to sync with SkyDrive, this app is for those avid Microsoft users looking for integration across multiple platforms. The app was released at the end of February with the major features most other note apps have, as well as Microsoft flair.

InkPad
InkPad is the notes app for users who want just a notes app, with no extra features. With a clean, simple layout this app is perfect for users who want to keep things simple.

With the incredible number of notes apps on the Android Market, there is a program that will meet any of your needs. If you would like to know more about Android Apps or tablets, please contact us.

The thing about the social media boom is that so many people are thinking of ways to make it better and to put a unique twist on an otherwise used and reused concept. Pinterest is one of the few that have been successful at this – which means, like in any other social media platform, businesses stand to benefit provided they use it the right way.

What is Pinterest? In a nutshell, it’s something like a social media scrapbook, album, and bulletin board combined. Each interest / theme has its own ‘Pinboard’ where you put photos, videos, or other media that interest you.

What makes Pinterest unique is its concept, which has been consistently growing in popularity, especially with female audiences. And while Facebook and Twitter are more open to overt advertising, Pinterest takes a more conservative stance. While advertising isn’t exactly prohibited, the marketing should definitely be more subtle and more consistent with a personal Pinterest profile. Here are some basic tips that will help you utilize Pinterest to your advantage.

1. Understand your market.
The first question you should ask yourself is if Pinterest is something worth your time investment. Since the majority of Pinterest users are female, ask yourself if your products and services appeal to them directly.

2. Invest time.
As in many other social networking sites, you need to put a personal and human touch to your Pinterest profile and in the way you interact with your audience. Log in often, update regularly, and respond quickly to any kind of feedback. Let your audience know that you’re there.

3. Use other social media to augment Pinterest.
Since Pinterest is less known, use your other social media accounts to point people your way in Pinterest, such as Tweeting or updating your Facebook status with your most recent Pinterest profile update.

4. Talk about what you represent.
As mentioned earlier, since Pinterest isn’t big on overt advertising, you need to market yourself in a different way. Talk about what your brand is all about. What do you represent? What content can you provide that would inspire your audience to share on their own Pinboards? If you’re a furniture company, for example, you can try giving some tips on basic interior design and picking the right furniture pieces for spaces, with pictures or videos. What’s good about Pinterest is that it challenges you to be more creative, and thus, more appealing to potential clients.

If Pinterest interests you, give us a call so we can discuss how you can maximize this new social media platform for your business.