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. In this 17-video course, learners can explore various ways to insert, edit, and manipulate data, including undo and redo, Flash Fill, spell check, and transposing a data range. Begin by learning how to select cells in order to apply changes to individual or multiple cells. Then learners will discover different ways of inserting, editing, and replacing data in a spreadsheet, and observe how to insert special characters. The course continues by demonstrating how to edit multiple worksheets simultaneously; delete items in a spreadsheet; and how to use the undo and redo actions. Explore how to create automatic data series; use the Flash Fill feature, and insert dropdown menus. Delve into configuring the spell check and autoCorrect options; transferring, and copying and pasting data. Complete this course by observing how to move data from one worksheet to another, and transpose 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