Manipulating Data in Excel 2016 for Mac

Excel 2016 (Mac)    |    Beginner
  • 16 videos | 59m 8s
  • Earns a Badge
Likes 13 Likes 13
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

  • select cells in Excel 2016 in Mac
    input data into your spreadsheet
    manipulate and insert special characters
    edit multiple worksheets simultaneously
    delete items from spreadsheets in Excel 2016 for Mac
    use the undo button in Excel 2016 for Mac
    create automatic data series in Excel 2016 for Mac
    use the Flash Fill tool in Excel 2016 for Mac
  • insert dropdown menus in Excel 2016 for Mac
    use the spell check tool
    configure your spell check and AutoCorrect settings
    transfer date from one location to another in Excel 2016 for Mac
    copy and paste data in Excel 2016 for Mac
    move data from one worksheet to another in Excel 2016 for Mac
    transpose data quickly in Excel 2016 for Mac
    consolidate your data in Excel 2016 for Mac

IN THIS COURSE

  • Playable
    1.  Selecting cells in Excel 2016 for Mac
    4m 29s
    Apply changes to individual or multiple cells in Excel 2016 for Mac 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… FREE ACCESS
  • Playable
    2.  Inputting data in Excel 2016 for Mac
    3m 1s
    The cells found in your Excel 2016 for Mac spreadsheet can contain both numerical and textual data. There are many different ways of inserting, editing, and replacing data in your spreadsheet. FREE ACCESS
  • Locked
    3.  Inserting special characters in Excel 2016 for Mac
    3m 20s
    You will often find it necessary to insert text characters and symbols not found on your keyboard. Excel 2016 for Mac features a library of special characters that can be inserted into your worksheet. You can manipulate… FREE ACCESS
  • Locked
    4.  Editing multiple worksheets simultaneously in Excel 2016 for Mac
    4m 20s
    In Excel 2016 for Mac, 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… FREE ACCESS
  • Locked
    5.  Deleting items in your spreadsheet in Excel 2016 for Mac
    2m 58s
    If you need to remove data from your Excel 2016 for Mac 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… FREE ACCESS
  • Locked
    6.  Undoing & redoing actions in Excel 2016 for Mac
    3m 28s
    If you have made a mistake in your worksheet, you might want to use the undo button. Excel 2016 for Mac keeps a record of your recent actions and operations. If you want to cancel your previous actions and return your… FREE ACCESS
  • Locked
    7.  Creating automatic data series in Excel 2016 for Mac
    2m 43s
    Organize your data into lists and avoid reentering the same categories repeatedly by creating automatic data series in Excel 2016 for Mac. You can create a numbered list that increases by any increment that you choose.… FREE ACCESS
  • Locked
    8.  Using the Flash Fill tool
    3m 36s
    The Flash Fill feature is a new addition to Excel 2016 for Mac, 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… FREE ACCESS
  • Locked
    9.  Inserting dropdown menus in Excel 2016 for Mac
    4m 40s
    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 2016 for Mac, you can create a dropdown… FREE ACCESS
  • Locked
    10.  Using the spell check tool in Excel 2016 for Mac
    4m 24s
    In Excel 2016 for Mac, you can check the spelling of a single worksheet or your entire workbook. Access the spell check function via the review tab to get started correcting your spelling. You'll be able to ignore or… FREE ACCESS
  • Locked
    11.  Configuring spell check & AutoCorrect options in Excel 2016 for Mac
    3m 35s
    If you don't always like the way that spell check flags words as incorrect or that words are automatically corrected, you'll want to check out your proofing settings to customize these options. For example, you… FREE ACCESS
  • Locked
    12.  Transferring data in Excel 2016 for Mac
    4m 10s
    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 2016 for Mac features… FREE ACCESS
  • Locked
    13.  Copying & pasting data in Excel 2016 for Mac
    3m 43s
    When you start copying and pasting data in Excel 2016 for Mac, 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… FREE ACCESS
  • Locked
    14.  Moving data from one worksheet to another in Excel 2016 for Mac
    4m 2s
    In Excel 2016 for Mac, 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… FREE ACCESS
  • Locked
    15.  Transposing a data range in Excel 2016 for Mac
    2m 9s
    Transposing data involves inverting the axes: columns become rows, and vice versa. Excel 2016 for Mac 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 2016 for Mac
    4m 30s
    Excel 2016 for Mac'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… 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE