1 / 12

Introduction to MS Excel: Mastering Spreadsheet Basics

This course provides a comprehensive introduction to Microsoft Excel for beginners. Learn to identify the functions of spreadsheets, explore their various applications, and understand the fundamental differences between columns and rows. Gain the skills to locate specific cell references, input formulas for calculations, and recognize different types of data that can be entered into spreadsheets. Enhance your ability to utilize Excel for managing grades, payroll, investments, and personal finances effectively.

camille-vaughn
Télécharger la présentation

Introduction to MS Excel: Mastering Spreadsheet Basics

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. Spreadsheets 101 Using MS Excel

  2. Objectives • Identify the functions of a spreadsheet. • Identify how spreadsheets can be used. • Explain the difference in columns and rows. • Locate specific cell references. • List the types of data that can be put into a spreadsheet. • Input a formula for adding and averaging data.

  3. What is a Spreadsheet? A program that allows you to use data to forecast, manage, predict, and present information.

  4. Spreadsheet Uses School: Student grades, payroll Sports: individual and team statistics Personal: checkbook, household expenses Business: payroll, investments

  5. Introduction to Excel Spreadsheets are made up of : • columns – identified with alphabetic headings • rows - identified with numeric headings • and their intersections are called cells • (Cell references: B4, A20)

  6. A1 Columns B3 E7 Rows

  7. Introduction to Excel In each cell there may be the following types of data: • text (labels) • number data (constants) • formulas (mathematical equations that do all the work)

  8. Data Types Text Formulas Data

  9. Formulas ALWAYS begin with an = sign. This “tells” Excel that a calculation will need to be performed. Reference cells, NOT the numbers in them!

  10. Built in Functions : =sum Use of colon = “through”

  11. To change column width: Put cursor on line between two columns and drag to the right to the desired width

  12. Familiar Toolbar

More Related