Logical Formulas - Count & Extract Customer Names for 8 Sales Coupon Groups

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn advanced Excel techniques for analyzing customer coupon usage across multiple stores in this comprehensive 31-minute video tutorial. Master the use of logical formulas to count and extract customer names for eight distinct coupon groups. Explore powerful functions like COUNTIFS, AND, OR, NOT, ROW, AGGREGATE, ROWS, INDEX, and IF to solve complex data analysis problems. Gain hands-on experience with array formulas and learn how to efficiently process large datasets. Download the provided Excel file to follow along and practice these essential skills for data analysis and customer segmentation.

Syllabus

) Introduction to Problem.
) Count number of coupons each customer redeemed for each store. See the COUNTIFS Function..
) Logical formulas for determining which customers fall into each of the eight coupon groups. Learn about AND Logical Tests, OR Logical Tests, and a NONE Logical Test (None are TRUE, or All are FALSE). See the Excel Spreadsheet Logical functions: AND, OR, NOT..
) Count Customers in each of the eight coupon groups using COUNTIFS Function..
) Formula to Extract Customer Names for each of the eight coupon groups. Learn about Array Formulas to looks an item and Return Multiple Items. Learn about the Excel Spreadsheet functions: ROW, AGGREGATE, ROWS, INDEX and IF..
) Conclusion.