Excel for Data Science: Your Guide to Important Functions for Data Analysis

Photo by Olivie Strauss on Unsplash

Here’s a list of important Excel functions that are frequently used in data science and analysis:

I. Data Cleaning and Manipulation:

CONCATENATE:

• Combines two or more strings into one.

LEFT / RIGHT / MID:

• Extracts a specified number of characters from the left, right, or middle of a text string.

TRIM:

• Removes leading and trailing spaces from a text string.

LEN:

• Returns the number of characters in a text string.

LOWER / UPPER:

• Converts text to lowercase or uppercase.

PROPER:

• Capitalizes the first letter of each word in a text string.

SUBSTITUTE:

• Replaces occurrences of a specified substring with another substring in a text string.

CLEAN:

• Removes non-printable characters from text.

TEXT:

• Converts a value to text in a specified format.

II. Statistical Analysis: