15 Excel Data Analysis Functions You Need to Know

15 Excel Data Analysis Functions You Need to Know

Your ability to examine data will be improved by  simple routines, and you'll wonder how you ever managed without them.

CONCATENATE

CONCATENATE

when conducting data analysis. Combine text, numbers, dates and more from multiple cells into one.

LEN

LEN

you can identify two different kinds of product Stock Keeping Units (SKUs) using the =LEN formula to see how many characters the cell contains.

COUNTA

COUNTA

COUNTA will allow you to evaluate any gaps the dataset might have without having to reorganize the data.

DAYS/NETWORKDAYS

 It is a useful tool for assessing the lifecycle of products, contracts, and run rating revenue depending on service length –

 It is a useful tool for assessing the lifecycle of products, contracts, and run rating revenue depending on service length – 

The IF function is extremely useful. This function means we can automate decision making in our spreadsheets.

IF

IF

TRIM

TRIM

when conducting data analysis. Combine text, numbers, dates and more from multiple cells into one.

SUMIFS is used to determine how much each product is contributing to top-line revenue. Formula: =SUMIF(RANGE,CRITERIA,[sum_range])

SUMIFS

SUMIFS

AVERAGEIFS

AVERAGEIFS

Much like SUMIFS, AVERAGEIFS allows you to take an average based on one or more criteria.

, accounts receivable might know how much each product costs, but the shipping department can only provide units shipped. That is the perfect use case for VLOOKUP.

VLOOKUP

VLOOKUP

if you use FIND to query for “Big” you will only return Big=true results

FIND/SEARCH

FIND/SEARCH

Use =IFERROR to replace the #VALUE errors with any text/value.

IFERROR

IFERROR

=LEFT, =RIGHT are efficient and straightforward methods for extracting static data out of cells

LEFT/RIGHT

LEFT/RIGHT

when conducting data analysis. Combine text, numbers, dates and more from multiple cells into one.

RANK

RANK

=RANK allows you to quickly denote how values rank in a dataset in ascending or descending order.

RANK

RANK

it allows you to take the minimum of a set of values, and match on criteria as well.

MINIFS

MINIFS

Our mission is to make Uttarakhand IT hub with our excellence in education in Data Science and Data analytics education.

enroll today