## The 4 Ways To Join the Content of Cells in Excel

There are four ways to join the content of the cells in Excel: the ampersand operator &, and the functions CONCATENATE, CONCAT, and TEXTJOIN. The & operator and the CONCATENATE function can be used whatever the Excel version is, whereas The CONCAT and the TEXTJOIN functions are available only in Excel 2019 or newer, and … Read more

## Excel Countif – Count Number of Cells With Specific Data

When doing statistical analysis in Excel, you’ll often need to count the entries that met a specific criteria; e.g. how much a text, number, or alphabetical entry occurs. To do that, you’ll need to use one the COUNTIF function. The COUNTIF function in Excel allows to count the number of occurrences of a number, text, … Read more

## The 4 Ways To Add Numbers in Excel Using SUM Function

This entry is part 6 of 9 in the series Learn Excel: For Beginners

In this tutorial, we will see different methods of how to sum in Excel using the AutoSum tool and the SUM function.

## Excel Formulas and Functions – The Ultimate Guide

This entry is part 5 of 9 in the series Learn Excel: For Beginners

In this tutorial, we will talk about Excel formulas and functions. Precisely, how to create or insert a formula, how to edit it, how to use functions in a formula, how to copy a formula down a column or along a row, and how to show formulas in Excel.