Use Excel as your calculator

Applies to: Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. Above all, use Microsoft Excel to handle the maths instead of a calculator! You can type basic formulas to add, divide, multiply, and subtract two or greater numeric values. Or apply the AutoSum feature to swiftly total a range of values without physicallyContinue reading “Use Excel as your calculator”

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”

Define and use names in formulas

Labelling formulas helps make them much simpler to understand and sustain. A name can be defined for a range of cells, function, constant, or table. After adopting the practice of applying names in your workbook, it is easy for you to update, audit, and organise these names. Windows Name a cell Choose a cell. InContinue reading “Define and use names in formulas”

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”

Adding or deleting rows/columns

Adding or deleting rows/columns to enhance the organisation of your worksheet. Applies to: Excel for Microsoft 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. Windows Note: Microsoft Excel has the following column and row limits: 16,384 columns wide by 1,048,576 rows tall. Add or delete a column Choose any cell within the column, then go to HomeContinue reading “Adding or deleting rows/columns”

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”