Microsoft excel fundamentals learning the basics
Download
1 / 16

microsoft excel fundamentals: learning the basics - PowerPoint PPT Presentation


  • 240 Views
  • Updated On :

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

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

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

Selecting cells l.jpg

Mouse

Selecting cells

Moving or copying cells

Keyboard

Name Box

Selecting Cells


Entering information l.jpg
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


Accepting information l.jpg
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


Changing information l.jpg
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


Types of information l.jpg

Text

Numbers

Dates and Times

Formulas

Types of Information

1234

10/08/69

=sum(b4:g7)


Numbers l.jpg
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%


Adjusting column width and row height l.jpg
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


Excel magic l.jpg
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


Selecting ranges l.jpg
Selecting Ranges

  • Click on first cell

    • jkj

  • Hold down mouse and drag


Using autofill l.jpg
Using AutoFill

  • Anticipates series and enters information into cells


Creating custom lists l.jpg
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


Using autosum l.jpg
Using AutoSum

  • Insert sum of range of cells


Using autocalculate l.jpg
Using AutoCalculate

  • Select range

  • Displays total in Status Bar

  • Used for quick calculating


Working with tabs l.jpg
Working with Tabs

  • Right-click on sheet tab

    • Insert

    • Delete

    • Rename

    • Move or Copy

    • Select all sheets…


Formatting text and numbers l.jpg
Formatting Text and Numbers

  • Formatting Toolbar

  • Format Cells Dialog Box


ad