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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Disaster can strike at any time, and it can be as simple as a server or system crash, or as severe as the recent worldwide natural disasters. No matter what it is, the disaster will affect your company’s operations and potentially its bottom line, or worse — force you out of business. Are you prepared?

Most companies have at least basic protection from emergencies and disasters in place. The most common forms of protection are insurance, server and computer backup, and basic preparations as required by law. While these protective measures are considered adequate for most companies, there is still a chance a disaster will strike, leaving your company in the lurch.

In the recent months and years an increasing number of occurrences, such as the earthquake in Japan and flooding in Thailand, have caused widespread disruption to businesses. To counter this, two business initiatives have risen to the forefront: Disaster Recovery (DR) and Business Continuity Planning (BCP). In fact, these two terms have become common buzzwords, a quick internet search returns over 53 million hits on business continuity alone. The problem is that many professionals are unclear on what each really is. It’s important to be clear on each topic and the basic steps to take to be prepared for any disaster.

What is a Business Continuity Plan (BCP)?
BCP, first seen during the Y2K scare of the late 90s, is a plan that covers the way an organization prepares for and maintains all critical business functions. BC planning is comprised of activities that ensure maintenance, stability, and recoverability of service before, during, and after a disaster. The plan is typically set up on a day-to-day basis, and covers the whole organization.

It’s important to have a BCP for your organization because if something happens and you can’t deliver to your customers, they will go to another company.

What is Disaster Recovery?
Disaster Recovery is considered a part of the overall continuity plan that focuses on the technical side of the business, including components such as data backup and recovery. Think of BCP as an umbrella and DR is under the umbrella — if you don’t have a disaster recovery plan, the overall umbrella is more or less useless.

What Should be in Your DR and BCP Plans?
These plans both share a number of similarities, generally following the same steps involving the same elements. Both plans should include:

1. An operational plan for a number of disasters that could happen in your geographical area. The plans should cover occurrences as small as computer hardware errors and as large as massive natural disasters.
2. A succession plan for you or your top management.
3. Training for substitute employees on important tasks.
4. Cross training of your employees on the basics of different roles so they will be able to take over if need be.
5. A communication plan focused on different crises, including ways of communicating if networks are down.
6. Off-site meeting places for staff and managers.
7. A focus on safety. Foster partnerships and communication with local and emergency response services: Fire, Police, National Guard, Search and Rescue. Ideally, all employees should at least know basic first aid. If you have employees who are volunteer members of local Emergency Response Services, ask them to be responsible for teams.
8. Daily plans to backup your Enterprise systems, along with training and testing of recovery of systems.
9. Training and testing of all employees to practice recovery activities in situations as realistic as possible.

It’s important that you conduct regular tests of your systems and processes, and make changes as needed. Be aware that your business is always changing and so should your Business Continuity and Disaster Recover Plans.

With a carefully prepared and practiced plan, your business should be ready to face a variety of disasters with minimal downtime. If you would like to know more about Business Continuity and Disaster Recovery please contact us.

We’ve spent quite a bit of time on our blog crowing about the benefits of Microsoft Office 365, but we just had to share this news.

Effective as of March 2012, Microsoft is now offering Office 365 for FREE to students, school faculty, and staff members! Offered as the Microsoft “A2″ plan, the free service includes the standard Office features you know and love like Word, Outlook, and Excel. But Microsoft ups the ante by the including power-packed applications Exchange, SharePoint, and Lync.

Microsoft is cutting prices for Office 365 across the board to make it more easily affordable for organizations of all types, and will be releasing a full Office 365 for education service this summer. But you can get the jump on it and get your faculty, staff members, and students using this great service today, free of charge.

For more details check out the full announcement from Microsoft.

Have questions about MS 365 and cloud-based computing? Just give us a call. We would love to hear from you.

Jeff Dettloff is the President and Chief Problem Solver for Providence Consulting, Lansing’s leading provider of advanced computer services and innovative technology solutions.

Cybercriminals will stop at nothing to prey on the uninformed. Help your employees be ready for scammers who may call them on the phone posing as support personnel. With a little education, you could save your business a lot of trouble.

Unfortunately, there are people with bad intentions who want to cheat you of time and money. Phone scammers use fear to prey on unsuspecting people to steal information that they can use, by pretending that they can help you with imagined computer problems or offering some helpful-sounding enticement. Your employees are the targets of these scams, as well as your first line of defense.

Here are some tips for preparing your front line to deal with these types of phone support scams.

Never trust unsolicited calls

It may seem like common sense, but when an employee is busy or distracted, it can be easy for a phone scammer to sound convincing and trustworthy. Scammers can be very clever and sound legitimate by claiming that they represent a software company like Microsoft or Google, and they often use publicly available phone directories, so they might know names and other business information when they call. Make sure your employees know that an unsolicited tech support call should never be trusted… ever.

Don’t be fooled by claims to “help”

Scammers often offer to help solve a computer problem or sell a software license. Once they have an employee talking, they might try to:

• Trick your employee into installing malicious software that could capture sensitive data, such as online banking user names and passwords.
• Take control of your employee’s computer remotely and adjust settings to leave the computer vulnerable.
• Request credit card information so they can bill you for phony services.
• Direct your employee to fraudulent websites that ask for credit card or financial information.

Employees should be on guard to verify, take names, and hang up if there is any question.

Take precautions

If you use an MSP or other outsourced IT services company, make sure that your employees know who they are and the security procedures that they follow. Monitors that IT providers offer can help to improve your security system and avoid malware issues.

Security should be a key part of your IT plan. Let’s talk about how we can help you prevent the unthinkable.

Hackers and other Internet Bad Guys are continually coming up with new ways to compromise their target’s accounts and access personal information. One of the more nefarious approaches is what is known as a “Trojan Horse,” or simply a “Trojan.”

Much like the ancient story, today’s Trojan Horse sneaks through your defenses by pretending to be something it is not. An Internet Trojan tricks a computer user into running a program that steals information, compromises their security, or worse.

We saw this happen last Christmas, with a rash of computer users receiving email messages purporting to be from the US Post Office, claiming they had missed delivery on a parcel and that the recipient needed to “click here” to set up redelivery. As you might guess, clicking on the link caused a Trojan to be installed.

Recently we have been seeing a variation on this theme involving FedEx instead of the Post Office. The messages can claim there is a package waiting to be picked up, or that the recipient has tickets for a concert or plane trip waiting for them. Security programs catch a lot of these messages, but very craftily written Trojans can slip through your defenses. If you receive any email asking you to open an embedded message or file, be on the lookout. It may well be waiting to deliver a nasty payload.

When in doubt, the best action is usually to delete the message from your email system and contact the delivery company directly to confirm whether or not the delivery exists.

Jeff Dettloff is President and Chief Problem Solver at Providence, a Lansing IT Consulting firm.

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.

Cloud-based services such as Microsoft’s Office 365 are becoming popular with many small businesses due to its flexibility and cost effectiveness. And with its recent update, users are promised more compatibility with several platforms, as well as smoother communication and ease of use.

For many businesses nowadays, working while on the go is a necessity. This is why there is also a growing need for services and applications that allow people to work and continue to be productive even while they are mobile.

One of these services is Office 365, which is a package offering Microsoft Office, SharePoint Online, Exchange Online, and Lync Online. Office 365 is cloud-based, which enables people to access files and applications in a much more seamless and efficient manner. This kind of system is especially suitable for small businesses, not only because of its cost efficiency, but also its flexibility of use – which in turn helps members of smaller firms handle multiple tasks more effectively with no loss to productivity, even when they are out of the office.

Office 365 has also recently launched its first major service update, which makes it a more versatile tool for better communication and collaboration. The more than 30 new updates include support for Windows Phone 7, which allows people to access and edit their SharePoint documents from their Windows Phone 7 mobile device; new SharePoint Business Connectivity Services, which enable people within an organization to use SharePoint interface to connect to customer relationship management (CRM) or SAP software, which are common critical line-of-business applications; as well as new support for Lync for Mac, giving users the ability to use instant messaging, presence, and videoconferencing.

If applied and implemented properly, Office 365 can prove to be a very efficient tool for small businesses who want to be more cost efficient without compromising the quality of their output or their productivity. If you want to know more about how Office 365 will impact your business, please don’t hesitate to get in touch with us.

Academic institutions can qualify for special volume licensing discounts for Microsoft products, including the Windows operating system, Office products, and more. Some retailers and college bookstores can sell individual copies, but organizations can only attain volume licensing through an approved Microsoft Authorized Education Reseller, or AER. Scott Zingery is our point-man on volume licensing, and he recently renewed his certification to continue Providence’s status as an AER.

What does this mean for you? If you work in a primary, secondary, or higher education institution, we have the tools and resources to recommend and implement the most appropriate and cost-effective Microsoft licensing solution for your organization. Many schools are not aware of this licensing opportunity or are not enrolled in the optimal program. For example, we recently worked with a client in the post-secondary education industry who realized a savings of more than $25,000!

Contact Scott Zingery at our office today to find out if your organization could be saving money on its software licensing. Scott can also tell you about programs to further simplify your school’s software management with single subscription services, easy compliance, customized solutions, and low administration time.

Jeff Dettloff is the President and Chief Problem Solver for Providence Consulting, Lansing’s leading provider of advanced computer services and innovative technology solutions.