Tip of the Week: How to Copy Excel Worksheets

First, you have to choose whether you want to copy an existing worksheet into the same workbook or to a new Excel file. You can do both with relative ease! Copy Your Worksheet Within the Workbook To copy a worksheet, all you have to do is right-click the sheet tab of the target worksheet and use the menu which appears. Select Move or Copy?, and after you have done so, you should select Create a copy from the options available. Select OK, and that?s it! You now have your copy, which you can edit and rename as you see fit. Copy Your Worksheet to a Different Workbook Copying a worksheet to a different book is a bit more involved, but still manageable. First, you might notice that Excel has this function built right into its user interface, but you will need to have both the current workbook and the target workbook open. On your original worksheet?s window, right-click the sheet tab. Then, you select the Move or Copy? option using the To Book option to locate the new target. You?ll see a list of open workbooks to select from, so find the one you want and make sure Create a copy is selected. Once you?re ready, click OK. You can also drag one worksheet to another, if you have both workbooks open. To do so, under the View tab, select View Side by Side from the Window group. Doing this tells Excel to split the view in two, allowing for an easier time doing this. You can then click and drag the sheet tab you want to copy from one workbook to the other while holding down the Ctrl key. Without the Ctrl key, you?ll just move the sheet over. We hope this tip helps you cut down on some of the time you might waste moving data around unnecessarily. To learn more tips and tricks to make the most of your technology, be sure to call us at (603) 889-0800.

A Significant Vulnerability is Present in Apple Devices Through MacKeeper

Let?s dive into Elastic Security Labs? claims and what they could mean for Mac users. Macs Do Get Malware?Just Not As Much Research from Elastic Security Labs shows that 54% of malware impacts Windows devices, whereas 6.2% of malware are found on macOS devices. On the other hand, 48% of macOS devices are infected by the same app?an app called MacKeeper. MacKeeper is a utility that provides tools to help maintain a computer?s privacy and security. In order to do so, the app needs to have considerable security and access permissions. The most dangerous thing here is that MacKeeper is a legitimate software, and it has fallen prey to malware that utilizes it against the user. For the sake of security, we recommend you remove it from your device. Follow the steps below to do so. Deleting MacKeeper from macOS Navigate to the Finder app Select Applications Locate MacKeeper Make sure you have This Mac selected and click the plus sign Open the dropdown by selecting Name Select Other Tick the checkbox next to System Files Click Name and select System Files Change aren?t included to are included Right-click and select Move to Trash for all files in the folder Right-click the Trash icon and select Empty Trash With this threat out of the way, you can breathe a little easier when using your macOS device. Although, you?ll still want to make sure you have some sort of security protection on your Mac. If you need assistance with your technology, be sure to contact us at (603) 889-0800.

Why Your Business Needs Cyber Insurance (and What to Look For)

First of All, What Does Cyber Insurance Cover? Depending on your provider, there are different levels of coverage that your business has to consider. First-Party Coverage Helps Cover Your Direct Losses Suffering a data breach is an expensive circumstance. In addition to the costs required to recover any data still available, you also need to consider the cost associated with your business? downtime and the fees incurred by any investigative services you enlist. Third-Party Coverage Takes Care of Your Clients and Business Partners Chances are that a data breach won?t just impact data that pertains to your business, potentially also harming the vendors you work with and the businesses you serve. You will be responsible for trying to make it right, which will be a costly endeavor. It is also important to mention that cyber insurance covers more than just cyberattacks. While you should check any policy you plan to sign, it isn?t uncommon for a cyber insurance policy to cover damages from any form of business interruption?and to also cover hard copies of your data. Don?t be afraid to confirm what your policy covers before committing to an extended agreement. What You Need to Determine as You Seek Out Cyber Insurance During your search for a cyber insurance policy, it will be massively helpful to have a few facts and figures ready. This includes things like: What is it your business will likely need? As we said before, there are various costs that different insurable events will incur. Let?s say that your business accepts card payments, and therefore needs to abide by the Payment Card Industry Data Security Standard?except somewhere along the way, someone fumbled the ball and left your business noncompliant and subject to fines. Cyber insurance may help cover these costs, and that?s just one example. It will be important for you to identify all potential needs like this and go about your search with them in mind. How much can you invest into your cyber insurance? This is the big question when it comes to any budgetary determination, of course, but it?s particularly important to consider when the potential costs are so high. Will you be able to maintain the premium costs so that you are protected from the cost of a disaster? What level of deductible is acceptable for your needs? Does the provider actually cover all situations you risk facing? Cybersecurity costs span a wide, wide range. Let?s say you were to suffer a breach?not only will you need to pay to have the root cause sniffed out and eliminated, but there are also the legal fees that will likely be involved, the costs associated with the notifications you legally need to make to your contacts, the PR expenses needed to preserve some aspect of your reputation, and the credit monitoring services for those affected that are all included under the umbrella of cybersecurity costs. In order to cover your bases, you need insurance that can be used to offset all of these costs. We can help you determine what level of cyber insurance is appropriate for your business, helping you find a provider that helps you cover these needs. Find out more by calling (603) 889-0800.

Tip of the Week: Freezing Panes in Your Excel Spreadsheets

Let?s say you were working with the following data, outlining the departments each of your employees are a part of, along with when they were first hired and their current pay rate. As you scroll down this list, you might find it useful to have a reminder of what each column is describing?and this only becomes more the case as your spreadsheets grow larger and more complicated. Luckily for us, Excel makes it easy to have certain data remain on screen. How to Freeze Panes in Excel Freezing a pane simply means that you?re telling Excel to keep that data visible as you scroll, and again, it?s laughably easy to do. First, select the row immediately below or the column immediately to the right of the data you want frozen. In our example, since we want to keep Row 1 in sight, we?d select Row 2. With the appropriate row or column (in this example, row) selected, you?ll next access the View tab in the ribbon and select Freeze Panes. You?ll then be presented with three options: Freeze Panes, Freeze Top Row, or Freeze First Column. For our purposes, we?ll be selecting Freeze Panes (although Freeze Top Row would also work in this context). Once you?ve done so, you can then scroll freely, with your top row remaining in sight. And just like that, you have continued access to critical context for your data! What else would you like to know how to do with your essential business software? Reach out to us at (603) 889-0800 and let us know, or to learn more about how we can generally make your IT maintenance a non-issue for your business.

Make Work Simpler Through Automation

The Minutiae ?Business operations? is generally used as an umbrella term, not necessarily in relation to a particular task or what makes up that task. Some of these tasks can be repetitive, and while they are important and must be fulfilled, they can often make even the best employee feel like their time is underutilized. Thankfully, there is an alternative solution that might be able to address this challenge. Automation Can Be The Remedy You Need Some studies have indicated that automation of rote tasks can save as much as two hours of work every day? per employee. Imagine how much more you can get done as an organization if you save that much time. You could focus on revenue-generating tasks or other intensive work tasks, and employees would be less likely to disengage from their work. More time could be spent focusing on what matters and innovating for a brighter future. Most business automation occurs through software solutions. Manufacturers can also incorporate robots to handle many of their automated tasks. Small businesses, on the other hand, will use automation to support their Standard Operating Procedures, using technology to build repeatable and trackable processes that provide them with much-needed consistency. How You Can Build Better Automation Processes Some businesses will find automation integration to be easier than others. Certain tasks will be easier to automate, while others will actually come at the detriment of your organization. Let?s examine the best ways automation can provide a return on investment for your business. Lead Generation Managing your lead lists can be time-consuming, but it is essential to optimizing your profits and revenue generation. If you automate these tasks, you are making it easier for your sales team to pursue meaningful connections with potential clients, improving your business? profitability as a whole. You can automate the process of inputting leads into your customer relationship management software or even assign them a score based on how likely they are to yield a return. You can then use these scores to make the most educated decisions possible for pursuing new prospects. Notifications Internal communications can be challenging to manage, too, but the fact remains that if they are managed effectively, they can improve your business? performance across the board. Automated notifications can improve the speed and efficiency at which your business communicates, and you can set them up to work with your pre-existing tools like instant messaging, phone systems, email, and so on. These notifications can help you better manage inventory, provide better support, update users on tasks, and so much more. Customer Support Small businesses have been innovating to provide better customer support and service through the use of automation. Technologies like AI-powered chatbots can provide excellent front-end customer support to handle simple, common issues, leaving your production staff more time to handle other tasks. Chatbots are just a good supplement to your current support team, providing yet another option for customers to receive support the way they want to. Automation can make your business much more profitable and productive. To learn more about how you can take advantage of it, be sure to contact us at (603) 889-0800.