OUTLINE – EXCEL LECTURE 
Dr.Don. Stierman

Basic point, click, drag with the mouse {demonstrate}

Spreadsheet cell entries: label, number, or equation {=}{demonstrate each}.

Operators (arithmetic): + , - , * , / , ^ (Also: brackets in equations)

Format numbers – how and why

Functions: f(x) {demonstrate Function Wizard}

    Note: trig functions require radians as arguments: there are 2p radians in a 360^O circle.

Cell address: Column (alphabetic), row (numerical).

    Relative address reference (c1) vs. absolute address reference ($c$1)

Generate series of numbers {input first 2 values of series, click and drag - demonstrate}

    NOTE: generate increasingly negative values; decimal series; etc., as well as integers.

Cut, copy and paste tools. Copy and paste equations {demonstrate}.

        Paste special - converting equations to values.

Insert and Delete columns or rows: Edit menu {Column - Width}; Insert menu; date and time.

File functions – saving your work; opening files saved previously: using your ZIP disk:

Chart functions: turning numbers into works of art. {demonstrate: selecting range, chart type, format chart elements. General rule: if you see something that has to be changed, point at and double click it.} 

Plan your chart, calculate the numbers needed, go to Chart Wizard. To edit basic chart elements, single click right button with cursor on the chart gets you the menu.

Label and format axes, add title (your name, date due) to chart. PREVIEW BEFORE PRINTING!!! {demonstrate}. Finally, Print chart to turn in before Noon, Monday January 24, or, convert your chart into an image in another application and send it to me attached to email (same deadline). 

Converting Excel charts to digital images is sometimes difficult - I have not found a simple "Save as" command that does it.  I sometimes select, than Copy an image, and then open Word or PowerPoint and then Paste the image into that application.  You may do this instead of printing your chart.  Try it out before spending a lot of time making a nice colored graph that will not show up well when printed on the black & white printers in BO 3051.

 Note: check your chart and compare with solutions displayed on the WWW. This link takes you to images of my graphs of these calculations. Thus you can preview your result before printing it, compare it with your current chart, and decide if additional editing is needed before making the hard copy.  If, in reviewing these instructions, you think you can do what is required without attending the lecture, simply complete the project, save the  spreadsheet and send me the entire file attached to an e-mail message.