Three New Fabulous Features in Microsoft Word 2013 (Word 2013)

Find out the top three new features in Microsoft Word 2013 that caught my attention! More »

Top 4 Basic Formulas You Should Know (Excel 2010)

These are the top 4 basic formulas that everyone should know 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)

Learn how you can insert superscript using the Find and Replace function More »

 

How to Control Where Your Headings Start (Word 2013)

Have you encountered this bizarre scenario where the heading in the document just refuses to budge and stays put at the beginning of a page?  Sometimes, the gap or blank space between one page of a document and the other is a little too wide and you want the next heading (or chapter) to start just after the previous one ends.

Three New Fabulous Features in Microsoft Word 2013 (Word 2013)

I have just recently switched to using Microsoft Office 2013 and yes, this means that most of my tutorials in Word, Excel, PowerPoint (and anything under the MS Office 2013 umbrella) will be based on version 2013.  In this post I will share with you, the top three new fabulous features in Microsoft Word 2013 that are indeed very useful.

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.