Excel 2016: Inserting & Manipulating Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

Excel 2016 contains a number of features to aid in data insertion and manipulation. Explore numerous ways to insert, edit, and manipulate your data, including undo and redo, Flash Fill, spell check, and transposing a data range.



Expected Duration (hours)
1.1

Lesson Objectives

Excel 2016: Inserting & 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 Flash Fill feature
  • Inserting dropdown menus
  • Using the Spell Check tool
  • Configuring Spell Check & AutoCorrect options
  • Transferring data
  • Copying & pasting data
  • Moving data from one worksheet to another
  • Transposing a data range
  • Consolidating your data

    • Course Number:
    ds_msex2016_03_enus

    Expertise Level
    Beginner