Extracting Information with Formulas in Excel 2016 for Windows

Excel 2016 (Windows)    |    Intermediate
  • 13 videos | 49m 56s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 299 users Rating 4.6 of 299 users (299)
Excel 2016 has a number of formulas for extracting both numeric and textual data from cells. Discover how to use some of these formulas, including MONTH, DAY, YEAR, MAX, MIN, CONCATENATE, SEARCH, LEN, LOOKUP, and VLOOKUP.

WHAT YOU WILL LEARN

  • Retrieving information with dates
    Finding a date automatically
    Finding the largest & smallest values in a list
    Separating data into multiple cells
    Combining data values in a single cell
    Retrieving information on a cell
    Retrieving information on your text
  • Cross referencing two data lists
    Inserting data automatically
    Finding a value in a double entry table
    Performing a search across two tables
    Finding data in a database
    Performing calculations using your database

IN THIS COURSE

  • 4m 44s
    Excel 2016 features a number of different date formulas that can be used to return precise information relating to a particular month, day or year. You can use these formulas - which include MONTH, DAY, YEAR, and WEEKNUM - to extract date information from an existing date entry. FREE ACCESS
  • 3m 22s
    Some formulas in Excel 2016 can be used to automatically find a date according to specified criteria. You can, for example, find out the last date of the previous month, the number of work days in a date range (including public holidays), and even next Sunday's exact date. FREE ACCESS
  • Locked
    3.  Finding the largest & smallest values in a list in Excel 2016 for Windows
    6m 30s
    The MAX, MIN, LARGE and SMALL formulas are all very useful for analyzing data that has been inserted into your Excel 2016 table. FREE ACCESS
  • Locked
    4.  Separating data into multiple cells in Excel 2016 for Windows
    4m 32s
    If you have a large amount of data inserted into your cells, you can use the Excel 2016 formulas to separate your entries and extract the individual components you need. The SEARCH, LEN, LEFT and RIGHT formulas can all be used to extract the different information and elements you might need. FREE ACCESS
  • Locked
    5.  Combining data values in a single cell in Excel 2016 for Windows
    2m 36s
    The CONCATENATE formula can be used in Excel 2016 to combine into a single cell data taken from multiple cells in your worksheet. FREE ACCESS
  • Locked
    6.  Retrieving information on a cell in Excel 2016 for Windows
    3m 23s
    If you have hidden columns or rows in your spreadsheet, you can extract information from them using the CELL formula. This Excel 2016 formula can be used to return a variety of different types of information, including the cell row, its contents, and even its level of protection. FREE ACCESS
  • Locked
    7.  Retrieving information on your text in Excel 2016 for Windows
    2m 38s
    In Excel 2016, you can extract information from text-based data that you have inserted using formulas such as SEARCH and LEN. The former helps you to find the starting point in a text string, while the latter returns the number of characters in a cell. FREE ACCESS
  • Locked
    8.  Cross referencing two data lists in Excel 2016 for Windows
    2m 29s
    In Excel 2016, you can use the VLOOKUP formula to cross reference the contents of two lists. This can help you to check for duplicates in your lists and extract them with ease. If your list is horizontal, you can use the HLOOKUP formula. FREE ACCESS
  • Locked
    9.  Inserting data automatically in Excel 2016 for Windows
    3m 10s
    The VLOOKUP formula can be used to fill in your data cells automatically. Once you have inserted your reference data into Excel 2016, you can use the VLOOKUP tool to automatically cross reference the data range and extract the required information. For all your horizontal lists, you can use the HLOOKUP tool. FREE ACCESS
  • Locked
    10.  Finding a value in a double entry table in Excel 2016 for Windows
    4m 10s
    You can use the LOOKUP formula to find a value in a double entry table that you have created in Excel 2016. You can, for example, use it to find a client's address based on their last name. You can also use the INDEX formula to return a particular value in a table if you know its row and column coordinates. FREE ACCESS
  • Locked
    11.  Performing a search across two tables in Excel 2016 for Windows
    2m 51s
    In Excel 2016, you can use a calculation combining the IF and VLOOKUP formulas to search for a value in two separate data tables. This is very useful if you want to consult multiple data sources and use them to automatically complete a summary table. FREE ACCESS
  • Locked
    12.  Finding data in a database in Excel 2016 for Windows
    6m 2s
    If you have a complex table containing a large number of different data types, you can use the Excel 2016 database formulas to extract the information you need. You will find formulas such as DGET, DBMIN and DMAX very helpful when it comes to analyzing your data. FREE ACCESS
  • Locked
    13.  Performing calculations using your database in Excel 2016 for Windows
    3m 29s
    A table that you have created in Excel 2016 can be used like a simplified database. You can use the DSUM, DAVERAGE, DSTDEV and DSTDEVP formulas to analyze the data found in your spreadsheet. 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 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 4.5 of 449 users Rating 4.5 of 449 users (449)
Rating 4.5 of 310 users Rating 4.5 of 310 users (310)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 75 users Rating 4.6 of 75 users (75)
Rating 4.6 of 473 users Rating 4.6 of 473 users (473)
Rating 4.5 of 285 users Rating 4.5 of 285 users (285)