Referencing Data in Excel 2013 for Windows

Excel 2013 (Windows)    |    Intermediate
  • 10 videos | 1h 9m 6s
  • Earns a Badge
Likes 29 Likes 29
Increase your Excel 2013 mastery by learning about referencing cells, using data across worksheets, absolute and relative references, and named ranges. In addition, explore automatic updates, formula auditing, and formula errors.


  • Referencing your cells
    Using data across multiple worksheets
    Choosing between absolute & relative cell references
    Naming your data ranges
    Performing calculations using constant values
  • Using cell references indirectly
    Keeping an eye on your data
    Activating automatic updates
    Using formula auditing
    Understanding formula errors


  • 7m 49s
    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 2013, you are going to need to know how to reference your cell correctly. FREE ACCESS
  • 7m 5s
    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 2013, you can even refer to data contained in completely different workbooks. FREE ACCESS
  • Locked
    3.  Choosing between absolute & relative cell references in Excel 2013 for Windows
    8m 35s
    Moving or automating a formula in Excel 2013 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 2013 for Windows
    6m 43s
    Naming your Excel 2013 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.  Performing calculations using constant values in Excel 2013 for Windows
    9m 11s
    You will often use constant data values when working on your Excel 2013 table. If one of your formulas is using a fixed value, then you may find it useful to use the value's cell reference, rather than the value itself. Using the data value in this way can ensure that if you have to make any changes to your fixed value, you only need to change the reference cell, and not every formulas that uses that value. This can save you a lot of time in the long run. FREE ACCESS
  • Locked
    6.  Using cell references indirectly in Excel 2013 for Windows
    6m 22s
    The INDIRECT formula can be used in Excel 2013 to refer to a cell indirectly. This can be very useful if you want to be able to manipulate the data referenced in certain formulas in your spreadsheet without having to adjust it manually. FREE ACCESS
  • Locked
    7.  Keeping an eye on your data in Excel 2013 for Windows
    6m 26s
    There are two very useful tools available in Excel 2013 which can be used to keep an eye on your data entries. These tools can be used to help you insert your formula arguments correctly and even make corrections to data entries stored in different locations in your workbook. FREE ACCESS
  • Locked
    8.  Activating automatic updates in Excel 2013 for Windows
    4m 12s
    Values produced by formulas that you have inserted into your Excel 2013 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
    9.  Using formula auditing in Excel 2013 for Windows
    5m 12s
    If you are unable to understand how your formula has been constructed, you can use the Excel 2013 formula auditing tools. These can show you which cells are used in a formula, and how formulas are dependent on certain data ranges. You can even see if your formula uses data taken from a completely different worksheet. FREE ACCESS
  • Locked
    10.  Understanding formula errors in Excel 2013 for Windows
    7m 32s
    Excel 2013 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


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.


Likes 11 Likes 11  
Likes 1300 Likes 1300