Microsoft Excel 2016 for Mac: Manipulating Data

Expected Duration
Lesson Objectives
Course Number
Expertise Level


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)

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:

    Expertise Level