1 / 16

Microsoft Excel Fundamentals: Learning the Basics

Microsoft Excel Fundamentals: Learning the Basics. Spreadsheet Application. Mouse Selecting cells Moving or copying cells. Keyboard Name Box. Selecting Cells. Entering Information. Click on cell

ostinmannual
Download Presentation

Microsoft Excel Fundamentals: Learning the Basics

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 Excel Fundamentals: Learning the Basics Spreadsheet Application

  2. Mouse Selecting cells Moving or copying cells Keyboard Name Box Selecting Cells

  3. Entering Information • Click on cell • Enter information and then, tap the ENTER/RETURN Key to advance to the next cell within the same column. Or, tap the TAB key to advance to the next cell within the same row. • Or, click in formula bar • Enter information = Cancel = Enter

  4. Accepting Information • Enter Key • Moves active cell to next available cell within same column • Tab Key • Moves active cell to next available cell within same row • Formula Bar • The current cell remains active

  5. Changing Information • Overwrite contents of cell • Click on cell • Enter new information • Edit by double clicking • Double-click cell you want to edit • Position I-Beam where you want to make change • Change information • Press Enter/Return to accept changes

  6. Text Numbers Dates and Times Formulas Types of Information 1234 10/08/69 =sum(b4:g7)

  7. Numbers • Integers 263 • Negative Integers (30) or -30 • Integers with Commas 1,234 • Decimals 3.154 • Currency Figures $3 or $3.10 • Percentage Figures 30.5%

  8. Adjusting Column Width and Row Height • AutoFit • Position mouse pointer between gray column headers • When East and West arrow appear, double-click • Dialog Box • Format  Column  Width • Format  Row  Height

  9. Excel Magic • AutoComplete • When entering information in consecutive cells in a column, Excel may try to complete the entry • Picking from list Click on entry to accept

  10. Selecting Ranges • Click on first cell • jkj • Hold down mouse and drag

  11. Using AutoFill • Anticipates series and enters information into cells

  12. Creating Custom Lists Window Platform Computers: • Tools  Options  Custom Lists  Click New List Enter information one item per line Mac Platform Computers: • Edit  Preference  Custom Lists Click New List  Enter information one item per line

  13. Using AutoSum • Insert sum of range of cells

  14. Using AutoCalculate • Select range • Displays total in Status Bar • Used for quick calculating

  15. Working with Tabs • Right-click on sheet tab • Insert • Delete • Rename • Move or Copy • Select all sheets…

  16. Formatting Text and Numbers • Formatting Toolbar • Format Cells Dialog Box

More Related