Class 9
Notes are in progress and are subject to change

<Log On>

Discourse
Minimize Discourse

Class 9 Outline

Homework

Copy 9wordspread from Class folder to your Groups (shared) folder



Three important uses of spreadsheets - remember these:

  • Calculations
  • Charting
    • can use charts in other applications
    • data analysis-pivot charts
    • Making Art
  • Databases
    • Sorting and Filtering - LABELS vs NUMBERS
    • Connecting to external databases
    • =DATEDIF("03-Dec-1988","01-Oct-2012","Y")
zz

Open a new blank Excel workbook in 9wordspread. Call it Practice and save it .

Ribbon - similar to Word - even has picture tools when a picture is selected

Excel Basics - cells, rows, and data types

Formula bar

Using the Print Preview and Page Setup menu

Practice Spreadsheet:

 Homework: Lynda.trinity.edu

Note: Because the mid-term exam will concentrate on spreadsheets, all EXCEL homework using lynda.com will be done on Windows computers since those are the ones we will use for the exam. Mac users will need to work these tutorials on a PC.

Open lynda.trinity.edu and search on Excel. Find this tutorial package:

Open it and work through the tutorials from Chapter one (Getting Started) through Chapter three (only to the end of Working with Dates and Times - we will go over the IF function in class next week). Take a screen shot of your final tutorial window and upload it to your blog with an analysis of this tutorial - good, bad, ugly. What confused you? What did you like? You will be responsible for this material on quizzes and the midterm.


<Log Off>