How to use Excel for data gathering and data analysis?

• Data gathering
• Data analysis and extended use of Microsoft Excel.

There is a Data Analysis function in Excel. You need to check whether it is enabled or not.
Follow this link to learn about it:
http://office.microsoft.com/en-us/excel-help/load-the-analysis-toolpak-HP010021569.aspx