Dynamic arrays have been rolled out to Office 365 users that are on the monthly channel updates.

Unfortunately, this means that if you are not on it, you will not have these (or other incredible updates) yet.

Do you know what update channel you are on?

If not, you can check this by clicking File > Account and viewing your product information on the right.

If you are on the Semi-Annual update channel you will not have dynamic arrays yet.

So let’s look at how to switch to the monthly update channel.

[Read more…] about How to Change to the Office 365 Monthly Update Channel

This blog post looks at some productivity hacks for creating professional, consistent and awesome MS Word documents.

These 10 skills are sure to save time and improve overall efficiency in MS Word.

1. Quick Parts and Building Blocks

Building Blocks is a fantastic feature in MS Word where you can store frequently used content for quick insertion to a document.

There are many galleries to the Building Blocks feature including cover pages, tables, headers, footers and text boxes. Quick Parts is the gallery for miscellaneous content that does not fit any of the other galleries.

For example, say I work for a company with 4 different offices. I frequently have to enter the address of these offices into documentation. This entails looking up the correct postcode etc. and then typing and formatting it. With Quick Parts these can be stored for easy re-use.

[Read more…] about 10 Great Word Productivity Hacks

This blog post uncovers 4 Secret PowerPoint Tricks that will help you to deliver effortless and high quality presentations. These 4 tricks are some of my personal favourites (PowerPoint has many useful tools).

These 4 tricks are easy to use, but will make massive differences to the way you develop and deliver PowerPoint presentations.

[Read more…] about Secret PowerPoint Tricks – 4 Tricks to Make You a Pro

If you find yourself creating projects on a regular basis, you should consider creating your own project templates in MS Project, or customising the default MS Project template. It is easy to do and will save you loads of time in the long run.

This tutorial will begin by showing you what a template consists of, and how to save one. This approach is best if you require multiple templates. For example, specific templates for specific clients or specific templates for specific types of job.

This tutorial will then show you how you can customise the default MS Project template. This will be the best option if you just need one template for all your projects.

[Read more…] about Save Time by Using Project Templates in MS Project

Custom Fields in Microsoft Project allow you to define your own fields (columns) for data that meets your organisation needs.

By creating your own custom fields you can display information on the project plan that is tailored to your requirements.

This tutorial looks at 5 reasons you may want to set up custom fields in Microsoft Project including creating drop down lists and using formulas in fields.

1. Create a drop down list
2. Display multiple fields next to task bars in Gantt Chart
3. Sum the total duration of tasks
4. Change colour of task bars dependent upon conditions
5. Using graphical indicators in custom fields

[Read more…] about 5 Reasons for Using Custom Fields in Microsoft Project