There is no denying that, of all the application suites in the world, Microsoft Office is the most famous and most popular. Regardless of their size, businesses rely on these programs in order to function–so much so, that a working knowledge of Microsoft Office is often a prerequisite for employment. However, despite so many people using these programs on such a regular basis, few understand their full capabilities. Take, for example, Excel, Microsoft?s spreadsheet program. There are plenty of formulas that you can use to enhance your use of your spreadsheet. For starters, let?s review where these formulas should go, and how they should be formatted. Using FormulasMicrosoft has made using formulas in Excel relatively painless. The process that follows identifies the individual pieces of an Excel formula and how a user can create essentially any formula they need. First, to notify Excel that you will be inputting a formula, the first character that you type into the formula bar should be an equals sign (=). Then you need to identify the proper action command that will inform the rest of your formula. The formula tab can be referenced to find the correct action command. Once you?ve done so, identify the letter and number for each cell the action command should apply to inside the parenthesis. Finally, press the Enter key. If your formula is correct, your data will automatically calculate and populate in the spreadsheet. Of course, knowing how to use formulas only comes into play when you have formulas to use. Let?s go over some useful formulas to have up your sleeve as you use Excel. Total to Find a Sum=sum(cell1:cell2)This action will add up all the cells in a given series. Including a colon in the equation tells Excel to include all the cells between the two in its calculation. =sum(a1:a12)If you select two cells in the same column, Excel will automatically include any cells between them. As a result, this equation would give the total of all numbers in rows 1 through 12 of column A. Count Characters in a Cell=len(cell)Entering a specific cell into this formula will give you the total number of all letters, numbers, and other characters that are entered into the cell in question. This comes in handy when trying to complete a task with strict character limits, like creating content for Twitter. You can use this formula to ensure that your posts don?t exceed the 140 character limit Twitter enforces. Calculating Percentages=(cell1/cell2)This function gives you a quick percentage calculation based on your selected cells. Excel also offers a few other useful utilities to make using it easier. Freeze PanesFreezing panes keep columns or headers from moving offscreen as you scroll through your spreadsheet, which comes in handy when working with a larger document. Remove DuplicatesIf you have a row, column, or even a cell that redundantly repeats (and therefore adds confusion to your spreadsheet) this feature makes it easy to eliminate the extra copies. This could be useful when trying to merge mailing lists that have contacts that overlap. Excel is designed to enable the work that can be done in a spreadsheet to be as comprehensive as possible, with shortcuts and functions to help conserve time and your team?s energy. This has just been a brief sample of how Excel […]

Some small businesses rely on their staff to ensure technology maintenance occurs regularly, which isn?t the best way to go. Your employees don?t have the same skills and certifications that a trained IT technician will have. Furthermore, if you don?t have an in-house IT department, chances are your employees simply don?t have anyone to go to if they are having technology troubles, forcing them to figure out the problems for themselves. You didn?t hire these specialists to do their job plus IT maintenance. You hired them to use their skills for the betterment of your organization–and chances are that they are spending more time than necessary on troubleshooting technology troubles. Your business doesn?t have time or resources to waste on managing IT tasks. Instead, let a managed IT provider like White Mountain IT Services handle this responsibility. Here are four benefits that your organization can take advantage of with managed IT. User ProductivityWhen your employees can reach out for assistance with their IT troubles whenever they need it, they are much more productive. Too many employees are concerned over how much cost their company will incur by contacting outside help, and don?t as a result. When employees don?t hesitate to get the IT help they need, however, they can focus on their work. Furthermore, since your technology is maintained in a more effective way, your workstations will simply run better, which leads to improved user productivity. Fewer IT ExpensesManaged IT means that your business? technology is going to be maintained regularly, which can go a long way in decreasing your IT expenses in the long run. For one, you?ll be at a reduced risk of hardware failure, which can make a world of difference in your budget. After all, replacing expensive equipment like workstations or servers in the event of a failure is a capital expense that no organization wants. Higher IT Staff ProductivityLet?s say that you have an in-house IT department. Chances are that they don?t have time to address all of the responsibilities they have been given. They likely only have time to devote to helping your employees with their technology problems, or implementing new solutions designed to enhance productivity. By working with a managed IT provider, you can supplement your IT staff so that they can get the most work done in the limited amount of time they are available. Greater Return on InvestmentThe break-fix model to IT maintenance is a problem for many organizations because it accrues major long-term costs. Add in a couple of hardware failures and the downtime they cause and you have a major issue at hand. Managed IT resolves these issues for a small monthly fee, rather than a major up-front expense that cripples your budget. Therefore, you pay less for more, offering a greater return on investment. Does your business? budget need some relief? You?re not alone–plenty of small businesses need the flexibility that managed IT can provide. White Mountain IT Services can help your organization succeed by improving the way you manage your technology. To learn more, reach out to White Mountain IT Services at (603) 889-0800.

It should come as no surprise that the practice of business continuity planning is one that every business needs to undergo. This planning serves as essentially your only insurance against some form of data disaster or another. Consider your own business for a moment–could it survive a fire, a critical failure in part of your infrastructure, or theft? With a business continuity plan, there?s a chance it just might. First Things First:In order to create a business continuity plan, you need to first have prepared a compiled list of the impact each department will feel in a worst-case scenario. What would you do if you lost access to your key vendors, your critical IT, your location, or your personnel and staff resources? How long would you take to recover if you lost each of these resources? Once you have established these variables within a reasonable range of success, it is time to develop a thorough business continuity plan. This plan needs to cover four considerations: employee safety, essential business functions, company assets, and communication throughout the event. This will help to ensure that every crucial part of your business is accessible in case of a disaster of some sort. The Four Considerations Communications: This serves a dual purpose. First, you need to be able to confirm that the team made it through whatever disaster took place safely. Second, if your business needs to enact its business continuity plan, there first needs to be an ability to reach out within the ranks of the business. Your strategy should include some means for your team to reconnect and reconvene, with meeting spots decided upon beforehand. Employee Safety: If it weren?t for the need of communication to confirm that your employees were okay, this would top this list. Not only do you no longer have a driving force behind your business if something were to happen to your workforce, more importantly, you will be morally (and most likely, financially) responsible for any harm that comes to them if they were working in unsafe conditions. Ensuring the safety of your employees is more than just a good business decision, it is a moral obligation. Company Assets: Once you have confirmed that your workforce is okay, it is time to evaluate what was able to be recovered from the remnants of your office. This is the main reason that we encourage all businesses to maintain a copy of their digital information in an offsite location that is safe from whatever disaster damaged your original data. Business Functions: Once you have ensured that your workforce is safe and sound and you have established a connection to your backup, your best chance of survival is to resume operations as best you can, given the circumstances. While it is unlikely that you will be able to immediately return to full function, you will be able to prove that you are still working to serve the needs of your clients until you can. With any luck, you will never need to use these strategies. Stress TestingOnce your plan is put together, test it out for effectiveness among your team. After all, a business continuity strategy that fails to enable the business to continue isn?t a strategy worth having. If some part doesn?t serve the way it needs to, go […]

Before the advent of the cloud, data backup was largely considered a manual task. Tape backup was the primary mode of ensuring your data wouldn?t be wiped away in the event of a disaster. This method, however, is a rather outdated concept that can become an inefficient hindrance. Tape backup requires a considerable time investment from your business? employees, as it needs to be set manually at the end of each business day. Furthermore, since tape backup can take a long time and use up a lot of network resources, the number of times you can take a backup every day is limited. Most businesses will opt to start to back up their data at the end of the day, after everyone has gone home and the network resources are no longer needed. This opens your business up to risk from neglect, intentional or otherwise. Plus, since you?re only taking one backup every day, you are potentially losing out on data that isn?t getting backed up. You could lose up to a whole day?s worth of data in the worst-case scenario. Unlike a tape backup solution, a cloud-based backup and disaster recovery system allows for a quick and efficient data backup process. Instead of relying on employees and risking user error, these systems are automated. This automation is one of the major draws to a cloud-based backup solution, as it eliminates much of the risk and helps to keep your organization?s data protected in the event of a disaster. Cloud-based BDR also makes data backup easier because it allows for more than one backup every single day. Tape backup is so intensive that it can only be performed once a day, but by taking ?snapshots? of data that has changed since the last backup was performed, cloud-based BDR aids redundancy in a significant way. Since the backups are only happening on files that are either in-use or those that have been changed, they are less intensive, and can happen much more frequently. We?re talking about at least every fifteen minutes or so, which is practically negligible data loss in a disaster scenario. Finally, the most important aspect of cloud-based BDR is, without a doubt, the ability to quickly recover in the event of a disaster. Tape backup solutions can take several hours (all of which is downtime) to restore. On the other hand, cloud-based BDR can happen almost instantaneously with minimal downtime. You can even restore data directly to the BDR device so that it can act as a temporary server in the event your computing infrastructure has been damaged or malfunctions. Your business can?t afford to waste time or resources on downtime. To learn more about how you can implement cloud-based BDR, reach out to us at (603) 889-0800.

The first step is to navigate to the folder you want to change. To change its color, right-click on the folder. This opens up a menu. You?ll have to scroll down about halfway, but you will see the option to Change color. An image of a palette with an arrow will also open up further options, including 24 colors for the folder display. Once you?ve found the color that you want, click on it. You?ll then see the folder change before your eyes. You?ll know for sure if it?s the color that you want, and you can always take a moment to change it to something else if you desire. However, it?s important to note that this feature won?t colorize the contents of the folders. If you have Google Docs and Sheets files in your folders, they will stay blue or green. It?s also crucial to remember that the color changes will be exclusive to your Drive. In other words, if you change the color of a folder in a shared Drive, only you will be able to see the change. If you tell your team to look for the red folder, they?ll have no way of knowing what you?re talking about. How will you use this color changing feature for your Google Drive? Let us know in the comments.