1 / 28

CA1-Excel 2007

CA1-Excel 2007. Lesson 1- The Basics. Excel 2007 Lesson 1-The Basics. In this lesson, you will learn how to: Start Excel. Open an existing workbook. Navigate within a workbook. Edit a worksheet. Manage files. Print Excel files. Excel 2007 Lesson 1-The Basics.

quinto
Download Presentation

CA1-Excel 2007

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. CA1-Excel 2007 Lesson 1- The Basics

  2. Excel 2007Lesson 1-The Basics • In this lesson, you will learn how to: • Start Excel. • Open an existing workbook. • Navigate within a workbook. • Edit a worksheet. • Manage files. • Print Excel files. CA1-Excel 2007 Lesson 1-The Basics

  3. Excel 2007Lesson 1-The Basics • What is Excel 2007? It can be used to… • organize data. • complete calculations. • make decisions. • graph data. • develop professional looking reports. • publish organized data to the Web. • access real-time data from Web sites. • Microsoft Office Excel 2007 is a powerful electronic spreadsheet software program. CA1-Excel 2007 Lesson 1-The Basics

  4. Starting Excel CA1-Excel 2007 Lesson 1-The Basics • There are several ways to start Excel depending on how your software is installed. You can… • Go to: Start-Programs-Microsoft Office-Excel 2007 • Or Click the Excel shortcut icon on your desktop. • Or Use the My Computer icon • Or Use Windows Explorer

  5. Complete Exercise 1-1 CA1-Excel 2007 Lesson 1-The Basics

  6. The Parts of the Excel Screen • Excel 2007 opens showing a blank workbook, the Quick Access Toolbar, the Command Tabs, etc. • New Workbooks and Worksheets • When Excel starts, it creates a new blank workbook. The default name is Book1. • The workbook is like a notebook. Excel opens a new workbook with three blank worksheets ready for you to enter data. They are named Sheet1, Sheet2 and Sheet3. CA1-Excel 2007 Lesson 1-The Basics

  7. The Parts of the Excel Screen CA1-Excel 2007 Lesson 1-The Basics

  8. Using the “Ribbon” • The Office 2007 Ribbon is actually a collection of several components: • The Quick Access Toolbar (appears in the top left of the window and contains the MS Office button, which opens the File menu), and the Save, Undo, and Redo icons. You can customize the QAT to add tools you frequently use. Use the arrow to customize Save, Undo, and Redo icons Quick Access Toolbar Microsoft Office Button The File Menu CA1-Excel 2007 Lesson 1-The Basics

  9. Using the “Ribbon” CA1-Excel 2007 Lesson 1-The Basics

  10. Complete Exercise 1-2 CA1-Excel 2007 Lesson 1-The Basics

  11. Navigating within a Workbook • A workbook is the file Excel creates to store your data. When you look at the screen, you are looking at a worksheet. • A worksheet has a grid that defines rows and columns. The rows are numbered 1 through 1,048,576. There are 16,384 columns, lettered from A to Z, then AA to AZ, BA to BZ, and so on, up to XFD. • You enter information at the intersection of a row and column, called a cell. Cells have addresses or references, which identify where the cell is located on the worksheet. • The Activecell is the cell that appears outlined with a thick border. It is ready to accept data, or to be modified if it already contains data. CA1-Excel 2007 Lesson 1-The Basics

  12. Navigating within a Workbook • Workbooks and Worksheets • You can add additional worksheets or delete existing worksheets as needed. • Each worksheet has a unique sheet name that appears on a sheet tab at the bottom of the workbook. The default name is Sheet1. You can rename your worksheets as you wish. Click here to add additional worksheets CA1-Excel 2007 Lesson 1-The Basics

  13. Complete Exercise 1-3 CA1-Excel 2007 Lesson 1-The Basics

  14. Complete Exercise 1-4 CA1-Excel 2007 Lesson 1-The Basics

  15. Complete Exercise 1-5 CA1-Excel 2007 Lesson 1-The Basics

  16. Closing a Workbook • After you finish working with a workbook, you usually would save your work and close the workbook. You can close a workbook in several ways: • Use the Close Window button on the right side of the menu bar. • Use the Microsoft Office button to access the File menu. Close is contained in this menu. Use keyboard shortcuts: Ctrl + W or Ctrl + F4 closes a workbook. CA1-Excel 2007 Lesson 1-The Basics

  17. Complete Exercise 1-6 CA1-Excel 2007 Lesson 1-The Basics

  18. Opening an Existing Workbook • In addition to starting a new workbook you will often open workbooks that have already been created. There are several ways to open an existing workbook: • Use the Microsoft Office button to access the File Menu. Open is contained in this menu. • Use keyboard shortcuts: Ctrl + O opens a workbook. • Double-click the workbook filename in Windows Explorer or My Computer. CA1-Excel 2007 Lesson 1-The Basics

  19. Complete Exercise 1-7 CA1-Excel 2007 Lesson 1-The Basics

  20. Change the Zoom Size • The Zoom size controls how much of the worksheet you see on the screen. You can set the Zoom size to see more of less on screen so you won’t need to scroll as much. The 100% Zoom size shows the data closest to print size. CA1-Excel 2007 Lesson 1-The Basics

  21. Complete Exercise 1-8 CA1-Excel 2007 Lesson 1-The Basics

  22. Complete Exercise 1-9 CA1-Excel 2007 Lesson 1-The Basics

  23. Previewing and Printing a Worksheet • When the worksheet is finished, printing it is easy. You can use any of these methods to print a worksheet: • Click the Print button on you customized Quick Access Toolbar. • From the File menu, choose Print. • Click Print while in Print Preview • Press Ctrl + P. CA1-Excel 2007 Lesson 1-The Basics

  24. Complete Exercise 1-10 CA1-Excel 2007 Lesson 1-The Basics

  25. Printing a Workbook • You can print all three sheets in the workbook with one command. To print the entire workbook, you must use the Print dialog box. You can print a workbook by using either of these methods: • From the File menu, choose Print. • Press Ctrl + P. CA1-Excel 2007 Lesson 1-The Basics

  26. Complete Exercise 1-11 CA1-Excel 2007 Lesson 1-The Basics

  27. Exiting Excel • You can exit Excel and close the workbook at the same time. If you give the command to exit Excel, you will see a reminder to save the workbook if you have not yet done so. There are four ways to close a workbook and exit Excel: • Use the Close Window button in the upper right corner to close a workbook, or the Close button to close Excel. • From the File menu, choose Close or Exit. • Right click on the task bar button for your workbook and choose Exit. • Use the keyboard shortcuts Alt + F4 to Exit Excel CA1-Excel 2007 Lesson 1-The Basics

  28. Complete Exercise 1-12 CA1-Excel 2007 Lesson 1-The Basics

More Related