Learn more about CMKG at CMKG.ORG
Building Excel Skills
Building Excel Skills
Building Excel Skills

Building Excel Skills

Course Overview

Participants will have access to a set of mini Excel courses that start “basic” and move up to “advanced” topics. All of the data examples used in these courses are appropriate to category management work. Participants learn to maximize their Excel skills across a broad range of topics, and they also benefit from the applied category management learnings provided in these courses. Topics reviewed include Range Names, Dynamic Range Names, Absolute and Relative References, Basic Formula Writing, Custom Formats, Custom Lists, Text Functions and VLOOKUP and HLOOKUP formulas.

Learning Objectives

  • Leverage formulas, text functions, auto filtering;
  • Extract data, filter and next functions;
  • Use charts, graphic, pivot tables and links to other programs; and
  • Have methods to translate basic data into added value, strategic work ideas that generate breakthrough results.

The estimated completion time of this course is 2.5 hours.*

*The maximum time will apply only​ for a participant that is new to Excel

Purchase Options

Training Course Package, $125 USD
  • 30-day Access via CMKG's Online Training and Resource Center. Desktop, Laptop and Mobile Device compatible. 
  • Hands-On Workshops
  • Downloadable Notes & Reference Guide
  • Knowledge Checks
  • Course Test
Training Course Videos Only, $59 USD
  • 30-day Access via CMKG's Online Training and Resource Center. 
  • Knowledge Checks

This accredited category management training course for retailers and manufacturers qualifies for for the Certified Professional Category Analyst (CPCA), Certified Professional Category Manager (CPCM), and Certified Professional Strategic Advisor (CPSA) training requirements.  

*CMKG's Online Training and Resource Center includes many resources you can use in your day to day: a Resource Library with whitepapers, articles, tips and tricks, e-books and more; a dynamic Industry Glossary with >300 terms, each with a definition, and formulas and links to other related descriptions.