YoVDO

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

Offered By: ExcelIsFun via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Array Formulas Courses

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

Microsoft Excel Dashboards & Data Visualization Mastery
Udemy
Excel 2011 for the Mac: Advanced Formulas and Functions
LinkedIn Learning
Microsoft Excel - Practical Excel Masterclass
Udemy
Intermediate Excel
Cybrary
Excel Statistical Analysis - Introduction to Probability, Power Query & Pivot Table Example
ExcelIsFun via YouTube