Inserting & Manipulating Data

Excel 2016 (Windows)    |    Beginner
  • 16 Videos | 1h 3m 32s
  • Includes Assessment
  • Earns a Badge
Likes 203 Likes 203
Excel 2016 contains a number of features to aid in data insertion and manipulation. Explore numerous ways to insert, edit, and manipulate your data, including undo and redo, Flash Fill, spell check, and transposing a data range.

WHAT YOU WILL LEARN

  • Selecting cells
    Inputting data
    Inserting special characters
    Editing multiple worksheets simultaneously
    Deleting items in your spreadsheet
    Undoing & redoing actions
    Creating automatic data series
    Using the Flash Fill feature
  • Inserting dropdown menus
    Using the Spell Check tool
    Configuring Spell Check & AutoCorrect options
    Transferring data
    Copying & pasting data
    Moving data from one worksheet to another
    Transposing a data range
    Consolidating your data

IN THIS COURSE

  • Playable
    1. 
    Selecting cells
    5m 25s
    UP NEXT
  • Playable
    2. 
    Inputting data
    2m 32s
  • Locked
    3. 
    Inserting special characters
    3m 21s
  • Locked
    4. 
    Editing multiple worksheets simultaneously
    4m 58s
  • Locked
    5. 
    Deleting items in your spreadsheet
    2m 56s
  • Locked
    6. 
    Undoing & redoing actions
    3m 46s
  • Locked
    7. 
    Creating automatic data series
    5m 19s
  • Locked
    8. 
    Using the Flash Fill feature
    4m 28s
  • Locked
    9. 
    Inserting dropdown menus
    4m 15s
  • Locked
    10. 
    Using the Spell Check tool
    3m 47s
  • Locked
    11. 
    Configuring Spell Check & AutoCorrect options
    3m 47s
  • Locked
    12. 
    Transferring data
    4m 41s
  • Locked
    13. 
    Copying & pasting data
    4m 2s
  • Locked
    14. 
    Moving data from one worksheet to another
    3m 44s
  • Locked
    15. 
    Transposing a data range
    2m 39s
  • Locked
    16. 
    Consolidating your data
    3m 51s

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 11 Likes 11  
Likes 212 Likes 212  
Likes 5 Likes 5  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 66 Likes 66  
Likes 139 Likes 139  
Likes 886 Likes 886