Summary Programming notes

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