Use Excel List for Data Analysis

November 13th, 2008 | Posted by iip in Spreadsheet tips - (1 Comments)

What make data analysis become easier? If we recognize features of Microsoft Excel, we found that create a list is more powerful to get insight of data analysis. The related data groups can be managed and analyzed well.

The most popular function of Micorofot Excel list is filter. By filtering columns, we can analyzed contained data within the list by the size (if it is a value type), sorting alphabetcally (if it is text data) or even create a pivot table report.

(more…)

Where they put statistical analysis tools in MS Excel 2007?

November 5th, 2008 | Posted by iip in Spreadsheet tips - (Comments Off)

Some people almost stuck with MS Excel just installed. After years using MS Excel 2003, they got new appearance of MS Excel 2007.  It looks some tools are either hided or removed.  Others admit the new look of MS Excel is more smoothly. Below are some statistical analysis tools that we can find in MS Excel 2007. Yes, it still there:

(more…)

Siapa bilang Excel hanya bisa membuat tabel dan perhitungan biasa saja? Microsoft Excel bisa melakukan lebih dari itu!

Pada artikel sebelumnya, sudah dijelaskan bagaimana menggunakan Goal Seek. Fungsi ini berguna sekali untuk men-traceback suatu perhitungan (tentu dengan formula yang digunakan) baik yang rumit maupun sederhana –sesuai dengan hasil akhir yang kita inginkan. Gampangnya, formula ini bisa digunakan untuk menjawab pertanyaan:

(more…)