Articles written by: Ben Kirk

Apr 04, 2021

Close All Excel Files at Once

If you find that you sometimes have more than one Excel spreadsheet open at a time and need a quick way to close and save all of them at once… Close All is for [...]

Feb 03, 2021

Custom AutoCorrect entries in Microsoft Office

The main purpose of AutoCorrect is to automatically fix commonly misspelled words. The idea is simple; you type a word incorrectly and, as soon as you press the spacebar [...]

Jan 18, 2021

What is OneDrive?

More and more these days, individuals and organisations alike are starting to embrace The Cloud as a medium for carrying out everyday tasks. OneDrive is one such [...]

Dec 13, 2020

Sharing a Word Document on OneDrive

If your organisation uses Office 365 then you have the ability to save files to the Cloud – to OneDrive. Saving files to OneDrive provides some benefits to both [...]

Dec 08, 2020

What you didn't know you could do in Skype for Business

If you are using Skype for Business to communicate with colleagues, you might appreciate these tips on using it more easily. Search for people using more than just [...]

Nov 02, 2020

Am I using PowerPoint effectively?

PowerPoint is the go to application for creating presentations on a Windows PC. It has evolved over time to incorporate the ability to include sound, video, animation [...]

Oct 18, 2020

Do a quick forecast in Excel 2016

Excel 2016 has a very handy new feature that enables you to create a quick forecast from a list of dates and their associated figures. It also automatically plots them [...]

Sep 19, 2020

Reduce those pesky meeting request response messages in Outlook

If you regularly send out meeting requests in Microsoft Outlook, perhaps on behalf of a number of people, you are probably fed up with the volume of responses that you [...]

Aug 22, 2020

The Windows Key

Back in 1994, Microsoft introduced a new product called the Microsoft Natural Keyboard. It was a split keyboard with each half separated and tilted slightly upwards to [...]

Jul 06, 2020

Search for a Worksheet Function in Excel

Excel has over 350 worksheet functions that provide a massive array of different uses. From the simple =PI() function that refers to the value of Pi (3.14159265358979) [...]

Jun 23, 2020

PowerPoint Designer

A recent update to Office 2016 for Office 365 subscribers added a new feature to PowerPoint 2016 called PowerPoint Designer. The way it works is: You insert a graphical [...]

May 12, 2021

Linking a Worksheet Title to a Chart Title in Excel

Automation is what technology is all about so if I can find ways to automate something, I will. Someone asked me recently whether you could link an Excel worksheet title [...]

May 02, 2021

Update Your Status (Bar) in Word

There’s a greatly underutilised part of the Word screen that has a great deal of functionality. By default the Status Bar shows the page number, a word count and whether [...]

Apr 15, 2021

Screen Clippings with Hyperlinks in OneNote

OneNote is an incredibly versatile note-taking and organising application. Since its inception with Office 2003, it has had new features added over time to become the [...]

Apr 07, 2021

Creating Custom Shows in PowerPoint

Many people think of PowerPoint presentations as being very linear in nature; you start at slide 1 and then go 2, 3, 4, 5 etc. until you get to the last slide. But this [...]

Mar 11, 2021

The New IFS() and SWITCH() Functions in Excel

If you use Excel through an Office 365 subscription or you use Excel Online or Excel Mobile, then you can take advantage of two new worksheet functions: IFS() and [...]

Feb 18, 2021

Get a Better View – Through Office Lens

Microsoft have an app for mobile devices called Office Lens. It is a mobile scanner that uses your device’s camera in conjunction with OCR software (Optical Character [...]

Feb 02, 2021

Text to Columns - First Space Only

I was recently asked how the street number and street name could be split into two cells (eg 344 Queen Street to 344 in one cell and Queen Street in another) using [...]

Jan 25, 2021

Using Text Functions in Excel

Excel is mainly known for creating spreadsheets. It has many worksheet functions, like =SUM(), for performing mathematical calculations. In addition to those, there are [...]

Dec 08, 2020

Office 2016: Tell me now so I'll know

In 1965, The Kinks sang: “Tell me now so I'll know, There are so many things that I could do. If you tell me now that I'd know what to do, Tell me now so [...]

Nov 06, 2020

Decorate Your Office

The Microsoft Office applications can be customised to use a different colour scheme and, in the case of Office 2013 and 2016, a background. The background is purely [...]

Oct 26, 2020

Selecting Layers in a Visio Flowchart Diagram

Visio enables the creation of a multitude of different types of diagram. Flowcharts, however, are one of the most common types. Formatting a flowchart can be made much [...]

Oct 09, 2020

Non-Breaking Spaces & Non-Breaking Hyphens in Word

Most of the time we separate words with a space. But occasionally we use a hyphen. There are also En Dashes and Em Dashes, but let’s not overcomplicate things! When we [...]

Sep 28, 2020

Create a Chart Template in Excel

A picture says a 1000 words… or so the saying goes. Charts are a popular way for people to graphically represent data when trying to emphasise trends and generally [...]

Sep 04, 2020

Rounding Numbers in Excel, Part 2

In Part 1 of this series I discussed the worksheet functions ROUND, ROUNDUP and ROUNDDOWN. They will truly round numbers to a certain number of decimal places. But what [...]

Aug 27, 2020

Rounding Numbers in Excel, Part 1

The first thing I’d like to point out about rounding numbers in Excel is that simply hiding decimal places isn’t true rounding; the decimal places are still there, just [...]

Aug 07, 2020

Dude, Where's My Ruler?

A common question I get asked in Microsoft Word courses is: “where’s the ruler gone?” Since Word 2007, the ruler has been hidden by default. To display it simply go to [...]

Jul 16, 2020

Recording Screen Action in PowerPoint 2013

PowerPoint 2013 now has a feature that enables you to take a full-motion screen capture. This could be very useful to demonstrate a process as part of the presentation [...]

Jun 25, 2020

Reuse slides in PowerPoint

There are many features of all of the Office Applications that get missed and people only find about when attending one of the many New Horizons Office Applications [...]

May 21, 2021

Remove those rogue records in Excel

When lists of data are merged, duplicates can be introduced. Fortunately, Microsoft Excel has a Remove Duplicates feature that will eliminate these rogue records. All [...]

Apr 21, 2021

Reduce those pesky meeting request response messages in Outlook

If you regularly send out meeting requests in Microsoft Outlook, perhaps on behalf of a number of people, you are probably fed up with the volume of responses that you [...]

Mar 13, 2021

The Spike

The Spike in Microsoft Word is a feature that has been around for years. I can remember it being featured in courses I taught back in the late ‘90s and early 2000s. [...]

Mar 09, 2021

Instant calculations in Excel

The ability to create formulas in Excel using worksheet functions is one of the applications' most important features. However, for six of these functions, it’s [...]

Mar 03, 2021

Screen Clip your Internet!

OneNote has many impressive features that makes it one of best ways to keep content organised, whether at work, school or home. In this article, I’d like to introduce [...]

Jan 22, 2021

Microsoft Sway - Will you be swayed?

Microsoft is well known for its Windows Operating System and its Office productivity suite. Their future however, is in the business of developing their unique [...]

Jan 15, 2021

Are you using the right colour?

Computer screens and TVs are capable of displaying up to 16,777,216 colours. This is referred to as True Colour. All the applications in the Microsoft Office suite use [...]

Jan 06, 2021

Compact and repair an Access database

Databases can get big. Very big. This can be because they contain a large amount of data, but it can also be because of wasted space taken up by deleted data. When [...]

Dec 16, 2020

Excel formulas are not just for numbers

I had a student recently say that she "didn't need to know formulas in Excel" as she "didn't work with financial spreadsheets." Formulas, however, do a lot more than [...]

Nov 20, 2020

Removing the background from a picture in Microsoft Office

If you have a picture that you want to insert into a Microsoft Office document that is perfect except for the photo-bomber or other unwanted content in the background, [...]

Oct 28, 2020

Use Office 2013 at home with an Office 365 subscription

If you find the Microsoft Office 2013 applications essential at work, then why not at home? Kids, especially, require access to applications like PowerPoint and Word for [...]

Oct 21, 2020

Inserting an online video in Word 2013

Microsoft Word 2013 introduces a new feature which I think is pretty great: the ability to insert a link to an online video. The most likely source of the video would be [...]

Oct 17, 2020

The mystery of mail merge in Microsoft Word

There seems to be some mystery surrounding the process of performing a mail merge in Microsoft Word. People are often daunted by the thought of having to use this [...]

Oct 03, 2020

Copying only the visible cells in Excel 2013

Hiding rows and columns in Microsoft Excel is quite commonly done when filtering data, collapsing a sub-totalled list, or where you just don’t need or want to see [...]

Aug 25, 2020

Using background pages in Visio 2010 & 2013

When you create drawings or diagrams in Microsoft Visio, you have the ability to insert multiple foreground pages. Each page might be part of an overall set of diagrams [...]

Aug 12, 2020

The enhanced Presenter View in PowerPoint 2013

There are two ways that you can run a slideshow in Microsoft PowerPoint. One way is to run it with the same image on both the projected screen and the presenter’s [...]

Aug 01, 2020

Creating multiple signatures in Outlook

For many years people have had two signatures in Microsoft Outlook; one for new messages and one that gets used when replying and forwarding. The latter is generally [...]

Jul 25, 2020

Remove excess spaces from data in Microsoft Excel

When data is imported into Excel, excess characters sometimes come with it. Non-printing characters are the hardest to detect as they are, of course, invisible. Spaces [...]

Jun 27, 2020

Protecting content in Microsoft Word with 'Restrict Editing'

I often ask people "what is the main reason for converting a Microsoft Word document into a PDF?" One of the most common answers is “to stop people from changing the [...]

Jun 06, 2020

Sorting made easy with custom lists in Excel

Sorting is a common task in Microsoft Excel, but it does have a few specific, sophisticated options that not too many people know. One of these is the ability to sort in [...]

Apr 29, 2021

Customise the Quick Access Toolbar in Microsoft Office

The Quick Access Toolbar (QAT) is the little toolbar located at the top left hand corner of all the Microsoft Office applications. It only has a few buttons on it by [...]

Mar 25, 2021

Creating a drop-down list in Microsoft Excel

Nothing looks more clever than a drop-down list of options for people to choose from in your Microsoft Excel spreadsheet. Drop-down lists also makes data entry [...]

Mar 17, 2021

Enhancing the IF function with nested IF functions in Microsoft Excel

Out of all the Microsoft Excel's worksheet functions, the IF function is one of the most useful and versatile functions. Its purpose is to decide, based on a [...]

Mar 04, 2021

Creating Building Blocks in Microsoft Outlook

Building blocks are a feature in Microsoft Word that are simply pre-made snippets of content that can be inserted into any document. Quite a number of building [...]

Feb 13, 2021

Master PowerPoint design with Slide & Layout Masters

Whether your PowerPoint deck is two slides or two hundred slides, wouldn't it be great to be able to modify the layout and format of your slides as well as add new [...]

Feb 10, 2021

The fundamentals of styles in Microsoft Word

Styles in Microsoft Word are one of the most misunderstood features and yet, ironically it's one of the most important aspects of formatting for the end-user. Styles [...]

Jan 07, 2021

Creating Effective Lists and Tables in Excel

Excel is the perfect application for storing lists. Lists of parts, lists of products, lists of people… the list, as it were, is endless as to what you can store. And [...]

Dec 03, 2020

How to integrate OneNote and Outlook

If you haven’t heard of OneNote and if you aren't aware of the how to integrate OneNote and Outlook, then you may be missing out on one of the best productivity [...]

Back to top