PPT: How to make a plane fly using Motion Path

Just finished a one-week tour of New Zealand. Covered 20 customers and 1100+ users. During the session for Air New Zealand, I promised them that I will write a blog about how to make a plane fly using two simple yet powerful PowerPoint features: Remove Background and Motion Path. Watch the video. I have also put detailed instructions below.

Continue reading PPT: How to make a plane fly using Motion Path

Word Templates and Building Blocks

Word provides two features for reusing the effort you have put in creating content. Word Templates are useful for creating an entire document from an existing one. Building blocks are useful for reusing parts of the document like common text, custom tables, headers, footers, textboxes, etc.

In this article we will see how to save a document as a template. It is very simple really – Choose File – Save As and select Word Template (.DOTX) option.

Continue reading Word Templates and Building Blocks

How to calculate YOY growth in Excel Pivot Table

Estimated reading time 3 min. Works with ALL versions of Excel.
The data is a list of sales transactions, two columns – amount and date.
We have 5000 transactions over many years. We want to know how the business grew year on year. Here are the steps…

SNAGHTML48223f                  image

Continue reading How to calculate YOY growth in Excel Pivot Table

Legal: How to manage 6 min billing in Outlook Calendar

Here is something I learnt yesterday at Wellington. I was conducting a session on Outlook for a team of EA and PAs for Government of NZ. I showed them the Outlook calendar can be managed at different levels of detail starting from 1 hour down to 5 minutes. Just right click on the time display in the daily or weekly view to change the setting.

6 minutes time slot in Outlook calendar

You will notice that there is a 6 minute option available there. Like most of us, I had never understood why would anyone want a 6 minute time slot. But then one of the participants enlightened me! Legal professionals always manage billing in 6 minute increments so that they can have 10 convenient slots per hour. I learnt something new.

This happens all the time. The more you teach, more you will learn!

If you think that a particular feature is useless – think again. This incident teaches you that every feature is designed with a purpose in mind. Discovering that purpose is called learning.

Want to learn more about effective email and time management?  Check out my Outlook Knowledge Pack (50+ articles).