Microsoft Excel - Formulas & functions - 60 minutes
Microsoft Excel - Formulas & functions - 60 minutes
Microsoft Excel - Formulas & functions - 60 minutes

Microsoft Excel - Formulas & functions - 60 minutes

Regular price $120.00
Unit price  per 

Overview of formulas in Excel

  • Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007

VLOOKUP

  • Excel for Office 365 Excel 2019 Excel 2016
  • Use VLOOKUP when you need to find things in a table or range by row.

COUNTIF function

  • Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 More...
  • Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.

IF function

  • Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016
  • The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect.

SUMIF

  • Excel for Office 365 Excel 2019 Excel 2016
  • Use the SUMIF function to sum the values in a range that meet criteria that you specify.

Automatically number rows

  • Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007
  • Unlike other Microsoft Office programs, Excel does not provide a button to number data automatically

Calculate the difference between two dates

  • Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007

Define and use names in formulas

  • Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007
  • By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.

Combine text from two or more cells into one cell

  • Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 More...
  • You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.