Learn more about CMKG at CMKG.ORG
Proficiency In Excel
Proficiency In Excel


Proficiency In Excel

Take Quiz

This accredited program builds your Excel skills, no matter to help you become more proficient in developing and analyzing Excel spreadsheets using category management data.

Your program is broken into different mini-modules that start with the basics, followed by intermediate and advanced topics. Each mini module includes a how-to video, followed by a workshop where you will complete examples that were taught in the video. You only need to complete the modules that are relevant or new to you.

Topics reviewed include Range Names, Dynamic Range Names, Absolute and Relative References, Basic Formula Writing, Custom Formats, Custom Lists, Text Functions, Pivot Tables and VLOOKUP and HLOOKUP formulas. All of the data examples used in these courses are appropriate for category management work. 

All of the examples tie in with real data sources that you use in your everyday business, so you get the benefit of also learning how to manipulate similar data sources within Excel. 

Program Curriculum

  • Building Excel Skills

Program Curriculum

  • Approximately 4-6 hours to complete
  • No Prerequisites

Purchase Details

  • 90-day Access via  CMKG's Online Training and Resource Center, including individual course Hands-On Workshops, Downloadable Notes & Reference Guides, Knowledge Checks, and Course Tests. Desktop, Laptop and Mobile Devices compatible. 
  • Ongoing student support (Email, Live Chat
    *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.