1 / 12

Mastering Microsoft Excel for Business and Science Calculations

Learn the basics of Microsoft Excel - navigating, keying in data, changing data, saving workbooks, and printing worksheets. Enhance your spreadsheet applications skills!

arturom
Download Presentation

Mastering Microsoft Excel for Business and Science Calculations

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. Spreadsheet Applications What is Excel?

  2. Microsoft Excel • MS Excel is an electronic workbook that gives you the ability to perform business and scientific calculations.

  3. The Basics • Start an MS Excel application by clicking on the start button and accessing programs. • Click Microsoft Office • Select Microsoft Excel. OR • Click Microsoft Excel on Desktop.

  4. Microsoft Excel Screen Using textboxes and arrows duplicate figure 1-3 on page 399 of your textbook to help label this image.

  5. Workbooks in Excel • When excel is started, a blank workbook named “Book 1” appears. • A workbook contains 3 worksheets. • Worksheets can be added, removed and renamed. • Worksheets are made up of 65,536 rows and 256 columns. • Rows are numbered and Horizontal. • Columns are labeled A thru Z and are Vertical.

  6. Columns and rows intersect to create cells. • Each cell has a cell address. • The current cell is called the active cell.

  7. Navigating in a Spreadsheet • Once the active cell is selecting, you can move to any cell through the use of the: • Arrow keys, mouse, scroll bar or keyboard commands. • GOTO • The goto command allows you to move to a specific cell address. It is located on the Edit menu.

  8. Navigate through Excel • Complete Exercises 1-6 and 1-7, pages 406-408 from your textbook.

  9. Keying Data in a Worksheet • To key data in a worksheet select the desired cell and type, then press enter. • The formula bar becomes active when data is keyed. • F2 will allow you to edit information within a cell.

  10. Change Data in a Worksheet • To change data in a worksheet, move to the desired cell, key the correct data and press Enter or an Arrow key. • Complete exercise 1-10 and 1-11, pages 412 and 413 from your textbooks.

  11. Saving a Workbook • Select file save as: to save as a different file name. • The extension of an Excel file is .xls. • Excel files can also be saved in html format and can be viewed as html files.

  12. Printing Worksheets • Choose print from the file menu:

More Related