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
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
Course Number: ds_msex16mc_03_12_enus
Expertise Level
Beginner