Unit+5+Excel


 * Subtotals**

media type="file" key="Movie.wmv" align="center" To have a constant cell in excel you must first select the cell you want to use. Then click the key F4. If two money signs don´t appear (one before the letter and one after it) you must insert the money signs. For example: Before F4, cell number and letter is D6 after F4 the signs are $D$6. That is how you lock a cell in Excel. media type="file" key="use of absolute reference.wmv" width="300" height="300" This function helps a lot if you want to find the minimum amount, this can be usedx in several things for example my table you can get the minimum quantity, the minimum final price, or the minimum cost. This function is much easier to use than writing the whole formula that could confuse you or you make a mistake and get it wrong. 2. MAX
 * Use of absolute references (constant cells)**
 * Functions of excel**
 * 1) MIN

This functions helps when you want to get maximum amounts, for example maximum amount sold, maximum quantity, etc. This is better than making the formula by the above reasons and because you save time.

3. AVERAGE This function helps to find the average amount on the amounts given. For example you can find the average amount won, average amount of quantity, the average of final prices, the average amount spent, etc. This is better than the formula because you don’t need to use the whole formula.

4. SUM

This function helps on finding the sum of all the amounts you choose added. You can use it to find the total sum of the items, the total sum of items, the total amount paid, etc. This is better than adding the amounts one by one saving time or even not making mistakes because its all at once.

5. If Statements

The if statements are formulas that help you categorize information, for example you want to know if something is overvalued you could use the if statement to point out what ones are overvalued to your opinion. This is very helpful to find and categorize values. This is also much easier than seeing one by one, it is also much faster than the other way. media type="file" key="funcations of excel.wmv" width="300" height="300"

Macros

To add a macro using exel you first need to have the table that you need to add the macro on. Then, on the menu bar you choose the option "View" and then the option "Macros". Start recording your macro and once you are finished go to the option "Macros" again and stop recording. Insert a figure and add text to it, name it as you named your macro. Then right click in the figure and assign a macro. Assing the one you just did and each time you click on the figure, you'll have the product of your recorded macro.

media type="file" key="Macros-Exel.wmv" width="300" height="300" Pivot Tables Pivot tables help you to orginize huge amounts of data into a more versatile table. Once you have your table go to "Insert" "Pivot Table". Once you have inserted your Pivot Table you can sort, fillter and manege certain data of your original table. media type="file" key="Pivot_Table.wmv" width="300" height="300" 7. Paste with link

To do this you must first to a chart in Excel and copy it into a Word document. Usually a chart will be pasted in as a picture. So in the lower right corner of the picture there is a square which when pressed will show many options. You must press the option that says Chart Linked to Excel Data. Then you can go to Excel and modify the chart and itwill modify the chart in Word. media type="file" key="Paste with link.wmv" width="300" height="300" the following video will explain what a column graph is, its uses, and a example of one and how to do one.media type="file" key="Movie_0002.wmv" width="330" height="330" media type="file" key="Division and EXponential .wmv" width="300" height="300" this video explains how a scatter plot works and what it is, with an exammedia type="file" key="Movie_0004.wmv" width="348" height="340" align="left"ple in the video

media type="file" key="Multiplication.wmv" width="300" height="300"

This video shows and explains how to use a pie graph and an example of one media type="file" key="Pie Graph.wmv" width="300" height="300" align="center"

media type="file" key="how to sort_x264_WMV V9.wmv" width="300" height="300" align="center"

How to sort media type="file" key="how to filter with and_x264_WMV V9.wmv" width="300" height="300" align="center"

How to filter with and media type="file" key="How to filter with or_x264_WMV V9.wmv" width="300" height="300" align="center"

How to filter with or media type="file" key="How to filter with asterisk_x264_WMV V9.wmv" width="300" height="300" align="center"

How to filter with wildcards * media type="file" key="How to filter with question_x264_WMV V9.wmv" width="300" height="300" align="center"

How to filter with wildcards ? Line Graph The next videoshows you how to make a line graph from a categorival data table. media type="file" key="Movie.wmv" width="300" height="300" align="center"