The pocket price band is an important form of analysis that shows variation in price, price capture, or margin. Learn how to create a revenue-weighted pocket price band in Excel, what this analysis reveals, and why to avoid Excel's built-in tool.
How to create powerful pocket price bands in Excel in clear, step-by-step lessons
Why to avoid Excel's built-in histogram tool
What You Get
Over 50 minutes of instruction through 8 lessons
Structured Excel workbook to download, follow along, and review completed exercises
Quiz to demonstrate understanding of material at course completion
Course curriculum
1
Welcome
Before we begin...
2
1: Introduction
Pocket Price Band worksheet
01 Pocket Price Band - Intro
3
2: Which Price?
02 Pocket Price Band - Which Price
4
3: Which Excel Method?
03 Pocket Price Band - Which Excel Method
5
4: SUMIF Overview
04 Pocket Price Band - SUMIF Overview
6
5: SUMIF Method
05 Pocket Price Band - SUMIF Details
7
6: Excel Histogram Method
06 Pocket Price Band - 2016 Built-In Histogram
8
7: Data Analysis ToolPak Method
07 Pocket Price Band - Data Analysis ToolPak
9
8: Pocket Price Band Insights
08 Pocket Price Band - Insights and Outro
10
Next steps
Pocket Price Band quiz
Before you go...
Instructor(s)
Instructor
Nathan Phipps
Nathan L. Phipps is a Consultant at Wiglaf Pricing and Instructor at the Wiglaf Institute. His areas of focus include pricing transformations, marketing analysis, conjoint analysis, and commercial policy.
Before joining Wiglaf Pricing, Nathan worked as a pricing analyst at Intermatic Inc., where he dealt with market pricing and the creation of price variance and minimum advertised price policies. His prior experience includes time in aerosol valve manufacturing and online education.
Nathan holds an MBA with distinction in Marketing Strategy and Planning & Entrepreneurship from the Kellstadt Graduate School of Business at DePaul University and a BA in Biology & Philosophy from Greenville College. He is a Certified Pricing Professional (CPP).
He is based in Chicago, Illinois.
FAQ
Who is this for?
These courses teach the quantitative skills required to excel in pricing analysis. Analysts on pricing, commercial, sales ops, and finance teams can improve their output via the Wiglaf Institute.
I'm a manager. Why should my team enroll?
Pricing analysis is a critical interstitial function whose goal is improving profitability. It affects, and is affected by, sales, marketing, and finance decisions.
You have many responsibilities. Teams need the right analytical training and skills to make the right decisions.
Train your team all at once and onboard new hires. Increase your team's impact and influence across the organization.
With the Wiglaf Institute, you know your team is equipped to deliver results.
I'm an analyst. Why should I enroll?
Pricing is a growing function across industries and organizations. Be a part of this exciting growth by getting the skills needed to succeed.
By acquiring new hard and relevant skills, you can get ahead of the competition for a new analyst role.
Or, you can increase your value to your current organization and be known as someone who can deliver.
What is your refund policy?
Due to the nature of the product, no refunds will be offered. All sales are final.
Get Started
Level up your analysis skills with this important tool!