December 2008

No Picture

How to reveal hidden tab in Word 2007

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…


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: alt shortcut for data analysis stat…


No Picture

5 Reasons to use SmartArt

SmartArt, one of the recent feature of Microsoft Office 2007 has several advantages.  You can find the feature within Insert Tab of the Ribbon.  Why we need to know how to use SmartArt?


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…