Excel Basics - The Foundations for Great Analysis

Get ready to master Excel in a fun and engaging way! As a business professional, having a strong foundation in Excel is crucial for effective and efficient data analysis. But who wants to sit through a boring course on calculating mortgages and other functions you'll never use? Our virtual classroom training dives straight into the essentials you need to excel in Excel.

In this session, you'll gain confidence in navigating spreadsheets, writing basic formulas like SUM, COUNT, RANK, UNIQUE, IFERROR, and conditional formulas, formatting cells, understanding absolute and relative ranges, and creating charts and PivotTables. We use real-world examples from the retail and CPG sectors to teach best practices in analyzing and calculating key measures in your data.

This fast-paced session is packed with hands-on workshops to ensure you get practical experience. Plus, we can customize the focus areas based on your organization's unique needs, using your own data and examples for maximum relevance. Join us and transform your Excel skills—sign up now for a session that participants have rated between 4.5 and 5.0!


Optimum class size: 10-15 participants (maximum 25)

Length of session: 120-150 minutes

Cost: Starts at $3,000 USD (includes development, customization, delivery, student notes, hands-on workshops). Multiple sessions of the same topic are at a reduced price.

Core Competency:  DATA AND ANALYTICS


This session can be combined with other training topics to create a virtual training series over days, weeks or months.



  • To explain the keys to help you move efficiently and effectively through Excel worksheets
  • To identify the steps needed to sort data
  • To list some common Excel formulas and the nomenclature for each (SUM, COUNT, RANK, SUMIF, ISERROR)
  • To describe how to create and format basic charts in Excel
  • To explain when to use PivotTables and how to make a basic PivotTable


Contact us for more details



Best 3-hour lecture / class I've ever attended!
Time went by too quickly.
I learned many new things (i.e. formula building, shortcuts, and emphasis on what I'm trying to say or do in Excel).
Handouts are incredibly helpful and I will go back to reference them.

Virtual Classroom Training FAQ:

  • What will individuals learn? Each Virtual Classroom training has defined learning objectives. If you have a question about what is specifically covered, please email info@cmkg.org to request more information.
  • What is required of individuals? Virtual Classroom training is designed as highly interactive and requires individual participation through chat, whiteboards, breakout rooms, contests, quizzes, and more. There may also be additional work required before class sessions and/or homework between class sessions.
  • Want to customize your training? With customized training, you’ll be able to focus on the specific areas where you’d like to optimize and hone your team’s skills. Personalizing your training allows you to tailor longer and extra sessions to fit your exact needs and overall goals. In addition, your customized training session can be expanded and combined with other sessions to create a virtual training program and/or regular sessions on different topic areas (chosen by you!) every month or two. Pricing will vary depending on the specifics of your customized training.

What are some other topics for Virtual Classroom training? 

Customize Your Training by Creating Your Own Topic, Combining Topics, or Creating Your Own Training Program!

CMKG_Coaching - Quickly build skills

Want to grow your skills, career, and potential? CMKG can help!

Your results are private to you and not shared with anyone outside of CMKG.

Not sure where to start ???!!

1. Start by understanding your skills.

You can complete any of the following assessments and get instant results by email for free. Then, you'll get a personalized, follow-up email with suggested next steps for your career.

Available FREE Assessments from CMKG.ORG:

  1. Category Management Levels 1–3 
  2. Category Management Level 4
  3. Sales
  4. Space Management
  5. Shopper Insights

Request a free assessment

2. Identify your career potential.

Take time to think about your career options. Start your Coaching Assessment for FREE. You can choose to receive the results by email.