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:
Useful shortcuts for data analysis in Excel
December 16th, 2008 | Posted by in Spreadsheet tips - (4 Comments)Data Analysis with Exponential Smoothing
December 4th, 2008 | Posted by in Spreadsheet tips - (0 Comments)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 can predict a value based on the forecast for previous period. Exponential smoothing adjusts error in that prior prediction. It uses Constanta which is reflects the magnitude of which control how strongly the forecasts react to errors in the previous prediction. Smaller constants can result in long lags for prediction values.
How to apply exponential smothing analysis in Excel 2007? You should install add-ins of Data Analysis before.
Bagaimana menghitung cepat tanpa formula di Excel
November 24th, 2008 | Posted by in Spreadsheet tips - (0 Comments)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 dengan fasilitas tersebut?
Copyright © 2010 All rights reserved.
Designed by 