NH Blog - Articles on office applications

Feb 06, 2021

Master Document in Word - Part 3

In today’s blog we will explore creating a Table of Contents from the Master Document. The Master Document now contains a collection of linked Subdocument files [...]

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 27, 2021

Secrets of Excel dates and numbers

This information isn’t meant to be ‘secret’ but I find that not a lot of people will tell you this about Excel. If you go back and read (or reread) [...]

Jan 12, 2021

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 09, 2021

Our most popular Office Applications blog posts of 2016

2016 was a diverse year for New Horizons. Our trainers worked on Office 365 productivity projects; taught dozens of advanced Excel classes; helped budding designers [...]

Sep 15, 2020

How-to: Add public holidays to a Microsoft Project 2013/2016 calendar

Microsoft Project comes installed with 3 basic calendars: Standard 24 Hours Night Shift Most people are using the Standard Calendar. This calendar has [...]

Sep 01, 2020

Are you using these features in Microsoft Word?

We are all familiar with Microsoft Word – and many of us use it every day of the working week. Despite our frequent use, many of us are yet to discover some really [...]

Feb 22, 2021

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

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

Nov 23, 2020

Ever typed a date into Excel and it turned into a number?

Before I explain why Excel might turn a date into a number I need to discuss how Excel stores data. When you type information into a cell in Excel, the program tries [...]

Nov 19, 2020

The best features of Excel 2013 - Part 1

NOTE: SkyDrive is now OneDrive, and SkyDrive Pro is now OneDrive for Business The first thing you will see when you open Excel is a brand new look. It is cleaner, but [...]

Nov 16, 2020

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

Nov 03, 2020

Microsoft Word: Make an Exclusion Dictionary

Previously, we’ve talked about adding extra words to a ‘custom dictionary’ so that the spellchecker of Microsoft Word marks them as correct. But what about when you are [...]

Oct 30, 2020

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

Oct 15, 2020

Save time by using your Document Stencil

Save time, update and reuse Visio Shapes with Your Document Stencil. The Document Stencil is a special stencil that is automatically created in each Visio drawing [...]

Oct 13, 2020

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

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

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

Sep 17, 2020

Put that marker down and Redact in Acrobat please!

Remove sensitive data from your file with Adobe Acrobat's redaction tools. Have you ever taken out a black marker and marked a document in an attempt to hide [...]

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

Sep 08, 2020

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

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

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

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

Jul 31, 2020

Excel – Fill in the Blanks

Spreadsheets are fantastic not just for number crunching but for extracting useful information from large quantities of data. Filtering, sorting, pivot tables all allow [...]

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

Unlinking A Pivot Table From Its Source Data

You may have a situation in which you need to send someone a pivot table summary report, but you don't want to include the original data. In other words, you want to [...]

Jul 23, 2020

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

Jul 13, 2020

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

Using conditional formatting to highlight weekend dates in Excel

When you design an automated calendar in Microsoft Excel, you don’t need to colour the weekends yourself. With the conditional formatting tool, you can automatically [...]

Jul 07, 2020

Autofill to the Last Row Using VBA

Sometimes you require imitating the operation of Autofill to the last cell in Excel VBA. This is when you double click the little dot located at the right bottom corner [...]

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

Join text without using the Concatenate function in Excel 2013

Excel 2013 has a new feature called Flash Fill. This feature will allow you to join text strings from different cells very quickly without using the Concatenate [...]

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

Dec 09, 2020

Change the Spell Check Language on all slides in PowerPoint using VBA (2007 onwards)

One limitation of PowerPoint is that you can only change the Spell Check Language for a one text box at a time; there is no way to set it for the entire presentation. [...]

Oct 24, 2020

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

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

top
Back to top