Skip Navigation

Live Online help Real-time discussions with your instructor and fellow students via technology

Excel Intermediate

Instructor

Steve Hultgren

See Course Dates

What You Will Learn

Get ready for interactive learning. Focus on complex examples from the textbook to reinforce your skills. You'll have access to additional exercises to use on your own for practice or certification prep. Expand your Excel knowledge with an in-depth look at conditional formatting, analysis functions, vlookup, outlines, and subtotals.

Meets Core and Expert objectives to complete Microsoft Office Specialist Certification. For questions about voucher purchase and certification exams, contact Regnier Testing Center on JCCC main campus.

Prerequisite: Excel Fundamentals or the ability to create a basic formula on your own


This is a component of the JCCC Continuing Education Excel Specialist Certificate.


This section is facilitated by an instructor online. Within 2 business days of the class start date, you will receive instructions about how to access the class online.

Certification

Excel Specialist Certificate

Receive instruction in our Excel course lineup.


Build a solid foundation with Excel Fundamentals and Excel Intermediate before moving on to more advanced topics in Excel Advanced. Complete all courses within one year and receive the Excel Specialist Certificate.

Once completed, you will be prepared to take the Microsoft Office Specialist exam at our Regnier Testing Center.

Prerequisite: Comfortable using Windows, keyboard and mouse.

See individual courses for detailed descriptions, outlines and online registration.

Required Courses

Courses may be taken in any order as long as Excel Fundamentals is taken first.

  • Excel Fundamentals (Formerly called @@!An Excel Foundation@@!)
  • Excel Intermediate (Formerly called @@!Excel-Formulas, Formatting and Functions@@!)
  • Excel Advanced (Formerly called @@!Excel-Organizing Data, Pivot Tables and Workbook Protection@@!)
Excel Intermediate
Course Dates

Live Online help Real-time discussions with your instructor and fellow students via technology

$199.00

Excel Intermediate

6/25/2025 - 6/26/2025 W Th 5:30PM-9:00PM
18 Seats Open
7/11/2025 F 8:00AM-5:00PM
20 Seats Open

Selected Course

Dates: 6/25/2025 - 6/26/2025 W Th

Course type: Microsoft Office

Times: 5:30PM-9:00PM

Location: Live Online Campus Map

Contact Hours: 7.0

Other Details

Course Code: EXCEL-195-38

Category: Microsoft Office

Contact Hours: 7.0

Format: Classroom

Schedule Details:

After registering for this course, you can come back to the catalog to register for more courses.

Issues with registering? Please contact us at CERegistration@jccc.edu or call 913-469-2323.

Similar Courses

Microsoft Office image
Online help Learning at your own pace, or facilitated by an instructor
Advanced Microsoft Excel 2019 (Self-Guided) Session start date:
24.0 contact hours $169.00
Microsoft Office image
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Microsoft Outlook 2019/Office 365 (Self-Guided) Session start date:
24.0 contact hours $169.00
Microsoft Office image
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Microsoft Excel 2019/Office 365 (Self-Paced Tutorial) Session start date:
24.0 contact hours $169.00
Microsoft Office image
Online help Learning at your own pace, or facilitated by an instructor
Microsoft Excel - Pivot Tables (Self-Guided) Session start date:
24.0 contact hours $169.00
Microsoft Office image
Online help Learning at your own pace, or facilitated by an instructor
Intermediate Microsoft Excel 2019 (Self-Guided) Session start date:
24.0 contact hours $169.00
Microsoft Office image
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Microsoft Access 2019/Office 365 (Self-Guided) Session start date:
24.0 contact hours $169.00
Microsoft Office image
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Microsoft PowerPoint 2019/Office 365 (Self-Guided) Session start date:
24.0 contact hours $169.00
Microsoft Office image
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Microsoft Project 2019/Office 365 (Self-Guided) Session start date:
24.0 contact hours $169.00
Microsoft Office image
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Microsoft Excel 2019/Office 365 Session start date: Aug 14
contact hours $159.00
Microsoft Office image
Online help Learning at your own pace, or facilitated by an instructor
Advanced Microsoft Excel 2019/Office 365 Session start date: Oct 16
contact hours $179.00
 
Close Modal Window

Online Registration Temporarily Down

Please contact us at ceregistration@jccc.edu or call 913-469-2323 to register now or please visit us later.

Close
Close Modal Window
  1. Advanced Formatting - Themes, Cell Styles, Customizing Page Setup
  2. Date and Time Functions, Conditional Formatting
  3. Advanced Functions for Analysis - Financial Functions, What-If Analysis Tools
  4. Text Functions, Conditional Functions, and Formula Auditing - 3-D Cell References, Troubleshooting Formulas
  5. Lookup Function and Outlines - vlookup and hlookup functions
Close Modal Window

Live Online help Real-time discussions with your instructor and fellow students via technology

Excel Intermediate

DATE TIME DAY PRICE AVAILABILITY LOCATION  
6/25/2025 - 6/26/2025 5:30PM-9:00PM W Th $199.00 18 Seats Open Live Online Campus Map Register
7/11/2025 8:00AM-5:00PM F $199.00 20 Seats Open RC, Regnier Center, 254 Campus Map Register
Close Modal Window

Live Online help Real-time discussions with your instructor and fellow students via technology

$199.00

Excel Intermediate

6/25/2025 - 6/26/2025 W Th 5:30PM-9:00PM
18 Seats Open
7/11/2025 F 8:00AM-5:00PM
20 Seats Open

Selected Course

Dates: 6/25/2025 - 6/26/2025 W Th

Course type: Microsoft Office

Times: 5:30PM-9:00PM

Location: Live Online Campus Map

Contact Hours: 7.0

Other Details

Course Code: EXCEL-195-38

Category: Microsoft Office

Contact Hours: 7.0

Format: Classroom

Schedule Details:

After registering for this course, you can come back to the catalog to register for more courses.

Issues with registering? Please contact us at CERegistration@jccc.edu or call 913-469-2323.