Referencing Data in Excel 2016 for Mac

Excel 2016 (Mac)    |    Intermediate
  • 7 videos | 32m 56s
  • Earns a Badge
Rating 4.4 of 8 users Rating 4.4 of 8 users (8)
To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.

WHAT YOU WILL LEARN

  • Reference cells in excel 2016 for mac
    Use data across multiple worksheets in excel 2016 for mac
    Choose between absolute and relative cell references
    Name your data ranges in excel 2016 for mac
  • Activate and deactivate automatic updates
    Use the formula auditing tools in excel 2016 for mac
    Identify formula error messages in excel 2016 for mac

IN THIS COURSE

  • 6m 3s
    If you want to use the contents of a particular cell or cell range, then you must know how to reference them. This involves inserting the coordinates of your cell in order to extract the value it contains. If you want to begin manipulating your data in Excel 2016 for Mac, you are going to need to know how to reference your cell correctly. FREE ACCESS
  • 3m 56s
    When storing and using data on several different worksheets in your document, it is important to know how to reference them correctly in your formulas. In Excel 2016 for Mac, you can even refer to data contained in completely different workbooks. FREE ACCESS
  • Locked
    3.  Choosing between absolute & relative cell references in Excel 2016 for Mac
    5m 40s
    Moving or automating a formula in Excel 2016 for Mac will automatically adjust the cell references that it contains. Any references to cells, columns and rows contained in these formulas are known as relative cell references. If you want to avoid any adjustments being made to your formula's cell references, you will need to learn how to use the dollar sign ($). FREE ACCESS
  • Locked
    4.  Naming your data ranges in Excel 2016 for Mac
    3m 33s
    Naming your Excel 2016 for Mac data ranges can allow you to refer to and use them later on. Once you have named your data range, you can easily incorporate it into your calculations, dropdown menus and filters. FREE ACCESS
  • Locked
    5.  Activating automatic updates in Excel 2016 for Mac
    3m 7s
    Values produced by formulas that you have inserted into your Excel 2016 for Mac worksheet are by default automatically kept up to date. This means that if data that your formula is using is modified at some point, your calculation will be adjusted to take into account the change in value. You can, however, deactivate this automatic update, and choose when your values are updated yourself. FREE ACCESS
  • Locked
    6.  Using formula auditing in Excel 2016 for Mac
    4m 55s
    If you are unable to understand how your formula has been constructed, you can use the Excel 2016 for Mac formula auditing tools. These can show you which cells are used in a formula, and how formulas are dependent on certain data ranges. FREE ACCESS
  • Locked
    7.  Understanding formula errors in Excel 2016 for Mac
    5m 42s
    Excel 2016 for Mac features a wide range of formula error messages. If you want to fix these problems, you are going to need to know how to identify what each message represents and how the error was produced. 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 1501 users Rating 4.5 of 1501 users (1501)
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)