How to open .chm file on Mac OS X

December 30, 2009 · Posted in Mac OS X, Open Source · Comment 

I downloaded an ebook from a web site. But the file extension of the ebook is in .CHM format. I cannot open it on Preview.

According to Wikipedia, .chm is a filetype devised by Microsoft which compresses HTML files into a single document, usually for the purpose of software manuals. Nowadays, most of the ebook are in PDF and CHM format. We can read the CHM files in Windows, but how about Mac OS X?

I did some research on Google. I found that there are 2 open source software which allow me to open the .CHM files. Below are the software that i going to share with all of you.

Read more

Excel 2007 -How to get the smallest value from a set of values without sorting out the data.

December 28, 2009 · Posted in Ms Office, Windows · Comment 

In the previous post, i have show how to use  “SUMIF” function. I will continue use the table from previous post to show how to use SMALL function in Microsoft Excel 2007.

Normally, we are using “SORT” function to get the smallest or largest records. However, by using “SMALL” function, we do not need to do it so. Read more

Excel 2007 – How to get the SUM value in Multiple Criteria

December 28, 2009 · Posted in Ms Office, Windows · 1 Comment 

How do I get to sum the values in a range that meet criteria that you specify?

We can use  SUMIF() formula to do that. Besides, we also can use SUMIF() worksheet function for the following situations:

  • When you want to return a sum for a single criteria (for example, a single IF condition)
  • When you want to use multiple criteria and return the sum to multiple cells

Syntax:
SUMIF(range, criteria, [sum_range])

Read more

Next Page »