whpl introduction to excel
DESCRIPTION
Introduction to Excel computer class taught at the West Haven Public Library. www.westhavenpl.orgTRANSCRIPT
![Page 1: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/1.jpg)
MICROSOFT EXCELOFFICE 2010
WEST HAVEN PUBLIC LIBRARY
WESTHAVENPL.ORG
![Page 2: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/2.jpg)
EXCEL?Used to create spreadsheets
![Page 3: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/3.jpg)
SPREADSHEET?
Similar to a paper ledger
Grid of columns and rows
Computes numbers
![Page 4: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/4.jpg)
ADVANTAGES
The COMPUTER does the calculations!
Use of variables provides flexibility
No erasing
No re-entering numbers
![Page 5: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/5.jpg)
USES
Manage Finances
Create lists (sortable)
Integral part of Microsoft Office
• Sought after job skill
Address book/list
• Mail Merge
![Page 6: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/6.jpg)
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
![Page 7: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/7.jpg)
![Page 8: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/8.jpg)
Title BarQuick Toolbar
Ribbon/Menu Bar
Tool Bar
Current Spreadsheet
![Page 9: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/9.jpg)
SPREADSHEET BASICS
![Page 10: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/10.jpg)
COLUMNS
![Page 11: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/11.jpg)
ROWS
![Page 12: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/12.jpg)
CELLS
![Page 13: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/13.jpg)
Each row has a number
EACH COLUMN HAS A LETTER
![Page 14: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/14.jpg)
Each cell is named by column and row
C4
![Page 15: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/15.jpg)
TITLE BAR
CloseDisplays name of the current documentNew/blank documents are named “Book1”
Minimize
Maximize
![Page 16: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/16.jpg)
QUICK TOOLBAR
Save
Undo
Redo
![Page 17: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/17.jpg)
FILE TAB
![Page 18: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/18.jpg)
FILE MENU
Save current file
Open previous files
Create new from template
![Page 19: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/19.jpg)
SAVING YOUR SPREADSHEET
Name the Document
Choose location to save in
Click save
![Page 20: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/20.jpg)
RIBBON/MENU BAR
• 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
Toolbar
![Page 21: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/21.jpg)
HOME TAB
• Font
• Size
• Bold, Italic, Underline
• Color Cell
• Color font
• Alignment
• Angle
• Indent
![Page 22: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/22.jpg)
HOME TAB
• Number Format
• General• Currency• Date• Time• Percent
• Styles
• Conditional Formatting• Format as Table• Cell Styles
![Page 23: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/23.jpg)
HOME TAB
• Functions
• Sum• Average• Count Numbers • Max• Min
• Sort & Filter
• Sort A to Z• Sort Z to A• Filter
![Page 24: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/24.jpg)
INSERT TAB
Insert graphs and charts by selecting cells
![Page 25: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/25.jpg)
FORMULAS
Used to calculate a 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
![Page 26: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/26.jpg)
FORMULAS (CALCULATIONS)
Addition +
Subtraction -
Multiplication *
Division /
![Page 27: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/27.jpg)
FORMULA EXAMPLES5 * 6 = 30
=A1*A2
![Page 28: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/28.jpg)
FORMULA
![Page 29: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/29.jpg)
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
![Page 30: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/30.jpg)
FORMULAS (FUNCTIONS)
=AVERAGE(A1:A4)
• Returns average of cells a1, a2, a3, a4
![Page 31: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/31.jpg)
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
![Page 32: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/32.jpg)
FORMULAS TAB
Step by step functions
![Page 33: WHPL Introduction to Excel](https://reader035.vdocuments.us/reader035/viewer/2022062614/5459c130b1af9f40378b54af/html5/thumbnails/33.jpg)
Visit our website for additional information and class materials
www.westhavenpl.org