1 / 9

Week 3: Introduction to Microsoft Excel Spreadsheet READING: Glade Manual Ch. 1

Learn the fundamentals of using Microsoft Excel, including creating formulas, working with multiple worksheets, graphing functions, and performing statistical analysis.

bperez
Download Presentation

Week 3: Introduction to Microsoft Excel Spreadsheet READING: Glade Manual Ch. 1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Week 3:Introduction to Microsoft Excel Spreadsheet • READING: Glade Manual Ch. 1

  2. EECS 1520 -- Computer Use: Fundamentals Glade Manual • Ch. 1 – Introduction to Excel • There are 5 demonstration models in Ch. 1 • Go to “Resources” “Support Files” “Chapter 1”

  3. EECS 1520 -- Computer Use: Fundamentals Glade Manual – Chapter 1 • Demo 1: - comments worksheet with text - simple addition function - three different types of formulas (see H6, H12, H18) in the demo file - changing values on a spreadsheet – everything instantly updated

  4. EECS 1520 -- Computer Use: Fundamentals Glade Manual – Chapter 1 • Demo 2: - more functions: MIN, MAX, AVERAGE, MEDIAN - introduce “Named Ranges” technique - shape of X, Y and XY is the same - “=X*Y formula” does row-by-row element pair multiplication

  5. EECS 1520 -- Computer Use: Fundamentals Glade Manual – Chapter 1 • Demo 3: - work with multiple worksheets - cell references - translating mathematical formulas into Excel formulas - graph a simple function: g = gravity v = velocity d = distance

  6. EECS 1520 -- Computer Use: Fundamentals Glade Manual – Chapter 1 • Demo 4: - graphs with more than 1 line (or curve) - change parameters (velocity or angle) until you hit the desired target - introduce more new functions: ^, EXP, TAN, COS

  7. EECS 1520 -- Computer Use: Fundamentals Glade Manual – Chapter 1 • Demo 5: - statistical analysis - how to simulate the throwing of a pair of dice? RAND() function – produces a random number in [0,1) COUNTIF – count the number of occurrences of a specified value Example to simulate throwing a die (i.e. generate an integer from 1 to 6 randomly): - RAND() gives 0.3102 - 0.3102*6 = 1.8612 - INT(1.8612) = 1 - INT(RAND()*6)+1 = 2

  8. EECS 1520 -- Computer Use: Fundamentals Glade Manual – Chapter 1 • Homework 1 (Due 11pm next Tuesday): - Exercise 1: • comments worksheet • Summing worksheet • Enter month names: enter “May”, then use fill right command - Exercise 2: • create a title that spans several columns and is centered • Create formulas to allow for adding columns - Exercise 3: • turn a mathematical formula (i.e. cosine function) into an Excel formula • Create a graph • Fine-tuning (i.e. format X- and Y-axis, create title)

  9. EECS 1520 -- Computer Use: Fundamentals Glade Manual – Chapter 1 • Homework 1: - Notes: • To “Format a cell”: “Home” “Cells” “Format” “Format Cells” • To select “Formula View”: “Formulas” “Formula Auditing” “Show Formulas” • To edit or fine-tune a graph: Click on the graph Select “Chart Tools” Select “Layout”

More Related