Excel is software used for storing, organizing and manipulating data. It is useful for doing cell based calculations, making pivot tables, graphs and many other functions.
Topics covered in this LibGuide
This video provides a basic introduction to Excel 2013. The topics included in the video :
A one-variable data table is part of the 'What If Analysis' tool in Excel. It helps to compute the possible results as the value of one variable changes in the particular formula that is used to compute the results. The following video shows how to compute the possible monthly payments for a range of different interest rates for the loan.
A two-variable data table is quite similar to the one-variable data table. The only difference is that, instead of using one variable, a two-variable data table computes the possible results in the change of two variables from the formula that is used to calculate the results. It helps to determine how a change in those values from the formula might change the results' values. The following video explains how to compute the change in value of the monthly payment for a loan changing both the rate and loan amount at the same time.
The scenario manger is also part of the 'What If Analysis' tool in Excel. It helps to create different scenarios by using the input values from the formula that is used to calculate the results. The following video shows how to create different scenarios using the scenario manager in excel 2013.
The following videos show:
How to make bar, column, and pie charts
How to make a line chart
How to plot scatter charts
Getting equation and r-squared values from charts
Tables in Excel
The following video shows: