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
    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 Formatting Data
Likes 176 Likes 176  
COURSE Excel Visualization: Getting Started with Excel for Data Visualization
Likes 0 Likes 0  
COURSE Creating & Editing Macros
Likes 23 Likes 23  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Inserting & Manipulating Data
Likes 886 Likes 886  
COURSE Using Basic Formulas
Likes 704 Likes 704  
COURSE Inserting & Manipulating Data
Likes 203 Likes 203