Response Vs. Respond – The Common Mistakes Made

Think you know the difference between response and respond? Well, think again! More »

Change the Formatting of Selected Words Throughout the Document (Word 2010)

You can certainly do more with the Find and Replace function! More »

Top 5 Commonly Misused Singular Words in IT Documentation

Find out which commonly misused singular words that make it into my top list. More »

Change the Values in a Drop-down List (Excel 2010)

Changing values in a drop-down list doesn’t have to be a headache. Learn how! More »

Simple Conditional Formatting (Excel 2010)

Let’s learn how to use simple conditional formatting to alert or warn you when a certain condition is met! More »


Insert Superscript for Selected Number Over Multiple Occurrences (Word 2010)

Here’s another way to demonstrate how powerful the Find and Replace function is in Word. In this tutorial, I will show you how you can insert superscript for a selected number that occurs (repeatedly) throughout the document.

Top 4 Basic Formulas You Should Know (Excel 2010)

There are just so many formulas in Excel that you could use to your advantage, especially when your report involves a fair bit of calculation or requires a certain amount of analysis. I will share with you, my top four basic formulas that I frequently use in most of my reporting tasks.

How to Get Rid of Markups and View the Document as Final (Word 2010)

Have you came across a document that opens up a dizzyingly view of red markings and balloons all over the place such as this one?

Search for Highlighted Words Using Find and Replace Function (Word 2010)

In my previous post on how you can creatively use the Find and Replace function to do more than just the average task of finding and replacing words, you can also use this function to search for highlighted words throughout the document. But then you’d probably wonder, why would you want to highlight some words and then search for it later?

Simple Conditional Formatting (Excel 2010)

Conditional formatting in Excel has many useful purposes. I normally use it to alert or warn me if a certain condition is met (or otherwise). Let me get started on how I use this feature in a spreadsheet that I have developed to monitor the status of a data migration project.

Change the Formatting of Selected Words Throughout the Document (Word 2010)

Most of us use the Find and Replace function for basic word search and/or to replace an existing word with a new one. You can certainly do more than that. Here’s the scenario. An engineer came up to me and asked whether he could do a global change on the formatting for selected words throughout a 20-page document without having to search and replace it one by one. Well, of course he can. Here’s how:

Top 5 Commonly Misused Singular Words in IT Documentation

I have been working in the IT industry for almost eight years and frequently encountered common singular words that are misused in project documentation. Just like the singular word “furniture”, these words do not have plural forms:

Change the Values in a Drop-down List (Excel 2010)

This simple tutorial will show you how easy it is to change the values in a drop-down list.

How to Quickly Align Shapes in Your Drawing (Visio 2007)

Drawing with precision takes a lot of effort and time, but this is usually necessary when you want to create a good quality professional diagram. Thankfully, Visio has an excellent feature that enables you to quickly align your shapes horizontally or vertically.

Three Useful Tips to Control Your Slide Show (PowerPoint 2010)

While there are countless tips and tricks out there, these three are perhaps the most widely used based on my experience so far.