Penangite.net

For all Google users out there who normally just type in a simple keyword and blame the search engine for not giving you accurate results, here’s a cheat sheet of the more advanced search functions you may use with our friendly neighborhood search engine. If these operators and functions still can’t help you get more accurate results then you may start swearing and cursing or even jump over to Bing perhaps?

OPERATOR EXAMPLE		FINDS PAGES CONTAINING…
vacation hawaii		the words vacation and Hawaii .
Maui OR Hawaii		either the word Maui or the word Hawaii
“To each his own“		the exact phrase to each his own
virus –computer		the word virus but NOT the word computer
+sock		Only the word sock, and not the plural or any tenses or synonyms
~auto loan		loan info for both the word auto and its synonyms: truck, car, etc.
define:computer		definitions of the word computer from around the Web.
red * blue		the words red and blue separated by one or more words.
I’m Feeling Lucky		Takes you directly to first web page returned for your query.
CALCULATOR OPERATORS		MEANING		TYPE INTO SEARCH BOX
+		addition		45 + 39
-		subtraction		45 – 39
*		multiplication		45 * 39
/		division		45 / 39
% of		percentage of		45% of 39
^		raise to a power		2^5 (2 to the 5th power)
ADVANCED OPERATORS		MEANING		WHAT TO TYPE INTO SEARCH BOX (& DESCRIPTION OF RESULTS)
site:		Search only one website		admission site:www.stanford.edu (Search Stanford Univ. site for admissions info.)
[#]…[#]		Search within a range of numbers		DVD player $100..150 (Search for DVD players between $100 and $150)
link:		linked pages		link:www.stanford.edu (Find pages that link to the Stanford University website.)
info:		Info about a page		info:www.stanford.edu (Find information about the Stanford University website.)
related:		Related pages		related:www.stanford.edu (Find websites related to the Stanford University website.)

I’m not an Excel user, out of the whole Microsoft Office suite I can say that I only use Microsoft Word 90% of the time, I even hardly use Powerpoint nowadays much less Excel. Then the request came up from my boss, ‘draw me a Gantt Chart of the schedule’, back in uni days you had specialized tools for doing this, Microsoft Visio, Microsoft Project and some web based project management systems. However in a typical office workstation you don’t have these tools, and all you have is the Microsoft Office suite. So I tried my look looking for ways to draw Gantt Charts in Excel, the manual way was possible with just keying in the dates, tasks and coloring the cells, but was not practical and cumbersome to do.

Lucky a few searches on Google came up with the following tutorial on YouTube which was rather helpful, and the end result of the chart was pleasing. I would like to share this video tutorial to those who might be facing the same situation, do let me know if you have a better way of doing this. The version in specific here is Excel 2003, so here goes the tutorial: