Adding & arranging data in Excel 365

Excel Microsoft 365 (2021)    |    Beginner
  • 13 Videos | 44m 43s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 13 Likes 13
In Excel 365, it is easy to add new content to workbooks and change how values are arranged. This course demonstrates how to add and manage content in your worksheets, including how to insert columns and rows, and data into cells. You will begin by learning how to fill cells using the AutoFill feature; as well as how to insert columns and rows into a worksheet. Next, you will observe how to paste copied data using the Paste Special tools; how to align values in cells; as well as how to freeze rows or columns to avoid unnecessary scrolling. Finally, you'll explore how to select cells and ranges; and how to merge content across various cells or unmerge if necessary.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this Microsoft 365: Adding and arranging data in Excel 365 course
    fill cells in Excel 365 using AutoFill
    insert columns, rows and cells into an Excel 365 worksheet
    use the Excel 365 Paste Special tools
    align data in Excel 365
    freeze and unfreeze panes in Excel 365
    select cells and ranges in Excel 365
  • merge and unmerge cells in Excel 365
    manage and move between multiple Excel 365 workbooks
    edit multiple Excel 365 worksheets simultaneously
    import data from a text file
    import data from a CSV file
    move data from one Excel 365 location to another

IN THIS COURSE

  • Playable
    1. 
    Course Overview: Adding and arranging data in Excel 365
    40s
    UP NEXT
  • Playable
    2. 
    Filling cells in Excel
    3m 58s
  • Locked
    3. 
    Inserting columns and rows
    3m 26s
  • Locked
    4. 
    Using the Paste Special tools
    3m 58s
  • Locked
    5. 
    Aligning your data
    4m 31s
  • Locked
    6. 
    Freezing and unfreezing panes
    4m 1s
  • Locked
    7. 
    Selecting cells and ranges
    4m 15s
  • Locked
    8. 
    Merging and unmerging cells
    2m 42s
  • Locked
    9. 
    Working with multiple workbooks
    4m 37s
  • Locked
    10. 
    Editing multiple worksheets simultaneously
    3m 21s
  • Locked
    11. 
    Importing data from a text file
    2m 22s
  • Locked
    12. 
    Importing data from a CSV file
    2m 27s
  • Locked
    13. 
    Moving data from one location to another
    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