5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Productivity & Collaboration Tools     Office 365     Excel 365

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.



Objectives

Excel 365: Adding & arranging data

  • 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
  • Knowledge Check: Adding and arranging data in Excel 365