$1.$ CONCATENATE

$=$CONCATENATE$()$ is one of the easiest to learn but most powerful formulas when conducting data analysis. Combine text, numbers, dates and more from multiple cells into one. This is an excellent function for creating API endpoints, product SKUs, and Java queries. Formula:

$=$CONCATENATE$($SELECT CELLS YOU WANT TO COMBINE$)$

In the example: $=$CONCATENATE$($A$4,$B$4)$

Ensure you have formulas in C$4$:C$7$ and C$11$:C$14$ on the sheet named CONCATENATE.

$2.$ LEN

$=$LEN$()$ quickly provides the number of characters in a given cell. As in the example above, you can identify two different kinds of product Stock Keeping Units $($SKUs$)$ using the $=$LEN formula to see how many characters the cell contains. LEN is especially useful when trying to determine the differences between different Unique Identifiers $($UIDs$),$ which are often lengthy and not in the right order.

Formula: $=$LEN$($SELECT CELL$)$

In this example: $=$LEN$($A$2)$

Ensure you have formulas in B$4$:B$8$ on the sheet named LEN. $3.$ COUNTA

$=$COUNTA$()$ identifies whether a cell is empty or not. In the life of a data analyst, you$$re going to run into incomplete data sets daily. COUNTA will allow you to evaluate any gaps the dataset might have without having to reorganize the data.

Formula: $=$COUNTA$($SELECT CELL$)$

In the example: $=$COUNTA$($A$4)$

Ensure you have formulas in D$4$:D$12$ on the sheet named COUNTA. $4.$ DAYS$/$NETWORKDAYS

$=$DAYS is exactly what it implies. This function determines the number of calendar days between two dates. This is a useful tool for assessing the life cycle of products, contracts, and run rating revenue depending on service length $$ a data analysis essential.

$=$NETWORKDAYS is slightly more robust and useful. This formula determines the number of $$workdays$$ between two dates as well as an option to account for holidays. Even workaholics need a break now and then! Using these two formulas to compare time frames is especially helpful for project management.

Formulas:

$=$DAYS$($SELECT CELL, SELECT CELL$)$

OR