Manipulating Data

Excel 2016 (Mac)    |    Beginner
  • 16 Videos | 59m 8s
  • Earns a Badge
Likes 13 Likes 13
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
    FREE ACCESS
  • Locked
    4. 
    Editing multiple worksheets simultaneously
    4m 20s
    FREE ACCESS
  • Locked
    5. 
    Deleting items in your spreadsheet
    2m 58s
    FREE ACCESS
  • Locked
    6. 
    Undoing & redoing actions
    3m 28s
    FREE ACCESS
  • Locked
    7. 
    Creating automatic data series
    2m 43s
    FREE ACCESS
  • Locked
    8. 
    Using the Flash Fill tool
    3m 36s
    FREE ACCESS
  • Locked
    9. 
    Inserting dropdown menus
    4m 40s
    FREE ACCESS
  • Locked
    10. 
    Using the spell check tool
    4m 24s
    FREE ACCESS
  • Locked
    11. 
    Configuring spell check & AutoCorrect options
    3m 35s
    FREE ACCESS
  • Locked
    12. 
    Transferring data
    4m 10s
    FREE ACCESS
  • Locked
    13. 
    Copying & pasting data
    3m 43s
    FREE ACCESS
  • Locked
    14. 
    Moving data from one worksheet to another
    4m 2s
    FREE ACCESS
  • Locked
    15. 
    Transposing a data range
    2m 9s
    FREE ACCESS
  • Locked
    16. 
    Consolidating your data
    4m 30s
    FREE ACCESS

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

COURSE Collaborating effectively in Excel 365
COURSE Ten common tools in Excel 365
Likes 1 Likes 1  
COURSE Complete Guide to Excel 365: Validating, Cleaning, & Performing Lookups on Data

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

BOOK Advance Excel 2016 Training Guide
COURSE Custom & Conditional Formatting
Likes 150 Likes 150  
COURSE Basic Formulas
Likes 255 Likes 255