Excel functions (alphabetical)

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Web App, Excel Starter 2010. Select a letter to view Excel functions (alphabetical) that begin with it. Alternatively, press Ctrl+F to access a function by entering theContinue reading “Excel functions (alphabetical)”

COUNTIF function

Applies to: Excel for Office 365, Excel for Office 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010. With COUNTIF, one of the statistical functions, you can count the amount of cells which qualify a criterion; for instance, to count how often a specificContinue reading “COUNTIF function”

Combine text from two or more cells into one cell

Applies to: Excel for Office 365, Excel for Office 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Mobile. Data from numerous cells can be joined into a single cell using the Ampersand symbol (&) or the CONCAT function. Combine data with the Ampersand symbolContinue reading “Combine text from two or more cells into one cell”

IF Function

Applies to: Excel for Office 365, Excel for Office 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010. The IF function is one of Excel’s most recognised functions, enabling you to make logical comparisons between a value and your expected outcome. Therefore, anContinue reading “IF Function”

Automatically number rows

Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. Conversely like other Microsoft Office programmes, Excel does not have a built-in function to number data automatically. Although, you can easily insert sequential numbers to dats rows by dragging the fill handle to populate a column with multiple ranges of numbers or by applying the ROWContinue reading “Automatically number rows”

SUM Function – Overview

This function simply adds values; whether single, cell references/ranges or a combination of all three. For example: =SUM(B2+B3+B4+B5) – Adds each individual cell from B2 to B5. =SUM(B2:B5) – Adds the values in the cell range of B2:B5. Syntax: SUM(number1,[number2],…) Argument name Description number1   Required The first number you want to insert. The number can beContinue reading “SUM Function – Overview”