Conestoga College Logo - Home Page

Part-time Courses - Spreadsheets

Click on the course code or title below for a full description of the course. If available for registration, clicking on "Details" in the Status column will open a new browser tab or window in the Student Portal.

Courses
Course # Courses Length (Hours) Distance Status
COMP1048 Advanced Microsoft Excel 2007

Description: 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.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

24 Yes Details
COMP1029 Advanced Microsoft Excel 2010

Description: Discover the advanced features and functions of Microsoft Excel 2010, including data analysis tools, database techniques, and advanced methods for using PivotTables.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

24 Yes Details
COMP1707 Advanced Microsoft Excel 2013

Description: 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 analysis 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, like creating Timelines, calculated fields, and calculated items. You'll learn how to use Excel's consolidation function to efficiently summarize data from multiple sources, become adept at importing external data, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.
Learn how Excel 2013 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!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

24 Yes Details
OLRN1293 Excel

Description: Recommended: Familiarity with MS Office products including MS Outlook

Learn to use MS Excel for Windows to create and format spreadsheets in order to analyze data and make more informed business decisions. You will discover how to; create, edit, format and print workbooks; use mathematical formulas and functions; create and format charts and shapes; insert images; cut, copy and paste data.
Hours: 42
Credits: 3
Pre-Requisites:
CoRequisites:

42 Yes Details
OLRN1303 Excel - Expert

Description: Recommended: Excel OLRN1293

This course is designed to teach advanced topics of MS Excel. Students will learn how to create and manipulate advanced spreadsheets and be able to manipulate data, work with templates and styles, connecting to external data and links, reviewing and protecting workbooks, custom formats and layouts and creating advanced formulas.
Hours: 42
Credits: 3
Pre-Requisites:
CoRequisites:

42 Yes Details

Contacts for Spreadsheets.

SEARCH PART-TIME (PT)
Back To Top