Basic Formulas in Excel 2016 for Mac

Excel 2016 (Mac)    |    Beginner
  • 12 videos | 55m 7s
  • Earns a Badge
Rating 4.6 of 130 users Rating 4.6 of 130 users (130)
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.

WHAT YOU WILL LEARN

  • Use the function library to insert a formula in excel 2016 for mac
    Perform simple formulas in excel 2016 for mac
    Create automated cumulative totals in excel 2016 for mac
    Use the fill down function to automate formulas in excel 2016 for mac
    Add subtotals in excel 2016 for mac
    Learn formulas to count cells in a range in excel 2016 for mac
  • Rank values in excel 2016 for mac
    Learn formulas to round your data values in excel 2016 for mac
    Use replacement formulas in excel 2016 for mac
    Insert conditional sum formulas in excel 2016 for mac
    Insert conditional message formulas in excel 2016 for mac
    Use if and or in conditional formulas

IN THIS COURSE

  • 4m 8s
    Excel 2016 for Mac's Function Library can help you to locate and insert the formula you need. These formulas are grouped according to category. If you are unable to find the formula you want, you can also launch a search query. Once you have selected the formula you wish to use, Excel 2016 for Mac can guide you through the arguments that you need to specify. FREE ACCESS
  • 4m 31s
    The cells in your Excel 2016 for Mac worksheet can be thought of as little calculator spaces. You can use these individual cells to perform simple and complex calculations. Once you have inserted a calculation, any data updates that you make will, by default, be included in any dependent calculations. FREE ACCESS
  • Locked
    3.  Creating automated cumulative totals in Excel 2016 for Mac
    3m 18s
    If you have organized your data entries into chronological order, a cumulative total can very quickly be created. In Excel 2016 for Mac, you can create the calculation once and then apply it automatically to the rest of your data entries, thereby saving yourself a lot of time and effort. FREE ACCESS
  • Locked
    4.  Using automated formulas in a table in Excel 2016 for Mac
    4m 36s
    If you are going to be applying your formulas to a large number of data entries in your worksheet, it is important to know how to use the Fill Down function. When a formula is copied and pasted into a new cell in Excel 2016 for Mac, it will - by default - be automatically adjusted to fit its new location. You can however change the way in which these adjustments are applied. FREE ACCESS
  • Locked
    5.  Inserting subtotals in Excel 2016 for Mac
    4m 47s
    When your Excel 2016 for Mac data table has become rather long, adding subtotals for individual subgroups within that table can be very useful. You can use these subtotals to perform various different calculations, all of which can be activated and deactivated at the touch of a button. FREE ACCESS
  • Locked
    6.  Counting cells in a range in Excel 2016 for Mac
    4m 23s
    The COUNTA formula is used in Excel 2016 for Mac to count up the number of cells that contain values. The COUNTIF formula can be used to perform a count of certain values that meet your conditions. You can even use the SUMPRODUCT and COUNTIF formulas together to perform complex but exceedingly useful calculations. FREE ACCESS
  • Locked
    7.  Ranking a value in Excel 2016 for Mac
    5m 37s
    Excel 2016 for Mac's RANK function is extremely useful if you want to find out where a particular value places in a list of data entries. You can also visualize the smallest and largest values in a list by using the SMALL and LARGE formulas. FREE ACCESS
  • Locked
    8.  Rounding a number in Excel 2016 for Mac
    5m 24s
    In Excel 2016 for Mac, there are many different formulas that you can use to round up or down your data values. Which one you choose will depend on how you want to perform the calculation. You can, for example, round a value up to the nearest multiple, round it down to the nearest fraction, and even truncate a value. FREE ACCESS
  • Locked
    9.  Using replacement formulas in Excel 2016 for Mac
    2m 42s
    If you have inserted text data into your spreadsheet and you need to make some changes, you may find that you can perform these modifications with the help of some Excel 2016 for Mac's formulas, SUBSTITUTE, TRIM and REPLACE. FREE ACCESS
  • Locked
    10.  Inserting a conditional sum formula in Excel 2016 for Mac
    6m 8s
    In Excel 2016 for Mac, you can use the SUMIF and SUMIFS formulas to perform a sum calculation on certain data values in your range. All you need to know is how to specify the conditions that your qualifying data values have to meet. These tools can be very useful when creating subtotals in Excel 2016. FREE ACCESS
  • Locked
    11.  Inserting a conditional message formula in Excel 2016 for Mac
    4m 26s
    The SI formula is made up of a range, a condition, a value if true, and a value if false. It can be used to display one message if a condition is met and another if the condition is not met. In Excel 2016 for Mac, you can use qualifying conditions to perform an analysis on a data entry and display a particular value or message depending on the result of the logical test. FREE ACCESS
  • Locked
    12.  Using IF & OR in conditional formulas in Excel 2016 for Mac
    5m 6s
    In Excel 2016 for Mac, you can combine qualifying and alternative conditions in your IF formula. This can allow you to specify various different optional conditions that can be met when calculating your formula. 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

Journey Microsoft Excel
Rating 2.7 of 3 users Rating 2.7 of 3 users (3)
Rating 4.6 of 416 users Rating 4.6 of 416 users (416)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 229 users Rating 4.6 of 229 users (229)
Rating 4.5 of 2842 users Rating 4.5 of 2842 users (2842)
Rating 4.4 of 6009 users Rating 4.4 of 6009 users (6009)