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
COMP1573 Advanced Microsoft Excel 2016

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 analysis. You'll discover ways to work with databases and 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 using Excel's built-in Power Query tool, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.
Learn how Excel 2016 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
COMP1911 Excel

Description: This course takes you beyond the basics to cover intermediate spreadsheeting concepts and techniques using Excel. Students will learn how to produce professional workbooks. Emphasis will be placed on: planning and creating spreadsheets using formulas and functions; data analysis; generating graphs; and, linking summarizing and consolidating worksheets.
Hours: 36
Credits: 3
Pre-Requisites:
CoRequisites:

36 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
COMP1912 Excel - Advanced

Description: This course builds on the knowledge gained in the Excel course. Emphasis will be placed on organizing and consolidating data with efficient multi-sheet models; applying arrays and formulas to new and powerful uses; working in an OLE (Object-Linking and Embedding) environment; recording and editing macros; advanced charting; utilizing scenarios; pivot tables; and finding the best solution using Solver.
Hours: 36
Credits: 3
Pre-Requisites:
CoRequisites:

36 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
COMP0272 Excel Level 2

Description: This course is intended for participants who are familiar with Microsoft Excel and is suitable for users of either version of Microsoft Excel 2013 and or 2016
Topics include; Worksheet Organization, Advanced Formulas, Using Multiple Workbooks and Worksheets, Working with Charts, Applying Formatting.
Hours: 6
Credits: 0
Pre-Requisites:
CoRequisites:

6   Details
COMP0273 Excel Level 3 - Data Management

Description: This course is intended for participants who are familiar with Microsoft Excel and is suitable for users of either version of Microsoft Excel 2013 and or 2016.
Topics include; Maintaining Data, Sorting Lists, Filtering List, Summarizing Data, Working with PivotTables, Working with External Data.
Hours: 6
Credits: 0
Pre-Requisites:
CoRequisites:

6   Details
COMP1720 Intermediate Microsoft Excel 2007

Description: Master advanced features of Microsoft Excel 2007, including charting and PivotTables, and discover how this powerful MS Office program can boost your productivity. In this practical, hands-on course, you'll learn how to create informative and eye-catching charts, as well as how to harness the power of Excel 2007's filtering techniques. You'll see how Excel 2007 can give you further insight into your valuable data. And by learning how to create macros that eliminate repetitive tasks, you'll earn your coworkers admiration and gratitude. With your macro knowledge, you'll be able to manipulate data with the push of a button.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

24 Yes Details
COMP1092 Intermediate Microsoft Excel 2010

Description: Take your Excel skills to the next level! In these on-line, hands-on lessons, you'll master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2010. Learn how to harness the power of Excel's data analysis and filtering tools and see how easy it is to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

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

24 Yes Details
COMP1567 Intermediate Microsoft Excel 2016

Description: This course is offered in partnership with Ed2go (Education to Go) and Conestoga College.
There are no books to purchase; your course materials are online.
To complete the enrollment process and activate your course,
Please go to the Online Instruction Center located at
www.ed2go.com/conestoga

Follow the steps to enrol by typing your course title or key word into the search bar
Click “Add to Cart”
Please note: No payment is required on the Ed2go site.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

24 Yes Details
COMP1378 Introduction to Microsoft Excel 2007

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

24 Yes Details
COMP1004 Introduction to Microsoft Excel 2010

Description: This on-line course is not a tutorial, but an in-depth class where you'll get training, help, and personal support from an experienced instructor as you're learning Excel basics step-by-step. 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:

24 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. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.
In addition, you'll get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. This informative course covers the new Quick Analysis, Flash Fill, and charting capabilities available in Excel 2013.
This is not a tutorial, but an in-depth class where you'll get training, help, and personal support from an experienced instructor as you're learning Excel basics step-by-step. By the time you're done, you'll be using this vital Office 2013 application like a pro.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

24 Yes Details
COMP1434 Introduction to Microsoft Excel 2016

Description: Do you work with numbers? Then you need to master Microsoft Excel 2016 (now available through Office 365)—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. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.
In addition, you'll get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. This informative course covers Quick Analysis, Flash Fill, and powerful charting capabilities available in Excel 2016.
This is not a tutorial, but an in-depth class where you'll get training, help, and personal support from an experienced instructor as you're learning Excel basics step-by-step. By the time you're done, you'll be using this vital Office 2016 tool like a pro.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

24 Yes Details

Contacts for Spreadsheets.

SEARCH PART-TIME (PT)
Back To Top