lecture

HW: do Numbers n' Strings in codeacademy

we saw variable in programming languages in general
how about in Excel?

how about in VBA?
Dim myName
is equivalent to
var myName;
from codeacademy

it won't work in the Immediate window, so we need to memorize for now

I CAN say:
myName = "Joshua"

and that wil;l work in the Immediate window


=NJ!$D$11
better
=NJ!D11

currentStudentMidterm:
=Sheet4!$B5

we did the simple stuff, including names for relative and mixed refs
what is left?
* indirect
dynamic names (later)
names for arrays

=INDIRECT("A1")

we finished ch 3 in formulas book (for now)

HW: read through ch 2 in grauer


ch 6 is date and time functions

date in Excel is REALLY just a number
'it is an offset from Jan 0, 1900