Excel

No Picture

Chart takes attentions

Chart has been used to explain matters more easily.  Adding charts in documents, reports or even website could attract more attentions.  Excel 2007 has more styles and features to make up the chart. Below are…



No Picture

Useful shortcuts for data analysis in Excel

Excel provides shortcuts of various command, from formatting to printing. Find your favorite shortcuts of excel when dealing with data analysis task. Here the useful shortcuts: Post relevance terms: goal seek shortcut key, shortcut to…


No Picture

Show workbook edit link of Excel 2007

Do you know that Excel 2007 placed functions/tools in a new tab? Pulldown menu has replaced by the Ribbon. In Excel 2003 and before, pulldown menu provide EDIT tab. This tab consists of various commands…


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

Bagaimana menghitung cepat tanpa formula di Excel

Ada satu fasilitas di Excel yang jarang orang mengetahuinya. Fasilitas tersebut ternyata sangat memudahkan kita dalam mengetahui hasil perhitungan.  Apalagi jika melibatkan banyak sel, sementara kita hanya tersedia sedikit waktu. Apa saja yang dapat dihitung…