Goal for Today

1. Goal for Today • Grasp Intermediate Excel – Pivot Tables, Formatting, Graphs… Etc • Be Able to apply towards Lessons and Real Life • Group into Core Subject Areas • Create a Lesson Plan that incorporates Excel that would be evaluated at a Loti 3 or higher • The lesson plan can be used for Tech Fusion • Engage the students in Learning!!!

2. Introduction to Excel How to Git R’ Done.. Jessi Rose

3. What you will Learn • Definitions • Parts of Excel • Basic Use of Excel • Short Cuts for Excel • Formatting Spreadsheets • Go through a project • Examples and Links • Fonts • Columns • Rows • Graphs • Merge • Sort • Pivot Tables • Graphs • Page Breaks • Hyperlinks • Formulas • Saving specialty

4. What is Excel? • Electronic spreadsheet software • Uses? • Produce reports • Perform simple business/personal calculations • Financial or Scientific calculations • Database management • Create Charts, Pivot Tables, and sort Data • Analysis Tools

5. Information about Excel • Spreadsheet – the software or entire workbook file • Workbook – the basic document .xls A WORKBOOK contains WORKSHEETS • Example a Phonics workbook for Reading • Worksheets – a single sheet of data or tabs at the bottom of you workbook • Example each workbook page in the Phonics workbook

6. Information about Excel • A regular computer with excel can have a workbook with 255 worksheets • A worksheet can have 256 columns and 65,536 rows. --- 32,000 Characters in a Single Cell  • In a single worksheet there can be 16,777,216 cells. • Amazing Huh?

7. Parts of the Screen

8. Menu Bar Title Bar Formatting Formula Bar Standard Name Box Active Cell Column Heading Vertical Scroll New Workbook options Row Heading Cell Sheet Tabs Horizontal scroll Draw Bar Status Bar

10. Shortcuts for Excel

11. Formatting Worksheets • Columns/Rows (inserting) • Cells – Font, Merging, Numbers, Dates • Insert picture/clip art • Sort, Formats, Find and Replace, Pivot Tables and Conditional Formatting • Print, views, page break • Formulas and Functions • Charts • Hyperlinks • Worksheets • Shortcuts

12. Formatting Worksheets • Worksheets • Add • Right click the worksheet tab that you want to appear after the new worksheet • Select Insert on the shortcut menu • In the insert dialog box (general tab), select the Worksheet icon and click Ok • Delete • Right click the worksheet tab that you want to delete • Click the delete • Move a worksheet • Right Click the sheet tab you want to move • Select Move or Copy on the shortcut menu • In the Before Sheet list, select the desired position • Copy a worksheet • Right click the sheet tab you want to copy • Select Move or Copy on the shortcut menu • IN the Before sheet list, select the desired position • Select the Create a Copy • Click ok

13. Formatting Worksheets • Columns/Rows (inserting) • Select the Row or column • On the Insert Menu Select (Row or Columns) • Delete … Select the Row or Column • Edit… Delete… Select • Hide and Unhide Rows • Select Rows or Columns • On the Format menu, Point to Row or Column select Hide or Right Click • To Unhide On the Format menu, Point to Row or Column select unhide or Right Click • Row/Column Height or Width • Select Row or Column • On the Format Menu point to Row/Column select Height or Width or Right Click • Freeze and Unfreeze Rows or Columns • Click the Cell below and to the right of where you want to freeze • On the Window menu, Select Freeze Panes • On the Window Menu, Select Unfreeze Panes to Restore

14. Formatting Worksheets • Formatting Cells • Select the Cells • Click the Font down arrow and click the desired Font • Click the Font Size down arrow and click the desired size • Click the Font Color down arrow and click the desired color • Click font attribute buttons, as desired • Click the Borders down arrow • Click the Fill Color Down arrow • Click the indent buttons as desired OR • Select the Cells • On the Format Menu, Select Cells • Make selections on the Alignment, Font, Border, and Patterns tabs • Use the Merge and Center Button

15. Formatting Worksheets • Insert Clip art • ON the Insert menu, point to Picture and select Clip Art • Type your search text into the Search text box • In the search results, click the image to insert it into the file • Drag the graphic to the desired position and drag a handle to resize it, if necessary • Insert Picture • On the Insert menu, Point to Picture and select From File • IN the Insert Picture dialog box, navigate to the location of your picture file • Click the picture file and click Insert • Drag the graphic to the desired position and drag a handle to resize it, if Necessary

17. Formatting Worksheets • Create and Modify a Graphic • Click the Drawing button to display the Drawing toolbar Or • On the View Menu, point to Toolbars and select Drawing • Select a shape or and Auto shape from the Drawing toolbar • Click in the worksheet to insert the graphic • With the graphic selected, open the Format menu and select AutoShape • In the Format AutoShape dialog box, make the desired changes and click OK

18. Formatting Worksheets Comments (Adding and Editing) • Select the cell in which you want to add a comment • On the Insert menu, Select Comment • Type the Comment • Click outside the comment to close the box • To Edit, select the comment • On the insert menu, select Edit Comment • Edit the comment • Click outside the box to close

19. Formatting Worksheets • Sort, Formats, Find and Replace • Sort • Click on Data on the Menu Bar • Select Sort • Select Type, Header Row, and Options • Formats (Numeric Formats, Dates, etc) • On the Format Menu, select Cells • On the Number tab, Select a Category • Set the number of Decimal places or type of format needed • Find and Replace • On the Edit menu, Select Replace • In the Find what box, type the data you wish to replace • In the Replace with box, type the replacement data • Click Find Next • Click Replace to replace each occurrence individually or Replace all • Pivot Tables • Select Data • Go to Data Menu … Pivot Table and walk through wizard • Select and drag data you want to use – at any time double click to change options • Conditional Formatting • Select Data • Format … Conditional Formatting.. Follow Wizard • Create Criteria for the information want for User

20. Formatting Worksheets • To Enter a Formula • Select Cell • Type = (Equal Sign) to begin the formula • Type the remainder of the formula, using operators as desired… Press Enter • Create an Absolute Reference • After entering the cell reference to the cell, press F4 • Type the remainder of the formula… Press Enter • Enter Function Manually • Select the Cell • Type = and the function name (such as SUM) • Type an opening parenthesis, enter the arguments, and type the closing parenthesis…Press Enter • Enter A Function using the Functions • On the Insert menu, Select Function • Select the desired category and function • Click OK • Enter the function arguments • Click OK

21. Formatting Worksheets • Create Charts • Select the data you want to chart • Click the Chart Wizard or Insert menu, select Chart • In step 1 of 4, select the chart type and sub-type • In step 2 of 4, select the chart data options • In step 3 of 4, make the various title and subtitle and label selections • In step 4 of 4, select As new sheet or as object in current sheet. Click Finish • Format Chart • Select the portion of the chart you want to modify • Select the desired command on the Format menu • Make the desired changes in the dialog box • Click OK • Or….. Double click on any portion of the chart that you want changed

23. Formatting Worksheets • Hyperlinks • Insert Hyperlink • Type the text or graphic you want to use • Select the cell containing the information • Click the Insert Menu, select hyperlink • In the Link to section, select Existing File or Webpage • IN the Look in Box, navigate to the file you want to link to and click OK… • To Edit • Click and hold to select the hyperlink • On the Insert Menu, Select Hyperlink and Edit • Or Right Click… you can Right click to Remove

24. Saving Worksheets • Pass Word Protect Worksheets • Got To File… Save As • On the Save As Dialog Box, Click on Tools • From the Tools Dialog, Click on General Options • Type Password to Open and Password to Modify • Check as Read Only • Check as Create Backup

25. Formatting Worksheets • Print • On the File Menu, select Print, change settings as desired • To Preview • On the File menu, Select Print Preview • Use Page Break to change margins and selections – for banners or to see page • Use Page Set Up to Align information on Page • Use to see Repeat Rows or Columns on Top

26. Formatting Worksheets • ShortCuts • CTRL+B • Make letters bold • CTRL+I • Make letters italic • CTRL+U • Make letters underline • CTRL+SHIFT+< • Decrease font size • CTRL+SHIFT+> • Increase font size • CTRL+SPACEBAR • Remove paragraph or character formatting • CTRL+X • Cut the selected text or object • CTRL+Y • Redo the last action • ShortCuts • Tab • Shift Tab (move Backwards) • Enter • Ctrl A – Select All • Ctrl C – Copy • Ctrl V – Paste • Ctrl Z – To Undo • Ctrl Tab – To go to next Tab • Shift F10 – Go to Short Cut Menu • Ctrl S – To Save • Print Screen • HOME or End • ESC

28. Challenge – Worksheet Challenge Answers Creating Pictographs Judy M&M Payment – Example Tip Sheet for Excel A Little bit of Everything http://www.manassas.k12.va.us/round/classweb/volz/excelweb/sslplan.htm All Kinds of Lessons http://www.nortellearnit.org/lessons/ Examples http://www.webquest.org/

29. http://www.sabine.k12.la.us/class/excel_resources.htm http://score.kings.k12.ca.us/standards/seventh.html#statistics http://www.internet4classrooms.com/on-line_excel.htm http://www.sites4teachers.com/links/redirect.php?url=http://www.science-education.org/classroom_activities/activity.pdf http://www.sites4teachers.com/links/redirect.php?url=http://education.arm.gov/teacherslounge/lessons.stm http://www.lessonplans4teachers.com/music.php Helpful Links http://www.digdb.com/ -- Webpage To help you when you are stuck http://www.exinfm.com/free_spreadsheets.html --- Excel business spreadsheets

30. DISCUSSION AND IDEAS