Entering data in Excel 365 (2023)

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. Before you can begin analyzing data in Excel, you need to know how to input it into a worksheet. This course explores a variety of tools and techniques for adding and arranging data in Excel 365. The first part of this course introduces you to essential data entry tools. Find out how to use the clipboard commands and Paste Special to copy and move data between cells and sheets. Learn how to use AutoFill and Flash-Fill to copy data, complete series, and find patterns in your data. See also how to insert drop-downs to allow users to select cell values from a list. Next, the course explores two ways to enter data in multiple worksheets or workbooks. See how to arrange and navigate between multiple windows, as well as how to group worksheets to edit several sheets simultaneously. Finally, learn how to import data from external sources, such as text files, online sources, and images. This course aligns with the objectives of Exams MO-210: Microsoft Excel (Microsoft 365 Apps) and MO-211: Microsoft Excel Expert (Microsoft 365 Apps). In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane.