MangoOrange™

I’ve often met situation where my friends complained to me that the Microsoft Office 2007 automatically “upgraded” their Microsoft Office 2003 without seeking their permission. It’s not a bad thing to have something new and nice to play with. Afterall Microsoft Office 2003 has been around for “ages”, it’s boring to keep looking at it. I personally preferred something new and fresh. As for some, they preferred things that “just work”.

Anyway, the biggest reason why people wanted to continue to stick to their Microsoft Office 2003 is because of the recent makeover of the Office File Format. They called it, OpenXML. If you happen to be using the new Office, all the Microsoft Word, Excel and Powerpoint files ends with an extra “x” to their extension, i.e. (*.docx, *.xlsx, *.pptx). So it’s frustrating that you have to always remembered to Save As (*.doc, *.xls, *.ppt) because the rest of the world aren’t using Office 2007 yet.

Continue reading »

written by mickeyckm

Ever wish that your Microsoft Word’s table cell is as powerful as your Microsoft Excel’s spreadsheet cell? Here’s I’m going to show you how you can leverage on Excel’s cell and place it into Word as a table which is very useful when you are working on statistical data that require your cells to contain formula.

So let’s take a look step-by-step on how Office 2007 will handle it…

Continue reading »

written by mickeyckm

Very often, we rely heavily on Microsoft Excel’s drag-and-expand feature to simplify our work in cutting and pasting formula or numbers such as 1, 2, 3 … 100. Thus, on one fine day, while I was dragging-and-expanding on my Excel financial sheet, I realised that all my figures are wrong and I’m very confident that it has nothing to do with the formula. I was wrong, after trying to figure out. My mathematical formula was right but, my Excel formula was wrong.

Below is a sample of the error that I made, where it suppose to calculate total cost for each day by multiplying the unit cost and the amount of product sold that day:

Before drag-and-expand: It was reflected correct here. Cost(30) = Unit Cost(10) x Sales(3) and the formula is =(A3*B6)

After drag-and-expand: The value for Monday and Tuesday were wrong as the cost should be both 50 and 60 respectively, instead of 75 and 30.

The problem lies in the variables of the formula while we drag-and-expand. The solution is actually pretty simple…

Continue reading »

written by mickeyckm