Archive for December, 2009

How to open .chm file on Mac OS X

December 30th, 2009 by @HKw@! | No Comments | Filed in Mac OS X, Open Source

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.

(more…)

Share

Tags: , , , , ,

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

December 28th, 2009 by @HKw@! | No Comments | Filed in Ms Office, Windows

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. (more…)

Share

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

December 28th, 2009 by @HKw@! | 1 Comment | Filed in Ms Office, Windows

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])

(more…)

Share
BlogCatalog