Analytical Skills for Business Using Excel 2.0 / 5 based on 2 ratings ? ICTMicrosoft Excel 2010UniversityNone Created by: Jafar SalamiCreated on: 21-11-14 19:05 #VALUE! Wrong type of data in the formula or function, such as trying to add numbers and text. 1 of 13 #DIV/0 Division by zero is in the formula. 2 of 13 #NAME? Unrecognisable name, such as a misspelt function name. 3 of 13 Absolute Cell Referencing It stick to the same cell, regardless of how you drag or copy it. E.g. $A$3 4 of 13 Relative Cell Referencing Relative cell reference identifies the location of a cell. E.g. C1 5 of 13 Range names Makes excel formulas readable. 6 of 13 & (Ampersand) Connects two or more values to produce one continuous text value. E.g. =F1&" "&G1&" "&H1 7 of 13 Function A function is a present formula in Excel. Function begin with an equal sign (=) followed by the functions name an it arguments. 8 of 13 Outlining A good solution for printing a selection of your spreadsheet. 9 of 13 Goal Seek Change an input to get a desired output (value) when it depends on the input. 10 of 13 Solver Change multiple inputs simultaneously to get a desired output when it depends on the inputs. 11 of 13 Pivot tables Fast summaries for large sets of data. 12 of 13 Scenarios Very useful "what if?" to use with your business model to analyse different business situation. 13 of 13
Comments
No comments have yet been made