Order By Display Density
Note! Payment is due at time of registration.

Microsoft Excel

XCOE 1000 - Excel 2010 Fundamentals

After an introduction to spreadsheet terminology and Excel's window components, learn how to use the Help system and navigate worksheets and workbooks. Students will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts. This class can also be taken as part of the Excel Specialist Certificate. For details visit our web page.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

Excel Fundamentals outline:

Unit 1:	Getting started
	Topic A:	Spreadsheet terminology
       	  A-1:	Discussing spreadsheet basics
	Topic B:	The Excel environment
   	  B-1:	Examining Excel window components
	Topic C:	Getting help
         C-1:	Getting help with using Excel
	Topic D:	Navigating a worksheet
	 D-1:	Navigating a worksheet

Unit 2:	Entering and editing data
	Topic A:	Entering and editing text and values
	  A-1:	Entering text and values
	  A-2:	Editing cell contents
  	  A-3:	Using AutoFill to fill a series
	Topic B:	Entering and editing formulas
   	  B-1:	Creating a basic formula
  	  B-2:	Entering cell references with the mouse
	  B-3:	Editing a formula
	  B-4:	Working with the order of operations
	Topic C:	Working with pictures
	 C-1:	Inserting and modifying a picture
	Topic D:	Saving and updating workbooks
	 D-1:	Saving a new workbook
	 D-2:	Saving a file as an Excel 97-2003 workbook
	 D-3:	Saving a worksheet as a PDF file 
	 D-4:	Editing and updating a workbook
	
Unit 3:	Modifying a worksheet
	Topic A:	Moving and copying data
	  A-1:	Moving data in a worksheet
	  A-2:	Copying data in a worksheet
	  A-3:	Moving and copying data by using drag-and-drop
	  A-4:	Using the Clipboard task pane
	Topic B:	Moving and copying formulas
	  B-1:	Moving a formula
	  B-2:	Copying a formula
	  B-3:	Using AutoFill to copy a formula
	  B-4:	Using Paste Link 
	Topic C:	Absolute and relative references
	  C-1:	Observing the limitations of relative references
	  C-2:	Applying absolute references
	Topic D:	Inserting and deleting ranges, rows, and columns
	  D-1:	Inserting a range of cells
	  D-2:	Inserting rows
	  D-3:	Deleting a range of cells
	
Unit 4:	Using functions
	Topic A:	Entering functions
	  A-1:	Entering a SUM function
	  A-2:	Using the mouse to enter a function argument
	  A-3:	Entering a function in the formula bar
	  A-4:	Inserting a function
	Topic B:	AutoSum
	  B-1:	Using AutoSum 
	Topic C:	Other common functions
	  C-1:	Using AVERAGE
	  C-2:	Using MIN
	  C-3:	Using MAX
	  C-4:	Using COUNT and COUNTA
	
Unit 5:	Formatting
	Topic A:	Text formatting
	  A-1:	Formatting text
	  A-2:	Formatting a non-contiguous range
	  A-3:	Using the Format Cells dialog box to format text
	Topic B:	Row and column formatting
	  B-1:	Changing column width and row height
	  B-2:	Applying color to a row
	  B-3:	Setting alignment
	  B-4:	Applying borders to cell ranges
	  B-5:	Using the border-drawing pencil
	  B-6:	Using the Paste Special command
	  B-7:	Removing a border
	Topic C:	Number formatting
	  C-1:	Using the Number group to format numbers
	  C-2:	Exploring the Number tab
	Topic D:	Conditional formatting
	  D-1:	Creating a conditional format
	  D-2:	Editing and deleting a conditional format
	Topic E:	Additional formatting options
	  E-1:	Copying formats
	  E-2:	Using AutoFill to copy formatting
	  E-3:	Applying cell styles
	  E-4:	Applying table styles and sorting data 
	  E-5:	Using Find and Replace to change formatting
	
Unit 6:	Printing
	Topic A:	Preparing to print
	  A-1:	Checking spelling in a worksheet
	  A-2:	Finding and replacing text
	  A-3:	Previewing a worksheet
	Topic B:	Page Setup options
	  B-1:	Setting page orientation and scaling
	  B-2:	Adjusting margins
	  B-3:	Creating headers and footers
	  B-4:	Formatting headers and footers
	  B-5:	Printing gridlines and headings
	Topic C:	Printing worksheets
	  C-1:	Printing a selected range
	
Unit 7:	Charts
	Topic A:	Chart basics
	  A-1:	Creating a chart
	  A-2:	Moving a chart within a workbook
	  A-3:	Examining chart elements
	  A-4:	Creating and editing a pie chart
	Topic B:	Formatting charts
	  B-1:	Applying chart types and chart styles
	  B-2:	Modifying chart elements
 
CRN Days Time Date Location Instructor Seats Open
53488 041 ---R--- 08:00-03:59 PM 11/06/14-11/06/14 RC 221 Tuck L 5 of 14
53490 043 M------ 08:00-03:59 PM 11/17/14-11/17/14 RC 255 Tuck L 11 of 14
53491 044 ---R--- 08:00-03:59 PM 12/04/14-12/04/14 RC 221 Tuck L 1 of 14

XCOE 1001 - Excel 2010 Intermediate

Learn how to use multiple worksheets and large workbooks efficiently. Discover how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging This class can also be taken as part of the Excel Specialist Certificate. For details visit our web page.Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Excel Fundamentals or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Excel Intermediate outline:

Unit 1:	Managing large workbooks
	Topic A:	Viewing large worksheets
	  A-1:	Locking rows and columns
	  A-2:	Opening and arranging new windows
	  A-3:	Splitting a worksheet into panes
	  A-4:	Hiding and unhiding columns and worksheets
	  A-5:	Minimizing the Ribbon
	Topic B:	Printing large worksheets
	  B-1:	Setting print titles
	  B-2:	Adjusting page breaks
	  B-3:	Inserting different even and odd headers
	Topic C:	Working with multiple worksheets
	  C-1:	Navigating between worksheets
	  C-2:	Naming worksheets and coloring tabs
	  C-3:	Working with multiple worksheets
	  C-4:	Previewing and printing multiple worksheets
	
Unit 2:	Using multiple worksheets and workbooks
	Topic A:	Using multiple workbooks
	  A-1:	Switching between workbooks
	  A-2:	Copying a worksheet to another workbook
	Topic B:	Linking worksheets with 3-D formulas
	  B-1:	Creating 3-D formulas
	  B-2:	Adding a Watch window
	Topic C:	Linking workbooks
	  C-1:	Examining external links in a worksheet
	  C-2:	Creating external links in a worksheet
	  C-3:	Editing links
	Topic D:	Managing workbooks
	  D-1:	Creating a workspace
	
Unit 3:	Outlining and subtotals
	Topic A:	Outlining and consolidating data
	  A-1:	Creating an outline
	  A-2:	Creating custom views
	  A-3:	Using the Consolidate command
	Topic B:	Creating subtotals
	  B-1:	Creating subtotals in a list
	  B-2:	Using multiple subtotal functions
	
Unit 4:	Cell and range names
	Topic A:	Creating and using names
	  A-1:	Naming and selecting ranges 
	  A-2:	Using names in formulas
	  A-3:	Using the Create from Selection command
	  A-4:	Applying names to existing formulas
	Topic B:	Managing names
	  B-1:	Modifying and deleting named ranges
  	  B-2:	Defining and applying 3-D names
	
Unit 5:	Tables
	Topic A:	Sorting and filtering data
	  A-1:	Examining the structure of data
	  A-2:	Sorting data
	  A-3:	Filtering data by using AutoFilter
	  A-4:	Using cell color and attributes to sort and filter data
	Topic B:	Advanced filtering
	  B-1:	Using Custom AutoFilter criteria
	  B-2:	Using the Advanced Filter dialog box
	  B-3:	Copying filtered results to another range
	Topic C:	Working with tables
	  C-1:	Creating a table
	  C-2:	Formatting a table
	  C-3:	Adding and deleting rows and columns
	  C-4:	Using structured references
	  C-5:	Naming tables 
	  C-6:	Creating functions with the [@] argument
	
Unit 6:	Advanced charting
	Topic A:	Chart formatting options
	  A-1:	Adjusting the scale of a chart
	  A-2:	Formatting a data point
	Topic B:	Combination charts
	  B-1:	Creating a combination chart
	  B-2:	Creating a trendline
	  B-3:	Inserting sparklines
 	  B-4:	Using a chart template
	Topic C:	Graphical elements
	  C-1:	Adding graphical elements
	  C-2:	Formatting a graphical element
	  C-3:	Adding a picture to a worksheet
	  C-4:	Modifying a picture
	
Unit 7:	Documenting and auditing
	Topic A:	Comments in cells and workbooks
	  A-1:	Viewing comments in a worksheet
	  A-2:	Adding a comment to a cell
	  A-3:	Adding comments to a workbook
	Topic B:	Protection
	  B-1:	Password-protecting a worksheet
	  B-2:	Unlocking cells and protecting part of a worksheet 
	  B-3:	Protecting the workbook structure
	  B-4:	Discussing digital signatures
 
CRN Days Time Date Location Instructor Seats Open
53498 044 --W---- 08:00-03:59 PM 11/12/14-11/12/14 RC 250 Tuck L 1 of 14
53500 046 MT----- 06:00-09:29 PM 12/01/14-12/02/14 RC 234 Snyder B 10 of 14
53501 047 ---R--- 08:00-03:59 PM 12/11/14-12/11/14 RC 221 Tuck L Full

XCOE 1002 - Excel 2010 Advanced

Work with advanced formulas, as well as lookup functions such as VLOOKUP. Explore data validation and database functions such as DSUM. Learn how to import and export data, and how to query external databases. Learn about running and recording macros. PivotTables and PivotCharts are covered in this course. This class can also be taken as part of the Excel Specialist Certificate. For details visit our web page.Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Excel Intermediate or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Excel Advanced outline:

Unit 1:	Logical and statistical functions
	Topic A:	Logical functions
	  A-1:	Using the IF function
	  A-2:	Using a formula to apply conditional formatting
	  A-3:	Using OR, AND, and NOT as nested functions
	  A-4:	Using nested IF functions
	  A-5:	Using the IFERROR function
	Topic B:	Math and statistical functions
	  B-1:	Using SUMIF 
	  B-2:	Using COUNTIF
	  B-3:	Using AVERAGEIF
	  B-4:	Using SUMIFS, COUNTIFS, and AVERAGEIFS
	  B-5:	Using ROUND 
	
Unit 2:	Financial and date functions
	Topic A:	Financial functions
	  A-1:	Using the PMT function
	Topic B:	Date and time functions
	  B-1:	Using date functions 
	  B-2:	Using time functions
	Topic C:	Array formulas
	  C-1:	Using an array formula 
	  C-2:	Applying arrays to functions  
	  C-3:	Modifying the array formula
	Topic D:	Displaying and printing formulas
	  D-1:	Showing, printing, and hiding formulas
	  D-2:	Setting calculation options
	
Unit 3:	Lookups and data tables
	Topic A:	Using lookup functions
	  A-1:	Examining VLOOKUP
	  A-2:	Using VLOOKUP to find an exact match
	  A-3:	Using VLOOKUP to find an approximate match
	  A-4:	Using HLOOKUP to find exact matches
	  A-5:	Using HLOOKUP to find approximate matches
	Topic B:	Creating data tables
	  B-1:	Creating a one-variable data table
	  B-2:	Creating a two-variable data table
	
Unit 4:	Advanced data management
	Topic A:	Validating cell entries
	  A-1:	Observing data validation
	  A-2:	Creating a data validation rule
	  A-3:	Setting date and list validation rules
	Topic B:	Exploring database functions
	  B-1:	Examining the structure of database functions
	  B-2:	Using the DSUM function
	
Unit 5:	PivotTables and PivotCharts
	Topic A:	Working with PivotTables
          A-1:	Creating a PivotTable
	  A-2:	Adding fields to a PivotTable
	  A-3:	Using slicers to filter PivotTable data
	Topic B:	Rearranging PivotTables
	  B-1:	Moving fields
	  B-2:	Collapsing and expanding fields
	  B-3:	Refreshing the data in a PivotTable
	Topic C:	Formatting PivotTables
	  C-1:	Applying a PivotTable style
	  C-2:	Changing field settings
	Topic D:	Using PivotCharts
	  D-1:	Creating a PivotChart
	
Unit 6:	Macros and custom functions
	Topic A:	Running and recording a macro
	  A-1:	Running a macro
	  A-2:	Recording a macro
 	  A-3:	Assigning a macro to a command button
	  A-4:	Inserting a macro button 
	  A-5:	Creating an Auto_Open macro
	Topic B:	Working with VBA code
	  B-1:	Observing a VBA code module
	  B-2:	Editing VBA code
	Topic C:	Creating functions
	  C-1:	Creating a custom function
 
CRN Days Time Date Location Instructor Seats Open
53506 023 --WR--- 06:00-09:29 PM 11/05/14-11/06/14 RC 255 Sheahan R 8 of 14
53507 024 M------ 08:00-03:59 PM 11/24/14-11/24/14 RC 221 Tuck L 3 of 14
53965 027 MT----- 06:00-09:29 PM 12/08/14-12/09/14 Off Campus OHEC 131 Grandgenett C 7 of 14
53509 026 ---R--- 08:00-03:59 PM 12/18/14-12/18/14 RC 232 Tuck L 6 of 14

XCOE 1003 - Excel VBA Programming

Gain proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Excel Advanced or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Course Outline:

Visual Basic Editor
1.	Visual Basic for Applications
2.	Object programming
3.	The Object Browser

Programming basics
1.	Data basics
2.	Scope of variables
3.	Scope of procedures

Control structures
1.	Decision structures
2.	Loop structures

Custom dialog boxes
1.	User forms
2.	Events

Debugging and error handling
1.	Errors
2.	Debugging
3.	Error handling
 
CRN Days Time Date Location Instructor Seats Open
53512 007 ----F-- 08:00-03:59 PM 12/12/14-12/12/14 RC 254 Tuck L 8 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 also be taken as part of the Excel Specialist Certificate. For details visit our web page. 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:  Advanced formatting
            Topic A:  Using special number formats
            Topic B:  Working with themes
            Topic C:  Other advanced formatting
Unit 3:  Outlining and subtotals
            Topic A:  Outlining and consolidating data
            Topic B:  Creating subtotals
Unit 4:  Cell and range names
             Topic A:  Creating and using names
             Topic B:  Managing names
Unit 5:  Data structure and tables
             Topic A:  Sorting and filtering data
             Topic B:  Working with tables
Unit 6:  Web and sharing features
             Topic A:  Saving workbooks as Web pages
             Topic B:  Using hyperlinks
Unit 7:  Documenting and auditing
             Topic A:  Auditing features
             Topic B:  Comments in cells and workbooks
             Topic C:  Protection
             Topic D:  Workgroup collaboration
Unit 8:  Application settings and templates
             Topic A:  Application settings
             Topic B:  Working with templates
 
CRN Days Time Date Location Instructor Seats Open
53516 006 M------ 08:00-03:59 PM 11/10/14-11/10/14 RC 255 Sheahan R 5 of 14

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 also be taken as part of the Excel Specialist Certificate. For details visit our web page. 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
53518 006 M------ 08:00-03:59 PM 11/24/14-11/24/14 RC 255 Grandgenett C 2 of 14

XCOE 1010 - Excel Dashboards Workshop

In this workshop students will learn how to build a dashboard using Excel. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisites: Excel Advanced or comparable knowledge.

CEU Hours: 1.4

Contact Hours: 14

1. Connecting to data
2. Pivot table and database functions
3. Named and dynamic ranges
4. Dynamic charting
5. Putting it all together in a dashboard
 
CRN Days Time Date Location Instructor Seats Open
54242 001 ---RF-- 08:00-03:59 PM 12/04/14-12/05/14 RC 232 Faculty 13 of 14

XCOE 5000 - Web-Based Introduction to Microsoft Excel 2007

Work with numbers? Then you need to learn Excel 2007. In this unique six-week online workshop, you'll discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas, using the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. You'll also learn the best ways to sort and analyze data, create custom charts and graphs, create 3-dimensional workbooks, build links between files, endow your worksheets with decision-making capabilities, and automate oft-repeated tasks with macros and buttons. To enroll or for more information about this online class and/or additional start dates, visit http://www.jccc.edu/enroll/ce/ways-to-register/ed2go.html

CEU Hours: 2.4

Contact Hours: 24

 
CRN Days Time Date Location Instructor Seats Open
54470 511 ONLNE ------- - 11/12/14-01/02/15 Online Faculty 99 of 100

XCOE 5004 - WB: Introduction to Microsoft Excel 2010

Discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. Learn the secrets behind writing powerful formulas, using functions, sorting and analyzing data, creating custom charts, creating 3-dimensional workbooks, building links, and creating macros and custom toolbar buttons. For more information about this online class and/or additional start dates, visit: http://www.jccc.edu/enroll/ce/ways-to-register/ed2go.html

CEU Hours: 2.4

Contact Hours: 24

 
CRN Days Time Date Location Instructor Seats Open
54540 512 CEONL ------- - 12/10/14-01/30/15 Online Faculty 99 of 100

XCOE 5007 - Web-based: Intermediate Microsoft Excel 2010

Take your Excel skills to the next level! Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2010, and discover how this powerful MS Office program can boost your productivity. In these hands-on lessons, you'll learn how to create informative, eye-catching charts and harness the power of Excel's data analysis and filtering tools. In addition, you'll find out how easy it is to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire. To enroll or for more information about this online class and/or additional start dates, visit http://www.jccc.edu/enroll/ce/ways-to-register/ed2go.html

CEU Hours: 2.4

Contact Hours: 24

 
CRN Days Time Date Location Instructor Seats Open
54515 511 CEONL ------- - 11/12/14-01/02/15 Online Faculty 98 of 100

XCOE 5008 - WB: Advanced Microsoft Excel 2010

Any proficient Microsoft Excel user will agree that this program is a very powerful analytical tool. Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed course, you'll see how to maximize this program's functions and capabilities.Most organizations rely heavily on Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization. You'll see how to work with the additional analytical tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform what-if data analyses. You'll discover advanced techniques for PivotTables, such as creating calculated fields and calculated items. Become adept at consolidating and importing external data, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Learn how Excel 2010 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer! For more information about this online class and/or additional start dates, visit: http://www.jccc.edu/enroll/ce/ways-to-register/ed2go.html

CEU Hours: 2.4

Contact Hours: 24

 
CRN Days Time Date Location Instructor Seats Open
54287 511 CEONL ------- - 11/12/14-01/02/15 Online Faculty 99 of 100

XCOE 5010 - WB: Intermediate Microsoft Excel 2013

Take your Excel skills to the next level! Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2013, and discover how this powerful MS Office program can boost your productivity.In these hands-on lessons, you'll learn how to create informative, eye-catching charts and graphs and harness the power of Excel's data analysis tools and AutoFilter commands. In addition, you'll find out how easy it is to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire.So get ready for six fun, action-packed weeks that will make you an Excel expert!

CEU Hours: 2.4

Contact Hours: 24

 
CRN Days Time Date Location Instructor Seats Open
54534 511 CEONL ------- - 11/12/14-01/02/15 Online Faculty 100 of 100

Microsoft Excel

XCOE 1000 - Excel 2010 Fundamentals

After an introduction to spreadsheet terminology and Excel's window components, learn how to use the Help system and navigate worksheets and workbooks. Students will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts. This class can also be taken as part of the Excel Specialist Certificate. For details visit our web page.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

Excel Fundamentals outline:

Unit 1:	Getting started
	Topic A:	Spreadsheet terminology
       	  A-1:	Discussing spreadsheet basics
	Topic B:	The Excel environment
   	  B-1:	Examining Excel window components
	Topic C:	Getting help
         C-1:	Getting help with using Excel
	Topic D:	Navigating a worksheet
	 D-1:	Navigating a worksheet

Unit 2:	Entering and editing data
	Topic A:	Entering and editing text and values
	  A-1:	Entering text and values
	  A-2:	Editing cell contents
  	  A-3:	Using AutoFill to fill a series
	Topic B:	Entering and editing formulas
   	  B-1:	Creating a basic formula
  	  B-2:	Entering cell references with the mouse
	  B-3:	Editing a formula
	  B-4:	Working with the order of operations
	Topic C:	Working with pictures
	 C-1:	Inserting and modifying a picture
	Topic D:	Saving and updating workbooks
	 D-1:	Saving a new workbook
	 D-2:	Saving a file as an Excel 97-2003 workbook
	 D-3:	Saving a worksheet as a PDF file 
	 D-4:	Editing and updating a workbook
	
Unit 3:	Modifying a worksheet
	Topic A:	Moving and copying data
	  A-1:	Moving data in a worksheet
	  A-2:	Copying data in a worksheet
	  A-3:	Moving and copying data by using drag-and-drop
	  A-4:	Using the Clipboard task pane
	Topic B:	Moving and copying formulas
	  B-1:	Moving a formula
	  B-2:	Copying a formula
	  B-3:	Using AutoFill to copy a formula
	  B-4:	Using Paste Link 
	Topic C:	Absolute and relative references
	  C-1:	Observing the limitations of relative references
	  C-2:	Applying absolute references
	Topic D:	Inserting and deleting ranges, rows, and columns
	  D-1:	Inserting a range of cells
	  D-2:	Inserting rows
	  D-3:	Deleting a range of cells
	
Unit 4:	Using functions
	Topic A:	Entering functions
	  A-1:	Entering a SUM function
	  A-2:	Using the mouse to enter a function argument
	  A-3:	Entering a function in the formula bar
	  A-4:	Inserting a function
	Topic B:	AutoSum
	  B-1:	Using AutoSum 
	Topic C:	Other common functions
	  C-1:	Using AVERAGE
	  C-2:	Using MIN
	  C-3:	Using MAX
	  C-4:	Using COUNT and COUNTA
	
Unit 5:	Formatting
	Topic A:	Text formatting
	  A-1:	Formatting text
	  A-2:	Formatting a non-contiguous range
	  A-3:	Using the Format Cells dialog box to format text
	Topic B:	Row and column formatting
	  B-1:	Changing column width and row height
	  B-2:	Applying color to a row
	  B-3:	Setting alignment
	  B-4:	Applying borders to cell ranges
	  B-5:	Using the border-drawing pencil
	  B-6:	Using the Paste Special command
	  B-7:	Removing a border
	Topic C:	Number formatting
	  C-1:	Using the Number group to format numbers
	  C-2:	Exploring the Number tab
	Topic D:	Conditional formatting
	  D-1:	Creating a conditional format
	  D-2:	Editing and deleting a conditional format
	Topic E:	Additional formatting options
	  E-1:	Copying formats
	  E-2:	Using AutoFill to copy formatting
	  E-3:	Applying cell styles
	  E-4:	Applying table styles and sorting data 
	  E-5:	Using Find and Replace to change formatting
	
Unit 6:	Printing
	Topic A:	Preparing to print
	  A-1:	Checking spelling in a worksheet
	  A-2:	Finding and replacing text
	  A-3:	Previewing a worksheet
	Topic B:	Page Setup options
	  B-1:	Setting page orientation and scaling
	  B-2:	Adjusting margins
	  B-3:	Creating headers and footers
	  B-4:	Formatting headers and footers
	  B-5:	Printing gridlines and headings
	Topic C:	Printing worksheets
	  C-1:	Printing a selected range
	
Unit 7:	Charts
	Topic A:	Chart basics
	  A-1:	Creating a chart
	  A-2:	Moving a chart within a workbook
	  A-3:	Examining chart elements
	  A-4:	Creating and editing a pie chart
	Topic B:	Formatting charts
	  B-1:	Applying chart types and chart styles
	  B-2:	Modifying chart elements
 
CRN Days Time Date Location Instructor Seats Open
90465 001 --WR--- 06:00-09:29 PM 01/07/15-01/08/15 RC 254 Sheahan R 14 of 14
90466 002 ----F-- 08:00-03:59 PM 01/16/15-01/16/15 Off Campus OHEC 131 Faculty 14 of 14
90467 003 -T----- 08:00-03:59 PM 01/20/15-01/20/15 RC 254 Tuck L 14 of 14
90468 004 M------ 08:00-03:59 PM 02/02/15-02/02/15 RC 255 Faculty 14 of 14
90469 005 -T----- 08:00-03:59 PM 02/10/15-02/10/15 RC 255 Faculty 14 of 14
90470 006 MT----- 06:00-09:29 PM 02/16/15-02/17/15 RC 255 Sheahan R 14 of 14
90471 007 --W---- 08:00-03:59 PM 02/25/15-02/25/15 RC 255 Tuck L 14 of 14
90472 008 ----F-- 08:00-03:59 PM 03/06/15-03/06/15 RC 254 Tuck L 14 of 14
90473 009 --WR--- 06:00-09:29 PM 03/11/15-03/12/15 RC 254 Faculty 14 of 14
90474 010 ---R--- 08:00-03:59 PM 03/26/15-03/26/15 RC 254 Tuck L 14 of 14
90475 011 MT----- 06:00-09:29 PM 03/30/15-03/31/15 Off Campus OHEC 131 Faculty 14 of 14
90476 012 M------ 08:00-03:59 PM 04/06/15-04/06/15 RC 254 Faculty 14 of 14
90477 013 ---R--- 08:00-03:59 PM 04/16/15-04/16/15 RC 254 Tuck L 14 of 14
90478 014 MT----- 06:00-09:29 PM 04/20/15-04/21/15 RC 255 Sheahan R 14 of 14
90479 015 ---R--- 08:00-03:59 PM 04/30/15-04/30/15 RC 254 Tuck L 14 of 14
90480 016 --W---- 08:00-03:59 PM 05/06/15-05/06/15 RC 254 Sheahan R 14 of 14
90481 017 --WR--- 06:00-09:29 PM 05/13/15-05/14/15 RC 232 Snyder B 14 of 14
91388 018 ----F-- 08:00-03:59 PM 05/22/15-05/22/15 Off Campus OHEC 131 Faculty 14 of 14
91389 019 ---R--- 08:00-03:59 PM 05/28/15-05/28/15 RC 253 Faculty 14 of 14
91390 020 M------ 08:00-03:59 PM 06/08/15-06/08/15 RC 254 Faculty 14 of 14
91391 021 --W---- 08:00-03:59 PM 06/17/15-06/17/15 RC 253 Faculty 14 of 14
91392 022 MT----- 06:00-09:29 PM 06/22/15-06/23/15 RC 255 Faculty 14 of 14
91393 023 M------ 08:00-03:59 PM 06/29/15-06/29/15 RC 253 Faculty 14 of 14
91394 024 ---R--- 08:00-03:59 PM 07/09/15-07/09/15 RC 254 Faculty 14 of 14
91395 025 --WR--- 06:00-09:29 PM 07/15/15-07/16/15 RC 238 Faculty 14 of 14
91396 026 --W---- 08:00-03:59 PM 07/22/15-07/22/15 RC 254 Faculty 14 of 14
91397 027 MT----- 06:00-09:29 PM 08/03/15-08/04/15 Off Campus OHEC 131 Faculty 14 of 14
91398 028 -T----- 08:00-03:59 PM 08/11/15-08/11/15 RC 254 Faculty 14 of 14

XCOE 1001 - Excel 2010 Intermediate

Learn how to use multiple worksheets and large workbooks efficiently. Discover how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging This class can also be taken as part of the Excel Specialist Certificate. For details visit our web page.Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Excel Fundamentals or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Excel Intermediate outline:

Unit 1:	Managing large workbooks
	Topic A:	Viewing large worksheets
	  A-1:	Locking rows and columns
	  A-2:	Opening and arranging new windows
	  A-3:	Splitting a worksheet into panes
	  A-4:	Hiding and unhiding columns and worksheets
	  A-5:	Minimizing the Ribbon
	Topic B:	Printing large worksheets
	  B-1:	Setting print titles
	  B-2:	Adjusting page breaks
	  B-3:	Inserting different even and odd headers
	Topic C:	Working with multiple worksheets
	  C-1:	Navigating between worksheets
	  C-2:	Naming worksheets and coloring tabs
	  C-3:	Working with multiple worksheets
	  C-4:	Previewing and printing multiple worksheets
	
Unit 2:	Using multiple worksheets and workbooks
	Topic A:	Using multiple workbooks
	  A-1:	Switching between workbooks
	  A-2:	Copying a worksheet to another workbook
	Topic B:	Linking worksheets with 3-D formulas
	  B-1:	Creating 3-D formulas
	  B-2:	Adding a Watch window
	Topic C:	Linking workbooks
	  C-1:	Examining external links in a worksheet
	  C-2:	Creating external links in a worksheet
	  C-3:	Editing links
	Topic D:	Managing workbooks
	  D-1:	Creating a workspace
	
Unit 3:	Outlining and subtotals
	Topic A:	Outlining and consolidating data
	  A-1:	Creating an outline
	  A-2:	Creating custom views
	  A-3:	Using the Consolidate command
	Topic B:	Creating subtotals
	  B-1:	Creating subtotals in a list
	  B-2:	Using multiple subtotal functions
	
Unit 4:	Cell and range names
	Topic A:	Creating and using names
	  A-1:	Naming and selecting ranges 
	  A-2:	Using names in formulas
	  A-3:	Using the Create from Selection command
	  A-4:	Applying names to existing formulas
	Topic B:	Managing names
	  B-1:	Modifying and deleting named ranges
  	  B-2:	Defining and applying 3-D names
	
Unit 5:	Tables
	Topic A:	Sorting and filtering data
	  A-1:	Examining the structure of data
	  A-2:	Sorting data
	  A-3:	Filtering data by using AutoFilter
	  A-4:	Using cell color and attributes to sort and filter data
	Topic B:	Advanced filtering
	  B-1:	Using Custom AutoFilter criteria
	  B-2:	Using the Advanced Filter dialog box
	  B-3:	Copying filtered results to another range
	Topic C:	Working with tables
	  C-1:	Creating a table
	  C-2:	Formatting a table
	  C-3:	Adding and deleting rows and columns
	  C-4:	Using structured references
	  C-5:	Naming tables 
	  C-6:	Creating functions with the [@] argument
	
Unit 6:	Advanced charting
	Topic A:	Chart formatting options
	  A-1:	Adjusting the scale of a chart
	  A-2:	Formatting a data point
	Topic B:	Combination charts
	  B-1:	Creating a combination chart
	  B-2:	Creating a trendline
	  B-3:	Inserting sparklines
 	  B-4:	Using a chart template
	Topic C:	Graphical elements
	  C-1:	Adding graphical elements
	  C-2:	Formatting a graphical element
	  C-3:	Adding a picture to a worksheet
	  C-4:	Modifying a picture
	
Unit 7:	Documenting and auditing
	Topic A:	Comments in cells and workbooks
	  A-1:	Viewing comments in a worksheet
	  A-2:	Adding a comment to a cell
	  A-3:	Adding comments to a workbook
	Topic B:	Protection
	  B-1:	Password-protecting a worksheet
	  B-2:	Unlocking cells and protecting part of a worksheet 
	  B-3:	Protecting the workbook structure
	  B-4:	Discussing digital signatures
 
CRN Days Time Date Location Instructor Seats Open
90482 001 ---R--- 08:00-03:59 PM 01/22/15-01/22/15 RC 254 Tuck L 12 of 14
90483 002 ----F-- 08:00-03:59 PM 02/06/15-02/06/15 Off Campus OHEC 131 Snyder B 13 of 14
90484 003 MT----- 06:00-09:29 PM 02/23/15-02/24/15 RC 238 Sheahan R 14 of 14
90485 004 -T----- 08:00-03:59 PM 03/10/15-03/10/15 RC 254 Tuck L 14 of 14
90486 005 --WR--- 06:00-09:29 PM 03/18/15-03/19/15 RC 254 Faculty 14 of 14
90487 006 --W---- 08:00-03:59 PM 04/01/15-04/01/15 RC 254 Tuck L 14 of 14
90488 007 MT----- 06:00-09:29 PM 04/06/15-04/07/15 Off Campus OHEC 131 Faculty 14 of 14
90489 008 ----F-- 08:00-03:59 PM 04/17/15-04/17/15 RC 254 Tuck L 14 of 14
90490 009 --WR--- 06:00-09:29 PM 04/22/15-04/23/15 RC 234 Faculty 14 of 14
90491 010 -T----- 08:00-03:59 PM 05/05/15-05/05/15 RC 238 Tuck L 14 of 14
90492 011 M------ 08:00-03:59 PM 05/11/15-05/11/15 RC 254 Tuck L 14 of 14
91399 012 -T----- 08:00-03:59 PM 05/26/15-05/26/15 RC 254 Faculty 14 of 14
91400 013 -T----- 08:00-03:59 PM 06/02/15-06/02/15 RC 254 Faculty 14 of 14
91401 014 ----F-- 08:00-03:59 PM 06/12/15-06/12/15 Off Campus OHEC 131 Faculty 14 of 14
91408 015 --W---- 08:00-03:59 PM 06/24/15-06/24/15 RC 254 Faculty 14 of 14
91409 016 MT----- 06:00-09:29 PM 06/29/15-06/30/15 RC 252 Faculty 10 of 10
91410 017 --WR--- 06:00-09:29 PM 07/22/15-07/23/15 RC 252 Faculty 10 of 10
91411 018 MT----- 06:00-09:29 PM 08/10/15-08/11/15 Off Campus OHEC 131 Faculty 14 of 14
91412 019 ---R--- 08:00-03:59 PM 08/13/15-08/13/15 RC 254 Faculty 14 of 14

XCOE 1002 - Excel 2010 Advanced

Work with advanced formulas, as well as lookup functions such as VLOOKUP. Explore data validation and database functions, such as DSUM. Learn how to import and export data, and how to query external databases. Learn about running and recording macros. PivotTables and PivotCharts are also covered in this course. This class can also be taken as part of the Excel Specialist Certificate. For details visit our web page.Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Excel Intermediate or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Excel Advanced outline:

Unit 1:	Logical and statistical functions
	Topic A:	Logical functions
	  A-1:	Using the IF function
	  A-2:	Using a formula to apply conditional formatting
	  A-3:	Using OR, AND, and NOT as nested functions
	  A-4:	Using nested IF functions
	  A-5:	Using the IFERROR function
	Topic B:	Math and statistical functions
	  B-1:	Using SUMIF 
	  B-2:	Using COUNTIF
	  B-3:	Using AVERAGEIF
	  B-4:	Using SUMIFS, COUNTIFS, and AVERAGEIFS
	  B-5:	Using ROUND 
	
Unit 2:	Financial and date functions
	Topic A:	Financial functions
	  A-1:	Using the PMT function
	Topic B:	Date and time functions
	  B-1:	Using date functions 
	  B-2:	Using time functions
	Topic C:	Array formulas
	  C-1:	Using an array formula 
	  C-2:	Applying arrays to functions  
	  C-3:	Modifying the array formula
	Topic D:	Displaying and printing formulas
	  D-1:	Showing, printing, and hiding formulas
	  D-2:	Setting calculation options
	
Unit 3:	Lookups and data tables
	Topic A:	Using lookup functions
	  A-1:	Examining VLOOKUP
	  A-2:	Using VLOOKUP to find an exact match
	  A-3:	Using VLOOKUP to find an approximate match
	  A-4:	Using HLOOKUP to find exact matches
	  A-5:	Using HLOOKUP to find approximate matches
	Topic B:	Creating data tables
	  B-1:	Creating a one-variable data table
	  B-2:	Creating a two-variable data table
	
Unit 4:	Advanced data management
	Topic A:	Validating cell entries
	  A-1:	Observing data validation
	  A-2:	Creating a data validation rule
	  A-3:	Setting date and list validation rules
	Topic B:	Exploring database functions
	  B-1:	Examining the structure of database functions
	  B-2:	Using the DSUM function
	
Unit 5:	PivotTables and PivotCharts
	Topic A:	Working with PivotTables
          A-1:	Creating a PivotTable
	  A-2:	Adding fields to a PivotTable
	  A-3:	Using slicers to filter PivotTable data
	Topic B:	Rearranging PivotTables
	  B-1:	Moving fields
	  B-2:	Collapsing and expanding fields
	  B-3:	Refreshing the data in a PivotTable
	Topic C:	Formatting PivotTables
	  C-1:	Applying a PivotTable style
	  C-2:	Changing field settings
	Topic D:	Using PivotCharts
	  D-1:	Creating a PivotChart
	
Unit 6:	Macros and custom functions
	Topic A:	Running and recording a macro
	  A-1:	Running a macro
	  A-2:	Recording a macro
 	  A-3:	Assigning a macro to a command button
	  A-4:	Inserting a macro button 
	  A-5:	Creating an Auto_Open macro
	Topic B:	Working with VBA code
	  B-1:	Observing a VBA code module
	  B-2:	Editing VBA code
	Topic C:	Creating functions
	  C-1:	Creating a custom function
 
CRN Days Time Date Location Instructor Seats Open
90493 001 --W---- 08:00-03:59 PM 01/28/15-01/28/15 RC 252 Tuck L 7 of 10
90494 002 ----F-- 08:00-03:59 PM 02/27/15-02/27/15 Off Campus OHEC 131 Faculty 14 of 14
90495 003 --WR--- 06:00-09:29 PM 03/04/15-03/05/15 RC 238 Faculty 14 of 14
90496 004 ----F-- 08:00-03:59 PM 03/13/15-03/13/15 RC 254 Tuck L 13 of 14
90497 005 MT----- 06:00-09:29 PM 03/23/15-03/24/15 RC 254 Faculty 14 of 14
90498 006 M------ 08:00-03:59 PM 04/13/15-04/13/15 RC 254 Tuck L 14 of 14
90499 007 MT----- 06:00-09:29 PM 04/27/15-04/28/15 Off Campus OHEC 131 Faculty 14 of 14
91413 008 --W---- 08:00-03:59 PM 05/20/15-05/20/15 RC 253 Faculty 14 of 14
91414 009 ----F-- 08:00-03:59 PM 06/05/15-06/05/15 RC 254 Faculty 14 of 14
91415 010 ----F-- 08:00-03:59 PM 06/26/15-06/26/15 RC 254 Faculty 14 of 14
91416 011 ---R--- 08:00-03:59 PM 07/02/15-07/02/15 Off Campus OHEC 131 Faculty 14 of 14
91417 012 --WR--- 06:00-09:29 PM 07/08/15-07/09/15 RC 234 Faculty 14 of 14
91418 013 --WR--- 06:00-09:29 PM 07/29/15-07/30/15 RC 255 Faculty 14 of 14

XCOE 1003 - Excel VBA Programming

Gain proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Excel Advanced or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Course Outline:

Visual Basic Editor
1.	Visual Basic for Applications
2.	Object programming
3.	The Object Browser

Programming basics
1.	Data basics
2.	Scope of variables
3.	Scope of procedures

Control structures
1.	Decision structures
2.	Loop structures

Custom dialog boxes
1.	User forms
2.	Events

Debugging and error handling
1.	Errors
2.	Debugging
3.	Error handling
 
CRN Days Time Date Location Instructor Seats Open
90500 001 M------ 08:00-03:59 PM 03/02/15-03/02/15 RC 253 Tuck L 14 of 14
90501 002 --WR--- 06:00-09:29 PM 04/15/15-04/16/15 RC 232 Stublen N 14 of 14
91419 003 ----F-- 08:00-03:59 PM 05/29/15-05/29/15 RC 254 Faculty 14 of 14
91420 004 -T----- 08:00-03:59 PM 06/30/15-06/30/15 RC 253 Faculty 14 of 14
91421 005 MT----- 06:00-09:29 PM 08/03/15-08/04/15 RC 253 Faculty 14 of 14

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 also be taken as part of the Excel Specialist Certificate. For details visit our web page. 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
90502 001 --WR--- 06:00-09:29 PM 01/28/15-01/29/15 RC 234 Faculty 14 of 14
90503 002 M------ 08:00-03:59 PM 03/16/15-03/16/15 RC 255 Faculty 13 of 14
91422 003 --WR--- 06:00-09:29 PM 06/03/15-06/04/15 RC 234 Faculty 14 of 14
91423 004 M------ 08:00-03:59 PM 07/27/15-07/27/15 RC 234 Faculty 14 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 also be taken as part of the Excel Specialist Certificate. For details visit our web page. 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:  Advanced formatting
            Topic A:  Using special number formats
            Topic B:  Working with themes
            Topic C:  Other advanced formatting
Unit 3:  Outlining and subtotals
            Topic A:  Outlining and consolidating data
            Topic B:  Creating subtotals
Unit 4:  Cell and range names
             Topic A:  Creating and using names
             Topic B:  Managing names
Unit 5:  Data structure and tables
             Topic A:  Sorting and filtering data
             Topic B:  Working with tables
Unit 6:  Web and sharing features
             Topic A:  Saving workbooks as Web pages
             Topic B:  Using hyperlinks
Unit 7:  Documenting and auditing
             Topic A:  Auditing features
             Topic B:  Comments in cells and workbooks
             Topic C:  Protection
             Topic D:  Workgroup collaboration
Unit 8:  Application settings and templates
             Topic A:  Application settings
             Topic B:  Working with templates
 
CRN Days Time Date Location Instructor Seats Open
90504 001 --WR--- 06:00-09:29 PM 02/04/15-02/05/15 RC 255 Sheahan R 14 of 14
90505 002 M------ 08:00-03:59 PM 03/30/15-03/30/15 RC 255 Faculty 14 of 14
91424 003 --WR--- 06:00-09:29 PM 06/10/15-06/11/15 RC 234 Faculty 14 of 14
91425 004 M------ 08:00-03:59 PM 08/03/15-08/03/15 RC 255 Faculty 14 of 14

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 also be taken as part of the Excel Specialist Certificate. For details visit our web page. 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
90506 001 --WR--- 06:00-09:29 PM 02/18/15-02/19/15 RC 255 Faculty 13 of 14
90507 002 M------ 08:00-03:59 PM 04/20/15-04/20/15 RC 255 Faculty 14 of 14
91426 003 --WR--- 06:00-09:29 PM 06/24/15-06/25/15 RC 255 Faculty 14 of 14

XCOE 1010 - Excel Dashboards Workshop

In this workshop students will learn how to build a dashboard using Excel. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisites: Excel Advanced or comparable knowledge.

CEU Hours: 1.4

Contact Hours: 14

1. Connecting to data
2. Pivot table and database functions
3. Named and dynamic ranges
4. Dynamic charting
5. Putting it all together in a dashboard
 
CRN Days Time Date Location Instructor Seats Open
91368 001 MT----- 08:00-03:59 PM 02/09/15-02/10/15 RC 238 Faculty 14 of 14
91369 002 --WR--- 06:00-09:29 PM 03/04/15-03/05/15 RC 234 Faculty 14 of 14
-----S- 08:00-03:59 PM 03/07/15-03/07/15 RC 234    
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.