Excel

= = Microsoft Excel =toc=

=What is it?= =How to create data? = =How to create calculations? = =How to create a Graph? = =How to create a Pivot Table = =Fun Fact = =Video Tutorial = media type="youtube" key="ZTGkN9hq-Co" height="315" width="560"
 * **Microsoft Excel** is a proprietary commercial 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 [|Visual Basic for Applications]
 * 1) In order to create data inside your excel chart you first choose a cellAfter choosing which cell you want to put your data in you simply type in the cell and press enter once you are finished
 * 2) a cell is the rectangular box located by a number that represents the vertical column and a letter that represents the horizontal column for example a cell could be A1, C3, D6
 * 3) After choosing which cell you want to put your data in you simply type in the cell and press enter once you are finished
 * 1) After finishing inserting your data you now can calculate them
 * 2) You first write in your cell the symbol =
 * 3) Next you can start to write out the calculation you want for example if you wanted to get the average of the data you would start to write average and you should then be given the option of choosing that task
 * 4) Once chosen your arrow will turn into a cross which allows you to highlight the data you inserted in for the calculation you want to receive
 * 5) lastly you put on a closing parentheses and select enter to receive your calculation
 * 1) After finishing to insert your data you can create a graph
 * 2) <span style="font-family: 'Times New Roman',Times,serif;">You start by going to Insert at the top of your tool bar
 * 3) <span style="font-family: 'Times New Roman',Times,serif;">Next your given array of options to create any graph you want from the data you inserted into your chart
 * 4) <span style="font-family: 'Times New Roman',Times,serif;">For example if we wanted to create a line graph we could go to the option where it says line and select an option of the various line graph given
 * 5) <span style="font-family: 'Times New Roman',Times,serif;">After selecting the specific line graph you then click it and it then appears your data in the form of a line graph
 * 1) <span style="font-family: 'Times New Roman',Times,serif;">To create a Pivot table after inserting your data first go to Insert on your tool bar
 * 2) <span style="font-family: 'Times New Roman',Times,serif;">Next go to the option that says pivot table which located to the underneath the tool bar to very left side
 * 3) <span style="font-family: 'Times New Roman',Times,serif;">It then asks the range of data you want to insert into your toolbar so select what information you want to select into your toolbar by highlighting the information wanted
 * 4) <span style="font-family: 'Times New Roman',Times,serif;">Next your pivot table is created and you can start to select what information from your ranged data and select the fields you want to specifically look at
 * 5) <span style="font-family: 'Times New Roman',Times,serif;">You can then decide to put those selected fields into rows or columns or both by selecting the field and then dragging them into the rows and columns
 * 6) <span style="font-family: 'Times New Roman',Times,serif;">You can then later drag them into the values box and get the max, avg, sum of the data you dragged into it
 * 7) <span style="font-family: 'Times New Roman',Times,serif;">It will automatically have you started on the sum value on the default settings so to change it click on the field in the values box and then select value field settings and then it will give you the option to select what calculation you want to receive
 * <span style="font-family: 'Times New Roman',Times,serif;">To easily find a calculation select a cell and then go to the functions key which is symbolized (fx) next to your formula bar
 * <span style="font-family: 'Times New Roman',Times,serif;">Cut, copy and pasting are very easy to use on excel.