1 / 63

Microsoft Office Excel 2007 Training

Enter formulas. Course contents. Overview: Goodbye, calculatorLesson 1: Get startedLesson 2: Use cell referencesLesson 3: Simplify formulas by using functions. Each lesson includes a list of suggested tasks and a set of test questions.. Enter formulas. . Overview: Goodbye, calculator. Excel is gr

amato
Download Presentation

Microsoft Office Excel 2007 Training

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. Microsoft® Office Excel® 2007 Training Enter formulas Before you begin: If you want to teach people the basics of creating a workbook and entering and editing text and numbers, take a look at the Microsoft Office Online training presentation called “Excel 2007—Create your first workbook.” Office Online also offers a training presentation that provides an overview of the new look in Excel 2007 called “Excel 2007—Get up to speed.” [Note to trainer: For detailed help in customizing this template, see the very last slide. Also, look for additional lesson text in the notes pane of some slides.] Before you begin: If you want to teach people the basics of creating a workbook and entering and editing text and numbers, take a look at the Microsoft Office Online training presentation called “Excel 2007—Create your first workbook.” Office Online also offers a training presentation that provides an overview of the new look in Excel 2007 called “Excel 2007—Get up to speed.” [Note to trainer: For detailed help in customizing this template, see the very last slide. Also, look for additional lesson text in the notes pane of some slides.]

    2. Enter formulas Course contents Overview: Goodbye, calculator Lesson 1: Get started Lesson 2: Use cell references Lesson 3: Simplify formulas by using functions

    3. Enter formulas Overview: Goodbye, calculator

    4. Enter formulas Course goals Do math by typing simple formulas to add, divide, multiply, and subtract. Use cell references in formulas, so that Excel can automatically update results when values change or when you copy formulas. Use functions (prewritten formulas) to add up values, calculate averages, and find the smallest or largest value in a range of values.

    5. Lesson 1 Get started

    6. Enter formulas Get started CD in this case stands for “compact discs.”CD in this case stands for “compact discs.”

    7. Enter formulas Begin with an equal sign

    8. Enter formulas Begin with an equal sign

    9. Enter formulas Begin with an equal sign

    10. Enter formulas Use other math operators Note: You could use more than one math operator in a single formula. This training presentation covers only single-operator formulas, but you should know that if there’s more than one operator, formulas are not just calculated from left to right. The rules of operator precedence and two example formulas are on the Quick Reference Card that’s linked to at the end of this course.Note: You could use more than one math operator in a single formula. This training presentation covers only single-operator formulas, but you should know that if there’s more than one operator, formulas are not just calculated from left to right. The rules of operator precedence and two example formulas are on the Quick Reference Card that’s linked to at the end of this course.

    11. Enter formulas Total all the values in a column Pressing the Sum button enters the SUM function, which adds up all the values in a range of cells. To save time, use this function whenever you have more than a few values to add up, so that you don’t have to type the formula. Pressing the Sum button enters the SUM function, which adds up all the values in a range of cells. To save time, use this function whenever you have more than a few values to add up, so that you don’t have to type the formula.

    12. Enter formulas Total all the values in a column

    13. Enter formulas Total all the values in a column The next two lessons explain cell references and functions in more detail. Tip: The Sum button is also on the Formulas tab. While you can work with formulas no matter what tab you work on, you might switch to the Formulas tab to work with more complex formulas (which aren’t covered by this training presentation). The next two lessons explain cell references and functions in more detail. Tip: The Sum button is also on the Formulas tab. While you can work with formulas no matter what tab you work on, you might switch to the Formulas tab to work with more complex formulas (which aren’t covered by this training presentation).

    14. Enter formulas Copy a formula instead of creating a new one

    15. Enter formulas Copy a formula instead of creating a new one Cell B7, you might remember, contains the January formula. Cell C7 is where you want to copy the formula. Note: You can drag the fill handle to copy formulas only into cells that are next to each other, either horizontally or vertically.Cell B7, you might remember, contains the January formula. Cell C7 is where you want to copy the formula. Note: You can drag the fill handle to copy formulas only into cells that are next to each other, either horizontally or vertically.

    16. Enter formulas Copy a formula instead of creating a new one

    17. Enter formulas Suggestions for practice Create a formula for addition. Create other formulas. Add up a column of numbers. Add up a row of numbers. [Note to trainer: With Excel 2007 installed on your computer, you can click the link in the slide to go to an online practice. In the practice, you can work through each of these tasks in Excel, with instructions to guide you. Important: If you don’t have Excel 2007, you won’t be able to access the practice instructions.][Note to trainer: With Excel 2007 installed on your computer, you can click the link in the slide to go to an online practice. In the practice, you can work through each of these tasks in Excel, with instructions to guide you. Important: If you don’t have Excel 2007, you won’t be able to access the practice instructions.]

    18. Enter formulas Test 1, question 1 What do you type into an empty cell to start a formula? (Pick one answer.)

    19. Enter formulas Test 1, question 1: Answer =

    20. Enter formulas Test 1, question 2 What is a function? (Pick one answer.)

    21. Enter formulas Test 1, question 2: Answer A prewritten formula.

    22. Enter formulas Test 1, question 3 A formula result is in cell C6. You wonder how you got the result. To see the formula, what do you do? (Pick one answer.)

    23. Enter formulas Test 1, question 3: Answer Click in cell C6.

    24. Lesson 2 Use cell references

    25. Enter formulas Use cell references The table shows how to refer to cells by using the column letter followed by the row number. The first section in this lesson describes what happens if the value in a cell changes after a total is calculated. The table shows how to refer to cells by using the column letter followed by the row number. The first section in this lesson describes what happens if the value in a cell changes after a total is calculated.

    26. Enter formulas Update formula results

    27. Enter formulas Update formula results Note: You can revise a formula in a selected cell by typing either in the cell or in the formula bar.Note: You can revise a formula in a selected cell by typing either in the cell or in the formula bar.

    28. Enter formulas Other ways to enter cell references

    29. Enter formulas Other ways to enter cell references Why enter the formula in cell C9? C9 is used for example purposes. You don’t need to store the total, so you can enter the formula in any empty cell and delete it later. Why enter the formula in cell C9? C9 is used for example purposes. You don’t need to store the total, so you can enter the formula in any empty cell and delete it later.

    30. Enter formulas Other ways to enter cell references As always, the formula appears in the formula bar near the top of the worksheet whenever cell C9 is selected. As always, the formula appears in the formula bar near the top of the worksheet whenever cell C9 is selected.

    31. Enter formulas Other ways to enter cell references

    32. Enter formulas Reference types The workings of relative references account for why, in the first lesson, you could copy the January formula to add up February expenses. The workings of relative references account for why, in the first lesson, you could copy the January formula to add up February expenses.

    33. Enter formulas Reference types The next lesson will go into more detail about why you’d use an absolute reference. The next lesson will go into more detail about why you’d use an absolute reference.

    34. Enter formulas Reference types

    35. Enter formulas Using an absolute cell reference

    36. Enter formulas Using an absolute cell reference

    37. Enter formulas Using an absolute cell reference

    38. Enter formulas Using an absolute cell reference

    39. Enter formulas Suggestions for practice Type cell references in a formula. Select cell references for a formula. Use an absolute reference in a formula. Add up several results. Change values and totals. [Note to trainer: With Excel 2007 installed on your computer, you can click the link in the slide to go to an online practice. In the practice, you can work through each of these tasks in Excel, with instructions to guide you. Important: If you don’t have Excel 2007, you won’t be able to access the practice instructions.][Note to trainer: With Excel 2007 installed on your computer, you can click the link in the slide to go to an online practice. In the practice, you can work through each of these tasks in Excel, with instructions to guide you. Important: If you don’t have Excel 2007, you won’t be able to access the practice instructions.]

    40. Enter formulas Test 2, question 1 How does an absolute cell reference work? (Pick one answer.)

    41. Enter formulas Test 2, question 1: Answer The cell reference is fixed.

    42. Enter formulas Test 2, question 2 Which of these is an absolute reference? (Pick one answer.)

    43. Enter formulas Test 2, question 2: Answer $A$1

    44. Enter formulas Test 2, question 3 If you copy the formula =C4*$D$9 from cell C4 to cell C5, what will the formula be in cell C5? (Pick one answer.)

    45. Enter formulas Test 2, question 3: Answer =C5*$D$9

    46. Lesson 3 Simplify formulas by using functions

    47. Enter formulas Simplify formulas by using functions

    48. Enter formulas Find an average The Sum button is also located on the Formulas tab, in the Function Library group. After you click Average in step 1, the formula =AVERAGE(B7:C7) appears in the formula bar near the top of the worksheet. You could also type this formula directly into the cell. The Sum button is also located on the Formulas tab, in the Function Library group. After you click Average in step 1, the formula =AVERAGE(B7:C7) appears in the formula bar near the top of the worksheet. You could also type this formula directly into the cell.

    49. Enter formulas Find the largest or smallest value The example in this set of slides is new; it uses a set of values that you haven’t seen before. After you click Max in step 1, the formula =MAX(F3:F6) appears in the formula bar near the top of the worksheet. The example in this set of slides is new; it uses a set of values that you haven’t seen before. After you click Max in step 1, the formula =MAX(F3:F6) appears in the formula bar near the top of the worksheet.

    50. Enter formulas Find the largest or smallest value When you click Min, the formula =MIN(F3:F6) appears in the formula bar. As with AVERAGE, you could type either the MAX or the MIN formula directly into a cell.When you click Min, the formula =MIN(F3:F6) appears in the formula bar. As with AVERAGE, you could type either the MAX or the MIN formula directly into a cell.

    51. Enter formulas Print formulas

    52. Enter formulas Print formulas Other tips: The ` key is next to the 1 key on most keyboards. Displaying formulas can also help you spot errors. You can hide the formulas on the worksheet by repeating the step you used to display them. Other tips: The ` key is next to the 1 key on most keyboards. Displaying formulas can also help you spot errors. You can hide the formulas on the worksheet by repeating the step you used to display them.

    53. Enter formulas What’s that funny thing in my worksheet?

    54. Enter formulas What’s that funny thing in my worksheet? Cells with error values such as #NAME? may display a color triangle. If you click the cell, an error button appears to provide some error correction options. The use of that button is not covered in this course. Cells with error values such as #NAME? may display a color triangle. If you click the cell, an error button appears to provide some error correction options. The use of that button is not covered in this course.

    55. Enter formulas Find more functions

    56. Enter formulas Find more functions Tip: You can also see other functions by clicking the Formulas tab. Tip: You can also see other functions by clicking the Formulas tab.

    57. Enter formulas Suggestions for practice Find an average. Find the largest number. Find the smallest number. Display and hide formulas. Create and fix error values. Create and fix the error value #NAME?. [Note to trainer: With Excel 2007 installed on your computer, you can click the link in the slide to go to an online practice. In the practice, you can work through each of these tasks in Excel, with instructions to guide you. Important: If you don’t have Excel 2007, you won’t be able to access the practice instructions.][Note to trainer: With Excel 2007 installed on your computer, you can click the link in the slide to go to an online practice. In the practice, you can work through each of these tasks in Excel, with instructions to guide you. Important: If you don’t have Excel 2007, you won’t be able to access the practice instructions.]

    58. Enter formulas Test 3, question 1 How would you print formulas? (Pick one answer.)

    59. Enter formulas Test 3, question 1: Answer In the Formula Auditing group on the Formulas tab, click Show Formulas; then click the Microsoft Office Button, and click Print.

    60. Enter formulas Test 3, question 2 What does #### mean? (Pick one answer.)

    61. Enter formulas Test 3, question 2: Answer The column is not wide enough to display the content of the cell.

    62. Enter formulas Test 3, question 3 What is the keyboard shortcut to display formulas on the worksheet? (Pick one answer.)

    63. Enter formulas Test 3, question 3: Answer CTRL+`

    64. Enter formulas Quick Reference Card For a summary of the tasks covered in this course, view the Quick Reference Card.

    65. USING THIS TEMPLATE See the notes pane or view the full notes page (View tab) for detailed help on this template. Using This Template This Microsoft Office PowerPoint® template has training content about working with basic formulas in Excel 2007. It’s geared for you to present to a group and customize as necessary. This template’s content is adapted from the Microsoft Office Online Training course called “Get to know Excel 2007: Enter formulas.” Features of the template Title slide: On the very first slide, there is placeholder text over which you should type the name of your company. Or you can delete the text box altogether if you don’t want this text. Animations: Custom animation effects are applied throughout the presentation. These effects include Peek, Stretch, Dissolve, and Checkerboard. All effects play in previous versions back to Microsoft PowerPoint 2000. To alter animation effects, go to the Slide Show menu, click Custom Animation, and work with the options that appear. If this presentation contains an Adobe Flash animation: To play the Flash file, you must register a Microsoft ActiveX® control, called Shockwave Flash Object, on your computer. To do this, download the latest version of the Adobe Flash Player from the Adobe Web site. Slide transitions: The Wipe Down transition is applied throughout the show. If you want a different one, go to the Slide Show menu, click Slide Transition, and work with the options that appear. Hyperlinks to online course: The template contains links to the online version of this training course. The links take you to the hands-on practice session for each lesson and to the Quick Reference Card that is published for this course. Please take note: You must have Excel 2007 installed to view the hands-on practice sessions. If you don’t have Excel 2007, you won’t be able to access the practice instructions. Headers and footers: The template contains a footer that has the course title. You can change or remove the footers in the Header and Footer dialog box (which opens from the View menu). Using This Template This Microsoft Office PowerPoint® template has training content about working with basic formulas in Excel 2007. It’s geared for you to present to a group and customize as necessary. This template’s content is adapted from the Microsoft Office Online Training course called “Get to know Excel 2007: Enter formulas.” Features of the template Title slide: On the very first slide, there is placeholder text over which you should type the name of your company. Or you can delete the text box altogether if you don’t want this text. Animations: Custom animation effects are applied throughout the presentation. These effects include Peek, Stretch, Dissolve, and Checkerboard. All effects play in previous versions back to Microsoft PowerPoint 2000. To alter animation effects, go to the Slide Show menu, click Custom Animation, and work with the options that appear. If this presentation contains an Adobe Flash animation: To play the Flash file, you must register a Microsoft ActiveX® control, called Shockwave Flash Object, on your computer. To do this, download the latest version of the Adobe Flash Player from the Adobe Web site. Slide transitions: The Wipe Down transition is applied throughout the show. If you want a different one, go to the Slide Show menu, click Slide Transition, and work with the options that appear. Hyperlinks to online course: The template contains links to the online version of this training course. The links take you to the hands-on practice session for each lesson and to the Quick Reference Card that is published for this course. Please take note: You must have Excel 2007 installed to view the hands-on practice sessions. If you don’t have Excel 2007, you won’t be able to access the practice instructions. Headers and footers: The template contains a footer that has the course title. You can change or remove the footers in the Header and Footer dialog box (which opens from the View menu).

More Related