EXCEL

Hi...everyone. Today i want to share my second lesson in computer class which is EXCEL. I believe eveyone had heard "Excel" at least once in their lifetime (except people who live long time ago before this spreadsheet was created...haha). Let me give you a brief  what is excel....

Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications). Excel forms part of Microsoft Office. The current versions are Microsoft Office Excel 2010 for Windows and 2008 for Mac.

This the five latest versions of Microsoft Excel was produced since 2001.

VERSION	YEAR
Excel 2010(version 14)	2010
Excel 2007(version 12)	2007
Excel 2003(version 11)	2003
Excel 2002(version 10)	2002

If you want to know more about Microsoft Excel and get tutorial, you can go to this website below;
http://www.free-training-tutorial.com/excel-books.html


When you open Microsoft Office Excel 2010, you will see this spreadsheet.

Like some other spreadsheet applications, Microsoft Excel supports charts, graphs or histograms generated from specified groups of cells. The generated graphic component either can be embedded within the current sheet, or added as a separate object.



By using Microsoft Excel, i can organize data and. From the data, we can graph it to view the data in convenient way. We also can make analysis from the graph and estimate some datas.

First, we have to insert all the data needed and related what we are going to do with it. Then we can graph it by using chart from the insert menu. There a bunch type of chart given in the spreadsheet such as column, line, pie, bar, area, scatter line and many more. This is some examples of excel spreadsheet that using pie and bar chart that can be use to compare values across categories.

I use Microsoft Excel to graph linear relationship between concentration of a colored compound in solution and the light absorption of the solution in Beer's Law.

Beer's Law states that there is a linear relationship between concentration of a colored compound in solution and the light absorption of the solution. This fact can be used to calculate the concentration of unknown solutions, given their absorption readings. First, a series of solutions of known concentration are tested for their absorption level. Next, a scatter plot is made of this empirical data and a linear regression line is fitted to the data. This regression line can be expressed as a formula and used to calculate the concentration of unknown solutions.