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