Tag Archives: analysis

Useful shortcuts for data analysis in Excel

  By iip | December 16, 2008 - 10:09 am | Spreadsheet tips
4 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:

(more…)

Related terms
    EXCEL REFRESH shortcut, refresh excel hotkey, excel data refresh shortcut, cara menggunakan autohotkey dengan excel tutorial, nielsen excel data, refresh data in excel shortcut, refresh worksheet shortcut excel, salary data analysis using excel 2007, short cut to refresh in excel

How to setup statistical analysis tools in Microsoft Excel 2007

  By iip | October 28, 2008 - 12:10 am | Spreadsheet tips
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?

(more…)

Related terms
    statistical tools excel 2007, how to install add in smart regression in excel 2007, how to set up stats on excell, smart regression for excel 2007, statistical tools for excel 2007