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

Télécharger la présentation

## Microsoft Excel Fundamentals: Learning the Basics

An Image/Link below is provided (as is) to download presentation Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. 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