Introduction to Microsoft Excel Objectives l To define

Introduction to Microsoft Excel Objectives: l To define spreadsheets and explain basic functionality l To introduce the basic features of Excel • • • Vocabulary Entering Data Formatting Data Precision vs. Display Operators & Order of Precedence CS&E 1111 Excel Intro

Spreadsheet: Electronic sheet of paper organized by columns & rows The advantage of an electronic spreadsheet is it allows you to easily change data and have all “related” calculations automatically update. . CS&E 1111 Excel Intro

Spreadsheets in Excel are referred to as worksheets. A workbook file may contain may worksheets. Help Button Quick Access Toolbar Sizing Buttons Home Ribbon Tabs Formula Bar Name Box Column Letter Headings Fx Insert Function Button Contents of Active Cell displayed on Formula Bar Row Numbers Scroll Bars Sheet Tabs Insert Worksheet Button View Buttons Zoom CS&E 1111 Excel Intro

Each box is referred to as a “cell”. Cells may contain Labels, Values or Formulas that result in a value or label. A cell is identified first by its column letter and then by its row number Columns Rows Labels Cell D 2 Contains the Formula = B 2*C 2 CS&E 1111 Excel Intro

One can also write formulas that refer to cells on other worksheets – Sheetname!Cell-Reference input!B 1*input!B 3 + A 1 When referencing a cell on the same spreadsheet as the active cell the sheet name is not required. Sheets may be named and displayed with different colors tabs, The order of the worksheets may be modified as well. CS&E 1111 Excel Intro

File tab – opens menus for opening and saving Files, and modifying Excel Options Quick Access Toolbar can be customized to include icons to frequently Used features such as Print Preview Home Ribbon use to change fonts, justify text, insert rows etc. Ribbons are organized into Groups of similar tasks such as the Font group or the Number group. In addition, there are other ribbons containing groups/buttons for laying out pages using the review features etc. CS&E 1111 Excel Intro

Highlight your data, select a Chart type and Edit & its done! $ 7. 00 $ 6. 00 $ 5. 00 $ 4. 00 $ 3. 00 $ 2. 00 $ 1. 00 $cereal milk eggs cheese meat pasta CS&E 1111 Excel Intro

The “Power” of using Spreadsheet Applications =B 2*C 2 l l Each entry can be related to other values by including cell referencing in formulas. Formula values are automatically updated when a referenced value changes Formulas can be copied Charts can be easily generated CS&E 1111 Excel Intro

Formulas l l l A formula is a sequence of values, cell references and operators that produce a new value. = E 8 + 3*(E 10 - E 11) Formulas always start with an equal sign = In addition a formula can also contain builtin functions like SUM, AVERAGE, IF, COUNTIF, etc. =Sum(A 2: A 8)*2 CS&E 1111 Excel Intro

Things you need to know when writing formulas in Excel Data precision vs. cell display l Types of operators that can be used l Order of precedence of operators =B 2+B 3*B 1/B 8^2 l / ≤ − CS&E 1111 Excel Intro

In order to write Excel formulas we also need to use the correct Operator Symbols Formulas contain two types of components: l Operators: Operations to be performed Arithmetic operators: * / + - ^ Relational operators: >, <, <=, >=, < >, = l Operands: Values to be operated on = B 2 + 5 Addition Operator Operands CS&E 1111 Excel Intro

Precedence of Operators l l l ( ) Parenthesis is a special operator that forces evaluation of the expression inside it first Exponentiation (2^3 8) Arithmetic operators: Multiplication & Division l l Arithmetic operators: Addition & Subtraction l l Multiplication & Division have equal precedence and are evaluated from left to right Addition & Subtraction have equal precedence and are evaluated from left to right Relational operators have a lower precedence than arithmetic operators CS&E 1111 Excel Intro

Precision: number of decimal places stored in the computer. Formatted Display: number of decimal places that appear in a cell Type in a cell : =1/8 display in cell Does the addition appear to be correct in col B? What value results for each - if multiplied by 1000? CS&E 1111 Excel Intro

Formatting affects display not the precise value: Formatting Number Group Percent Currency Decimal Display Commas CS&E 1111 Excel Intro

Values can also be used to display dates l l l Dates are values that can be entered in several formats: January 27, 2013 or 1/27/2013 Excel converts these dates to a numerical representation (1/22/2013 41301) Thus dates may be used in formulas: =A 1–B 1 will result in the value 5 Note: To do arithmetic calculations with dates if you type =1/27/20131/22/2013 directly in a cell it does not interpret it a date – cell references must be used. CS&E 1111 Excel Intro

Walkthrough: Building a Simple Spreadsheet • Entering labels and values • Formatting cells –font, size, style, color, borders, alignment –Numeric Format, Currency, Decimal Places –text wrap, center titles –Column widths, row height • Inserting/Deleting rows and columns and sheets • Writing a simple formula & modify decimal display • Create a simple chart • Sheet tabs –Creating a new worksheets in a workbook (“new sections in a document”, Naming Sheets CS&E 1111 Excel Intro

Microsoft Excel Vocabulary CS&E 1111 Excel Intro

Follow-Assignments: l l Read the chapters of the Course Notes - 1. 1, 1. 2 p. 1 -30 Read ICAPS: pages 1 -6, 11 -14, 20 -27, 37 -39, 45 -49, 67 -71 CS&E 1111 Excel Intro