Goal seek
 good, but limited
  -- can only set the target cell to a specific value
  -- can only fiddle with one other cell
  -- no constraints
Solver
http://cs101.wvu.edu/media/1/10/19/35/Excel_Chapter_8.pdf

Pivot Tables

Text to Columns

in excel
hidden programming language
called VBA
visual basic for applications

imperative programming languages
Alt-f11: VBA editor
Ctrl-G immediate window
? means print

? 5
 5
? 5 + 2
 7
? 50 + 100 / 2
 100
? "Ryan"
Ryan
? Len("Ryan")
 4
myName = "Josh"
? myName
Josh


Excel Exam
Sun, Apr 22

First Web assignment:

1) Write up a single webpage about your favorite sport.
Use 2 pictures to illustrate it. Some text should be:
* bold
* italics
* bold italics
* underlined

Also, include a link to another webpage somewhere on the Web
which discusses your sport.

Use WinSCP to make this web page.



1) We logged in
2) We created public_html folder. (one time only)
3) We dbl-clicked on public_html to enter that folder
4) We created hello.html
5) We changed the properties on hello.html
6) We saw that web page in a web browser
http://cs12.cs.qc.cuny.edu/~loginname/hello.html

Prepare for the Excel exams

Excel practice exam files,

Practice Excel Exam 1.
Practice Excel Exam 2.
Practice Excel Exam 3.
Practice Excel Exam 4.
Practice Excel Exam 5.
Excel Review Presentation.


Walkthroughs:
Exam 1



Exam 2


Exam 3


Exam 4


Exam 5

mid function
in Excel
substitute in Excel
UPPER and LOWER in Excel
for next time, in codecademy,
"5. Editor and Arrays"

reference styles
A1
R1C1 reference style

serial numbers
date is offset, or number days, from Jan 0, 1900

for next week, prepare
Numbers n' Strings on codecademy

next week, section B in ch 5