Blog

KeeranAssist – The only support tool you need

September 26th, 2014
KeeranAssist – The only support tool you need

Businesses today have come to rely on their systems. From computers to servers, you need systems that simply work if your business is to be successful. The thing is, all technology will eventually break down or stop working. From software bugs to full-on hardware crashes, any technical problems will result in lost productivity, profits, and even clients.

3 common social media uses

September 24th, 2014
3 common social media uses

For many small to medium businesses, social media has become an integral part of their overall business strategy. Most businesses have a presence on at least one platform, but one issue many business owners and managers struggle with is how they should be using social media effectively.

Avoid cloud and data breach

September 19th, 2014
Avoid cloud and data breach

Data breaches are growing both in number and intensity. While many businesses have turned to cloud apps for better security measures, some experts and businesses worry about the cloud, mentioning that it could see an increased data breach risk. This leads to a collision course between data breaches and cloud usage.

What to do when tech doesn’t work

September 18th, 2014
What to do when tech doesn’t work

Almost every employee in every role relies on technology in order to do their job. When technology is working, everything hums along and productivity is solid. The second our technology stops working however, we can find ourselves struggling to even complete the most basic of tasks.

Content marketing – 4 success tips

September 17th, 2014
Content marketing – 4 success tips

One way to really expand your online presence is through content marketing. Many business owners and managers are aware of this, but may be unsure as to how they can ensure that any content marketing is successful. There are many ways in which you can achieve a good result and here are four tips to help you achieve a great content marketing strategy.

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.