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 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:

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:

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:

Yes Details
OLRN1293 Excel

Description: Recommended: Familiarity with Windows 95 or higher. Introduction to Computers or equivalent.

Excel allows you to create powerful, professional spreadsheets and graphics. The first lessons will cover the basic introductory skills of how to create, edit, format and print spreadsheets; the remainder of the course will focus on more advanced features such as sorting, charts, formulas and functions to facilitate any of your marketing, budgeting and projecting needs.

Note: Students wishing to enrol in this course as an equivalent credit at Conestoga College must be using the Excel 2007 or higher version.
Hours: 42
Credits: 3
Pre-Requisites:
CoRequisites:

Yes Details
OLRN1303 Excel - Expert

Description: Recommended: Excel - Specialist or equivalent.

As a continuation of the introductory course, you will focus on some of the more sophisticated functions of Excel, including importing databases, queries, pivot table functions, macros and forms plus shortcuts. Software requirements: Excel 2007 or higher.

Note: Students wishing to enrol in this course as an equivalent credit at Conestoga College must be using the Excel 2007 or higher version.
Hours: 42
Credits: 3
Pre-Requisites:
CoRequisites:

Yes Details
COMP1443 Intermediate Microsoft Excel 2013

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

Yes Details
COMP1217 Introduction to Microsoft Excel 2013

Description: Do you work with numbers? Then you need to master Microsoft Excel 2013, and this is the place to do it. Even "non-techie" beginners will find it easy to learn Excel in this fun, step-by-step online course. These lessons will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Yes Details

Contacts for Spreadsheets.

SEARCH PART-TIME (PT)

Back To Top