《Chapter17UsingPeachtreeComplete2002withMicrosoftExcel….ppt》由会员分享，可在线阅读，更多相关《Chapter17UsingPeachtreeComplete2002withMicrosoftExcel….ppt（16页珍藏版）》请在三一文库上搜索。
1、Chapter 17: Using Peachtree Complete 2002 with Microsoft Excel and Word,McGraw-Hill/Irwin The McGraw-Hill Companies, Inc., 2003,17-2,Using Peachtree with Microsoft Office,If you have Microsoft Office 97 or Microsoft Office 2000, you can use Peachtree Complete 2002, Release 9.0, data in numerous ways
2、. For example, you can add data to an Excel spreadsheet. Or, you can add Peachtree financial statements to a Word document. Chapter 17 describes several procedures for adding Peachtree data to Microsoft Office applications.,McGraw-Hill/Irwin The McGraw-Hill Companies, Inc., 2003,17-3,Software Object
3、ives, p. 639,Copy Peachtree report data to an Excel spreadsheet. Copy Peachtree report data to Word. Save Microsoft Excel and Word files.,McGraw-Hill/Irwin The McGraw-Hill Companies, Inc., 2003,17-4,Web Objectives, p. 639,Use your Internet browser to go to the books website at Go to the Internet Ac
4、tivity link on the books website. Then, select WEB EXERCISES PART 4. Complete the third exercise in Part 4, “Web Development.” Use a word processing program to write summaries of the websites that you visited.,McGraw-Hill/Irwin The McGraw-Hill Companies, Inc., 2003,17-5,Peachtree Tips,You use Bellwe
5、ther Garden Supply (the sample company) to complete the activities in Chapter 17. You may use Bellwethers starting data or restore Exercise 6-2. If necessary, see Appendix A, Installing Starting Data for the Sample Companies, pages 701-702.,McGraw-Hill/Irwin The McGraw-Hill Companies, Inc., 2003,17-
6、6,Backing up Chapter 17,McGraw-Hill/Irwin The McGraw-Hill Companies, Inc., 2003,17-7,Chapter 17 topics,Software objectives and web objectives, p. 639 Getting started, p. 640 Copying Peachtree report data to Microsoft Excel, p. 640 a. Balance sheet, pp. 640-642 b. Income statement, pp. 643-644 Copyin
7、g Peachtree report data to Microsoft Word, pp. 644-646 Internet Activity, p. 646 Summary and Review, pp. 646 a. Going to the net, p. 647 b. Short-answer questions, pp. 647-649 c. Exercise 17-1, p. 649 d. Exercise 17-2, p. 649 e. Chapter 17 index, p. 650,McGraw-Hill/Irwin The McGraw-Hill Companies, I
8、nc., 2003,17-8,Getting started, p. 640,Start Windows and Peachtree in the usual way. Open Bellwether Garden Supply.,McGraw-Hill/Irwin The McGraw-Hill Companies, Inc., 2003,17-9,Balance Sheet, pp. 640-641,Restore Exercise 6-2.ptb data. Click on Reports, Financial Statements. Click on the “Excel” icon
9、. Then, select . Click on .,McGraw-Hill/Irwin The McGraw-Hill Companies, Inc., 2003,17-10,Excel Book1, p. 641,After completing steps 1 4 on pp. 640-641, Peachtree starts Excel. To see the rest of the balance sheet, scroll down the report.,McGraw-Hill/Irwin The McGraw-Hill Companies, Inc., 2003,17-11
10、,Save as, p. 642,Complete steps 6 9 on p. 642. Put a floppy disk in drive A. Click on . Complete steps 10 and 11 on p. 642.,McGraw-Hill/Irwin The McGraw-Hill Companies, Inc., 2003,17-12,Excel Book2, p. 643,To create an income statement in Excel, complete steps 1 4 on page 643. Complete steps 5 8 on
11、page 644.,McGraw-Hill/Irwin The McGraw-Hill Companies, Inc., 2003,17-13,Copying Peachtree report data to Microsoft Word, pp. 644 and 645,Complete steps 1 8 on pp. 644 and 645. Click on File, Save As. Select drive A.,McGraw-Hill/Irwin The McGraw-Hill Companies, Inc., 2003,17-14,Save as, p. 645-646,Ma
12、ke sure drive A is shown in the “Save in” box. Accept the file name. Click on Save. Complete steps 11 and 12 on p. 646.,McGraw-Hill/Irwin The McGraw-Hill Companies, Inc., 2003,17-15,Internet Activity, p. 646,McGraw-Hill/Irwin The McGraw-Hill Companies, Inc., 2003,17-16,Going to the Net, p. 647,Acces
13、s the Microsoft Office website at What is the website address for Microsoft Word? After linking to the Microsoft Word website, briefly describe what kind of information can be obtained. If you link to other websites, include the appropriate address(es) in your answer. What is the website address for Microsoft Excel? After linking to the Microsoft Excel website, briefly describe what kind of information can be obtained. If you link to other websites, include the appropriate address(es) in your answer.,