Downloaded 70 times
Uploaded byWest Haven Public Library
WHPL Introduction to Excel
This document provides an overview of Microsoft Excel and spreadsheets. It explains that Excel is used to create and manage spreadsheets, which organize data into a grid of columns and rows. Formulas and functions allow spreadsheets to perform calculations automatically. The document describes spreadsheet basics like columns, rows, cells, and formatting options. It also covers creating and saving files, using the ribbon toolbar, and inserting formulas and functions to calculate values.
More Related Content
Similar to WHPL Introduction to Excel
WHPL Introduction to Excel
- 1. MICROSOFT EXCEL OFFICE 2010 WEST HAVEN PUBLIC LIBRARY WESTHAVENPL.ORG
- 2. EXCEL? Used tocreate spreadsheets
- 3. SPREADSHEET? Similar to apaper ledger Grid of columns and rows Computes numbers
- 4. ADVANTAGES The COMPUTER doesthe calculations! Use of variables provides flexibility No erasing No re-entering numbers
- 5. USES Manage Finances Create lists(sortable) Integral part of Microsoft Office • Sought after job skill Address book/list • Mail Merge
- 6. Spreadsheets consist of • columns • rows • and their intersections are called cells In each cell there may be the following types of data • text (labels) no numerical value • number data (constants) 0123456789 • formulas (mathematical equations) c4/a2,a4
- 8. Quick Toolbar Title Bar Ribbon/Menu Bar Tool Bar Current Spreadsheet
- 9.
- 10.
- 11.
- 12.
- 13. EACH COLUMN HASA LETTER Each row has a number
- 14. Each cell isnamed by column and row C4
- 15. TITLE BAR Minimize Maximize Displays name of the current document Close New/blank documents are named “Book1”
- 16. QUICK TOOLBAR Undo Save Redo
- 17.
- 18. FILE MENU Save current file Open previous files Create new from template Print
- 19. SAVING YOUR SPREADSHEET Chooselocation to save in Name the Document Click save
- 20. RIBBON/MENU BAR Toolbar • Each tab on the ribbon changes the toolbar • Each tab provides a different selection of tools • File, Home, Insert, Page Layout, Formulas, Data, Review, View
- 21. HOME TAB • Font • Alignment • Size • Angle • Bold, Italic, Underline • Indent • Color Cell • Color font
- 22. HOME TAB • Styles • Number Format • Conditional Formatting • General • Format as Table • Currency • Cell Styles • Date • Time • Percent
- 23. HOME TAB • Functions • Sort & Filter • Sum • Sort A to Z • Average • Sort Z to A • Count Numbers • Filter • Max • Min
- 24. INSERT TAB Insert graphsand charts by selecting cells
- 25. FORMULAS Used to calculatea value Formulas MUST BEGIN with an equal sign (=) Mathematical Equations or functions Reference information by cell number (a2,a3) • No need to change equations if data changes
- 26. FORMULAS (CALCULATIONS) Addition + Subtraction - Multiplication * Division /
- 27. FORMULA EXAMPLES 5 *6 = 30 =A1*A2
- 28.
- 29. FORMULAS (FUNCTIONS) =SUM(a1,a2,a3) •Adds the values in cells a1, a2, a3 =SUM(a1:a3) • Use : to add all cells in this range
- 30. FORMULAS (FUNCTIONS) =AVERAGE(A1:A4) • Returnsaverage of cells a1, a2, a3, a4
- 31. FORMULAS (FUNCTIONS) =max (a1:a4) • Returns the highest number in the list =min (a1:a4) • Returns the lowest number in the list =count (a1:a4) • Returns the number of values =pmt (a4/12,a5,-a3) • Calculate monthly payments with interest
- 32. FORMULAS TAB Step bystep functions
- 33. Visit our websitefor additional information and class materials www.westhavenpl.org