• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part I: Using Excel Worksheets > Entering and Editing Data

Chapter 3. Entering and Editing Data

by Sherry Kinkoph

  • Entering information

    Learn the differences between text entries, values, and formulas and learn how to enter these data types into your Excel worksheets.

  • Working with ranges

    Learn how to work with ranges in a worksheet and assign range names to use in formulas.

  • Speeding up data entry

    Find out all the shortcuts for making data entry easy. Use Excel's AutoFill feature to automatically create fill series in your worksheets, and let AutoComplete help you enter repetitive data.

  • Working with formulas

    Learn how to construct a formula using operators, cell references, and range names. Create array formulas and 3-D references. Learn the difference between absolute and relative cell references.

  • Rearranging worksheet data

    Familiarize yourself with the various methods used to move data around in a worksheet, to edit entries, and to add columns and rows.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint