Plan for today:
* date and
time arithmetic
* conditional formatting
pivot tables
* goal seek vs.
solver
advanced filtering

excel practice exams

web pages

begin Microsoft Access

----

* date and
time arithmetic

a Date is a whole number (integer) representing the number of days since January 0, 1900

we can do simple arithmetic using + - / *
and also, there are date functions such as Today(), Day(), Month(), Year(), Date()

Time is represented by a fraction of a day
we can do simple arithmetic using + - / *
and also, there are date functions such as Now(), Minute(), Second(), Hour(), Time()

goal seek vs. solver

Goal seek has limitations
goal seek only lets you fiddle with ONE number
does not allow you to apply constraits to reflect reality
only lets you "seek" towards a specific number, rather than, say, a maximum or a minimum

Instead, solver

Solver is a add-in, comes free with Excel

Excel exam, two weeks from now