Inserting & Editing data in Excel for the Web
Excel for the Web
| Intermediate
- 10 videos | 34m 56s
- Includes Assessment
- Earns a Badge
Excel for the Web contains a number of features to aid in data insertion and manipulation. Explore numerous ways to insert, edit, and manipulate your data, including undo and redo, Flash Fill, spell check, and transposing a data range. To enhance your worksheets, also learn how to insert pictures, shapes, and hyperlinks.
WHAT YOU WILL LEARN
-
Select cells, rows, columns, and tables
Insert, edit, and replace data
Create and duplicate data series
Delete columns, rows, and data
Align data and merge cells -
Undo and redo actions within a spreadsheet
Copy & paste data and formulas
Move data within a worksheet and a worbook
Insert, edit, and delete images and shapes
Insert, edit, and delete links
IN THIS COURSE
-
3m 26sYou can apply changes to individual or multiple cells in Excel for the Web by selecting them. You can select data cells using your mouse, your keyboard or both at the same time to select cells more quickly. Once you know how to select cells, you can start performing other actions like moving or duplicating data. FREE ACCESS
-
2m 21sYou can enter numerical or textual data into your Excel for the Web workbook cells. In this video, you will see how to insert, edit and replace data in your spreadsheet. FREE ACCESS
-
3. Creating automatic data series in Excel for the Web4m 44sOrganize your data into lists and avoid re-entering the same categories repeatedly by creating automatic data series in Excel for the Web. You can create a numbered list that increases by any increment that you choose. You can also create a repeating list using categories like the date, the day of the week or the month. Automatic data series can be created vertically in columns or horizontally in rows. FREE ACCESS
-
4. Deleting items in Excel for the Web3m 38sIf you need to remove data from your Excel for the Web spreadsheet, you can use the delete tools. You have the possibility of removing data within a single cell or within multiple cells. You can also remove entire cells, rows, and columns from your workbook. FREE ACCESS
-
5. Aligning your data in Excel for the Web3m 31sImprove the overall appearance of your table by adjusting your cell's alignment settings. In Excel for the Web, you can not only adjust the horizontal alignment of your cells, but also the vertical alignment. You can also add indents and merge multiple cells. FREE ACCESS
-
6. Undoing & redoing actions in Excel for the Web2m 22sIf you make a mistake while working in your workbooks, use the Undo tool to return your document to its previous state. You can also Redo undone actions if you decide to use them after all. Excel for the Web keeps a record of your recent actions so you can undo and redo multiple actions while working on your workbook. FREE ACCESS
-
7. Copying & pasting data in Excel for the Web4m 2sWhen you copy and paste data in Excel for the Web, you have a number of different options available to you. You can move data from one worksheet to another, and even from one workbook to another. When you paste, you can paste everything that you've copied to a new location, or choose to exclusively paste the formatting, the data values or the data formulas. FREE ACCESS
-
8. Transferring data in Excel for the Web2m 29sExcel for the Web features a number of different ways you can transfer data from one location to another. You can move data within individual sheets, from one worksheet to another, and even from one workbook to another. FREE ACCESS
-
9. Inserting pictures & shapes in Excel for the Web3m 50sIn Excel for the Web, you can insert images and shapes to illustrate your table. See how to insert images from your computer. You will also learn how to insert, edit, and remove shapes. FREE ACCESS
-
10. Inserting a hyperlink in Excel for the Web4m 33sHyperlinks are clickable links that can be inserted into your spreadsheet so that users can be quickly redirected to websites, email addresses, and other places in your document. Excel for the Web automatically recognizes certain hyperlinks - such as email and website addresses. In this video, you'll see once you've inserted a hyperlink you and edit it or remove it. 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.
