Adding & arranging data in Excel 365

Excel Microsoft 365 (2021)    |    Beginner
  • 13 videos | 44m 43s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 2813 users Rating 4.5 of 2813 users (2813)
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. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this microsoft 365: adding & 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

  • 40s
    This video outlines the key content covered in the Microsoft 365: Adding & arranging data in Excel 365 course, including how to insert columns and rows, merging and unmerging cells, and how to import data from a text or CSV file. FREE ACCESS
  • 3m 58s
    Worksheets often contain repetitive information, such as dates. In this video, you will discover how to use the AutoFill feature to complete a series of data in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 2.1.2 Fill cells by using Auto Fill. FREE ACCESS
  • Locked
    3.  Inserting columns and rows
    3m 26s
    Worksheets consist of columns and rows. In this video, you will explore how to insert columns and rows in Excel 365 and insert multiple columns, rows and cells in a single action. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 2.1.4 Insert and delete cells. As well as MOS MO-200 / Excel Associate Certification exam objectives: 2.1.3 Insert and delete multiple columns or rows and 3.2.1 Add or remove table rows and columns. FREE ACCESS
  • Locked
    4.  Using the Paste Special tools
    3m 58s
    Excel has various options to paste your data, such as pasting only the formats or transposing the data. In this video, you will discover how to use the Paste Special tools in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 2.1.1 Paste data by using special paste options. FREE ACCESS
  • Locked
    5.  Aligning your data
    4m 31s
    The appearance of an Excel 365 worksheet can be improved by adjusting a cell's alignment, or the placement of data within a cell. In this video, you will explore how to change the horizontal and vertical alignment, wrap text, and adjust a text's orientation. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 2.2.2 Modify cell alignment, orientation, and indentation. As well as MOS MO-200 / Excel Associate Certification exam objective: 2.2.4 Wrap text within cells. FREE ACCESS
  • Locked
    6.  Freezing and unfreezing panes
    4m 1s
    Scrolling through a large worksheet can be tedious, especially if you lose track of the headers. In this video, you will learn how to freeze panes, the first row and the first column in your Excel 365 worksheet. You will also learn how to use the Split view. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.4.3 Freeze worksheet rows and columns, as well as MOS MO-200 / Excel Associate Certification exam objective: 1.4.4 Change window views. FREE ACCESS
  • Locked
    7.  Selecting cells and ranges
    4m 15s
    In Excel 365, you can apply changes to individual or multiple cells once you've made a selection. In this video, you will discover how to select cells and ranges using your mouse, your keyboard, or both at the same time. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.2.2 Navigate to named cells, ranges, or workbook elements. FREE ACCESS
  • Locked
    8.  Merging and unmerging cells
    2m 42s
    The Merge feature in Excel 365 allows you to create and center your text, such as a header, across a range or table. In this video, you will explore how to merge values across cells and unmerge cells that have been merged. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 2.2.1 Merge and unmerge cells. FREE ACCESS
  • Locked
    9.  Working with multiple workbooks
    4m 37s
    Occasionally, you may need to alternate-working between more than one workbook in Excel 365. In this video, you will explore how to manage multiple workbooks, adjust the visualization of the windows, and move from one workbook to another. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.4.4 Change window views. FREE ACCESS
  • Locked
    10.  Editing multiple worksheets simultaneously
    3m 21s
    Sometimes different Excel 365 worksheets contain similar data, such as the same headers. In this video, you will learn how to perform simultaneous edits of data cells with the same cell location in different worksheets. FREE ACCESS
  • Locked
    11.  Importing data from a text file
    2m 22s
    If you've entered data into a text file that you want to import to Excel, there's a feature that makes it possible. In this video, you will discover how to import data from a text document into Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.1.1 Import data from .txt files. FREE ACCESS
  • Locked
    12.  Importing data from a CSV file
    2m 27s
    CSV files, which contain comma-separated-values, can be imported into Excel 365. In this video, explore how to import CSV data into a worksheet. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.1.2 Import data from .csv files. FREE ACCESS
  • Locked
    13.  Moving data from one location to another
    4m 27s
    To save time, Excel 365 allows you to easily move data between worksheets and even from one workbook to another. In this video, explore the methods to move data from one location to another. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Ten common tools in Excel 365
Rating 4.5 of 1331 users Rating 4.5 of 1331 users (1331)
Course Working with tables in Excel 365
Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)
Course Managing macros in Excel 365
Rating 4.4 of 163 users Rating 4.4 of 163 users (163)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Getting started with charts in Excel 365
Rating 4.5 of 1670 users Rating 4.5 of 1670 users (1670)
Course Printing spreadsheets in Excel 365
Rating 4.6 of 1014 users Rating 4.6 of 1014 users (1014)
Course Collaborating effectively in Excel 365
Rating 4.6 of 378 users Rating 4.6 of 378 users (378)