Extracting Information with Formulas in Excel 2016 for Mac

Excel 2016 (Mac)    |    Intermediate
  • 10 videos | 43m 24s
  • Earns a Badge
Excel includes a number of formulas for extracting information from data. Discover how to use a number of these formulas, including MAX, MIN, LARGE, SMALL, CONCAT, and VLOOKUP.

WHAT YOU WILL LEARN

  • Retrieve information with dates
    Find dates automatically using formulas
    Find the smallest and largest values in a list
    Separate data into multiple cells
    Combine data values in a single cell
  • Insert data automatically into excel 2016 for ma
    Retrieve information using the cell formula
    Retrieve information from your text-based data
    Find data in a database in excel 2016 for mac
    Perform calculations using your data

IN THIS COURSE

  • 3m 46s
    Excel 2016 for Mac 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
  • 6m 4s
    Some formulas in Excel 2016 for Mac 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 Mac
    5m 20s
    The MAX, MIN, LARGE and SMALL formulas are all very useful for analyzing data that has been inserted into your Excel 2016 for Mac table. FREE ACCESS
  • Locked
    4.  Separating data into multiple cells in Excel 2016 for Mac
    4m 50s
    If you have a large amount of data inserted into your cells, you can use the Excel 2016 for Mac 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 Mac
    2m 24s
    The CONCAT formula can be used in Excel 2016 for Mac to combine into a single cell data taken from multiple cells in your worksheet. FREE ACCESS
  • Locked
    6.  Inserting data automatically in Excel 2016 for Mac
    4m 20s
    The VLOOKUP formula can be used to fill in your data cells automatically. Once you have inserted your reference data into Excel 2016 for Mac, 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
    7.  Retrieving information on a cell in Excel 2016 for Mac
    3m 28s
    If you have hidden columns or rows in your spreadsheet, you can extract information from them using the CELL formula. This Excel 2016 for Mac 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
    8.  Retrieving information on your text in Excel 2016 for Mac
    2m 37s
    In Excel 2016 for Mac, 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
    9.  Finding data in a database in Excel 2016 for Mac
    6m 7s
    If you have a complex table containing a large number of different data types, you can use the Excel 2016 for Mac database formulas to extract the information you need. You will find formulas such as DGET, DMIN and DMAX very helpful when it comes to analyzing your data. FREE ACCESS
  • Locked
    10.  Performing calculations using your database in Excel 2016 for Mac
    4m 28s
    A table that you have created in Excel 2016 for Mac 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

Course Finding and analyzing data with formulas in Excel 365
Book Microsoft Excel Functions and Formulas, Sixth Edition: With Excel 2021 / Microsoft 365
Course Using macros in Excel 365

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Using Formulas to Obtain Data in Google Sheets 2020
Book VLOOKUP Awesome Quick: From Your First Excel VLOOKUP to Becoming a VLOOKUP Guru
Course Excel with Python: Performing Advanced Operations