Posts Tagged ‘microsoft excel’

How to reveal hidden tab in Word 2007

Posted in Spreadsheet tips on December 29th, 2008 by iip – 1 Comment

In the default view mode of Word 2007, there are seven tabs presence.  Tabs showed in the Ribbon are Home, Insert, Page layout, References, Mailings, Review and View. A hidden tab could be revealed through excel options.  What are in the hidden tab?

read more »

Show workbook edit link of Excel 2007

Posted in Spreadsheet tips on December 10th, 2008 by iip – 1 Comment

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 related to file editing, such as edit link. Choose this command will release the wizard.

read more »

Data Analysis with Exponential Smoothing

Posted in Spreadsheet tips on December 4th, 2008 by iip – Be the first to comment

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.

read more »

Get Adobe Flash playerPlugin by wpburn.com wordpress themes