Blog

April 2nd, 2012

In the past, most office software was just that, office software. There was little to no ability to make the software yours, to set it up how you like. This has been changing in the past few years, with many programs allowing for customization - settings and appearances can be altered to suit users’ needs and preferences. Microsoft Office 365 is one such program.

Microsoft Office 365 is first and foremost a suite of familiar office software for businesses to use in their day-to-day operations. But just because this software is instantly recognizable as a Microsoft product, it doesn’t mean that you can’t make some small changes to personalize your computing workspace. Here are a few ways you can do just that:

Set Your Profile Picture You can set a profile picture which will show up on any window or application that has the ability to show your image - e.g., Microsoft Lync. To set your picture:

  1. Log into Office 365 and go to the Home page.
  2. Click the My Profile header. It’s located in the top right hand side of the screen, underneath your name.
  3. Click Change Photo.
  4. Choose your photo by selecting Browse. It’s recommended that your picture be under 100kb in size, you’ll get an error message telling you if it is any larger. When you have selected your picture, press Save.
Add a Signature to Your Emails Many business emails include a signature at the bottom, a way to make each email seem a little more personal, or provide more information including contact details and a potential message about an upcoming promotion. To set your signature:
  1. Navigate to the Outlook page, click on Options. It’s located in the top right hand side of the screen, underneath your name.
  2. Click See all options from the drop-down menu that opens.
  3. Select My Account, followed by Settings which is located in the left hand menu.
  4. Under the Mail Tab, you will have an option to edit your signature. If you want Outlook to automatically place your signature on every outgoing email, click the radio button below the signature that says Automatically include my signature on messages I send.
If you don’t choose to have Outlook automatically add your signature, you can add the signature in your email by selecting the Messages Tab in each new email, and clicking the little arrow below Signature. A list of created signatures will be shown, select the one you wish to use.

Add Your Picture or Logo to Your SharePoint Site If your company uses SharePoint, you can add a logo or picture to enhance what is a relatively plain environment.

  1. First, you need to create an image. You can use almost any picture, just ensure you can legally use it. Get creative, this is your space!
  2. When you have the image you want to use, open SharePoint, click Site Actions and select More Options.
  3. Select Picture Library, and in the window that opens, select a name for a new library, and press Create.
  4. Your new Library should be on the left side of the screen. Click to open it and select Upload.
  5. When your picture shows up in the library, select it twice, so it’s in its own window. Copy the web address from the top of the page.
  6. Under Site Actions select Site Settings followed by Look and Feel.
  7. Beside Logo URL and description paste the URL you just copied. Click Ok and your image will show up on your SharePoint site.
With a few steps you can make Office 365 a little more personal. Just be sure that you can legally use the images you select. If you would like to learn more about Microsoft Office 365 or any other Microsoft products, give us a call.
Published with permission from TechAdvisory.org. Source.

March 29th, 2012

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

Published with permission from TechAdvisory.org. Source.

March 28th, 2012

When it comes time for your organization to evaluate ERP systems, whether you are replacing a small business accounting package or an aging ERP, it’s important to clarify the components.  Each piece (often called module) of the ERP system delivers different value for your organization. To get the most from the full system, make sure your evaluation team understands the fundamentals.

Financial Management At the core of ERP are the financial modules, including general ledger, accounts receivable, accounts payable, billing and fixed asset management. If your organization is considering the move to an ERP system to support expansion into global markets, make sure that multiple currencies and languages are supported, as well as regulatory compliance in the U.S. and in foreign countries.

Other functionality in the financial management modules will include budgets, cash-flow, expense and tax reporting. The evaluation team should focus on areas that are most important to support the strategic plans for your organization.

Business Intelligence Business Intelligence (BI) has become a standard component of most ERP packages. In general, BI tools allow users to share and analyze the data collected across the enterprise and centralized in the ERP database. BI can come in the form of dashboards, automated reporting and analysis tools used to monitor the organization’s business performance. BI supports informed decision making by everyone, from executives to line managers and accountants.

Supply Chain Management Supply Chain Management (SCM), sometimes referred to as logistics, improves the flow of materials through an organization by managing planning, scheduling, procurement, and fulfillment, to maximize customer satisfaction and profitability. Sub modules in SCM often include production scheduling, demand management, distribution management, inventory management, warehouse management, procurement and order management.

Any company dealing with products, from manufacturers to distributors, needs to clearly define their SCM requirements to properly evaluate an ERP solution.  It’s easy for a vendor to focus on their applications’ strengths and not address the full needs of the company.

Human Resource Management Human resource management ERP modules should enhance the employee experience - from initial recruitment to time tracking.  Sub modules can include payroll, performance management, time tracking, benefits, compensation and workforce planning. Self-service tools that allow managers and employees to enter time and attendance, choose benefits and manage PTO are available in many ERP solutions.

Manufacturing Operations Manufacturing modules make manufacturing operations more efficient through product configuration, job costing and bill of materials management. ERP manufacturing modules often include Capacity Requirements Planning, Materials Requirements Planning, forecasting, Master Production Scheduling, work-order management and shop-floor control.

Integration Key to the value of an ERP package is the integration between modules, so that all of the core business functions are connected. Information should flow across the organization so that BI reports on organization-wide results.

ERP can be easier than you imagine - Microsoft Dynamics ERP is cost effective and familiar to your users. If you are thinking about upgrading your systems to a fully integrated ERP system, give us a call.

Published with permission from TechAdvisory.org. Source.

March 27th, 2012

For employees developing Java applications, there are a number of ways they can go about it. In the past, many had to first develop a framework, then develop the applications around it. This changed when VMWare released the Spring Framework. The Spring Framework 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.

Published with permission from TechAdvisory.org. Source.

March 26th, 2012

As the economy rebounds, it’s time to realign your view of cash flow. During the recession, maintaining enough cash to make payroll and keep the doors open was the primary focus for most organizations. Now that the future is looking brighter, are you ready to align your resources and costs to maximize cash flow and profits?

The next stage of growth The accounting program and spreadsheets you used in the past to manage payable, receivables, inventory, and payroll can’t handle the larger task of optimization as your business grows. Balancing all of the variable resources in your business, and matching them to your forecasts goes beyond manual processes.

To grow your business effectively and remain competitive in today’s fast paced economy, you must have a clear view of:

  • the status of your resources, including inventory, employees and capital assets
  • operational efficiencies, including the costs to produce and deliver your products
  • cash flow through the business to support operations
Aging accounting systems and spreadsheets cobbled together can’t deliver a complete picture of the three fundamental building blocks of your organization. To support growth and take advantage of the growing economy, it’s time to look for an ERP system. Connected data and consolidated reporting will give you the ability to balance all the elements for success.

Usability for fast results As you begin evaluation of ERP systems, keep in mind that usability is critical to fast results. The economy is rebounding now, and you need to implement an ERP system quickly. Choose an ERP solution that gives employees a familiar user interface, and is integrated with Microsoft Office. With both cloud and on-premises deployment options, Microsoft Dynamics ERP is an easy choice.

Let’s talk about how you can take your business to the next level. Call us today.

Published with permission from TechAdvisory.org. Source.

March 20th, 2012

Many companies realize the benefits of virtualizing their systems, and some have even started the process. In the current economies around the world, businesses are looking at ways to save money and streamline processes. A recent report on virtualization found that some organizations achieved investment returns of up to 269%. Read on to learn more.

What is Virtualization? Virtualization is the creation of a virtual computing environment, where one hardware system can run multiple virtual environments. Common types of virtualization include servers, storage devices, or networks. The benefits of virtualization include lower costs, improved IT management, and reduced energy consumption.

The Survey A report published by CDW-G focuses on government organizations in the United Sates. Many SME owners and managers like yourselves are probably asking, “How do study results involving the government help my business?” Well, if you look closer you can see that what the government organizations did can easily be replicated by SMEs, just on a smaller scale.

Results In recent years, many companies have had to tighten their belts due to economic difficulties. Government agencies are no exception. The results of the survey found that agencies and organizations realized investment returns as high as 134 to 269%. The survey found that if IT managers invest in Server Virtualization, Document Management, Storage Virtualization, and Cloud Computing in that order, the returns on Server Virtualization alone can help pay for, if not totally cover the cost of, the other three processes. CDW-G found that on average, the total cost of implementing all four separately is over USD 1.1million, but when implemented in order, the average cost was around USD 400,000.

While it is unlikely that SMEs will see a return on investments of this magnitude, it is highly likely that they will see increased returns if they follow this method of re-investing returns from Server Virtualization into the other three steps. In times of economic stress, this could be a huge boost to your bottom line.

Helpful Recommendations From the results, CDW-G offered some useful recommendations that all businesses can use:

  • When budget cuts are needed, first look for ways to increase efficiency without service cuts.
  • Review technologies and processes to identify inefficiencies.
  • Consider savings and efficiency opportunities in all new solutions.
  • Leverage available savings into new projects.
As with any new process, it’s equally important to ensure that you educate the users of the processes and stay on your toes to keep updated.
Published with permission from TechAdvisory.org. Source.

March 15th, 2012

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.

Published with permission from TechAdvisory.org. Source.

March 15th, 2012

We all use technology, and many of us are comfortable setting up and using multiple programs, but what happens when a product stops working? Most business owners or managers will be on the phone to support looking for answers, or wading through hundreds of search results for a fix. Does it have to be so hard?

The answer is: No, it does not have to be. Microsoft Office 365 is a good example of a suite of programs with a strong background of troubleshooting and support resource data bases. If you have a question or problem while using Microsoft Office 365, there are a number of ways you can get the problem solved.

  • Troubleshooting Tool:  This tool should be the first place you look when you have questions or need support. When you go to the page you will asked four questions and presented with links to solutions based on the answers given.
  • Office 365 Community: The community, run by Microsoft, provides information on all aspects of Office 365 with the majority of the information being provided by users of the various products. This community also has information on updates and commonly asked questions. It’s a good idea to check with the community to see if there are any other users who have had the same questions or issues as you.
  • Office 365 Technical Blog: If you can’t find answers on the Community page, try looking at the Technical Blog. The blog is run by Microsoft engineers and is a direct link to the developers of the product you are using. Any answers to questions on this blog will often be straight from the source with the answers usually being more on the technical side with lots of explanations or update information.
  • Tools and Diagnostic Wiki: This is a wiki article that covers products in the Office 365 suite. Think of this as the umbrella section that covers troubleshooting of all issues, while providing you with links and updates related to troubleshooting. You can search issues based on product plan, specific products, services, and more. If you are having a problem not covered by the other resources, chances are you will find the answer here.
With comprehensive coverage and a number of different places to go to when you have questions or a problem, you should be able to get back on track in no time. Please contact us if you would like to know more about Office 365 or any other Microsoft products.
Published with permission from TechAdvisory.org. Source.

March 13th, 2012

Hey, it's nowhere near the gargantuan status of Facebook or Twitter, but lesser-known Pinterest has a following, and especially if your target market is females, it can be a very versatile and unique online marketing tool – that is, if you 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.

Published with permission from TechAdvisory.org. Source.

March 12th, 2012

As your company grows, so does your use of specialized business applications that serve your industry. Manufacturers and companies serving the medical, hospitality, or educational markets often depend on line-of-business (LOB) applications built to serve the unique needs of the industry or specialty. Connecting you to vendors and customers, LOB applications save time but also can separate the information that you depend on to make decisions.

Smart decisions require full information

Typically LOB applications provide excellent functionality, fulfilling the operational needs of a specific business requirement. LOB applications support everything from engineering drawings to patient management to student services, delivering functionality that is critical to the organization.

But there is a price for that tailored functionality. The data gathered and stored by the LOB application is not connected to your ERP system. Summary data often has to be reentered from one system to another, with accompanying loss of detail and productivity. Manual processes to import data from one system to another are error prone and not real time.

Integration is the answer

In today’s fast-paced economy in which customers’ needs change on a dime, your organization can’t afford to have limited information to drive decisions. Only real-time integration between your LOB applications and ERP system will give you the information you need — when you need it.

While most ERP systems can be programmed to automatically import information from other systems, few are easy and inexpensive. The ERP system that you choose should offer multiple options for integration of disparate systems to meet the varying requirements of LOB applications. You may require integrations from web-based applications as well as those housed on your own servers.

With full integration across all the applications in your organization, you can serve customers better and respond quickly to change. Let’s get started today, connecting your systems for better insight.

Published with permission from TechAdvisory.org. Source.