What to Expect

The tools and training to get pricing done right

In this course you will learn:
  • 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


    • 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...



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.


  • 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!