IT Support for New Brunswick Small and Mid-sized Businesses

NetAdmins provides enterprise-class IT services & tech support to New Brunswick, Nova Scotia and PEI small and mid-sized businesses. We manage every part of your IT, so you can focus on what you do best—running your business.

Partnering with NetAdmins is like having an entire IT support department at your disposal, whenever you need it. With a range of services including IP telephony (VoIP), email and web hosting, data back ups, paperless document management, security audits and 24-hour IT helpdesk, New Brunswick businesses can count on us as their only stop for business IT solutions.

On top of our à la carte offerings, we also provide comprehensive Managed IT Services in New Brunswick, Nova Scotia & PEI—including unlimited onsite and remote IT support, so you have a constant hedge against IT disasters. Our skilled computer technicians in New Brunswick maintain your business IT systems, keeping them in top shape, and minimizing downtime.

We make sure your managed IT services in New Brunswick are stronger and more secure so your users can be more productive and focused on your core business—always at a savings to your bottom line.

Contact us today to learn more about our Managed IT Service plans or our range of expert IT and communication services.

Understanding Errors With Microsoft Excel

Microsoft Excel is one of the most widely used spreadsheet programs for business as well as personal record keeping. As those who use it often will know, Excel gives truly unique error messages that neither novices nor the experienced can immediately understand.

The first error message might be the most often encountered. If you get a row of hashtags (####), it means that the field is too narrow for the data. Simply go to the top of the column, click on one edge and drag your cursor until the column is wide enough to accommodate the data. Note that this only happens with numeric data.

  • If you use formulas a lot, you may have seen this error message:  ?Name#. When you see that, it means that Excel doesn’t recognize something in your formula. If you, for instance, wanted to add a range of numbers and typed in =SU(A2:A15), because you forgot the M in SUM, you would get ?Name# in the field where you wanted the sum to appear. Once you add the M, you should get the expected result.
  • Another error message that formula users may recognize is #REF!. This error message appears when your formula has an invalid reference. For instance, if you wanted to add ranges and you typed in =SUM(C2:C15, D2:D15, E2:E15) and then deleted column C, you would get #REF! in the field where your sum should appear. Simply undo the column deletion, and the response you want should appear.
  • Another extremely common error message is #VALUE!. If you see this error message, it means you’re trying to add a range of cells that have no numeric value. When tested, a range of cells [=SUM(B2:B15)] with only text yielded a sum of zero; however, when the range of cells was entered without the word SUM or the parentheses [=B2:B15] it yielded #VALUE!. This happened with Excel 2010. Perhaps earlier versions of Excel will give #VALUE!  as a response when you try to add a column or row of text. If you try to divide a cell with text by a cell with numbers [=QUOTIENT(B3,B5)], the #VALUE! will also come up.
  • Have you ever tried to divide by zero? If you have, then you’ve seen this: #DIV/0!. Excel will have none of it. It violates the rules of mathematics, so give it up. If you get a little green triangle in the upper left corner of a cell, this, too, indicates a problem with your formula. If you click on the green triangle, you will get a list of ways to correct the error. Again, with Excel 2010, this is not always the case. Sometimes, Excel will simply flash an error warning or it will let you know that it caught the error, corrected it and gives you the option to accept or reject the correction.

These are only some of the more common errors you could encounter when using Microsoft Excel. Microsoft offers tutorials for those who are just starting out or want to improve their skills.

Looking for help with Microsoft Excel?  Give our team of Microsoft Professionals a call and we can assist you with all your Microsoft needs.