Date and Time: June 15, 2026 - 1:30 pm - 3:00 pm MT (90 Minutes)

Location: Zoom - Virtual Instructor Led Training by OpenCircle.

Cost: $80.00 (OpenCircle Members get 25% off)

Course Description: Excel 3: Sorting & Graphing

This session introduces learners to essential data analysis and visualization tools in Microsoft Excel.

Participants will learn how to sort data using both standard and custom options—including sorting by cell color, font color, and custom lists—to uncover trends and insights. The session also covers the creation and customization of charts such as column, line, pie, and bar charts, with a focus on selecting the right chart type for the data and enhancing visual impact through formatting options like labels, legends, and colors.

Learning Objectives:

• Understand how to apply basic ascending and descending sorts on single columns while avoiding common sorting errors

• Use custom sort options (e.g. sorting by cell color, font color, or custom lists)

• Create basic charts to visually represent data sets

• Use chart tools to format and enhance visual clarity and impact

Course Outline:

1. Sorting in Excel

   • Understanding the purpose and benefits of sorting data

   • Recognizing and avoiding common sorting mistakes (e.g. sorting a single column)

   • Applying basic sorts (ascending and descending)

   • Applying customer sorts (e.g. by color or custom lists)
     

2. Charting and Graphing

   • Using the Chart Design and Format tabs to customize appearance

   • Creating a clustered column chart to compare data across categories

   • Editing chart elements such as titles, axis labels, and legends

   • Exploring other common chart types (e.g. line, bar, pie)
     

3. Chart design tools

   • Using the Chart Design and Format tabs to customize appearance

   • Changing chart styles and color schemes to improve readability

   • Adding and adjusting data labels for clarity

   • Moving charts to new sheets or repositioning within the existing worksheet.

Refund Policy - by OpenCircle

A 50% refund is offered for cancellations within 5 business days from scheduled start date. No refund offered for non-attendance. OpenCircle reserves the right to cancel or re-schedule classes due to unforeseen circumstances including not achieving minimum classroom registration requirements.  Registrants will receive a full refund or be offered enrollment in the next scheduled course.

System Requirements:

Computer or tablet, internet connection, audio and camera. ZOOM link and instructions will be emailed to participants closer to the start date.

Certificate of Completion:

Upon successful completion of this course, a certificate of completion will be available for download and printing.

Please register here.