Saturday, July 14, 2012

What is Excel and why we need it?


Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.


Excel Spreadsheets can be very useful for student interactive activities, interactive lectures, and instructor use for developing materials for class. Example aspects of spreadsheets that are relevant to science education are:
  • Using Excel as a calculator to explore what mathematical equations can tell us about how the real world works for specific input conditions or for a range of possible values.
    • The calculator can be pre-constructed with a focus on student exploration or students can be guided to construct their own calculators and then explore. The first option saves time but the second option prepares students to use Excel for their own projects and future activities.
  • Graphically displaying equations (analytical models) and real data.
  • Obtaining numerical solutions to more mathematically complex models.
  • Graphically comparing results from a model and observations.
  • Statistical analysis including mean, standard deviation, error bars on graphs, linear and polynomial fits, multivariate analysis, etc.
  • Spectral analysis (Fast Fourier Transforms).
  • Displaying histograms of students results or student response to exams or questions.

Could we use Excel to assist in our life?

I am an excel daily user, i use to create some of the excel spread for some of the company to record their sales, stock inventory, profit, analytically information for sales and etc.  Some of the people ask could excel be useful if i not using it for business? SURE!! i had create an account saving excel spread for a customer, it helps to calculate all the expenses and income he/her use everyday and every month, it helps to understand where's the money use everyday, it helps to save your money and to prevent to use your money in unnecessary method.Below is the sample of the saving spreadsheet. Please enjoy!! and try to like my FB page if it is useful to you!!
FB page>> https://www.facebook.com/pages/Data-And-Financial-Analysis-Excel-Spreadsheet/401496019877613

If you think it is useful to you, download it here>>> http://www.mediafire.com/?my4gkxtqx9a048g