Course details

Excel 2019 for Windows: Inserting & Manipulating Data

Excel 2019 for Windows: Inserting & Manipulating Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Excel 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.0

Lesson Objectives

Excel 2019 for Windows: 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
  • Using the Paste Special tools
  • Transposing a data range
  • Consolidating your data
  • Course Number:
    ds_msex2019_03_enus

    Expertise Level
    Beginner