Blog

Predictive analytics: 3 Components

September 11th, 2014
Predictive analytics: 3 Components

In business, as in life, we constantly try to make predictions about the future. How will sales be next year if we implement a new procedure? What will the weather be like for the annual staff event next week? It’s no surprise then that businesses of all sizes have started to embrace the idea of predictive analytics.

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.

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.

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.

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.

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.

Massive new security threat exposed

August 25th, 2014
Massive new security threat exposed

It seems like nearly every week, and in some cases nearly every day, there is some security breach announced. The vast majority of these assaults tend to revolve around online user accounts, where password, account information, and even usernames are stolen.

What is If This Then That?

August 22nd, 2014
What is If This Then That?

These days many of us have integrated various apps and programs on our computers and mobile devices into our daily lives. The problem many of us face, however, is that apps and programs are all different and many don’t work all that well together, so we need to take time to transfer information or even share the same content.

Creating accessible technology plans

August 21st, 2014
Creating accessible technology plans

In many countries around the world, businesses are required to meet the needs of all employees. For able-bodied employees, one system will usually be able to meet needs, but disabled employees may have different requirements. Therefore, businesses should ensure that they develop an accessible technology plan.

5 common ways virtualization fails

August 15th, 2014
5 common ways virtualization fails

Virtualization has become common place in small to medium size businesses. After all, the idea of moving physical systems to virtual ones that not only usually costs less but also allows owners to get rid of physical hardware, makes it an appealing option.