Entering data in Excel 365 (2023)
Excel 365 (2023)
| Beginner
- 11 videos | 42m 23s
- Includes Assessment
- Earns a Badge
- CPE
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.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in the entering data in excel 365 course
Copy, paste, and cut items with the office clipboard
Use paste options and paste special to paste values, formats, and more
Use autofill to copy data and complete a series
Complete a series using advanced fill series options
Use flash fill to fill in data following a pattern -
Create and remove drop-down lists
Group multiple worksheets to edit them simultaneously
Import data from a text or csv file
Import data from online sources
Import data from a picture file in excel 365
IN THIS COURSE
-
1mThis video outlines the key content covered in the Entering data in Excel 365 course, including using the clipboard tools, using the Fill Series command, and importing data from online sources. FREE ACCESS
-
4m 28sIn Microsoft Office programs, you can copy all kinds of items, from data ranges to images, to the Office Clipboard. The Clipboard holds up to 24 items which can be copied from other documents and programs, not just Excel. In this tutorial, you will see how to use the Office Clipboard to cut, copy, and paste items in Excel. FREE ACCESS
-
3. Applying special paste options in Excel 3655m 3sWhen you copy and paste data in Excel, all formulas, formatting, and other information in the source cells are pasted by default. Paste Options allow you to customize the content and formatting of pasted cells. Find out more in this tutorial. This video aligns with MO-210 Microsoft Excel Exam objective: Paste data by using special paste options. FREE ACCESS
-
4. Using AutoFill in Excel 3654m 47sData entry can be a repetitive task. In Excel, you can use AutoFill to save time by copying data or completing a series of numbers, days, dates, or times. See how in this tutorial. This video aligns with MO-210 Microsoft Excel Exam objective: Fill cells by using Auto Fill. FREE ACCESS
-
5. Using the Fill Series command4m 2sMuch like AutoFill, the Fill Series command allows you to quickly create a series. You can use this feature to generate linear series, growth series, as well as patterns based on dates and text. Find out more in this tutorial. This video aligns with MO-211 Microsoft Excel Expert Exam objective: Fill cells by using advanced Fill Series options. FREE ACCESS
-
6. Using Flash Fill in Excel 3653m 58sFlash Fill is an intelligent feature that automatically fills rows or columns when it detects a pattern. In this video, you will see how to use Flash Fill to split text into two columns, combine information from multiple columns, and format text. This video aligns with MO-211 Microsoft Excel Expert Exam objective: Fill cells by using Flash Fill. FREE ACCESS
-
7. Creating drop-down lists in Excel 3654m 50sDrop-down lists can help you and your team work more efficiently by selecting values from a list. In this tutorial you will see how to create drop-downs from a comma-separated list and from a table. You will also see how to add and remove items from your list. FREE ACCESS
-
8. Editing multiple worksheets at once in Excel 3653m 30sIn Excel, you can group worksheets together. This allows you to save time by editing multiple worksheets simultaneously. Find out how in this tutorial. FREE ACCESS
-
9. Importing data from a text or CSV file in Excel 3653m 28sCSV and text files both store tabular data in plain text. While these formats cannot always be edited directly in Excel, you can import both types of files as tables in Excel. This video aligns with MO-210 Microsoft Excel Exam objective: Import data from text files FREE ACCESS
-
10. Importing data from online sources in Excel 3653m 43sCompared to manually entering data, you can save time by importing data from online sources. In this video, you will see how to import online data and manage the data you have imported. This video aligns with MO-210 Microsoft Excel Exam objective: Importing data from online sources. FREE ACCESS
-
11. Importing data from a picture in Excel 3653m 34sA new feature of Excel 365 allows you to turn images into data that you can edit. With the Data from Picture feature, you can insert data from a screen capture on your clipboard, or an image file from your computer. In this video, learn to import data from a picture in Excel 365. 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.
