Introduction to
Programming:Part 1 Excel
Basics
Future Value
investmentperiod
-
Investment. (1 + interestrater
Reference
Absolute reference: *A$1 -
$A$1
Mixed reference: 181 -
81
8A 1 -
$A2
(i
Ranges
*
amples: =Sum(D1:27
-Max /A2: A5, A8:A10
->
SumMax/A1:251, Min/An:c5/-> Nested Functions
If -
then
-
else
->
llogical fest, value if true, value iffalsel
Lookup/Loohup
fetical horizontal
->
Koohup/ohup value, range, column indes, rangelookupf
->
value you want to
lookup
of cells
range
-
-
number of the column
->
"False"for exact result
Koohup
-
XLoohup/oohup value, bohup array, return array
->
value you want
-
where to look
value to return
range containing
-
Goal Seek
Set CU: Cell thatcontains formula /optimal result
%o value: Answer you're looking for
B cel: Number to
y
changing change
, Using Solver
Set can't
variable that change
->
->
Seit result to Min, Max or specific
->
Put variables are
that suposed
to
change
Set all the constaints
->
->
Check box for non-negative result
->
Always putGRC Nonlinear
Pivot tables Pivot chart
Change Value Format Summarizing by
carculated Fields
calculate
Use
categorys to
->
new one's
Programming:Part 1 Excel
Basics
Future Value
investmentperiod
-
Investment. (1 + interestrater
Reference
Absolute reference: *A$1 -
$A$1
Mixed reference: 181 -
81
8A 1 -
$A2
(i
Ranges
*
amples: =Sum(D1:27
-Max /A2: A5, A8:A10
->
SumMax/A1:251, Min/An:c5/-> Nested Functions
If -
then
-
else
->
llogical fest, value if true, value iffalsel
Lookup/Loohup
fetical horizontal
->
Koohup/ohup value, range, column indes, rangelookupf
->
value you want to
lookup
of cells
range
-
-
number of the column
->
"False"for exact result
Koohup
-
XLoohup/oohup value, bohup array, return array
->
value you want
-
where to look
value to return
range containing
-
Goal Seek
Set CU: Cell thatcontains formula /optimal result
%o value: Answer you're looking for
B cel: Number to
y
changing change
, Using Solver
Set can't
variable that change
->
->
Seit result to Min, Max or specific
->
Put variables are
that suposed
to
change
Set all the constaints
->
->
Check box for non-negative result
->
Always putGRC Nonlinear
Pivot tables Pivot chart
Change Value Format Summarizing by
carculated Fields
calculate
Use
categorys to
->
new one's
