RSS   Subscribe by email  

MS Excel 2010 Drop-down

How to create a dropdown in Excel 2010

drop-down list in Excel 2010

I have a similar post about making drop-down with Excel 2003, which has apparently become obsolete with the introduction of ribbon menu in Excel 2007/2010. Regardless of the changes, the general concept of creating a drop-down list in Excel 2010 is still the same as 2003: using Excel Data Validation List. The drop-down list is very useful in that it presents a limited number of options for users to select, users can’t enter their own input, thus limit potential errors and create more consistent output.

Website Maintenance Tools

Want to do the website maintenance yourself? Here are some basic tools you need

DIY - Website maintenance

There are a lot of good HTML tutorials online from beginning to intermediate and advanced levels. You can find almost everything about HTML and other web design coding languages at This article and the followings, however, only aim to help you gain some fundamental knowledge of essential tools and HTML basics – not enough to build a whole website but perhaps enough and quickly enough to know what to use to look at an HTML page and know what’s what and to maintain the web pages by yourself.

About Content Management System – CMS

Content Mangement System (CMS) and CMS advantages


Ever wonder what is a CMS and its advantages? Ever wonder whether your company should switch from using a traditional website to a CMS-driven website. Hopefully this article will give you some understanding about CMS, the differences between CMS and non-CMS sites and more.

CMS overview – From Wikipedia

A web content management system is basically a way of separating your visual presentation from your actual content – whether that content includes photos, text or product catalogs. This separation allows one to accomplish several key things, including:

Google Places – Google Local Business Listing

Get your business on Google Places

Google Places

In the previous post Has Your Website Search Ranking Dropped Lately? we briefly mentioned search localization emphasizing the fact that today’s search engines tend to give more priority to local search results over general search results. A search term like “London pizza” on Google UK will give pizza restaurants based in London more priority over the rest as Google displays a map with highlighted London-based pizza stores at the top of the search results. To take advantages of this change and trend in search, you can and should list or claim your business with Google Places.

Google PageRank Algorithm

Interesting content about Google PageRank algorithm

Found in The Big Switch: Rewiring the World, from Edison to Google by Nicholas Carr

The information is not new; basically it’s about the importance of having related links – both inbound and outbound – on your websites. I still find the author’s description intesteting and well written.

Most Popular Posts