Inserting & Manipulating Data

Excel Microsoft 365 (Windows)    |    Beginner
  • 17 Videos | 1h 17m 9s
  • Includes Assessment
  • Earns a Badge
Likes 886 Likes 886
Delve into data manipulation techniques with Excel Office 365 for Windows. In this course, learners can explore numerous ways to insert, edit, replace or delete data. Key concepts covered in this course include; how to insert a text character or symbol if this is not located on your computer; how to perform simultaneous edits of data cells with the same cell locations, but found on different worksheets. Learn how to simultaneously edit cells across multiple worksheets; undo previous actions; create an automatic data series; and flash fill data ranges, based on patterns. Other topics include how to limit values and speed up data entry with drop down menus; how to use and configure spell check and autocorrect; edit the dictionary and copy and paste data. Explore how to format values and formulas within spreadsheets, between spreadsheets, or within workbooks; transpose a data range. Finally, familiarize yourself with how to extract data from multiple worksheets and consolidate.

WHAT YOU WILL LEARN

  • select cells in your Excel 365 spreadsheet
    input data in your Excel 365 spreadsheet
    insert special characters in Excel 365
    edit multiple Excel 365 worksheets simultaneously
    delete items in your Excel 365 spreadsheet
    undo and redo actions in Excel 365
    create automatic data series in Excel 365
    use the Excel 365 Flash Fill feature
    insert dropdown menus in Excel 365
  • use the Excel 365 spell check tool
    configure spell check and AutoCorrect options in Excel 365
    transfer data in Excel 365
    copy and paste data in Excel 365
    move data from one Excel 365 worksheet to another
    use the Excel 365 Paste Special tools
    transpose a data range in Excel 365
    consolidate your data in Excel 365

IN THIS COURSE

  • Playable
    1. 
    Selecting cells
    5m 2s
    UP NEXT
  • Playable
    2. 
    Inputting data
    3m 26s
  • Locked
    3. 
    Inserting special characters
    4m 26s
  • Locked
    4. 
    Editing multiple worksheets simultaneously
    4m 30s
  • Locked
    5. 
    Deleting items in your spreadsheet
    3m 44s
  • Locked
    6. 
    Undoing & redoing actions
    3m 25s
  • Locked
    7. 
    Creating automatic data series
    3m 29s
  • Locked
    8. 
    Using the Flash Fill feature
    3m 1s
  • Locked
    9. 
    Inserting dropdown menus
    5m 12s
  • Locked
    10. 
    Using the spell check tool
    2m 51s
  • Locked
    11. 
    Configuring spell check & AutoCorrect options
    5m 22s
  • Locked
    12. 
    Transferring data
    3m 53s
  • Locked
    13. 
    Copying & pasting data
    4m 10s
  • Locked
    14. 
    Moving data from one worksheet to another
    4m 38s
  • Locked
    15. 
    Using the Paste Special tools
    4m 34s
  • Locked
    16. 
    Transposing a data range
    2m 31s
  • Locked
    17. 
    Consolidating your data
    4m 27s

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 705 Likes 705  
Likes 212 Likes 212  
Likes 39 Likes 39  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 628 Likes 628  
Likes 704 Likes 704  
Likes 372 Likes 372