Spreadsheet office

No Picture

Data Analysis with Exponential Smoothing

Exponential smoothing is a time series analysis that omits irregular variation without take account of both seasonal variation and trend.  MS Excel provides exponential smoothing as a part of tools in Data Analysis.  The tool…


No Picture

Use Correlation Test of MS Excel

Data Analysis of Excel has a function to determine the relationship between two variables.  Result of this function is coefficient of correlation which shows the strengh or weakness of a relationship. The value of coefficient…


No Picture

How to protect your Excel sheet

If you have done something complex computation task of excel, you might be need to protect your sheet. Sheet protection will prevent changes on formula, deletion or even cell moving.   In Excel, we can arrange…


No Picture

Use Excel List for Data Analysis

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…



No Picture

Ber-statistik-ria di Microsoft Excel

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…