1 / 16

Microsoft Excel Fundamentals: Learning the Basics - PowerPoint PPT Presentation

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

Related searches for Microsoft Excel Fundamentals: Learning the Basics

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

PowerPoint Slideshow about 'Microsoft Excel Fundamentals: Learning the Basics' - ostinmannual

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Microsoft Excel Fundamentals: Learning the Basics

Selecting cells

Moving or copying cells

Keyboard

Name Box

Selecting Cells

• 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

• 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

• 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

Numbers

Dates and Times

Formulas

Types of Information

1234

10/08/69

=sum(b4:g7)

• 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%

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

• 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

• Click on first cell

• jkj

• Hold down mouse and drag

• Anticipates series and enters information into cells

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

• Insert sum of range of cells

• Select range

• Displays total in Status Bar

• Used for quick calculating

• Right-click on sheet tab

• Insert

• Delete

• Rename

• Move or Copy

• Select all sheets…

• Formatting Toolbar

• Format Cells Dialog Box