Blog

Predictive analytics: 3 Components

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.

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.

New themes for Office 365

New themes for Office 365

When it comes to purchasing and implementing public cloud solutions, such as Microsoft’s Office 365, business owners know that they are getting pretty much exactly the same product as every other business that uses the same solution. While this uniformity and consistency is positive, users often look for ways to customize the platform so that it relates more directly to a specific company.

New DEA rule makes e-Prescribing harder

New DEA rule makes e-Prescribing harder

The Drug Enforcement Administration (DEA) is making it more difficult for physicians to prescribe opioids, and in doing so, has necessitated changes to e-prescribing.

The issue stems from titles II and III of the Comprehensive Substance Act (CSA), under which controlled substances are classified into one of five schedules based on potential for abuse and likelihood of dependence.

Juice jacking 101

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

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

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.