Blog

Avoid cloud and data breach

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

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

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.

Apple’s new mobile phones

Apple’s new mobile phones

For many Apple fans, September 9 was a big day; possibly the biggest day of the year. This was the day Apple announced not only new iPhones, but also a new smartwatch and some interesting changes to the upcoming update to iOS 8. If you missed the news then here is a quick overview of the announcements made by Apple.

Introducing Chrome profile lock

Introducing Chrome profile lock

Many of us may feel uncomfortable about letting others use their computer to search the Internet. Our computer is often seen to be an extension of ourselves, and usually has private information that we would not like others to see. To protect your privacy, Google has released Chrome profile lock, a feature being tested that allows you to lock your Chrome session.

5 Facebook spam posts to be aware of

5 Facebook spam posts to be aware of

As of the first quarter of 2014, Facebook has 1.28 billion active users (users who log in at least once a month). With around a fifth of the world’s population using the service, you can bet that it is a target for spammers and hackers. If you use Facebook on a regular basis, there is a good chance that you have seen some suspicious or outright blatant spam links.

How to combine cells in Excel

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.