Microsoft word, excel, and powerpoint have all become a regular part of our day to day lives. But there is one more program in Microsofts suite of office applications that is often ignored and is by far one of the easiest to use and most useful of the bunch and in this weeks ITech Insights I’ll tell you all about it.

A common trend among new software is in giving users the ability to personalize certain areas. This could be something as simple as adding your picture or changing the layout. Many programs that have traditionally been utility in nature, such as office suites, are starting to offer ways for users to customize. Microsoft Office 365 is one of those such programs offering these features.

Microsoft Office 365 is first and foremost a suite of familiar office software for businesses to use in their day-to-day operations. But just because this software is instantly recognizable as a Microsoft product, it doesn’t mean that you can’t make some small changes to personalize your computing workspace. Here are a few ways you can do just that:

Set Your Profile Picture
You can set a profile picture which will show up on any window or application that has the ability to show your image – e.g., Microsoft Lync. To set your picture:

1. Log into Office 365 and go to the Home page.
2. Click the My Profile header. It’s located in the top right hand side of the screen, underneath your name.
3. Click Change Photo.
4. Choose your photo by selecting Browse. It’s recommended that your picture be under 100kb in size, you’ll get an error message telling you if it is any larger. When you have selected your picture, press Save.

Add a Signature to Your Emails
Many business emails include a signature at the bottom, a way to make each email seem a little more personal, or provide more information including contact details and a potential message about an upcoming promotion. To set your signature:

1. Navigate to the Outlook page, click on Options. It’s located in the top right hand side of the screen, underneath your name.
2. Click See all options from the drop-down menu that opens.
3. Select My Account, followed by Settings which is located in the left hand menu.
4. Under the Mail Tab, you will have an option to edit your signature. If you want Outlook to automatically place your signature on every outgoing email, click the radio button below the signature that says Automatically include my signature on messages I send.

If you don’t choose to have Outlook automatically add your signature, you can add the signature in your email by selecting the Messages Tab in each new email, and clicking the little arrow below Signature. A list of created signatures will be shown, select the one you wish to use.

Add Your Picture or Logo to Your SharePoint Site
If your company uses SharePoint, you can add a logo or picture to enhance what is a relatively plain environment.

1. First, you need to create an image. You can use almost any picture, just ensure you can legally use it. Get creative, this is your space!
2. When you have the image you want to use, open SharePoint, click Site Actions and select More Options.
3. Select Picture Library, and in the window that opens, select a name for a new library, and press Create.
4. Your new Library should be on the left side of the screen. Click to open it and select Upload.
5. When your picture shows up in the library, select it twice, so it’s in its own window. Copy the web address from the top of the page.
6. Under Site Actions select Site Settings followed by Look and Feel.
7. Beside Logo URL and description paste the URL you just copied. Click Ok and your image will show up on your SharePoint site.

With a few steps you can make Office 365 a little more personal. Just be sure that you can legally use the images you select. If you would like to learn more about Microsoft Office 365 or any other Microsoft products, give us a call.

Social media has really become a major way for businesses to get their name out and gain exposure to the many different people on the Internet, build their brand and find new customers. With the large numbers of people currently using the Internet, it makes sense for businesses to have some form of online presence as they will be able to connect with more customers.

Social media, once called a fad, has become the norm and is going to be with us for some time. A large number of companies already have an online presence, and are taking advantage of the benefits that social media can bring. Here are a number of things you can do to get your social media adventures underway.

Be Clear on Social Media
It’s important that before you start looking into the different forms of social media that are out there, you are clear on what social media is, and what it isn’t. Social media is a way to meet people, and share content and ideas with them. For companies it’s a form of non-traditional marketing – think of it as soft marketing – it’s not meant to be the place where you flog your products, rather a place to develop interest in your company, so people will want to do business with you. By using social media you can show people who your company is, and connect with them on a more personal level. If you are clear on what social media is from the beginning, there’s a higher chance that you’ll be successful when you develop your online presence.

Before You Launch Into Social Media
There are a number of things that your company needs to have either already done, or considered, before you jump in:

• Have a website: It’s a good idea to have a solid website with information about your company, contact information, products and services. Most potential customers will look at your website after looking searching for you online, and before they choose to do business with you, so your website needs to provide the relevant information they are looking for. If you don’t have a website, or feel yours is lacking, it’s easier than ever to get a professional looking site. With a quick search you will be able to find some competent designers.
• Get educated: It will be beneficial to educate yourself on current trends regarding social media. This can be done by simply going to social media websites, taking the free introduction tours and reading blogs related to the sites. Beyond that you should also research your competitors’ websites and Internet presence. Observe what content they have online, and more importantly: what they don’t have. It will also help to connect with and observe industry experts, see what they post online, and note the style and tone they use. This will help provide you with a sound knowledge base from which you can then create a more effective online presence.
• Set goals: As with any step in business, you should have a plan with realistic goals. Aim for results that are achievable for your company. If you’re a small, local IT company that focuses on providing support for banks, don’t expect to have the same massive hype that Microsoft and Apple do. Clearly set objectives and review periodically.
• Develop a focus: In real life, you can’t be all things to all people. The same goes for social media. You need to develop a focus on what type of online content you would like to share. You should aim to create content that your customers will want to share with people.
• Stake a claim: You should to go to the main social media websites – Google+, Facebook, LinkedIn and YouTube – and reserve your personal and business usernames. This is important because it will make you look more professional by having the same username across all sites, and users will be able to find you easier.
• Ask for help if you need it: While some companies make social media sound easy, it can be deceptively hard to master. If you feel lost, or are having a tough time with it, there are knowledgeable consultants out there who are happy to help.

Time to Get Social
When you feel you know what direction you will take, it’s time to start developing your online profiles. It can be tough to decide which social media tools to utilize. Unfortunately there is no right answer. Most small businesses follow the crowd, and this means having pages on Facebook and Linkedin. This does not mean that you should join these networks simply because they have the most users. It is recommended that you follow what similar businesses or direct competitors are doing. If they are on one service but not another, do the same to begin with, but be on the lookout for new social media sites, or features being added to existing sites.

One Thing to Not Forget
There is one really important thing we can share with businesses thinking of pursuing social media: it isn’t a turnkey operation. You can’t just, “set it and forget it.” To be successful, you need to be active by posting updates, news, and above all interacting with the people who reach out to you. After all, they are your customers. If you do establish your social presence but forget to keep it up to date, you will be the company that’s forgotten.

If you would like help with your social media strategy, please get in touch with us. We’d love to hear from you.

There are a number of things application developers have had to deal with in the past, especially when working with Java. When their company asked for a new application they would first have to build a framework, and then build the application. This was a time consuming process, until VMWare released the Spring Framework, making the developer’s job much easier. The Spring Framework was recently updated – read on to find out more.

VMWare recently announced that extensions to its Spring Framework are now compatible with Spring 3.1. This update ensures extensions like Spring Android, Integration, Security, Data and Mobile, etc. play nicely with the latest version of Spring, allowing for developers to more quickly develop business solutions and applications.

Who is VMWare?
VMWare was founded in 1998 on the platform of providing virtualization solutions and software to companies of all sizes. The company creates virtualization software to work on Microsoft Windows, Linux and Mac OS X with a focus on shifting businesses onto the cloud, without disturbing existing operations or compromising security.

What is Spring Framework?
Spring Framework is a process that allows developers to develop applications that can be integrated with Web services, security, messaging and databases that use Java. The Spring Framework builds a framework for developers to use, so they don’t have to develop one themselves. Therefore, it allows them to focus on creating and deploying Java applications in a number of different environments.

What do the Updates Bring?
With Spring 3.1, there are a number of updates to the existing framework. The biggest accomplishment with this update is that all of Spring’s Frameworks are compatible with each other. This allows developers to not worry about developing workarounds, if one part of the framework is out of date. In short, it makes developers more efficient, while giving them the ability to develop Java based applications much faster.

Work safety and injury prevention – a common topic in all blue collar jobs. Did you know that many of us who work in white collar jobs also need work safety? Safety from what? From the computer. There are a number of injuries you can get from sitting at a desk working on a computer all day, do you know what they are and how to prevent 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 (bottom) 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. If you would like to learn more ways to prevent injuries, or increase productivity please contact us.

Many businesses have come to rely on both internal and external technology networks for day-to-day operations. If there is a problem with a network, a small business can lose more than just profit—with a large enough outage the business could go under. 24/7 networking can help prevent this from happening.

How can 24/7 network monitoring help your business, you ask? Through preventative operations. The main idea of network monitoring is to act as an “Early Warning System” to let managers and owners know of potential problems before they strike.

What Does Network Monitoring Monitor?
There are a number of things you can monitor with Network Monitoring. The most popular areas include application and system performance, bandwidth usage, and server status. You can also set up monitoring of additional areas, for instance: server load, ink levels in printers, time left on software license agreements, which devices are connected to the network, their data usage, and more. This is all done 24/7.

The one thing Network Monitoring does not normally monitor is unauthorized access to networks. It can be set up to look for unauthorized access, but this is normally taken care of by another system.  

How Does Network Monitoring Help Me?
Network Monitoring is a preventative system, intended to warn you about potential network problems so you can proactively seek solutions before a vital network goes down. This makes it, in a round-about way, a justifiable addition to business value since, when implemented right, there will be less network crashes—which means less or no profit loss.

What Should I Monitor?
In an ideal world, you would monitor each and every network. Over time, you can get there, but if you’re like most Small Business owners or managers, you have neither the time nor the budget to implement a full system. As with most projects, it’s suggested that you implement a system like this in stages. The most common areas to start with are:

• Local Area Network (LAN) Data
• Internet data usage
• server status
• alerts to existing networks

If you’re unsure of where to start, try contacting a local Network Monitoring service, or hire a consultant to establish a system. If you would like to know more about 24/7 Network Monitoring, or other ways to improve business value, please contact us.

When we hear someone mention “Microsoft Excel” many of us will instantly think of an open spreadsheet we are working on, or have recently seen. Known by all business owners and managers, and mastered by few, Excel has become one of, if not the, most widely used business applications. While it is a widely used program, there are a number of errors that are confusing. Read on to learn about the most common ones.

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 formal 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.

Technology and software: two things many business owners and managers use on a daily basis. The majority of people in business have some knowledge and comfort working with computers, but when the software they are using stops working there’s a “What do I do now?” moment. Does it have to be so frustrating?

The answer is: No, it does not have to be. Microsoft Office 365 is a good example of a suite of programs with a strong background of troubleshooting and support resource data bases. If you have a question or problem while using Microsoft Office 365, there are a number of ways you can get the problem solved.

• Troubleshooting Tool:  This tool should be the first place you look when you have questions or need support. When you go to the page you will asked four questions and presented with links to solutions based on the answers given.
• Office 365 Community: The community, run by Microsoft, provides information on all aspects of Office 365 with the majority of the information being provided by users of the various products. This community also has information on updates and commonly asked questions. It’s a good idea to check with the community to see if there are any other users who have had the same questions or issues as you.
• Office 365 Technical Blog: If you can’t find answers on the Community page, try looking at the Technical Blog. The blog is run by Microsoft engineers and is a direct link to the developers of the product you are using. Any answers to questions on this blog will often be straight from the source with the answers usually being more on the technical side with lots of explanations or update information.
• Tools and Diagnostic Wiki: This is a wiki article that covers products in the Office 365 suite. Think of this as the umbrella section that covers troubleshooting of all issues, while providing you with links and updates related to troubleshooting. You can search issues based on product plan, specific products, services, and more. If you are having a problem not covered by the other resources, chances are you will find the answer here.

With comprehensive coverage and a number of different places to go to when you have questions or a problem, you should be able to get back on track in no time. Please contact us if you would like to know more about Office 365 or any other Microsoft products.

More and more people are now telecommuting from home, in fact entire companies are now built around the concept of a virtual workforce. Even if your company isn’t leaning in the direction of stay at home employees, the chances are that you still face some of the interesting challenges that a mobile workforce creates. In this week’s ITech Insights, We’re sharing a few services which will help you to take advantage of this new way of doing business and the new tools that are a part of it.

Just when you think things have peaked – in this case the social media boom – somebody comes up and thinks of a way to make things more interesting. Case in point: Pinterest. While it can hardly stand shoulder to shoulder with giants like Facebook or Twitter, it certainly brings something new to the fold that could prove useful to businesses.

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.