Adding & arranging data in Excel 365

Excel Microsoft 365 (2021)    |    Beginner
  • 13 Videos | 1h 11m 44s
  • 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
    47s
    UP NEXT
  • Playable
    2. 
    Filling cells in Excel
    4m 49s
  • Locked
    3. 
    Inserting columns and rows
    4m 4s
  • Locked
    4. 
    Using the Paste Special tools
    4m 44s
  • Locked
    5. 
    Aligning your data
    5m 27s
  • Locked
    6. 
    Freezing and unfreezing panes
    4m 50s
  • Locked
    7. 
    Selecting cells and ranges
    5m 13s
  • Locked
    8. 
    Merging and unmerging cells
    3m 24s
  • Locked
    9. 
    Working with multiple workbooks
    5m 31s
  • Locked
    10. 
    Editing multiple worksheets simultaneously
    3m 55s
  • Locked
    11. 
    Importing data from a text file
    2m 47s
  • Locked
    12. 
    Importing data from a CSV file
    2m 53s
  • Locked
    13. 
    Moving data from one location to another
    5m 20s

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.