Blog

Before selling your phone, read this!

September 11th, 2014
Before selling your phone, read this!

When you go to upgrade your phone you may consider selling your old one. However, one issue you may face is having a number of apps on your device that contain personal information. You need to take care that you deauthenticate apps when you’re considering getting rid of, or selling your upgraded devices.

Office apps for iPad updated

September 10th, 2014
Office apps for iPad updated

Earlier this year, software giant Microsoft released iPad specific Office apps, which many iPad users have been eagerly awaiting. While these apps bring full-versions of the four most popular Office programs to the iPad, you do need an Office 365 account in order to get the most out of them.

How to combine cells in Excel

September 10th, 2014
How to combine cells in Excel

Have you ever been working with a list in Excel and had to combine more than two cells into a new cell? The seemingly easiest way to do this is to copy the contents from both cells and paste them into the new cell, then edit them for spacing. But, did you know that there is actually a formula called concatenate that you can use to combine contents and display this in new cells?

Using the concatenate formula to combine cells

If, for example, you have a spreadsheet with first names in column A, last names in column B, and want to combine them into column C to display the full name you can do so by:

Clicking on cell C2 (or the row where the information you want to combine is)
Typing =concatenate(
Clicking on cell A2 and then adding a comma (,)
Clicking on cell B2 and closing the formula with a closing bracket
Hitting Enter

You should see the two cells are now combined in cell C2, with the formula for cell C2 reading:

=CONCATENATE(A2,B2).

The problem is, there will be no space inbetween the letters or numbers, so you will need to edit the formula to read:

=CONCATENATE(A2,” “,B2)

The double quotations with a space in between them tells Excel to add a space to the cell in between the contents of A2 and B2.

If you have more than two columns you would like to combine, then simply add a comma after each cell.

Protecting your network

September 5th, 2014
Protecting your network

As of June 30, 2014, more than 1,000 data breaches affecting more than 500 patients each have been reported to the Department of Health & Human Services – for a total of roughly 32,000,000 people who have had their privacy compromised.

Juice jacking 101

September 4th, 2014
Juice jacking 101

With smartphones playing a larger role in today’s daily business, the need to recharge them while you are on the go increases. And when you’re nowhere near your charger, that public charging kiosk can look pretty promising. But what you might not know is that common traits in smartphone hardware and software design makes recharging phones through public chargers prone to juice jacking.

Introduction to computer monitors

September 4th, 2014
Introduction to computer monitors

You undoubtedly use computer monitors daily, whether at work, at home or both. So, you know that they are available in a variety of shapes, designs, and colors. What a lot of people might not know is, based on the technology used to make them, they can be broadly categorized into three types commonly used today.

Business impact analysis tips

September 3rd, 2014
Business impact analysis tips

Many people wonder why it’s necessary to perform business impact analysis (BIA) when they’ve already invested a large amount of time on a risk assessment. The answer is simple: because the purpose of a BIA is different, and wrong results could incur unnecessary expenses or create inadequate business continuity strategies.

Take better screenshots on Mac

September 3rd, 2014
Take better screenshots on Mac

Today’s operating systems offer a vast array of different features, some of which users find essential, and some that are deemed non-essential but are still handy. One such feature is the ability to take a screenshot. There is a good chance that you probably have taken screenshots before, but have you ever wished that there was a better way to take them? Here are four tips for better screenshots on OS X.

1. Know the shortcuts

As a Mac user, you likely know that the system is shortcut heavy.

Better Instagram pics with your camera

August 27th, 2014
Better Instagram pics with your camera

Have you ever looked at images and visuals posted by businesses and users on Instagram? While many users take photos using their mobile devices, there are many images that simply look way too good to be taken with a phone camera, especially the ones without filters.

Changing Android location settings

August 26th, 2014
Changing Android location settings

When you first get your hands on your Android smartphone, you’ll be asked about location services and whether you want to enable them. Google and your carrier will have its own location services that you’ll need to approve as well. But what you might not know is that there are actually a few other options for location services with Android which can affect your smartphone’s security.