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.

In many businesses, including yours, a good presentation can be the difference between success and failure. The majority of your employees have a degree of competence and comfort while creating presentations. The key questions are: do they reach the target audience, and are they effective? Unfortunately, the majority of the time the answer is no.

It’s important that you, that as a manager, you ensure that your employees are creating PowerPoint presentations that are effective. Here are a few tips you can give to your employees to help them 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.

When we hear the word “Windows” many of us don’t think of the pieces of glass separating us from the outside world, we think of the Operating System. Windows has become the main OS for people and business alike, with many adopting or upgrading to Windows 7. As with all programs, there are times when it decides to take a short holiday and stops working, what do you do then?

It can be extremely frustrating when you are working on an important document, Windows 7 stops working and you’re forced to reboot. Before you restart your computer, here are three useful things to try.

Using the Resource Manager If your computer starts to act sluggish or slow, and is taking a long time to open a program or respond, it may be because it’s taking up a large amount of processing power, forcing other programs you have open or running to use less - this is commonly known as a “bottleneck”. To figure out where the bottlenecks are when your computer is slow is relatively easy:

• Click Start and type: RESMON and select RESMON.exe. A window with all running programs and processes, graphs and tabs will pop up. This is called the Resource Manager.
• Under the Overview tab, you will see a list of programs. Click Status and the programs will be ordered by their status, an easy way to quickly figure out what is working and what isn’t.
• Once you have identified the bottlenecks, you can look for solutions using the Internet or contact the people responsible for your IT. It will make their job easier if you can tell them exactly what’s wrong.

If you want to find more information on why a program isn’t working, click the CPU tab, beside Overview. You will be presented with a dialog box similar to the task manager from XP. Select a program which isn’t responding, right-click on it and select Analyze Process. Windows will run an analysis and try to tell you why that program isn’t working. This goes a long way in figuring out what is happening, and also gives you more information if you have to call your IT team.

If you have a program that has completely stopped working:

• Open the Resource Monitor; click start and type RESMON.
• Click the CPU tab, and the program should be highlighted in red.
• Right-click and press Analyze Wait Chain.
• If there are more than two processes, the lowest one on the bottom is the process that isn’t working.
• Click the box beside it and select End process. The program should re-open.

A word of warning on the Resource Monitor: don’t go stopping programs or processes just because they take up what looks like a lot of processing power. They could be essential to the operation of Windows, and if stopped you could make the problem worse. If in doubt, make a note of the program, search the Internet for more information, or ask your IT department for help.

Open Program in New Process If you are working on an important project and would prefer not to have it crash when another program does, you could start the program in a new process. This essentially creates another window in the same environment. If one crashes, it won’t affect the other. To open in another process, hold down Shift and right click on the program, and select Open in a new window. The downside to this is that it will consume more system resources, so your computer will run slower.

Record Your Steps One neat and underutilized feature is the Problem Steps Recorder. When activated it will record mouse movements and clicks, key presses, folders opened and even take screenshots. When the problem is solved, it will put them all the recordings into a file and email them to you. This is extremely useful if a problem keeps happening, and you have your IT team come in to help. To turn on the recorder:

• Press Start and type in PSR, select PSR.exe
• Press record.

If all else fails, and you can’t fix the problem, then you can try restarting the computer or calling IT. As ever, don’t forget to save your work often, and ensure your data is backed up regularly. If you would like to learn more about Windows 7, or other Microsoft products, please contact us.

Most businesses have started to take social media seriously. They are spending time and effort developing their profiles and reaching out to customers. It makes sense for a business to have an online presence beyond their website. Are you taking advantage of all the available options the Internet has to offer? If not, it may be time to start.

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.

One of the biggest complaints of many Java developers is that when they are asked to develop an application, they have to often develop frameworks before they can write the program. This is a time consuming process. To help make the developer’s job easier, VMWare introduced Spring, a framework for Java developers. Spring was recently updated, read on to learn 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.

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

It is more or less the end of the first quarter of 2012, many companies have released their annual figures and people are looking to move jobs. Heading into Q2, the quarter in which companies are most likely to hire, chances are you will be doing some hiring in the not so distant future. These days, many companies use VoIP software like Skype or Microsoft Lync to conduct interviews. Do you?

Let’s face it, there are very few people out there who love conducting interviews. The ones that do, are journalists, the rest of us see it as a means to the end. But that doesn’t mean that you should put interviews on the back burner. Remember, the purpose of the interview is to find an employee that meets your needs and is a good fit for your business. Many of us have watched or conducted interviews over VoIP, and have walked away unimpressed, or unsure of the results. Here are some tips to ensure you get the most out of VoIP while interviewing.

Remember the Rules Many of us have another identity or personality when we are online, it’s common to see people who are usually quiet and reserved in real life become very vocal when placed in front of a computer. This also happens when people conduct interviews online, another personality often comes out during the interview. Remember: even though you are conducting an interview over VoIP, it is still an interview, and as such, you need to follow the same rules and guidelines you would when conducting a face-to-face interview. One of the biggest things interviewers forget when they conduct interviews via VoIP is that you are a representative of your company and its brand, the interviewee will form their own opinion based on what you say and how you act. Adopt your face-to-face interview persona, not the online persona.

Lights, Camera, Office? When conducting the interview it is best to pick a well-lit spot, with minimal to no distractions. Your office may be the one with Nirvana posters on the wall - which is cool - but they’re probably not the best thing to have as your background during the interview. The best spot to conduct face-to-face interviews is in a conference room, so why not conduct the online interview there? If you don’t have a conference room, pick a quiet spot in the office. Wherever you settle, be sure you are comfortable there, as chances are you will be conducting more than one interview.

When you have found a good spot, be sure to turn off your cellphone, or at least put it on silent. Also be sure to turn the various sound alerts on your computer off. Nothing is more annoying to interviewees than being interrupted mid-sentence by a telephone call, or the ubiquitous IM alert.

Test the Tech Before you conduct the interview, ensure you are familiar with the program you are using. You don’t want to accidentally mute the interviewee, or even worse, hang up on them. It is a good idea to set up in the place you are going to be conducting the interview, and check that the internet connection is stable, or if you are using WiFi, that the signal is strong. Conduct a test call with a colleague or another person to ensure that your webcam is working correctly, and you can hear the other person. It is best to do this a few days in advance, so you can iron out any glitches or problems with lots of time to spare.

If a technological mishap occurs during the interview, or you lose your connection, don’t give up and walk away, simply call the interviewee back, apologize and carry on. Better still, establish at the outset that if there is a problem, you will definitely call back. This will ensure that the interviewee isn’t calling you when you are calling them.

The Interview Remember that you are using technology for the interview, and this technology has many useful features, the most pertinent being the ability to record. Being able to play the interview back later if you feel you have missed something, or want to know other employees’ opinions, is an excellent perk to using VoIP. Be sure to let the interviewee know that their interview will be recorded, as it could be illegal to record the person without their consent.

One common oversight by both the interviewer and interviewee is time. It may happen that you need to conduct an interview with someone in another timezone. It’s important to be aware of the time difference and ensure that both parties are on the same page. Also, if you’re in an area that has Daylight Savings Time, be aware that some places don’t observe it, and adjust accordingly. If you know the interviewee is in another timezone, clearly state when you are setting up the interview time, if you mean your time or the interviewee’s time.

Finally, when conducting the interview: be aware of where you are looking. Most programs will have the other person in a large image with you in a smaller image. Look at the image of the person when they are speaking, and at the camera when you are speaking. This is the best way to replicate eye-contact in a face-to-face interview.

When you remain professional and can execute a good interview using VoIP software, you can be sure that the interviewee will be impressed and will want to join your company. Good luck! If you would like to know more about using VoIP for interviews, or other business operations give us a call - we are more than happy to hear from you.

One issue that has caused business owners and managers many headaches, and possible sleepless nights, is cybercrime. Businesses are always under threat of having data or money stolen, and need to be taking actions to stop this. Do you know what you need to protect your business?

A quick Google search for “cybercrime trends” yields over 78 million results, the majority of which are likely to affect large enterprises or governments. 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 some current cybercrime trends that SMEs should be aware of.

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.

In this modern age, many businesses have become reliant on technological networks, with businesses big and small using some form of network in their day-to-day operations. But what happens when one of those networks goes down? Larger businesses will normally lose some profit, but will be able to recover. However, a network outage could be the death of a smaller business. 24/7 networking can help prevent this.

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.

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