Microsoft Excel 2016 for Mac: 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)
1.0

Lesson Objectives

Microsoft Excel 2016 for Mac: 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 tool
  • 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_msex16mc_03_12_enus

    Expertise Level
    Beginner