Manipulating Data in Excel 2013 for Windows
Excel 2013 (Windows)
| Beginner
- 15 videos | 1h 20m 33s
- Earns a Badge
Learn the basics of working with data in Excel 2013, including selecting cells, inputting data, undoing and redoing actions, filling, spellchecking, copy and pasting, moving data to another worksheet, and consolidating data.
WHAT YOU WILL LEARN
-
Selecting cellsInputting dataInserting special charactersEditing multiple worksheets simultaneouslyDeleting items in your spreadsheetUndoing & redoing actionsCreating automatic data seriesUsing the flash fill feature
-
Inserting dropdown menusUsing the spell check toolTransferring dataCopying & pasting dataMoving data from one worksheet to anotherTransposing a data rangeConsolidating your data
IN THIS COURSE
-
7m 1sIf you want to add data to a cell in your worksheet, the quickest way to do so is to select it. In Excel 2013, you can select individual cells, multiple cells, and even non-contiguous cells. These cells can be selected using your mouse, your keyboard or both at the same time. FREE ACCESS
-
3m 44sThe cells found in your Excel 2013 spreadsheet can contain both numerical and textual data. There are a number of different ways of inserting data into your spreadsheet. There are also a number of different ways of editing existing cell entries and deleting them. FREE ACCESS
-
5m 11sYou will often find it necessary to insert text characters and symbols not found on your keyboard. Excel 2013 features a library of special characters that can be inserted into your worksheet. You can manipulate them in exactly the same way as you would any standard text characters or numbers. You can also insert multiple characters at the same time. FREE ACCESS
-
5m 12sIn Excel 2013, you can perform simultaneous edits of data cells with the same cell locations but found in different worksheets. This can be very useful if, for example, you are modifying all the header entries in multiple tables across different worksheets. The modifications will be applied to the same cells in each selected worksheet, as if they were superimposed. These cell selections are sometimes referred to as 3D ranges. FREE ACCESS
-
5m 24sIf you need to remove data from your Excel 2013 spreadsheet, you can use the delete tools. You can remove single cells, cell selections, and even entire rows or columns. Excel can also adjust your table to ensure that no spaces are left in your table. It is also possible however to simply remove the contents of a cell. You will need to know how to use both methods if you want to get the most out of Excel 2013. FREE ACCESS
-
5mIf you have made a mistake in your worksheet, you might want to use the undo button. Excel 2013 keeps a record of your recent actions and operations. If you want to cancel your previous actions and return your worksheet to a previous state, the undo history is the tool you need. It is also a good idea to know how to create a backup copy of your file, just in case you make any changes that you will need to undo later on. FREE ACCESS
-
6m 2sYou can quickly add data to your worksheet with Excel 2013's data series tools. You can, for example, create a standard data series that goes up in increments of one. You can also create weekday lists, insert complex data patterns, and even perform calculations to work out the incremental increases in a data range. FREE ACCESS
-
6m 11sThe Flash Fill feature is a new addition to Excel 2013 which allows you to automatically and instantly complete data lists. Excel can work out patterns in your data entry by analyzing the data that your table already contains. Once you have started your list, Excel can complete it automatically, thereby saving you an enormous amount of time. FREE ACCESS
-
4m 42sDropdown menus are very useful if you want to limit the data values that can be inserted into a cell. They are also very useful if you want to speed up your data entry. In Excel 2013, you can create a dropdown menu via the Data Validation menu. FREE ACCESS
-
6m 21sBefore sharing or printing your workbook, it is a good idea to check it for spelling and grammatical mistakes. Excel 2013 features an integrated spell check feature that can take you through any recognized errors. It is also very easy to configure and customize. FREE ACCESS
-
5m 52sSometimes you will need to know how to move 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. Excel 2013 features a number of different ways of transferring your data from one location to another. FREE ACCESS
-
7m 9sWhen you start copying and pasting data in Excel 2013, you will find that you have a large number of options available to you. You can, for example, paste everything that you have copied to a new location. You can also paste any formatting that has been applied, paste values, and even remove any formulas from your copied data range. FREE ACCESS
-
4m 42sIn Excel 2013, it is very easy to move data from one worksheet to another. This can help you save time if you want to use your data in different documents. You can use the standard copy and paste options or the drag and drop mouse manipulations to transfer data to a new location. FREE ACCESS
-
2m 35sTransposing data involves inverting the axes: columns become rows, and vice versa. Excel 2013 features a paste special operation that can help you to reuse an existing table and transpose it in a matter of seconds. FREE ACCESS
-
5m 29sExcel 2013's powerful consolidation tool can extract data that you have spread across multiple worksheets and combine and synthesize it all into a single table. You can also perform multiple calculations on this data, including SUM, AVERAGE and COUNT. 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.