Inserting & Manipulating Data
Excel 2019 (Windows)
| Beginner
- 17 Videos | 1h 2m 37s
- Includes Assessment
- Earns a Badge
- CPE
Delve into data manipulation techniques with Excel 2019 for Windows. In this course, learners can explore various ways to insert, edit, and manipulate data. Begin by learning how to select cells in order to apply changes to individual or multiple cells. Then learners will discover different ways of inserting, editing, and replacing data in a spreadsheet, and observe how to insert special characters. The course continues by demonstrating how to edit multiple worksheets simultaneously; delete items in a spreadsheet; and how to use the undo and redo actions. Explore how to create automatic data series; use the Flash Fill feature, and insert dropdown menus. Delve into configuring the spell check and autoCorrect options; transferring, and copying and pasting data. Complete this course by observing how to move data from one worksheet to another, and transpose a data range. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Inserting & Manipulating Data Exercise as well as the associated materials in the Resources section.
WHAT YOU WILL LEARN
-
select cells in Excel 2019input data in Excel 2019insert special characters in Excel 2019edit multiple Excel 2019 worksheets simultaneouslydelete items in your Excel 2019 spreadsheetundo and redo actions in Excel 2019create automatic data series in Excel 2019use the Excel 2019 Flash Fill featureinsert dropdown menus in Excel 2019
-
use the spell check tool in Excel 2019configure spell check and AutoCorrect options in Excel 2019transfer data in Excel 2019copy and paste data in Excel 2019move data from one Excel 2019 worksheet to anotheruse the Excel 2019 Paste Special toolstranspose a data range in Excel 2019consolidate your data in Excel 2019
IN THIS COURSE
-
1.Selecting cells4m 29sUP NEXT
-
2.Inputting data2m 45s
-
3.Inserting special characters4m 24s
-
4.Editing multiple worksheets simultaneously4m 25s
-
5.Deleting items in your spreadsheet3m 8s
-
6.Undoing & redoing actions3m 7s
-
7.Creating automatic data series3m 18s
-
8.Using the Flash Fill feature2m 48s
-
9.Inserting dropdown menus4m 27s
-
10.Using the spell check tool2m 36s
-
11.Configuring spell check & AutoCorrect options4m 34s
-
12.Transferring data3m 10s
-
13.Copying & pasting data3m 31s
-
14.Moving data from one worksheet to another3m 50s
-
15.Using the Paste Special tools4m 38s
-
16.Transposing a data range3m 15s
-
17.Consolidating your data4m 13s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.