NH Blog - Articles on Desktop Applications

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 [...]

Oct 22, 2020

Absolute Cell References use in Formulas

Definition: In Excel, an absolute cell reference, like other cell references, identifies the location a cell or group of cells and are used in such things as [...]

Mar 27, 2021

Excel Array Formulas (Part 1)

Excel array formulas are power tools that enable you to perform operations that in many cases can’t be done with regular Excel functions. So what are array functions? In [...]

Mar 17, 2021

Background images in OneNote 2013

OneNote allows you to insert online pictures or pictures from your computer hard drive into your notebook pages. Then you can set the picture as a background, so you can [...]

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 [...]

Feb 06, 2021

Introduction to transitions and animations in PowerPoint 2010/13

Today, I’m going to talk about two features of Microsoft PowerPoint that really make PowerPoint a distinctive part of the Office suite - transitions and animations. Both [...]

Nov 24, 2020

Comparing and combining two lists using VLOOKUPs

You may remember that in my last blog post, I talked about how to do a VLOOKUP in Microsoft Excel. Today, we are going to use VLOOKUPS to compare and combine two lists [...]

Oct 31, 2020

Doing a VLOOKUP that finds exactly what you want

A VLOOKUP in Microsoft Excel looks up and finds a piece of information in a list, a list like the one below: The V in VLOOKUP stands for vertical because you are [...]

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 10, 2020

Why use section breaks in Microsoft Word?

So you just got told that you are going to have to write the next training manual for your job. No problem. Just type everything up and then print it out, right? Hold [...]

Sep 30, 2020

Customise the Ribbon in an Excel workbook

We all know how to customise the Ribbon in Microsoft Excel by using the graphical user interface, but the problem with this way of customisation is that if you move the [...]

Sep 26, 2020

Dynamic charts in Microsoft Excel

Charts in Microsoft Excel are a great way of representing data graphically, but sometimes that data is subject to change and when it does change, we need our charts to [...]

Sep 22, 2020

All about autofill in Microsoft Excel

You all agree that Microsoft Excel’s Autofill feature is one of the most popular and versatile features in Excel, however not a lot of people know about its full [...]

Back to top