Class 9 Notes are in progress and are subject to change

<Log On>

Discourse
Minimize Discourse

Class 9 Outline

• Quiz Review 
• Word Advanced Formatting (review Tables)
• Introduction to Excel

Homework

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

Three important uses of spreadsheets - remember these: Calculations Simple (adding) and Complex (differential equations) Analysis and "What If?" Questions - Guesstimates 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")

• Show Examples -  Attendance, Guitar, Advanced Functions and Formulas, Product list. In product list, find which salesman sold 25 cases of apples.

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

• Name Box
• Formula Bar
• Columns (60,000
• Rows (1,000,000+)
• Worksheets

Excel Basics - cells, rows, and data types

Formula bar

• Entering and moving information
  • Type text in A1 and A2 - type in B1 - text is covered up by new entry
  • Double-click to edit (F2)
  • Enter
  • ctrl+enter
  • number keys
  • moving blocks of cells
  • copying - ctrl+drag
  • Escape key
• Autofill & Format Painter
  • Autofill black cross works up or down
  • Works with abbreviations
  • Numbers - ctrl+drag or create sequence
  • Custom list

• My Dear Aunt Sally
• Formulas and Functions both ALWAYS start with the =sign

Using the Print Preview and Page Setup menu

Practice Spreadsheet:

• Guesstimates
• KRTU Fundraiser
• Camp Capers
• Accessories 2
• Ice Cream

 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>