How to Apply New Template to Existing Presentation Slide & What to Do Next (PowerPoint 2013)

These simple steps will show you how to quickly apply new PowerPoint template to your existing slide...and more! More »

The Trick to Inserting an Image in a Specific Cell without the Need for Macro (Excel 2013)

Learn this simple trick to insert an image in a specific cell. No macros needed! More »

Using Table to Control Header and Footer in Word – Part I (Word 2013)

Learn this simple trick to control both header and footer in your Word document! More »

How to Remove Document Information Panel (Office 2013)

Annoying panel? No problem! Find out how to get rid of it! More »

2 Interesting Ways to Create Bulleted Lists (PowerPoint 2013)

Spice up your bulleted list with these two creative ways! More »

 

How to Emulate Website Overlay Technique in PowerPoint (PowerPoint 2013)

Website overlay is widely used to give users focused attention on something. This technique is often adopted to promote a newly launched product, get users to sign up for newsletters, showcase a gallery of photos, alert users of system error or prompt users for action. Isn’t it great to use this overlay technique in your presentation, especially if you want to conduct a system demonstration or training?

The Trick to Inserting an Image in a Specific Cell without the Need for Macro (Excel 2013)

Inserting an image into an Excel file is very easy and straightforward as you would do so in any Word or PowerPoint file. The challenging bit is…to insert an image in a specific cell. This also means that you intend to ‘lock’ an image in a particular cell so that the image will stay put in that cell only. You don’t really need macro to help you with this. You just need a little trick to do the job!

How to Apply New Template to Existing Presentation Slide & What to Do Next (PowerPoint 2013)

You will probably find these scenarios familiar. Scenario 1. You are in the midst of preparing a presentation for a project kick-off meeting with the client. Your division then blasts an email, requiring all project delivery team members to use the latest corporate template as part of the compliance process. Scenario 2. You are knee-deep in preparing a presentation for a project progress meeting with the client. The client then comes back to you and says “Please use our template instead”. What would you do in these situations?

2 Interesting Ways to Create Bulleted Lists (PowerPoint 2013)

Generally, when preparing a presentation slide, most of us would use the default bullet style in PowerPoint (yes, that boring, black dot).  In fact, I’ve seen the same bullet style being used in almost all of the projects I’ve worked on for the past nine years. The only minor deviation from the rather traditional style, is the use of other bullet types, i.e. the ones you can easily select from the bullet library.

How to Remove Document Information Panel (Office 2013)

Are you annoyed by the Document Information Panel (DIP) that appears every time you open your file? This panel seems to appear in some of the Microsoft Office files that are downloaded from the company’s SharePoint server. If you are, well, I have a solution for you (but it’s not exactly permanent!).

Using Table to Control Header and Footer in Word – Part II (Word 2013)

In my previous tutorial, you have learnt how to control the header section of a document that involves text and image. Now let’s learn how you can easily do the same for the footer section. In this example, the footer does not contain any image. It is more of controlling the alignment of three separate blocks of elements, i.e. the filename, copyright notice and page numbering.

Using Table to Control Header and Footer in Word – Part I (Word 2013)

I have seen many occurrences of header and footer going out of places in Word documents for various reasons (some are even unexplainable!). While there are many ways to solve problematic header and footer, I prefer to use table to control them, especially if it involves a combination of text and image.

6 Types of Hyperlink You Can Create in Excel (Excel 2013)

Creating hyperlinks in Excel can be beneficial in terms of helping you to navigate better, i.e. jumping from one worksheet or cell to another, or opening an external file that is linked to a particular worksheet. Here are six types of hyperlink that you can easily create in Excel:

The Proper Way to Upgrade Your WordPress

It is always a good practice to keep your WordPress updated. Whenever a new version of WordPress is available, the message “WordPress X.X is available! Please update now” will appear in your WordPress main screen where X.X refers to the latest released version. There are two ways to upgrade your WordPress, i.e. one-click update and manual. This tutorial will focus on the one-click update.

Create Table of Contents in Excel File (Excel 2013)

There are times where your spreadsheet will expand and have several worksheets within the same spreadsheet file. Normally, you would click the worksheet tabs (or next / previous arrow buttons) to navigate between worksheets. That’s okay, but…if you have more than 15 of them, it will be rather troublesome to sort through the list of tabs in your file just to find that particular worksheet!