Manipulating Data
Excel 2016 (Mac)
| Beginner
- 16 Videos | 59m 8s
- Earns a Badge
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.
WHAT YOU WILL LEARN
-
select cells in Excel 2016 in Macinput data into your spreadsheetmanipulate and insert special charactersedit multiple worksheets simultaneouslydelete items from spreadsheets in Excel 2016 for Macuse the undo button in Excel 2016 for Maccreate automatic data series in Excel 2016 for Macuse the Flash Fill tool in Excel 2016 for Mac
-
insert dropdown menus in Excel 2016 for Macuse the spell check toolconfigure your spell check and AutoCorrect settingstransfer date from one location to another in Excel 2016 for Maccopy and paste data in Excel 2016 for Macmove data from one worksheet to another in Excel 2016 for Mactranspose data quickly in Excel 2016 for Macconsolidate your data in Excel 2016 for Mac
IN THIS COURSE
-
1.Selecting cells4m 29sUP NEXT
-
2.Inputting data3m 1s
-
3.Inserting special characters3m 20s
-
4.Editing multiple worksheets simultaneously4m 20s
-
5.Deleting items in your spreadsheet2m 58s
-
6.Undoing & redoing actions3m 28s
-
7.Creating automatic data series2m 43s
-
8.Using the Flash Fill tool3m 36s
-
9.Inserting dropdown menus4m 40s
-
10.Using the spell check tool4m 24s
-
11.Configuring spell check & AutoCorrect options3m 35s
-
12.Transferring data4m 10s
-
13.Copying & pasting data3m 43s
-
14.Moving data from one worksheet to another4m 2s
-
15.Transposing a data range2m 9s
-
16.Consolidating your data4m 30s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.