MicrosoftOfficeExcel培训精品PPT课件.pptVIP

* * * * * * * * * * * * * * * * * * * * That’s all you have to do to open a file created in a previous version. You’re ready to get to work. But before you do, here are a few notes about using the Microsoft Office Button, located in the upper-left corner of the window. Clicking it opens a menu showing the same commands you’ve used in the past to open and save your workbooks. This menu is packed with useful items. For example, here is where you’ll find the program settings that control things like turning the R1C1 reference style on or off, or showing the Formula Bar in the program window. Click Excel Options at the bottom of the menu to access the options. In previous versions of Excel, you could set such options in the Options dialog box, opened from the Tools menu. Now many of those options are here, where they are more visible and conveniently close at hand when you start work on old files or new ones. * * Your worksheet contains rows of products ordered from various suppliers. Your new column will identify the various products as dairy, grains, produce, and so on. The animation illustrates the process: You want to add the column to the right of the Quantity column, so you click in the Supplier column. On the Home tab, in the Cells group, click the arrow on Insert. On the menu that appears, click Insert Sheet Columns. A new blank column is inserted, and you enter the new data in the column. [Note to trainer: To play the animation when viewing the slide show, right-click the animation, and then click Play. After playing the file once, you may have to click Rewind (after right-clicking) and then click Play. If you have problems viewing the animation, see the notes for the last slide in this presentation about playing a Macromedia Flash animation. If you still have problems viewing the animation, the slide that follows this one is a duplicate slide with static art. Delete either the current slide or the next slide before showing the presentation.] * * [Note to