Excel 2010: Manipulating Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

It's possible to manually edit data in Excel; however, this can become tedious, especially with a lot of data. Work smarter, not harder, by exploring various methods for efficiently and effectively inserting and manipulating data in Excel.



Expected Duration (hours)
0.9

Lesson Objectives

Excel 2010: Manipulating Data

  • Selecting cells
  • Inputting data
  • Inserting special characters
  • Editing multiple worksheets simultaneously
  • Deleting items in your spreadsheet
  • Undoing & redoing actions
  • Creating automatic data series
  • Using the AutoComplete function
  • Inserting dropdown menus
  • Using the spell check tool
  • Using AutoCorrect
  • Transferring data
  • Transferring data between sheets
  • Copying & pasting values
  • Transposing data
  • Consolidating your data

    • Course Number:
    ds_msex2010_03_enus

    Expertise Level
    Beginner