Separate First and Last Name with the LEFT, RIGHT, FIND, and LEN functions
Text data in a spreadsheet rarely comes to you in the format you need.
First and last names are combined or the company name is only available through a customer’s email address.
An explanation of the common spreadsheet Logic Functions
IF [this expression evaluates to true]
THEN [return this value]
ELSE [return this value]
The signature of the IF Function:
=IF(logical_test, [value_if_true], [value_if_false])
The first input is logical test. This is where your expression is evaluated.
Logical Test Examples: A > B…
Leverage the lesser known features of SUM and COUNT
Both SUM and COUNT ignore empty cells and cells that contain text.
=SUM() returns the sum of numerical values in a range
=COUNT() returns a count of numerical values in a range
A ground up explanation
A Function does two things:
=FUNCTION_NAME(input_a, [input_b], …)
Save time and avoid re-work with the clever use of simple formulas in Microsoft Excel.
Formulas can be as simple as a cell reference. Microsoft has a good intro video here
Sales Manager: Are there any canceled customers on our DO NOT CONTACT List?
Clever Data Person: Hmm. I’m not sure, but I can find out. What are we using this for?
Sales Manager: We want to reach out to customers who have canceled and understand more about why our service…
Do you have time to clean up this email list?
As clever data people, our answer is “yup, for sure.”
Work involving data is rarely as simple as the question makes it seem.
Let’s find out by asking the Sales Manager a couple of quick questions.