Data Tables Arrays Macros VBA user subroutine to automate repetitive operations in excel Keyboard shortcut fast way to make the macro run CTRL letter Activate ID: 579378
Download Presentation The PPT/PDF document "Macros" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
MacrosData TablesArraysSlide2
MacrosVBA user subroutine to automate repetitive
operations
in
excel
Keyboard
shortcut
: fast way to
make
the macro
run
(CTRL+ «
letter
»)
Activate
the macro
Attach
macros
to a
button
on the
Ribbon
or the
Quick
access
toolbarSlide3
Data tablesTo do complex sensitivity
analysis
One
dimensional
(
one
variable
is
changed
)
Two
dimensional
(
two
variables
are
changed
)
Put
formulas
on the top
row
and the
variable
we
wish
to
vary
in the
column
Highlight
the
table
area
Data/
sensitivity
analysis
/ Data
table
Select the
cell
input in
row
or in
columnSlide4
Data TablesTwo dimensional (two
variables
are
changed
)
Upper
left
hand
corner of the
Table
contains
the formula
Two
variables
we
wish
to
vary
in the
adjacent
column
and
rowSlide5
Arrays, matricesRow vector, column
vector
,
matrix
Matrix
operations
(
addition
, scalar
multiplication
)
Transpose
(
matrix
)
matrix
multiplication
:
Mmult
(
matrix
1;
matrix
2)
Inverse of a
matrix
:
Minverse
(
matrix
)
CTRL+SHIFT+ENTERSlide6
Solving systems of symultaneous linear equations
Ax
=b
A
matrix
of
coefficients
x=
vector
of
unknowns
b=
vector
of
constants