A rising trend these days is the integration of a company's Web based marketing - social media and online presence - with their physical operations. As such, many programs have been introduced with the goal of giving businesses a chance to get their name out there. There’s a new online map that’s doing just this: integrating Web and physical presence.

CityMaps is a novel new online map. At first look it appears similar to any other online map: streets, check; transport routes, check; geographic features, check. So, what sets it apart? Well, when you zoom in on a neighbourhood you don’t get a fancy street view, or outlines of buildings, you get a map populated with businesses.

What is CityMaps? Think of those city maps that we’ve all used while on vacation, the ones with restaurants, shops and tourist attractions, and that’s the basic idea of CityMaps. When you zoom in on an area, you will see icons and logos of businesses. Click on one and a popup window will open with the business name, contact information, pictures, related tweets, reviews, and more.

Essentially, it’s a tool to help you plan your next adventure in the city. If you’re out with your friends and looking for a place to go for dinner, you can search for nearby restaurants, look at reviews and deals, and finally: make a reservation, all from the app.

How will this help my business? With social integration, a business like yours can post a special offer on one of the many deal websites, and it will show up in CityMaps as an unobtrusive blinking green dollar sign. If someone tweets about your business, the tweet will show up on the map as well.

This program is a great example of good integration across social media and business. If a review is posted online, it’ll show up on the map. This can also be beneficial to your business as you will get near real-time feedback. CityMaps also encourages businesses to develop and maintain an Internet presence, while giving them a practically free way to literally put their name on the map.

Currently, the map is only available for New York, San Francisco and Austin. There’ll be more cities soon, but it’ll be a few years before every city in the US is on the map. So keep your eye on this program if you’re not in the three cities, as you’ll soon be able to take advantage of it.

If you would like to learn more about CityMaps, or other Web trends, please let us know, we are happy to help.

No matter what industry your business is in, managers and employees will at one time or another need to give a presentation. Presentations can at times scare many employees, causing undue stress and poorly created presentations that could cost a company a key contract.

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.

It’s hard to find someone who isn’t using social media in some way, or at the very least isn’t aware of its existence. Companies are becoming wise to this and are starting to utilize social media tools to build their brand, or bring in new customers. If your company does not use any form of social media, it may be time to look into getting your business out there.

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

Two Things to Not Forget
There are two really important things we can share with businesses thinking of pursuing social media. The first being: 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.

The second thing not to forget is that once you start creating content on the social media site or sites you should be sure to link to it as often as possible. Some great opportunities include in the signature of your email, in your customer newsletter, on your website, and on your business cards. No matter where you put your links, it is important to actually be social and let people know who you are and what you can do.

If you would like help with your social media strategy, or are unsure of where to start, please check out and connect with us on our Facebook and Twitter pages. We are also available to discuss social media strategies, check our website for our contact information.

 

The computer and all its related gadgets is probably the most important device in business. Many of us spend our whole work day on the computer, we then go home and spend more time on another computer. One of the consequences to this is that there has been an increase in the number of computer related injuries.

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.

March is almost over, many of the big companies and MNCs have released their bonus figures, tax season is in full swing, the economy is kind of rebounding and people are looking for work. Chances are, your company will be hiring a new staff member or two in the near future. One of the most popular ways is to conduct interviews via VoIP based programs such as Skype and Microsoft Lync. Do you conduct interviews using VoIP?

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.

Ever since the computer became a household item, malicious software has been developed, aimed at causing havoc, or worse, stealing information. Businesses and governments have spent untold amounts of money to ensure safety from all sorts of cybercrime, but it is still a rising trend.

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.

We invite you to join us for a free luncheon on Thursday, April 12th to discover how you can better safeguard your business from devastating cybercrime and take control of your network. Space is limited, so register today!

Firefox is one of the most popular Web browsers available. It has become especially popular with the business crowd due to powerful add-ons that make business related browsing easier. There are a large number of useful add-ons out there, and it can sometimes be tough to see what’s best. Don’t worry, we are here to help.

At first look, Firefox is a fairly simple browser. Where it really shines though, is in the wealth of add-ons available for all users. If you were to compare different users’ browsers, it is highly doubtful they would look the same. There are some useful add-ons for small business users that can help make your life easier. Here are our top five:

Make Add-ons Compatible With New Versions of Firefox Firefox is on an aggressive update schedule. It feels like only a few weeks pass in between each new rollout, and this can pose a problem if the developers of the add-ons don’t keep their add-ons up to date. To solve this, install the Add-On Compatibility Reporter. This useful add-on will disable version checking, allowing the add-ons to continue working. If you have an add-on that won’t work, you can send a report to the developer. It is recommended that this is one of the first add-ons you install.

Speed Dial Speed Dial is an add-on that allows you to quickly access your favorite, or most visited sites. You set your bookmarks up to show via Speed Dial, which will show current thumbnails of the website. From there you can click on the thumbnail to go to the website. This is particularly useful if you have pages you visit on a regular basis and wish to navigate to them quickly.

OutWit Docs This add-on is for those managers who have a ton of documents on their computer and want to quickly find one without closing or minimizing Firefox. Think of having a version of Google for your docs - you enter a query into the search bar, and up comes the results with thumbnails so you can easily pick and open the document you were looking for.

Google Global An interesting add-on that allows you to see where your website, or any website for that matter, will show up according to the local Google page rankings. This is great for quickly viewing your presence in other regions or countries. However, this add-on will only work when on a Google search results page.

Screengrab If you are preparing a presentation or need to take a screenshot it can be a bit of a chore, especially on a Mac. With Screengrab you can take a screenshot of just the visible part of the browser or the whole page. This will save time from having to take multiple screenshots and then stitching the images together to gain one image.

These five apps are just the tip of the iceberg, there are many more on the Firefox Add-ons page. If you would like to know more about Firefox or other Web browsers, please contact us.

The majority of businesses, no matter the size, are networked these days—and are often also connected to the Internet and other networks. Many of these businesses have come to rely on internal/external networks for their day-to-day business. However, when one of the networks goes down this can be a problem since an outage could cause a loss of profits. 24/7 networking can help reduce these losses.

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.

Cloud computing systems are continuing to grow and become more popular, especially with small businesses. And as cloud services continue to grow and evolve along with the needs of users and clients, we are sure to see some positive developments for the cloud this year.

Anyone who tells you that the cloud has reached a peak is definitely mistaken. While cloud computing is already a powerful IT service that has made a positive difference in the way businesses operate—especially small and medium sized ones—there are still many aspects of it that are continuously being improved and developed.

Better security One of the major trends in cloud services is improvements in the security aspect. Businesses trust cloud providers with important and sensitive data, and with cyber-attacks becoming more frequent and clever, vendors have to step up their security protocols and keep clients’ data safe.

Wider integration and compatibility As it stands, there are still several issues between clouds (especially public ones) and an enterprise's systems, which limits the connectivity and data exchange between users. The same can be said for the current standards being used, which have the tendency to be very vendor-centric. The trend now is to reverse this, and provide better connectivity and data sharing, as well as less vendor-centric standards for better compatibility and integration.

A more ‘solid’ cloud It’s unfortunate, but expected, that there are service providers who are hitching onto the increasing popularity of cloud computing by offering half-baked cloud services. As time progresses, expect to see a better definition—which will reflect in the service provided—of what cloud computing can and cannot do.

As expected of any emerging technology, cloud computing has a ways to go before it reaches its peak. Expect to hear better things about the cloud in the coming months and years as businesses continue to maximize the potential of cloud computing, and vendors and service providers constantly find ways to improve what is already a fantastic concept.

If you are interested in knowing more about cloud services and what it can do for your business, please don’t hesitate to contact us so we can address your specific inquiries and concerns.

Many business owners and managers use Microsoft’s spreadsheet program, Excel, on a daily basis. It has become the go-to program for basic book keeping, forecasting, scheduling, chart making, and much more. It’s safe to say we are comfortable with it, and some may even call themselves experts. For those who are less comfortable, there are a number of errors that can cause confusion. 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.