Posts Tagged ‘analysis’

Useful shortcuts for data analysis in Excel

Posted in Spreadsheet tips on December 16th, 2008 by iip – 3 Comments

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:

read more »

How to setup statistical analysis tools in Microsoft Excel 2007

Posted in Spreadsheet tips on October 28th, 2008 by iip – 2 Comments

I’ve been two years using Microsoft excel to complete almost all my office tasks. It’s nice to know how to use statistics analysis tools in this software, instead of using particular statical analysis software. In fact, table-related tasks mostly need calculation, either simple or complex.

If you have to deal with complex task calculations, you may need this simple guideline. There are two facilities to make statistic analysis in Microsoft excel 2007. The first one is Data Analysis which is an additional instruction. How to set up this instruction?

read more »

Get Adobe Flash playerPlugin by wpburn.com wordpress themes