Serve shoppers better with CMKG, Learning & Training Experts

Excel Basics - The Foundations for Great Analysis

Written by Sue Nicholls, Founder & President CMKG | Feb 13, 2023 8:28:53 PM

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!

SESSION DETAILS:

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.

 

KEY LEARNING OBJECTIVES:

  • 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

 

 

PARTICIPANT FEEDBACK:

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.