Entering data in Excel 365 (2023)

“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).
Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.”