5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Productivity & Collaboration Tools     Microsoft Office for Mac 2016     Microsoft Office for Mac 2016: Excel (No Assessments)

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.



Objectives

Microsoft Excel 2016 for Mac: Manipulating Data

  • select cells in Excel 2016 in Mac
  • input data into your spreadsheet
  • manipulate and insert special characters
  • edit multiple worksheets simultaneously
  • delete items from spreadsheets in Excel 2016 for Mac
  • use the undo button in Excel 2016 for Mac
  • create automatic data series in Excel 2016 for Mac
  • use the Flash Fill tool in Excel 2016 for Mac
  • insert dropdown menus in Excel 2016 for Mac
  • use the spell check tool
  • configure your spell check and AutoCorrect settings
  • transfer date from one location to another in Excel 2016 for Mac
  • copy and paste data in Excel 2016 for Mac
  • move data from one worksheet to another in Excel 2016 for Mac
  • transpose data quickly in Excel 2016 for Mac
  • consolidate your data in Excel 2016 for Mac