What to Expect

The tools and training to get pricing done right

In this course you will learn:
  • How to create powerful boxplots in Excel in clear, step-by-step lessons
  • Why to avoid Excel's built-in boxplot tool

What You Get

  • 80 minutes of instruction through 12 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 by Market Variable (Discrete) worksheet

    • 01 Boxplot - Intro
  • 3

    2: Which Price?

    • 02 Boxplot - Which Price
  • 4

    3: Boxplot Introduction

    • 03 Boxplot - Intro
  • 5

    4: Stepping into Excel

    • 04 Boxplot - Excel Intro
  • 6

    5: Setting Up the PivotTable

    • 05 Boxplot - PivotTable Setup
  • 7

    6: Organizing the Data

    • 06 Boxplot - Organizing the Data
  • 8

    7: Calculating Percentiles

    • 07 Boxplot - Calculating Percentiles
  • 9

    8: Percentiles Function Detail

    • 08 Boxplot - Percentiles Function Detail
  • 10

    9: Final Data Table

    • 09 Boxplot - Final Data Table
  • 11

    10: Creating the Chart

    • 10 Boxplot - Creating the Chart
  • 12

    11: Using Excel's Built-in Boxplot

    • 11 Boxplot - Excel Built-In
  • 13

    12: Boxplot Insights

    • 12 Boxplot - Insights and Outro
  • 14

    Next steps

    • Pocket Price by Market Variable (Discrete) 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!

Sign up