1 / 15

Back to Basics: Excel

Back to Basics: Excel. Tech Tuesdays. Open a new spreadsheet Enter data Use formulas Change cell size Sort data. Format border and numbers Add or delete rows Align data Create a chart Set Print Area. What will we learn today?. Opening a Spreadsheet.

camdyn
Download Presentation

Back to Basics: Excel

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. Back to Basics: Excel Tech Tuesdays TechTuesdays

  2. Open a newspreadsheet Enter data Use formulas Change cell size Sort data Format border and numbers Add or delete rows Align data Create a chart Set Print Area What will we learn today? TechTuesdays

  3. Opening a Spreadsheet • Start>Programs>Microsoft Office>Microsoft Excel • Spreadsheet - basic document in Excel • Cell - square where you put data (A1, B46, etc.) TechTuesdays

  4. Enter Data: • In A1: type NAMES • A2: type our first volunteer’s name (first name only) • A3 - A4: type the other 2 names • B1: type TV TIME? • B2 thru B4: type their answers TechTuesdays

  5. Using Formulas: Cell Ranges • In A6, type Average TV Viewing (don’t worry about being longer than the cell) • In B6, type =(B2+B3+B4)/3 [a formula] • What if you had lost of cells to include? • Use Cell Range:(B2:B4) means (B2+B3+B4) • so =(B2:B4)/3 would work too! TechTuesdays

  6. Using Formulas: Functions! • What if you had even more cells to average? • Functions: pre-programmed formulas • Main ones: SUM, AVERAGE, MIN, MAX • How to use a function for our spreadsheet? • In B6, type =AVERAGE(B2:B4) [replaces the /3] TechTuesdays

  7. Three Ways to Change Cell Size • Double-click on the line between the A and the B above Names and TV Time • Click and hold any line between the letters or numbers of a cell to make it fatter or smaller • Format>Rows>Height or Format Column>Width to be really precise TechTuesdays

  8. Sorting Data • Sometimes, we need to rearrange our data (make names in alphabetical order, highest to lowest grade, most TV to least, etc.) • Highlight A2:A4 and B2:B4 • Go to Data>Sort • Change names to TV time • Change to Descending & hit OK TechTuesdays

  9. Formatting: Borders • Go to File>Print Preview...what’s missing? • Highlight A1:A6 and B1:B6 • Go to Format>Style>Modify>Border • Click the black lined box above Outline • Hit OK twice • Go to File>Print Preview...you have borders! TechTuesdays

  10. Formatting: Numbers • Go to Format>Style>Modify>Number • Notice General is selected (will not give you lots of decimal places) • Change to Number and make sure decimal places are at 2 • Hit OK twice • See how your number formatting has changed! TechTuesdays

  11. Add or Delete Rows • Click on #3 next to second name (whole line must be highlighted) • Go to Insert Rows...new row! • Type another name and her/his TV viewing • Notice how Average in B7 now changes for you!! That’s why functions are helpful! • Click on #5 and go to Edit>Delete • CTRL Z to undo! TechTuesdays

  12. Align Data • Highlight B2:B7 • Click on the second group of lines next to the U in BIU at the top of the page to center these numbers • CTRL Z to undo TechTuesdays

  13. Set Print Area • IMPORTANT! • In Word, you print only where you’ve typed • In Excel, it will print tons of cells! • To limit what it prints, highlight A1:A7 and B1:B7 • Go to File>Print Area>Set Print Area TechTuesdays

  14. Create a Chart • Highlight A2:A5 and B2:B5 • Go to Insert>Chart • Click Next twice • Chart Title: Staff TV Viewing • Category (X) axis: Names • Value (Y) axis: Hours • Click As New Sheet and hit Finish...Cool! TechTuesdays

  15. Phew! • You survived! • Next week...Back to Basics-PowerPoint! • Check out this and other presentations at:www.lausanneschool.com/Technology/techtuesdays.html TechTuesdays

More Related