Manipulating Data in Excel 2010 for Windows

Excel 2010 (Windows)    |    Beginner
  • 16 videos | 53m 54s
  • Earns a Badge
Rating 4.5 of 40 users Rating 4.5 of 40 users (40)
It's possible to manually edit data in Excel; however, this can become tedious, especially with a lot of data. Work smarter, not harder, by exploring various methods for efficiently and effectively inserting and manipulating data in Excel.

WHAT YOU WILL LEARN

  • Selecting cells
    Inputting data
    Inserting special characters
    Editing multiple worksheets simultaneously
    Deleting items in your spreadsheet
    Undoing & redoing actions
    Creating automatic data series
    Using the autocomplete function
  • Inserting dropdown menus
    Using the spell check tool
    Using autocorrect
    Transferring data
    Transferring data between sheets
    Copying & pasting values
    Transposing data
    Consolidating your data

IN THIS COURSE

  • 3m 15s
    If you want to add data to a cell in your worksheet, the quickest way to do so is to select it. In Excel 2010, 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 14s
    The cells found in your Excel 2010 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
  • Locked
    3.  Inserting special characters in Excel 2010 for Windows
    3m 20s
    You will often find it necessary to insert text characters and symbols not found on your keyboard. Excel 2010 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
  • Locked
    4.  Editing multiple worksheets simultaneously in Excel 2010 for Windows
    3m 33s
    In Excel 2010, 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
  • Locked
    5.  Deleting items in your spreadsheet in Excel 2010 for Windows
    3m 33s
    If you need to remove data from your Excel 2010 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 simple 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 2010. FREE ACCESS
  • Locked
    6.  Undoing & redoing actions in Excel 2010 for Windows
    3m 36s
    If you have made a mistake in your worksheet, you might want to use the undo button. Excel 2010 keeps a record of your recent actions and operations. FREE ACCESS
  • Locked
    7.  Creating automatic data series in Excel 2010 for Windows
    2m 32s
    You can quickly add data to your worksheet with Excel 2010's data series tools. You can, for example, create a standard data series that goes up in increments of one. You can also insert weekday and date increments. FREE ACCESS
  • Locked
    8.  Using the AutoComplete function in Excel 2010 for Windows
    2m 26s
    Excel 2010 includes an AutoComplete function which can be used to automatically add data values to your cells. If you have a lot of information to add to your spreadsheet, this tool can save you a great deal of time and effort. FREE ACCESS
  • Locked
    9.  Inserting dropdown menus in Excel 2010 for Windows
    2m 35s
    Dropdown 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 2010, you can create a dropdown menu via the Data Validation menu. FREE ACCESS
  • Locked
    10.  Using the spell check tool in Excel 2010 for Windows
    4m 43s
    Before sharing or printing your workbook, it is a good idea to check it for spelling and grammatical mistakes. Excel 2010 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
  • Locked
    11.  Using AutoCorrect in Excel 2010 for Windows
    3m 51s
    Certain typos can be corrected automatically in Excel 2010 with the AutoCorrect function. See how to use and configure your AutoCorrect settings to quickly correct common errors in your spreadsheet as you type. Quickly enable or disable this feature from you options menu. FREE ACCESS
  • Locked
    12.  Transferring data in Excel 2010 for Windows
    3m 5s
    Sometimes 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 2010 features a number of different ways of transferring your data from one location to another. FREE ACCESS
  • Locked
    13.  Transferring data between sheets in Excel 2010 for Windows
    4m 3s
    In Excel 2010, 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
  • Locked
    14.  Copying & pasting values in Excel 2010 for Windows
    3m 30s
    When you start copying and pasting data in Excel 2010, 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
  • Locked
    15.  Transposing data in Excel 2010 for Windows
    2m 27s
    Transposing data involves inverting the axes: columns become rows, and vice versa. Excel 2010 features a paste special operation that can help you to reuse an existing table and transpose it in a matter of seconds. FREE ACCESS
  • Locked
    16.  Consolidating your data in Excel 2010 for Windows
    4m 11s
    Excel 2010'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.

YOU MIGHT ALSO LIKE

Rating 4.5 of 435 users Rating 4.5 of 435 users (435)
Rating 4.6 of 1438 users Rating 4.6 of 1438 users (1438)
Rating 4.5 of 250 users Rating 4.5 of 250 users (250)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.2 of 501 users Rating 4.2 of 501 users (501)
Rating 4.5 of 89 users Rating 4.5 of 89 users (89)
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)