rock out with excel basics summer 2007 janie hardt [email protected]
TRANSCRIPT
![Page 2: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/2.jpg)
Spreadsheet Computer equivalent of a paper ledger sheet
Allows manipulation of data and number calculation
Data entered Numbers Formulas Text
![Page 3: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/3.jpg)
Components Rows- horizontal lines Columns- vertical lines Grid rectangles are cells Sheets
![Page 4: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/4.jpg)
![Page 5: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/5.jpg)
![Page 6: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/6.jpg)
Highlight multiple cells or single cell
Fill cell contents into cells below or to the right
Drag contents of cell to any other cell
Place the cursor into the Formula bar to edit an equation or function
Cursor Styles
![Page 7: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/7.jpg)
Movement
Enter- Down Tab- Right Shift Enter- Up Shift Tab- Left
![Page 8: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/8.jpg)
Symbols
+ Addition - Subtraction * Multiplication / Division = Used before an equation : Separates first and last number in a
range of numbers , Separates nonadjacent numbers
![Page 9: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/9.jpg)
Formatting
All text and numbers can be formatted using the formatting toolbar.
1. Resize
2. Change style of font
3. Change color of font
4. Change position of font
5. Format numbers
23
5 54
![Page 10: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/10.jpg)
![Page 11: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/11.jpg)
Merge and Center Icon
Allows text to be centered on spreadsheet
across several cells
![Page 12: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/12.jpg)
Format Numbers
![Page 13: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/13.jpg)
Select Format, Cells, Choose style
![Page 14: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/14.jpg)
Accounting Dollar sign is placed on the left of the column Underline for single line Hold down Shift key and U for double line
![Page 15: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/15.jpg)
Row and Column Size
Increase or decrease by dragging Increase or decrease by selecting Format
from the toolbar and choosing Row or Column Increase or decrease number
![Page 16: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/16.jpg)
![Page 17: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/17.jpg)
![Page 18: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/18.jpg)
Formulas =A2+B2 =SUM(A2:D2)
(A2 is start of a cell range and D2 its end). Identifies the calculation needed to place the result
in the cell it is contained within. A cell containing a formula has two display
components; 1. Formula itself 2. Calculated value.
Must always press Enter after formula or data is entered
![Page 19: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/19.jpg)
![Page 20: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/20.jpg)
Calculated Value
Formula
![Page 21: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/21.jpg)
Functions A built in equation
Insert, Choose function
Choose function icon on formula bar
![Page 22: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/22.jpg)
Select your function from a list
![Page 23: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/23.jpg)
Add the cell range and click OK
![Page 24: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/24.jpg)
AutoSum
Allows the addition on several cells without entering a formula
Click empty cell below values then AutoSum icon.
Sum will appear in that cell.
Select the cells including cell where sum to appear, click AutoSum icon ∑ on toolbar and sum will appear in the last cell selected
![Page 25: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/25.jpg)
Selected cellsThen icon.
Selected single cell then icon.
![Page 26: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/26.jpg)
Charts
Select data to be graphed and choose Chart Wizard icon.
Select chart.
![Page 27: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/27.jpg)
![Page 28: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/28.jpg)
Daily Fundraiser
$0.00
$50.00
$100.00
$150.00
$200.00
$250.00
Day 1 Day 2 Day 3 Day 4 Day 5 Total
Days
Am
ou
nt
Brow n
Jones
Ricks
Little
Riddle
![Page 29: Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us](https://reader035.vdocuments.us/reader035/viewer/2022062619/5515842055034691418b5722/html5/thumbnails/29.jpg)
Web Sites
http://www.forsythcountyschools.org/kadkins/abc.htm
http://www.internet4classrooms.com/index.htm
http://www.fi.edu/fellows/fellow4/may99/ss-procedure.html