1 / 10

Introduction to Microsoft Excel: Spreadsheet Program

Learn the basics of Microsoft Excel, including organizing data, performing calculations, creating graphs, and automating tasks.

sdobbins
Download Presentation

Introduction to Microsoft Excel: Spreadsheet Program

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. Technology 3 Using Tables, Cells, Formulas in Excel Creating Web Pages with Tables and embedded objects. Programming with Scratch Introduction to Open Source Solutions for the Classroom

  2. Greetings and Welcome to Tech 3! • Log in as yourself • Go to your home directory and make the following Folder: • Lastname Tech 3 • In your “Lastname Tech 3 folder you need to make the following folders: • Excel Exercises • Web Pages • Scratch Projects

  3. Section 6 Using Microsoft Excel (Review from Tech 1) Created by: Christopher Michaud Nebo Elementary: May 2007

  4. Microsoft Excel: Spreadsheet Program • Organizes lists of data • Performs basic and advanced mathematical and statistical calculations. • Produce graphs of data • Automate certain tasks (ex: Schedule) • Data collection and analysis Created by: Christopher Michaud Nebo Elementary: May 2007

  5. Microsoft Excel: Key Vocabulary • Cell: Smallest unit where data can be entered. • Column: A stack of cells. Labeled with a letter (Ex: A, B, C . . .) • Row: Horizontal line of cells. Labeled with a number. • Worksheet: Collection of Columns and Rows • Cell Label: Column letter and Row Number (Like a grid) (Example: B2) • Formula: Mathematical expression to calculate a value of a range of cells. Created by: Christopher Michaud Nebo Elementary: May 2007

  6. Microsoft Excel Layout “Michaud” is in cell “B3” Row Numbers: Column Letters Worksheet Name Created by: Christopher Michaud Nebo Elementary: May 2007

  7. Example: List of Data (Names, Class Roster) Created by: Christopher Michaud Nebo Elementary: May 2007

  8. Example: Data Analysis (CRCT scores) Created by: Christopher Michaud Nebo Elementary: May 2007

  9. Example: Automation and formulas (Schedule) Created by: Christopher Michaud Nebo Elementary: May 2007

  10. Microsoft Word Prose or writing Organizing pictures and text on paper. Newsletters Programs Microsoft Excel Lists in categories Sorting Data Creating Graphs Analyzing Numbers Math Functions Schedules Checklists Word vs. Excel Created by: Christopher Michaud Nebo Elementary: May 2007

More Related