Articles written by: Liz French

Aug 15, 2020

Quick Tuts: Word 2010 - Easily align text with leader tabs

It's time to stop using spaces and full stops to align your documents, and start using leader tabs. In our QuickTuts video, Liz French shows how to use leader tabs [...]

Aug 02, 2020

Quick Tuts: PowerPoint 2010 - Animating SmartArt Graphics

Are you struggling to deliver engaging and interesting presentations? Learn how to easily create and animate SmartArt graphics in PowerPoint 2010 with New Horizons' [...]

Aug 01, 2020

Quick Tuts: Excel 2010 - vLookups simplified

New Horizons' Liz French explains how to use one of Excel's most useful functions; vLookup. Most people think vLookups are difficult and complex, however, this [...]

Apr 24, 2021

Automate your table of contents in Microsoft Word

In order to create an automatically generated table of contents (TOC) in Microsoft Word, you need to ensure you apply heading styles throughout your document. That is, [...]

Mar 31, 2021

How to create custom lists in Excel

Did you know that Microsoft Excel is very smart? If you type the name of the month (e.g. January), it knows automatically what comes next in the series so that if you [...]

Feb 26, 2021

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

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

Dec 19, 2020

Use the Eyedropper tool in PowerPoint 2013

In PowerPoint 2013, there is a handy feature called the Eyedropper that makes matching colour easy. Not only can you match colours within your presentation but also [...]

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

Why you need to know about the Show/Hide button ¶

The Show/Hide Button is located in the Paragraph group in the top right corner in Microsoft Word. It looks like a backwards letter “P” but it dates back to Roman [...]

Jul 14, 2020

Easily convert dates to Australian format in Excel

This is one of the most frequently asked questions that come up when I'm teaching Microsoft Excel courses.  Many people export their data from an accounting system [...]

Jun 16, 2020

Multi-level sorting made possible in Microsoft Word

Did you know that in Microsoft Word, you can sort your information up to 3 levels? This means that when all things are equal in the first column then it will do a second [...]

May 13, 2021

How to create fillable forms in Microsoft Word

When you create a form in Microsoft Word to capture information that is to be entered by another user, a few problems may arise. The problem that occurs will depend on [...]

Apr 07, 2021

How to create a custom theme in Office 2013

Themes in the Microsoft Office suite are used to format a whole document quickly and uniformly. In this blog post, I'll go through some ways of creating a custom [...]

Feb 28, 2021

How to sort lists with multiple levels in Excel

In Microsoft Excel, you are able to sort lists from 1 to 64 levels. This means that when all things are equal in the first column (i.e. duplicate values), Excel will do [...]

Jan 14, 2021

Master the tricks behind numbered lists in Microsoft Word

Are numbered lists in Microsoft Word frustrating you? More often enough, people aren't using numbered lists correctly. I see many cases where people just type in the [...]

Jan 10, 2021

How to do an IF statement in Excel

An IF statement or an IF function is a way to ask a closed ended question that can be one of two answers, either true or false. Once the result is determined then you [...]

Dec 13, 2020

Manipulate dates with custom number formats in Excel 2010

Imagine you’re in a situation where you want to send a list of the employees’ birthdays so that everyone in the company will know when to send their regards to others in [...]

top
Back to top