Excel 2013: Basic formulas, basic charts & graphs, and output.
SECTION 1 GAMEPLAN
Info Lookups
Basic Formulas
DISCUSSION
Formulas - Formula Tab
Excel allows you to handle both simple and complex mathematical calculations, such as general ledger work, comparison tables, averages, and much more.
You can quickly set a sum for a row or column of numbers.
You can create a function on your own, if you write your own calculations.
You can choose from several types of calculation info, like financial, date, math, and more. This is dependent on you knowing what you want the document to accomplish.
You can set calculation options, based on selecting a column, row, or specific cells of data.
You can use formulas to change the appearance of data, like concatenating.
Cell References are a way to refer to the contents of a cell.
Absolute: Absolute references remain constant, no matter where they are copied
Relative: Relative references change when a formula is copied to another cell.
Selection: You select one or more cells while creating a formula or a location reference in another table and/or worksheet.
Named: You can Define a Name of a cell so that the cell remains stable in a formula that you copy and paste for further use in other cells in a column. This would be an Absolute reference. Otherwise, the pasted formula will changed the cell's location reference to be relative to the new row it is seeking to create the formula for. Example: =Fee*20, where the cell I5 hase been named FEE, is more stable than =I5*20.
Circular Reference: This happens when a formula is trying to calculate itself, and you have an Excel feature called iterative calculation turned off. It can also happen during indirect references in a formula. Check it out!
DEMO
Modify a basic Excel spreadsheet document to look at basic Excel cell lookups and formulas.
Download formulabasics.xlsx and
save it in your MIC102e/demos folder under the same name.
A pivot table can automatically sort, count total or give the average of the data stored in one table or spreadsheet and display the summarized data results in a second "pivot table".
Pivot tables can also be useful for creating unweighted cross tabulations.