Analytical Skills for Business Using Excel

HideShow resource information
#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

Other cards in this set

Card 2

Front

#DIV/0

Back

Division by zero is in the formula.

Card 3

Front

#NAME?

Back

Preview of the front of card 3

Card 4

Front

Absolute Cell Referencing

Back

Preview of the front of card 4

Card 5

Front

Relative Cell Referencing

Back

Preview of the front of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Microsoft Excel 2010 resources »