Aug 29, 2020
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, 2020
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, 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 10, 2021
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, 2020
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, 2020
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, 2020
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, 2020
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, 2020
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, 2020
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, 2020
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, 2020
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, 2020
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, 2021
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, 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 [...]
Nov 30, 2020
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, 2020
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, 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 26, 2020
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, 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 [...]
Jul 03, 2020
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, 2020
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, 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 [...]
Jun 02, 2021
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, 2021
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, 2021
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, 2021
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, 2021
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, 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 [...]
Mar 06, 2021
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, 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 [...]
Feb 06, 2021
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, 2021
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, 2021
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, 2021
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, 2020
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, 2020
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, 2020
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, 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 17, 2020
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, 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 [...]
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 30, 2020
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, 2020
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, 2020
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, 2020
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, 2021
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, 2021
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 [...]
