Inserting & Manipulating Data

Excel 2019 (Windows)    |    Beginner
  • 17 Videos | 1h 2m 37s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Likes 180 Likes 180
Delve into data manipulation techniques with Excel 2019 for Windows. In this course, learners can explore various ways to insert, edit, and manipulate data. Begin by learning how to select cells in order to apply changes to individual or multiple cells. Then learners will discover different ways of inserting, editing, and replacing data in a spreadsheet, and observe how to insert special characters. The course continues by demonstrating how to edit multiple worksheets simultaneously; delete items in a spreadsheet; and how to use the undo and redo actions. Explore how to create automatic data series; use the Flash Fill feature, and insert dropdown menus. Delve into configuring the spell check and autoCorrect options; transferring, and copying and pasting data. Complete this course by observing how to move data from one worksheet to another, and transpose a data range. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Inserting & Manipulating Data Exercise as well as the associated materials in the Resources section.

WHAT YOU WILL LEARN

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

IN THIS COURSE

  • Playable
    1. 
    Selecting cells
    4m 29s
    UP NEXT
  • Playable
    2. 
    Inputting data
    2m 45s
  • Locked
    3. 
    Inserting special characters
    4m 24s
    FREE ACCESS
  • Locked
    4. 
    Editing multiple worksheets simultaneously
    4m 25s
    FREE ACCESS
  • Locked
    5. 
    Deleting items in your spreadsheet
    3m 8s
    FREE ACCESS
  • Locked
    6. 
    Undoing & redoing actions
    3m 7s
    FREE ACCESS
  • Locked
    7. 
    Creating automatic data series
    3m 18s
    FREE ACCESS
  • Locked
    8. 
    Using the Flash Fill feature
    2m 48s
    FREE ACCESS
  • Locked
    9. 
    Inserting dropdown menus
    4m 27s
    FREE ACCESS
  • Locked
    10. 
    Using the spell check tool
    2m 36s
    FREE ACCESS
  • Locked
    11. 
    Configuring spell check & AutoCorrect options
    4m 34s
    FREE ACCESS
  • Locked
    12. 
    Transferring data
    3m 10s
    FREE ACCESS
  • Locked
    13. 
    Copying & pasting data
    3m 31s
    FREE ACCESS
  • Locked
    14. 
    Moving data from one worksheet to another
    3m 50s
    FREE ACCESS
  • Locked
    15. 
    Using the Paste Special tools
    4m 38s
    FREE ACCESS
  • Locked
    16. 
    Transposing a data range
    3m 15s
    FREE ACCESS
  • Locked
    17. 
    Consolidating your data
    4m 13s
    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 Working with Macros
Likes 77 Likes 77  
COURSE Creating & Saving Workbooks
Likes 172 Likes 172  
COURSE Getting started in Excel 365
Likes 1 Likes 1  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Creating Charts & Graphics
Likes 119 Likes 119  
COURSE Using Conditional Formulas
Likes 112 Likes 112  
COURSE Creating & Saving Workbooks
Likes 172 Likes 172