Excel Office 365 (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 numerous ways to insert, edit, and manipulate data, including undo and redo, Flash Fill, spellcheck, and transposing a data range. Key concepts covered in this course include the many different ways of inserting, editing, and replacing data in your spreadsheet; how to insert a text character or symbol if this is not located on your computer; and how to perform simultaneous edits of data cells with the same cell locations, but found on different worksheets. Next, you will learn how to use deletion tools to remove data from your spreadsheet; learn to organize your data into a list and avoid reentering the same categories repeatedly by creating automatic data series, including working with patterns and dates; and learn to use the Flash Fill feature which allows you to automatically and instantly complete data lists. Finally, you will learn how to insert dropdown menus, use spelling tools, and move data from one worksheet to another.



Expected Duration (hours)
1.1

Lesson Objectives

Excel Office 365 (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_msex365_03_enus

    Expertise Level
    Beginner