Manipulating Data

Excel 2016 (Mac)
  • 16 Videos | 59m 8s
  • Earns a Badge
Likes 11 Likes 11
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 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

IN THIS COURSE

  • Playable
    1. 
    Selecting cells
    4m 29s
    UP NEXT
  • Playable
    2. 
    Inputting data
    3m 1s
  • Locked
    3. 
    Inserting special characters
    3m 20s
  • Locked
    4. 
    Editing multiple worksheets simultaneously
    4m 20s
  • Locked
    5. 
    Deleting items in your spreadsheet
    2m 58s
  • Locked
    6. 
    Undoing & redoing actions
    3m 28s
  • Locked
    7. 
    Creating automatic data series
    2m 43s
  • Locked
    8. 
    Using the Flash Fill tool
    3m 36s
  • Locked
    9. 
    Inserting dropdown menus
    4m 40s
  • Locked
    10. 
    Using the spell check tool
    4m 24s
  • Locked
    11. 
    Configuring spell check & AutoCorrect options
    3m 35s
  • Locked
    12. 
    Transferring data
    4m 10s
  • Locked
    13. 
    Copying & pasting data
    3m 43s
  • Locked
    14. 
    Moving data from one worksheet to another
    4m 2s
  • Locked
    15. 
    Transposing a data range
    2m 9s
  • Locked
    16. 
    Consolidating your data
    4m 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.

YOU MIGHT ALSO LIKE

Likes 176 Likes 176  
Likes 23 Likes 23  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 886 Likes 886  
Likes 704 Likes 704  
Likes 203 Likes 203