“Microsoft Excel” is a common buzzword known by all business owners and managers. This program 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. Read on to learn more about them.

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.

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.

In many industries there is a fine line between profit and disaster. This is especially true for small businesses, where even a tiny mistake can can have big negative implications. Owners and managers need to ensure that their projects are living up to expectations in order to be successful and stay in business.

How many times have you started a project only to have it spiral out of control? Mistakes, delays, and other problems can be costly - both to you and your company. Here are some common reasons projects fail, and ideas to be aware of before you start your next big project.

No plan Possibly the biggest mistake any company can make is to not have a plan. A project without a plan is like a football team without a quarterback - it just won’t work. The most common plan used by businesses is a “project plan”: a plan that outlines your final goal, your plan to get there, and what resources are needed along the way. It is a good idea to involve all project team contributors in the planning phase. This will help encourage your team to stay on track.

Unrealistic budget An equally important mistake to avoid is having an unrealistic budget. All managers know they have to set and stick with a budget. However, few managers really know how to set a proper budget, and many projects end up being over budget. The easiest things you can do are:

• Determine the knowable costs. These can include software, parts, wages, fixed costs, etc. Be sure to include costs like shipping and tools needed for the project.
• Consider different parts of the project separately. Try to think which are more likely to have problems. Budget an extra percentage of the total costs based on how risky that aspect is.
• Look at budgets from similar past projects. These will help you judge whether you are on the right track.

Poorly defined expectations Many projects suffer from members not really understanding the expected outcome of efforts made. This could cause a decrease in morale among your employees. It’s best to review and update goals regularly, and tweak the scope or timelines as progress is made. It’s also equally important to involve employees in this process.

Scope creep While some change in the focus of the project can be good, beware of scope creep - uncontrolled or big changes to the original plan of the project. This can happen when the extent of the project is not properly defined or controlled. It is important that you clearly define the scope of the project with both yourself and your employees, and try to make as few changes as possible.

Poor communication This cannot be stressed enough: communication is very important. Many projects fail due to lack of good communication and interaction between the parties involved. We recommend that you stay in constant contact with all parties to ensure understanding of the project. Encourage an open communication environment where any employee can talk about anything and suggest ideas.

With good communication, a clear focus on the project and a solid plan your next IT project is on its way to be a successful one. For more information on project planning, please contact us.

Here are some tips to extend the life of your laptop for the long term and keep it in tip-top shape!

Despite the growing popularity of smartphones and tablets, nothing beats the personal computer for general, all-purpose computing. But even so, many people today still prefer a portable computing device to one tied to a desk—thus explaining the popularity of laptops over desktop computers.

Laptop computers, however, can suffer more abuse than desktop-bound devices since they are carried around and used everywhere. Here are some tips to help you extend the life of your laptop, keeping it in tip-top shape for as long as possible.

Power

• Don't overcharge your battery. Overcharging or leaving your laptop plugged in all the time with the battery on will actually reduce battery life over time. Batteries were designed to be fully used and then recharged from time to time. If you are not going to be mobile, remove the plug from time to time or, if your laptop is constantly on your desk, remove the battery.
• Manage the power settings in your laptop to extend battery life. Laptops nowadays have different power settings to extend battery life, such as reducing brightness, CPU speed, and other settings.

Storage

• Defragment your harddrive. Over time, a computer's disk can become fragmented – meaning data written by the computer is scattered all over your harddisk. This makes your drive work harder, reducing its lifespan as well as slowing it down. Defragment your disks to have data written in contiguous spaces to reduce this effect.
• Offload unused data to another place. A better way of reducing the work your disk needs to do and increasing its life is by using an external storage device, such a USB memory key or external drive. Offload things like old documents, movies, and photos. If others need access to this data, store it in a place where content can easily be shared so that you don't have to copy files back and forth. You can share files using a network attached disk (NAS) or a cloud storage service such as Dropbox or Google Docs.
• Use SSD. If you can afford it, or if you are buying a new laptop anyway, go for SSDs (Solid State Disks) which, unlike traditional Magneto-optical disks, have no moving parts and have longer lives – and are faster as well.

Other Components

• Avoid overheating. Laptops were designed to run cool, usually with heat vents or internal fans. Avoid obstructing these vents or fans by covering them up, such as putting your laptop on the bed or couch which tends to block them.
• Maintain cleanliness. Components such as the keyboard, mouse, and screen tend to get dirty over time with dust or sweat and oil from your fingers. Other things such as food and can spill over these components and ruin them as well. Make sure you clean your laptop from time to time, as debris tends to build up and damage electronic parts.
• Protection. Whenever possible, use protective gear such as covers and cases to protect your laptop from wear and tear when being transported. Avoid leaving your laptop in places where they can be sit on or stepped over as well.

These are just some tips to help you extend the life of your laptop. Know of some more? Contact us and share your tips!

In late February 2012, Twitter hit 500 million users. This milestone has cemented Twitter as a major Social Media player. With this large user base, companies should be seriously considering integrating twitter with their marketing strategies. Benefits of integration include increased followers, brand awareness, and potentially a better bottom line. Here are some tips for increasing your followers.

Search for companies and people you know While it’s easy to use the search function in Twitter, it can be time consuming to search for people one by one. Instead:

1. Log into your Twitter account
2. Press the # Discover button at the top of the page
3. Press Find Friends
4. Log into the various accounts available
5. Add people as followers

This is a great way to rapidly increase your followers, and reconnect with customers and contacts you may have lost contact with.

Combine your Twitter and Facebook feeds You can combine your Twitter and Facebook feeds easily:

1. Log into your Twitter account
2. Select Profile Settings
3. Select Profile
4. Select Post your tweets to Facebook
5. Follow the instructions provided

Within minutes, your Tweets will show up in your Facebook status, enabling you to reach two platforms simultaneously. Be warned, this could spam your followers, causing them to stop following you - so it’s best to keep your Tweets or status updates to the most important information.

Join Twitter Ads for Small Business This recently announced service will be up and running soon, allowing small business owners to advertise on Twitter through Promoted Tweets. This service will be released in the near future, enabling businesses of all sizes to advertise.

If you are not on Twitter, would like to join, or know more please contact us.

Are you having trouble keeping up with the ever-changing demands of technology? Maybe it's time to consider enlisting the services of a Managed Service Provider (MSP). MSPs help businesses of all sizes manage IT so that it not only supports current operations, but propels business into the future with greater efficiency and faster growth.

The nature of business has changed. Companies, no matter how small, can market products and services worldwide over the Internet. At the same time, customers can find products and services from your competitors in just a few clicks of the mouse. A Managed Service Provider (MSP) can help you maintain the technology that will give you the edge to compete and win.

Global business requirements

To compete effectively in a global market, your business needs:

• Integrated internal and external business support systems.
• Up-to-the-minute access to sales, order processing, and production information for fast decision making.
• Flexible processes that can adapt dynamically to changes in the business climate.
• A fast, reliable, and secure IP network.

Maintaining the networking infrastructure is often the biggest challenge for a small company. It's expensive to keep up with new technologies and devote IT resources to ongoing network management.

The value of a Managed Service Provider

A qualified Managed Service Provider (MSP) can bridge the gap to give you access to leading network technologies. MSPs provide management expertise without requiring high initial capital investment or ongoing costs associated with technology upkeep. A partnership with an MSP will:

• Reduce costs, including traditional service fees, as well as hardware and IT operations costs.
• Increase support levels and network availability without additional staff.
• Keep IT costs stable and predictable.
• Provide access to the latest technology and skill sets with limited risk.

Let's talk about how you can compete better globally and take your business to the next level without big capital investment.

For many businesses, it's hard to draw the line between what they can and cannot do when it comes to social media. And while social media use can help boost a business's growth, it can also impair growth when it's used the wrong way. Here are some important practices to remember when using social media for business.

Social media is booming. Since its introduction a few years ago, social media platforms have not only changed the way people connect on the internet, it's also changed the way business is done. When applied correctly, it's a cost-effective tool that helps businesses connect with a much larger audience and client base, as well as potential clients. That is, however, IF it's used properly.

One common mistake businesses make is the failure to draw the line between personal and professional. While showing a human aspect of your business isn't bad at all, doing it too much makes you less consistent as a business entity and makes followers or audiences lose touch of what you're really about.

Another common error is the failure to handle bad feedback correctly. More often than not, one negative comment can balloon into a full blown argument that will only give people an even more negative impression about you and your business. While you should acknowledge even bad feedback, more detailed discussion should be done privately and only between the parties concerned.

Social media is not a "set it and forget it" kind of thing. You need to constantly update and monitor your social media platforms so they don't become stagnant. People will be more encouraged to follow you on Twitter or visit your Facebook page if they have something new to look forward to every once in a while. Make sure, though, that you don't post too frequently – or worse, fall into the trap of making it too promotionally-driven, which comes across as self-serving and impersonal.

If you're interested in knowing more and drawing up a comprehensive and effective social media plan for your business, please don't hesitate to contact us so we can discuss things and better respond to any issues or questions you might have.

Getting dazed and confused with all of the options for chatting, texting, tweeting, posting, liking and poking people at work nowadays? Fear not, Unified Communications can help you and your business manage and make sense of all of these different communication forms. Read on to find out more.

Because of continued improvements in technology and changes in the way people work, we now have a multitude of options to communicate with one another. This can be both a boon and a curse, as not only do we have to learn and master a variety of devices from which to communicate—but also contend with an equal or higher number of forms with which to communicate. For example, not only do we make a phone call to talk nowadays, but we also chat, text, tweet, post, like, poke, huddle, share screens, do white board sessions, and more. We can do all of these whether on the desktop computer, laptop, netbook, tablet, desk phone, mobile phone, TV – and soon maybe even from the kitchen refrigerator! Not surprisingly, people have started looking for ways to tame and simplify all of this complexity—and thus was born the concept of "Unified Communications."

Unified Communications, simply stated, encompasses the organization of different communication tools and models so that it can be used and managed in an integrated way, with the goal of improving flexibility, efficiency, and effectiveness. To illustrate the benefits of Unified Communications, here are some examples of how it can be used in several business scenarios:

1. Have a "single number to call" or a simpler way of reaching people. Instead of remembering and sharing a phone number, IM handle, email address, twitter account, and more, you can have just one number or address by which people can reach you—and systems will bridge that with whatever device or application your Unified Communications happen to be on or you prefer. So you can easily have calls placed to your desk phone routed to your mobile phone when you are out, and have voice mail emailed to you as a recording in case you can't answer.
2. Reaching people when you need them. If you are working remotely, or managing remote workers, Unified Communications systems can indicate your or your colleagues' location or "presence"—i.e., whether you or they are available at the normal location, working remotely, or out in the field.
3. Synchronous or asynchronous way of working. If you work with people in different time zones you can opt to conference when your schedules overlap, or swap messages that can be answered at their convenience if they don't —and be able to track and tie all of these together.
4. Richer collaboration. If you work on projects, Unified Communications can allow you or your team to get in touch and collaborate in a richer and more interactive way. While working on a project you can chat, switch to voice calls for better clarity, or conference via video to provide more context, as well as share screens for easier collaboration—all from a single screen or session.
5. Application integration. Imagine if you had the ability to call people from your email application's address book, or initiate a web conference from your instant messaging tool. With Unified Communications that is all possible.

Unified Communications may sound expensive and complex, but in reality it can actually lessen costs and make things simpler for you and your business. Learn more about Unified Communications and what else it can do to improve your business by contacting us today.

Usually due to budget and manpower constraints, small and midsized businesses (SMBs) often need to outsource a few aspects of their operations – and partnering with a Managed Service Provider (MSP) is one example. Just as in any other partnership, and especially since IT management is a relatively long-term deal, it's important that you establish the right business relationship between yourself and your MSP.

Business relationships are cultivated. Grown. That's what you do – at least if you want your business to flourish. The healthier your business relationships, the more productive and efficient your operations become.

Naturally, this applies to your relationship with your Managed Service Provider (MSP). Your IT is an important part of your day-to-day operations, and contributes greatly to how productive your business can become – so establishing good working rapport with your MSP is especially essential. Here are a few pointers for building and maintaining a great relationship with your current or prospective MSP partner.

Assess what your MSP can provide for you Sit down with your MSP to learn their ideas for your business, then carefully assess whether the services they offer support and augment your operations – current and planned. Look closely at contracts and make sure you understand the fine print, and carefully evaluate whether the service agreement meets your needs. Do some research about prospective MSPs (which is easy to do through the Internet) to verify their claims. Making sure you have the right fit is an important first step in getting the most out of an MSP.

Define roles and manage expectations Make sure that roles and responsibilities are clearly defined and understood early in the process, especially if your MSP is integrated with or augmenting an existing IT operation. This will help minimize overlapping job roles (which is ultimately unproductive for the both of you), as well as territorial disputes and misunderstandings.

Communicate constantly While your MSP will essentially manage your IT, it's still YOUR IT department. Make sure that you open healthy channels of feedback and communication. It's also recommended that you keep your MSP informed of any new directions or strategies that you feel will affect the IT operations that your MSP partner handles. It's a good idea to schedule regular planning sessions and meetings with them so that they will be able to anticipate what you need – and provide it – in line with your own goals and timetables.

Establish trust and respect your MSP's decisions Treat your MSP like you would your IT manager. Give them general direction, and then let them do what they do best: manage IT. Entrusting your IT to an outside contractor can be a difficult decision, but as long as your MSP is reliable and secure, it may very well be one of the best business decisions you've ever made.

Thinking of adopting a "bring your own device", or BYOD, policy at work? Learn more about what it is, why it's becoming popular – and what you need to consider before rolling it out.

You may have noticed more and more of your employees or colleagues bringing their own computing devices to work—be it their mobile phone, tablet, or laptop. Or perhaps in your company or in other companies you may have seen, they have let people decide which device they prefer because they are used to it at home. You may not realize it, but this is all part of a large trend called the "consumerization" of IT, in which the influence of consumer technology is being increasingly felt in the workplace. With the wide availability of cheap but powerful mobile devices and online services, a growing number of people are being exposed to the latest technology at home first—adopting them at a rate faster than most businesses are able to manage. This flips on its head the old paradigm in which traditionally new technologies would be rolled out to businesses first, before they would find their way to consumers.

This trend, plus the increasing sophistication of young workers today and their frustration with the tools available to them at the office, is pushing some companies to adopt a "bring your own device" or BYOD policy at work. They are not alone. According to research by technology analyst group Gartner, end users, not the IT department, will soon be responsible for 50 percent of business IT procurement decisions—ultimately bringing and running their own systems on company networks. Meanwhile, according to management consultants Accenture, around one-third of today's younger generation of workers (a group called "millenials") not only wants to use the computer of their choice at work, but also wants control of the applications they use too.

The benefits companies cite to adopting a BYOD policy are many, among them:

• Savings on capital expenses and training costs in using company equipment—compensating employees instead via other means such as flexible work hours, subsidized purchases, insurance, and other benefits.
• Less management headache—effectively letting employees decide what to use releases the company from some overhead and management responsibilities.
• Improved employee satisfaction—by giving employees the freedom to use devices and applications that they prefer.

However, before you consider letting employees bring their own personal technology to the work place, be aware that there are also disadvantages, and sometimes very real dangers in doing so. These include:

• Non-standardization of hardware, operating systems, and applications. If your business operations require that some equipment is integrated with others, then BYOD can in the long run actually increase IT management costs and decrease efficiency.
• Exposing your network to malware or security vulnerabilities and breaches. When your employees bring their own devices to work, you lose important control over their security. Consumer devices often don't employ comparable bullet-proof security technologies mandated by businesses.
• Leakage of confidential or proprietary information. Employees will naturally do what they want with the data on their devices, even if it doesn't belong to them, or it's against company policies. Employees can also lose precious company data when they misplace or damage their personal devices.
• Lower economies of scale in procurement. Essentially because everyone is buying devices on their own, you miss out on the chance to consolidate purchases and lower purchase costs for everybody.

Have you adopted a BYOD policy at work? Thinking about it? Worried about this trend? If you need to understand BYOD better so you can define a policy for your staff, contact us and see how we can help.