NH Blog - Articles on Microsoft Office

Aug 29, 2018

Predict your data with Excel Forecasting

Predict your data’s future using a Forecast Sheet  (Excel 2016 – Subscription Version) Did you know that you can easily create a forecast when [...]

Aug 08, 2018

How to manage your transition to Microsoft Office 365

If your organisation is looking to move to Office 365, it's important to plan exactly what steps you want to take, when to perform them, and who will perform them. [...]

Jan 12, 2017

Secrets of Excel dates

It’s not meant to be a secret, but do you know what Excel really stores dates as? I’ll give you a clue, have you ever typed a date into Excel and it [...]

Jan 10, 2017

What can we expect from Microsoft in 2017?

What happens when you stop being afraid? Ask Microsoft! The Redmond-based company that built its fortune on Windows seems willing to break more than a few digital eggs [...]

Oct 21, 2016

Define and solve a problem by using Excel Solver

Solver is a Microsoft Excel add-in program you can use for What-If Analysis. You can use Solver to determine the maximum or minimum value of one cell by changing other [...]

Oct 18, 2016

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

Oct 18, 2016

Outlook on the Web in Exchange Server 2016

Outlook on the Web (formerly Outlook Web App) – has been greatly updated and optimised for tablets and smartphones, as well as desktop PC’s. Supports all recent versions [...]

Oct 13, 2016

Remove all hyperlinks from an Excel sheet using VBA

You can remove all hyperlinks in an Excel sheet by writing only one statement in VBA and that’s: ActiveSheet.Hyperlinks.Delete Of course if you were to remove [...]

Sep 16, 2016

Use conditional formatting to create a Gantt Chart in Excel

Efficient Project Management involves displaying the project plan in a visual format. The tool used to do this is called the Gantt Chart. The Gantt Chart is a list of [...]

Sep 12, 2016

Excelling in Excel

Microsoft Excel is packed with features, libraries of formulas, and comes with an increasing number of intuitive abilities. Excel is the most powerful spreadsheet [...]

Sep 08, 2016

Working with Styles - Part 4

Previously on Word Styles we looked at changing the Style attributes of the Normal Style and Heading Styles that would mean a company font theme can be applied to new [...]

Aug 30, 2016

Our most popular Excel blog posts

Microsoft Excel is an extremely powerful application that allows you to have meticulous control over your data and reporting. The first step to achieving control is [...]

Aug 29, 2016

How to use Excel range names efficiently in calculations

A Microsoft Excel user can use range names in calculations which will create meaningful reports to management. While names make calculations easier to understand, [...]

Feb 18, 2016

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 08, 2016

Custom number formats in Excel

While Excel has plenty of standard formats for dates and numbers, if these don’t suit what you need, you can make use of custom number formats to display your data [...]

Feb 02, 2016

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

Nov 30, 2015

Custom Data Validation Rules in Excel

Data Validation is a feature of Excel that can greatly improve the quality of data that is entered into cells by limiting what a user can type. You can create simple [...]

Nov 10, 2015

I wasn't meant to send that!

Recall a message in Outlook We've all done it before, we've clicked on Send before proofreading one of our emails, forgotten to upload an attachment into the [...]

Oct 30, 2015

Power Map in Excel 2013

If you are using Office 365 Pro Plus or Excel 2013, you can take advantage of Power Map for Excel. Power Map is a three-dimensional (3-D) data visualisation tool that [...]

Oct 26, 2015

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

Sep 22, 2015

The best features in Office 2016!

Office 2016 is the latest release from Microsoft’s Office productivity suite. Microsoft has reimagined the traditional Office experience for a mobile-first, cloud-first [...]

Jul 03, 2015

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 11, 2015

Customising the Project 2013 interface

First time users to Microsoft Project often ask me how to do an initial customisation of the Microsoft Project 2013 interface so I have created these four simple steps [...]

Jun 09, 2015

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 02, 2015

Creating Quick Parts in Microsoft Word

Quick Parts are a type of building block in Microsoft Word that allow you to insert a ‘standard clunk’ into your Word documents. They are great for ‘bits of a document’ [...]

May 25, 2015

Understanding the difference between Office 2013 and Office 365

You’re looking to upgrade from Office 2010, but instead of just a choice between Home and Professional to make, you now have to choose between Office 365 and Office [...]

May 21, 2015

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 17, 2015

Create a SharePoint list based on an Excel spreadsheet

You can create a list in Microsoft SharePoint by importing an Excel spreadsheet file, if your data is already in a spreadsheet format. When you create a list from a [...]

Mar 17, 2015

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, 2015

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 06, 2015

The Best Excel Keyboard Shortcut

OK, I may be exaggerating slightly with the title because the ‘best’ keyboard shortcuts are really the ones we each individually use the most, and you may do different [...]

Feb 26, 2015

What is a Concordance File?

If you are doing long documents that require an Index to find things quickly for the reader then you need to know about a Concordance file. It will save you from having [...]

Feb 10, 2015

Master mail merge to email in Microsoft Word

Have you ever needed to send the same letter out to 100 clients? It would be very time consuming to have to create each of those on your own. A better option is to [...]

Feb 06, 2015

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

Jan 22, 2015

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, 2015

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 13, 2015

Using Outlook flags and categories to manage emails

Here are two quick tips for managing emails in Microsoft Outlook. I’m not going to include ‘folders’ as one of the these tips even though they are a useful option for [...]

Nov 24, 2014

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

Nov 06, 2014

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

Oct 28, 2014

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 24, 2014

Use the master slide to save time in PowerPoint 2013

So you need to make a new presentation quickly and only have a half an hour!! Eek! Have no fear the Master Slide is here! Open a new presentation in Microsoft [...]

Oct 17, 2014

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 14, 2014

3 easy ways to send a standard e-mail in Outlook

I was speaking with a Learning Solutions Advisor, Sean, at New Horizons about being able to efficiently respond to his clients through email. While discussing, I came up [...]

Oct 10, 2014

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, 2014

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 18, 2014

Action buttons and hyperlinks in PowerPoint

Microsoft PowerPoint makes it easy for users to navigate within their presentations or link objects and shapes to files, programs or videos. The two easiest ways of [...]

Sep 01, 2014

Heading styles in Microsoft Word

Recently, one of the students in a Microsoft Word training course asked me whether it was a good idea to use the existing Heading styles (Heading 1, Heading 2 Heading 3, [...]

Aug 28, 2014

5 steps to create a custom field in Microsoft Project

Microsoft Project 2010 and 2013 allows end users to customise their application views by creating custom fields. Not every industry has the same type of information [...]

May 01, 2014

How to access Office Applications from within VBA

Did you know you can access and manipulate any Office application from within Visual Basic (VB) code? In today's blog post, we'll go through the basic steps to connect [...]

Apr 29, 2014

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

top
Back to top