Articles written by: Steve Wiggins

Jan 19, 2021

Joining values in Excel made simpler!

One of the more common uses of Excel we see here at New Horizons is using Excel for data formatting and simple manipulation. With that in mind, there is often a [...]

Nov 04, 2020

Using PowerShell to find dead computers in Active Directory (AD)

Teaching a System Center Configuration Manager class a couple of weeks ago I was asked if there was a PowerShell command to find dead or stale computers in Active [...]

Sep 30, 2020

Decisions made easily with Excel

So, we’re in Excel and we have to apply some conditional logic. Hopefully, you are familiar with the IF function. Basically we provide a condition that will evaluate to [...]

Aug 30, 2020


To establish ITIL roles in the various ITIL processes, included within the structure is a responsibility matrix known as the RACI (Responsible, Accountable, Consulted, [...]

Aug 19, 2020

The Deming Cycle

The Plan, Do, Check and Act cycle is an invaluable way to continually improve processes or products iteratively. This ideology was created by Dr Deming who is thought [...]

Aug 11, 2020

Secure and sync in OneDrive for Business

Millions of files and documents are stored on OneDrive for Business which, in turn, helps people collaborate and get work done seamlessly. However, when documents are [...]

Jul 08, 2020

What is Continual Service Improvement (CSI)?

This is the metrics approach to improve the services. Despite being a separate ITIL module it can be successful only, if integrated with every part of the ITIL life [...]

Jun 17, 2020

What is Service Operation?

Service operation is where the “rubber hits the road”, i.e. then normal day-to-day tasks performed by the service desk. Delivering valuable processes and services to [...]

Jun 02, 2021

Service Transition in ITIL®

Service transition is a complex time as this is where testing piloting and deploying occur and it when most downtime can occur. Service transition is when services [...]

Apr 22, 2021

Rounding in Excel

There are times where, despite its precision, you'd like Excel to do a little work for you in terms of reducing precision. There are three functions used to round [...]

Mar 08, 2021

Windows 10 Command Prompt Shortcut Keys

In an earlier post, I mentioned how awesome the command prompt improvements in Windows 10 are. In this post, I'll dig a little deeper into some of the shortcut keys [...]

Feb 12, 2021

Service Design in ITIL®

Service Design is the ITIL® lifecycle stage that logically happens after the Strategy phase and before Transition. During the Design phase, we create new services [...]

Nov 20, 2020

What is ITIL?

ITIL® Stands for Information Technology Infrastructure Library® (ITIL®). It considered to be the most widely used framework for managing IT service management [...]

Oct 08, 2020

Deleting an undelete-able site collection

If you create site collections using a batch script, and if one of those was unreachable. As the site creation process may have failed thus any resources will not be [...]

Oct 01, 2020

Introduction to Office 365 Video

Over time, SharePoint has been used for many things of a similar ilk: collaboration, documents, search, dashboards, intranets, wikis, blogs etc. Microsoft have termed [...]

Sep 11, 2020

Creating a layout for Word and Excel

How many times have you wanted to test a layout in Word or Excel before actually putting the content in? In this post, I'll show you a couple of simple ways of [...]

Aug 24, 2020

Multiple Desktops in Windows 10

Whilst support for "virtual" desktops has been around for a while, Microsoft hadn't made it a first-class member of the OS. Now, in Windows 10, you can easily create [...]

Aug 17, 2020

Exchange Online Protection and Evolution

So, we all know that Monty Python loved spam, we all know that we hate receiving spam. On average, Microsoft block roughly 10,000,000 messages every single minute of [...]

Jul 28, 2020

Connector Enhancements in Office 365

Due to overwhelming feedback, the way in which you create connectors for mail flow in Office 365 has been revamped! The experience has been re-jigged for connectors [...]

Jul 03, 2020

Task types and scheduling in Project

One of the hardest aspects of working with Microsoft Project is being able to understand the relationship between the three main units of measurement. Correctly [...]

Jun 18, 2020

For Each loops in Excel VBA

Unlike the traditional For Next loops, the For Each loops do not iterate a ‘set’ number of times. Simply put, this looping structure allows you to iterate through a [...]

May 15, 2021

What is new in Office 365

Office 365 has had a great New Year. Microsoft has delivered Office across more platforms and has been busy adding new features, apps and updates to services across all [...]

Apr 13, 2021

Using Yammer as your social network

>A little over a year ago, Microsoft announced you could make Yammer the primary enterprise social experience in Office 365 for everyone in your organisation. This [...]

Feb 27, 2021

Hyper-V Network Types

When working with Hyper-V, you’ll often need some form of connectivity between the world, the VMs, the host etc. You need a virtual switch. Each virtual switch can have [...]

Feb 16, 2021

Innovations in Office 365

The technology industry runs on innovation: new products, new features and new ideas. Innovation is the arena in which technology companies compete to offer products and [...]

Feb 09, 2021

Normalising your database: Third Normal Form (3NF) – Part 3

In our final part of the three part series about normalising databses (for part 1, click here and for part 2, click here), we satisfy all requirements for 3NF, or the [...]

Jan 12, 2021

Normalising your database: Second Normal Form (2NF) - Part 2

In the first part of the series, we looked at normalising into first normal form (1NF). In this article, the second part of the 3-part series, we focus on second normal [...]

Dec 08, 2020

Normalising your database: First Normal Form (1NF) - Part 1

In this first part (of a 3-part series), we'll look at normalising our database design! The First Normal Form (1NF) sets the very basic rules for an organised [...]

Nov 06, 2020

Evolving Office 365 plans

Making Office 365 even better for small and mid-sized businesses. On October 1, 2014, Microsoft released three new Office 365 plans tailored to meet the needs of [...]

Jul 03, 2020

Combine MATCH and INDEX in Excel for a powerful tool

If you have used Excel for comparisons, reconciliations, validations or have attended our Microsoft Excel Level 2 course, you will have encountered "VLOOKUP" before. [...]

Jun 24, 2020

Manage your administration with ADAC and PowerShell

You may find that during your day to day administration, you will be creating, renaming, and moving objects from one Organisational Unit (OU) to another. Now, this [...]

Jun 17, 2020

Taking the shortcuts in Windows 8

For many years, there has been a split between those who prefer the mouse and those who prefer the keyboard. Often, shortcut keys were realised as the more efficient [...]

Jun 13, 2020

Spring clean your PC with Windows ‘Disk Cleanup’

It’s not a secret that the longer we use a computer, the more we mess them up. We have temporary internet files, log files, errors and other files that effectively [...]

Aug 01, 2020

Secure and sync with Information Rights Management on OneDrive for Business

Millions of files / documents are stored on OneDrive for Business, which, in turn helps people collaborate and easily get work done. However, sometimes when documents [...]

Back to top