Logical Formulas - Count & Extract Customer Names for 8 Sales Coupon Groups
Offered By: ExcelIsFun via YouTube
Course Description
Overview
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.
Taught by
ExcelIsFun
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard