NH Blog - Articles on office

Jan 23, 2017

Master Document in Word - Part 2

In my previous "Working with Styles" blog, we explored the creation of a new Master Document and setting a collection of subdocument links. This allows members [...]

Oct 25, 2016

Master Document in Word - Part 1

The Master Document in Microsoft Word is a tool that gets highly overlooked but can provide a great level of efficiency when working on company files. If you have [...]

Feb 22, 2016

Transparent Images in PowerPoint 2013

Here are two useful options to work with transparency of images in PowerPoint 2013. 1. How to make an image’s background transparent This is useful when you want [...]

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

Jan 25, 2016

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

Nov 16, 2015

The Quick Brown Fox...

To insert sample text in Word 2007, 2010 or 2013, use one of the following methods. Method 1: Use rand() You can control how many paragraphs and lines appear by [...]

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

Nov 06, 2015

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

Oct 23, 2015

What is new in Office 2016

In today’s blog I will cover some of the new features of Microsoft Office 2016. Office 2016 is optimised for phones and tablets. Microsoft calls these new apps as [...]

Oct 13, 2015

Welcome to the new Edge

Microsoft Edge which was formerly known as Project Spartan is the next generation browser that ships along with Windows 10. In today’s blog, I will be covering some of [...]

Oct 01, 2015

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

Do the Quick Step in Outlook

In Outlook, what is a quick step? It is a way to make a common action you perform in Outlook 2010 or 2013 take a single click. It isn’t like a Rule that often happens [...]

Sep 03, 2015

Word Equations

Microsoft Word is not only a great tool for everyday business documents like reports, memos and minutes, it can also be used to produce much more specialised [...]

Aug 18, 2015

Create a Custom Tracking View in Project 2013

By creating custom tables and views, you’ll import the same data and still be able to switch back to the delivered Gantt chart and standard tables. If you don’t create a [...]

Aug 14, 2015

Excel – Weighted Average Calculation

Calculating an average in Excel is really easy, but sometimes the business requirement calls for a more sophisticated weighted average. For example when analysing a [...]

Aug 11, 2015

Spellcheck and custom dictionaries in Microsoft Word

Almost everyone who uses Microsoft Word has used spellcheck to fix spelling mistakes in their documents. However, when spellchecking a document you have several choices [...]

Jul 28, 2015

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

Creating a chart with a secondary axis

Here is how to show two different types of information on the same chart; especially if the two types of information are on different scales (one set of information is a [...]

Jul 13, 2015

Selecting Text in Microsoft Word

Before we do anything to the text we’ve written in Microsoft Word, such as formatting or copy and paste, we first have to select the text, or as some people say, [...]

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

Troubleshooting Office 365: Real solutions

I had a question not long ago in regards to OneNote and OneDrive not syncing anymore, and no matter what was tried, it didn't work. The problem The [...]

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

May 15, 2015

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

Mar 27, 2015

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

Jan 27, 2015

Three really handy Excel keyboard shortcuts

Here are three keyboard shortcuts I find really handy in Microsoft Excel. These shortcuts each do something very useful they and are often hard to achieve using the [...]

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

Monitoring user connections to Office 365

In today’s blog post, I will discuss the area of monitoring Office 365. Effective monitoring tracks performance and ensures that consumers receive a quality experience. [...]

Dec 12, 2014

Two ways to put a sticky note on your desktop

If you don’t have a pad of post-it notes on your desk but you need to make a quick note, you can create an onscreen reminder in a couple of ways. 1. Use Windows 7’s [...]

Nov 20, 2014

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

Sep 17, 2014

Telling people that their feet smell and other delightful office conversations

She arrives at her desk in the open-plan office, her feet, hot and sweaty. She takes off her shoes, switches on the small fan she’s bought to cool her feet and all [...]

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

Back to top