How to use MS Excel conditional formatting to change text/background colors of cells automatically
When doing some Excel-based marketing report, whether it’s web analytic report or sales related report, most of the times, I used some conditional formatting to automatically highlight cells that meet certain criteria such as highlighting cells of under-performing or over-performing shops, under/over-performing regions for revenue reports; highlighting cells based on contract value; highlighting cells that have “N/A” or negative numbers; or highlighting cells of web pages that have poor performance in page visits for a certain period of time. Read more...
Possible reasons why your website search ranking changes over time or even overnight.
Updated in 2017 – This post was originally posted in 2010 and has been revised / updated in 2017.
Search engine algorithm
Times change, people change and so does search engine algorithm. If algorithm sounds like a big word to you, as it does to me, then consider it as a giant set of complex [mathematic] formula that search engines like Google, Yahoo! or Bing develop to decide which websites are more relevant to what people search, thus will be displayed at the top, compared to all the sites indexed in their database. Read more...
Different tools to help you with your competitive website data analysis
Updated in 2017 – This post was originally posted in 2012 and has been revised / updated in 2017
In an earlier post SWOT analysis for your website, I mentioned the four elements of your SWOT analysis include identifying your website strength (S), uncovering your its weaknesses (W), identifying opportunities (O) for the site and uncovering threats (T) against it. While a decent web analytics application like Google Analytics can help you get insight into your own website S and W elements, what and how can you know about your competitor’s web performance in order to make your SWOT analysis more complete? I emphasized “web performance” as opposed to other general information that you can obtain by browsing your competitors’ websites. Below are some tools to help you get some idea about your competitors’ website performance. Read more...
Simple but fundamental steps to make your website more search engine friendly and enhance its traffic and visibility.
Updated 2016 – This post was originally written in 2010 and has been revised / updated in 2016
Already knew about how search engines work, here are some simple but fundamental ways to make your site more visible with better ranking and more visibility.
If your site has ranked well in the past, but gradually or suddenly lost its ranking, then check out this post Search Ranking Dropped – Why & How to Be Visible Again.
How to use Adobe Acrobat Professional from creating a PDF document, inserting or deleting pages, to creating and editing bookmarks
Creating a PDF document
The free Adobe Acrobat Reader is to read/open a PDF file; to create a PDF document, you need Adobe Acrobat Writer, also called Adobe Acrobat Professional, which is not free. With Adobe Acrobat Professional installed, you can convert almost any type of documents into a PDF by using menu File > Print then select Adobe PDF as the printer; hit OK and you’ll have a PDF document. Read more...