OM 300 HW 1 - 20 EXCEL DATA
ANALYSIS FUNCTIONS - NATHAN
CHILCUTT(SCORED A+)
CONCATENATE function - ANSWER- A function that joins two or more text strings
into one text string
- Useful for creating API endpoints, product SKUs, and java queries
- if you want a space in between two columns:
=Concatenate(Text 1, " ", Text 2)
NETWORKDAYS function - ANSWER- determines the number of workdays between
two dates as well as an option to account for holidays.
- useful for project management
COUNTIFS Function - ANSWER- the easiest way to count the number of instances
a dataset meets a set of criteria
- powerful because of the limitless criteria you can input
SUMIFS Function - ANSWER- the function calculates the sum values based on
multiple criteria
- useful to determine how much each product is contributing to top-line revenue
LEN function - ANSWER- returns the length of a sequence such as a list
- provides number of characters in a given cell
- useful when trying to determine the difference between different unique identifiers
COUNTA function - ANSWER- A function that returns the number of cells in the
selected range that contain text or values, but not blank cells.
- evaluates any gaps that a dataset might have without having to reorganize data
DAYS function - ANSWER- a function that determines the number of calendar days
between two dates
- useful for assessing the life cycle of products, contracts, and run rating revenue
depending on service length
ANALYSIS FUNCTIONS - NATHAN
CHILCUTT(SCORED A+)
CONCATENATE function - ANSWER- A function that joins two or more text strings
into one text string
- Useful for creating API endpoints, product SKUs, and java queries
- if you want a space in between two columns:
=Concatenate(Text 1, " ", Text 2)
NETWORKDAYS function - ANSWER- determines the number of workdays between
two dates as well as an option to account for holidays.
- useful for project management
COUNTIFS Function - ANSWER- the easiest way to count the number of instances
a dataset meets a set of criteria
- powerful because of the limitless criteria you can input
SUMIFS Function - ANSWER- the function calculates the sum values based on
multiple criteria
- useful to determine how much each product is contributing to top-line revenue
LEN function - ANSWER- returns the length of a sequence such as a list
- provides number of characters in a given cell
- useful when trying to determine the difference between different unique identifiers
COUNTA function - ANSWER- A function that returns the number of cells in the
selected range that contain text or values, but not blank cells.
- evaluates any gaps that a dataset might have without having to reorganize data
DAYS function - ANSWER- a function that determines the number of calendar days
between two dates
- useful for assessing the life cycle of products, contracts, and run rating revenue
depending on service length
