Heads up! Continuing Education is switching to a new registration system. For a listing of our classes starting after July 1, please go to our new class search.

Order By Display Density

Microsoft Excel

XCOE 1006 - Excel 2013 Fundamentals

Discover the fundamental concepts of Microsoft Excel 2013. Learn how to enter and edit text, values, and formulas. Work with simple functions, apply formatting techniques, and create and modify charts. This class can be taken as part of the Microsoft Office Essentials Certificate and the Excel Specialist Certificate. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Comfortable using Windows, keyboard, and mouse.

CEU Hours: .7

Contact Hours: 7

Unit 1:  Getting started
          Topic A:  Spreadsheet terminology
          Topic B:  The Excel environment
          Topic C:  Navigating a worksheet
          Topic D:  Using a template
Unit 2:  Entering and editing data
          Topic A:  Entering and editing text and values
          Topic B:  Entering and editing formulas
          Topic C:  Saving and updating workbooks
Unit 3:  Modifying a worksheet
           Topic A:  Moving and copying data
           Topic B:  Moving, copying, and viewing formulas
           Topic C:  Absolute and relative references
           Topic D:  Inserting and deleting ranges, rows, and columns
Unit 4:  Functions
           Topic A:  Entering functions
           Topic B:  AutoSum
           Topic C:  Other common functions
Unit 5:  Formatting
           Topic A:  Text formatting
           Topic B:  Row and column formatting
           Topic C:  Number formatting
           Topic D:  Conditional formatting
           Topic E:  Additional formatting options
Unit 6:  Charts
           Topic A:  Chart basics
           Topic B:  Formatting charts
Unit 7:  Graphics
           Topic A:  Working with pictures
           Topic B:  Conditional formatting with graphics
           Topic C:  SmartArt graphics
Unit 8:  Printing
           Topic A:  Preparing to print
           Topic B:  Page Setup options
           Topic C:  Printing worksheets
 
CRN Days Time Date Location Instructor Seats Open
51538 009 --WR--- 06:00-09:29 PM 06/28/17-06/29/17 Off Campus OHEC 141 Stublen N 10 of 14

XCOE 1007 - Excel 2013 Intermediate

Manage workbooks and worksheets more efficiently with Excel 2013. Use workbook styles and themes, create outlines and subtotals, and sort and filter data. Learn to save workbooks as Web pages, insert and edit hyperlinks, and share workbooks via email. This class can be taken as part of the Excel Specialist Certificate. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Excel 2013 Fundamentals or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Unit 1:  Managing workbooks and worksheets
            Topic A:  Viewing large worksheets
            Topic B:  Printing large worksheets
            Topic C:  Working with multiple worksheets
            Topic D:  Linking worksheets with 3-D formulas
            Topic E:  Using multiple workbooks
            Topic F:  Linking workbooks
Unit 2:  Outlining and subtotals
            Topic A:  Outlining and consolidating data
            Topic B:  Creating subtotals
Unit 3:  Cell and range names
             Topic A:  Creating and using names
             Topic B:  Managing names
Unit 4:  Data structure and tables
             Topic A:  Sorting and filtering data
             Topic B:  Working with tables
Unit 5:  Documenting and auditing
             Topic A:  Auditing features
             Topic B:  Comments in cells and workbooks
             Topic C:  Protection
             Topic D:  Workgroup collaboration
 
CRN Days Time Date Location Instructor Seats Open
51543 009 --W---- 08:00-03:59 PM 06/21/17-06/21/17 RC 252 Snyder B 2 of 10

XCOE 1008 - Excel 2013 Advanced

Work with advanced functions and formulas in Excel 2013. Learn about data validation and use advanced data filtering. Apply chart formatting options; create PivotTables and PivotCharts; export and import data; and query external databases. Discover the analytical features, such as Goal Seek; run and record macros; and explore VBA code. This class can be taken as part of the Excel Specialist Certificate. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Excel 2013 Intermediate or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Unit 1:  Advanced functions and formulas
           Topic A:  Logical functions
           Topic B:  Conditional functions
           Topic C:  Financial functions
           Topic D:  Text functions
           Topic E:  Date and time functions
           Topic F:  Array formulas
           Topic G:  Calculation options
Unit 2:  Lookups and data tables
           Topic A:  Using lookup functions
           Topic B:  Creating data tables
Unit 3:  Advanced data management
           Topic A:  Validating cell entries
           Topic B:  Advanced filtering
Unit 4:  Advanced charting
           Topic A:  Chart formatting options
           Topic B:  Combination charts
           Topic C:  Graphical objects
Unit 5:  PivotTables and PivotCharts
           Topic A:  Working with PivotTables
           Topic B:  Modifying PivotTable data
           Topic C:  Formatting PivotTables
           Topic D:  Using PivotCharts
           Topic E:  PowerPivot
Unit 6:  Exporting and importing data
           Topic A:  Exporting and importing text files
Unit 7:  Analytical tools
           Topic A:  Goal Seek
           Topic B:  Scenarios
           Topic C:  Instant data analysis
Unit 8:  Macros and Visual Basic
           Topic A:  Running and recording a macro
           Topic B:  Working with VBA code
Unit 9:  Accessibility and language features
           Topic A:  Accessibility considerations
           Topic B:  Internationalization
 
CRN Days Time Date Location Instructor Seats Open
51548 008 MT----- 06:00-09:29 PM 06/26/17-06/27/17 RC 253 Grandgenett C 13 of 14
51549 009 ----F-- 08:00-03:59 PM 06/30/17-06/30/17 RC 254 Heutinck C 7 of 14

XCOE 1012 - Excel 2016 Intermediate

Learn how to leverage the power of data analysis and presentation by working with functions and lists in order to analyze data. You will also see how to visualize data with charts and how to use PivotTables and PivotCharts. This class can be taken as part of the Excel Specialist Certificate. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Excel 2016 Fundamentals or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Lesson 1: Working with Functions
Topic A: Work with Ranges
Topic B:	 Use Specialized Functions
Topic C: Work with Logical Functions
Topic D: Work with Date & Time Functions
Topic E: Work with Text Functions
Lesson 2: Working with Lists
Topic A: Sort Data
Topic B: Filter Data
Topic C: Query Data with Database Functions
Topic D: Outline and Subtotal Data
Lesson 3: Analyzing Data
Topic A: Create and Modify Tables
Topic B: Apply Intermediate Conditional Formatting
Topic C: Apply Advanced Conditional Formatting
Lesson 4: Visualizing Data with Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Use Advanced Chart Features
Lesson 5: Using PivotTables and PivotCharts
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Timelines and Slicers
 
CRN Days Time Date Location Instructor Seats Open
51593 005 --W---- 08:00-03:59 PM 06/28/17-06/28/17 RC 234 McAtee R 4 of 18
Clinic Courses (CLI) provide practical application and are offered on or off campus. Instructors supervise/direct student in a simulated or on-site setting.
Face-to-Face Courses (F2F) take place in a classroom. Based on JCCC's Statement of General Education. Students in all classes, including face-to-face classes, are expected to use technology appropriate to the course content and as needed to access web-based course materials. Face-to-face classes typically require access to computer equipment (either at home or in college labs provided for student use) and computing skills utilizing standard office, business and web browsing applications.
Hybrid Courses (HYB) combine face-to-face classroom instruction and the convenience of online web-based learning, resulting in a reduction of the amount of time spent in the face-to-face classroom and a significant increase of time spent studying online materials. Students registered in hybrid courses must attend class meetings as listed in the JCCC Schedule of Classes.
Internships (INT) provide experience to students for on-the-job training with cooperating businesses, agencies, and organizations. The number of hours for each internship varies.
Lab Courses (LAB) are face-to-face classes where students perform tasks as directed by faculty. Faculty members monitor the activity and provide individual and/or group instruction/assistance
Media Courses (MED) deliver all or a portion of instruction through either cable broadcast or pre-recorded video lessons. The videos are available in DVD format from the Billington Library.
Online Courses (ONLNE) use the Internet and a Learning Management System (D2L) to deliver course materials and to facilitate student-instructor, student-content, and student to student interaction. To participate in online courses, the student should have a good understanding of computer hardware and software applications and the Internet.
Continuing Education Online Courses (CEONL) and materials are delivered via the Internet. To participate in online courses, the student should have a good understanding of computer applications and Internet navigation. For more information about this course and other online learning options visit CE Online.
Private (PLV) lessons for credit are available from beginning to advanced in voice, piano, guitar, brass, woodwind and percussion. Lessons are scheduled by arrangement with private music instructors.
Self-Paced Courses (SEL) and Self-Paced Online (SPO) are offered on a schedule of study that allows students more flexible scheduling options. Course interaction is based upon a contract between student - instructor and in some cases can take up to one calendar year to complete. Some courses may use online delivery to facilitate the learning experience.
Self-Paced Courses (SEL) and Self-Paced Online (SPO) are offered on a schedule of study that allows students more flexible scheduling options. Course interaction is based upon a contract between student - instructor and in some cases can take up to one calendar year to complete. Some courses may use online delivery to facilitate the learning experience.
Travel Courses (TRV) may require in-class activities as well as traveling to a destination. Students will be responsible for the cost of the travel as well as the course costs.
Seats Open is an approximation of the number of seats available and may not represent the actual number of seats open at the time of registration.
This course is approved by the Kansas Board of Regents for guaranteed transfer among all Kansas public postsecondary institutions. Additional courses may also be eligible for transfer. Please visit the JCCC Registrar to learn more.