Self-paced online Retail Math & Excel courses

All four self-paced online courses are only sold as a bundle.

If you are enrolled in the Business Insights programs, you do not need to purchase this bundle as it is included in your curriculum.

Core math and Excel skills are critical to making smart business decisions. However, data indicates these skills are not as strong as many leaders expect. With Excel, there are often 4 to 5 ways to complete the same task – but not all of them are efficient or correct. The Retail Math course focuses on developing math skills so individuals can calculate market share, mix share, opportunity gap, gross margin, and other basic math formulas. The Excel Formulas & Functions and Excel Charts courses are not exhaustive courses on Excel but only those components required in the consumer products industry. The Excel PivotTables course is an exhaustive review of PivotTables and Pivot Charts.

The courses use data, language and Business Management Questions™ (business scenarios) often faced in the retail and foodservice industries.

Retail Math

Retail Math

Excel Formulas & Functions

Excel Formulas & Functions

Excel Charts

Excel Charts

Excel Pivot Tables

Excel PivotTables

To learn more, request a demo or view the sample videos and course descriptions below.
Retail-Math-Shopping-Cart---Delta-Market-Share

Retail Math

Build retail math skills essential to everyday business conversations. Answer common Business Management Questions™ by breaking down the questions into their parts and identifying what metrics to calculate. Learn to effectively use math to emphasize or de-emphasize your business story. Discover the cautions and tricks of calculating and using market share.

Topics:

  • Percent Change
  • Difference, ratio, percent difference
  • Share (both mix and market share)
  • Opportunity gap
  • Average retail price
  • Profit (margin, margin percent, margin per unit)
  • Markdown
  • Tips and tricks

Time:

22 hours of self-paced online lessons, practices, business applications and quizzes.

Audience:

Anyone who uses everyday retail business metrics.

Excel Formulas & Functions

Build foundational Excel skills for working with retail data. Efficiently manipulate spreadsheet data to accomplish everyday tasks and answer common Business Management Questions™. Become comfortable using core Excel functions to assist with basic analysis. Discover additional Excel functions and features that can speed up your analysis and give you more time to allocate to what matters – finding the business insight!

Topics:

  • Navigation and formatting
  • Sort and filter
  • Shortcuts and tips and tricks
  • Formulas & functions including: SUM, AutoSum, SUBTOTAL, IF, AVERAGE, SUMIF, COUNTIF, VLOOKUP, INDEX, MATCH, IFERROR, text and date functions, etc.
  • Lookup and manage data
  • Handle formula error messages
  • Create tables and slicers, and use names

Time:

16 hours of self-paced online lessons and practices.

Audience:

Anyone who uses Excel more than 20 minutes per week.

Excel Formulas & Functions online training
Excel-Charts-v3

Excel Charts

Well-designed charts bring your story to life. Learn how to quickly create Excel charts to communicate business insights. Identify what makes a chart easy to read and then create impactful bar, column and line charts. Discover several chart types that allow you to quickly compare two metrics to each other to tell a compelling story.

Topics:

  • Column charts
  • Bar charts
  • Line charts
  • Jazz-Hands™ charts
  • Overlay/bullet charts
  • Chart template creation and usage
  • Chart tips and tricks

Time:

7 hours of self-paced online lessons, practices and business applications.

Audience:

Anyone who creates charts in Excel or PowerPoint.

Excel PivotTables

Unleash the power of Excel PivotTables to work with large retail data sets. Effortlessly use PivotTables to analyze retail data by any attribute (product attribute, geography, time, etc.) Answer challenging Business Management Questions™ based on retail data sets – questions that would be difficult to answer without a PivotTable. Whether you have never heard of a PivotTable or are someone who has experience, you will quickly strengthen your analytical skills.

Topics:

  • Create and format PivotTables
  • Sort and filter
  • Group
  • Create calculated fields and items
  • Summarize and show values
  • Utilize slicers
  • PivotChart
  • Tips and tricks

Time:

7 hours of self-paced online lessons, practices and business applications.

Audience:

Anyone who uses Excel more than 60 minutes per week.

Excel-PivotTables-v2