REGISTER NOW
Excel Professional Series
Adapted from our corporate training programs, these seminars allow you to enhance your skills in a particular area, or take them all to attain an advanced functional proficiency with Excel for use in business.
Excel 1: Setting Up a Spreadsheet
Discover the basic functions of Excel and learn how you can use the program to organize your data. Topics include general spreadsheet structure, entering text/values, adjusting the widths of columns/rows, changing alignment in cells, basic functions, and enhancing/printing output.
Course Details
| Date | Time | Day | Delivery Mode | Status |
| Jan 14, 2025 | 6-9:30 pm | Tues | In-Person (Belleville Campus) | REGISTER NOW |
$54.87 plus HST
Facilitator: Mike McClelland
Prerequisite: Not Applicable
Excel 2: Excel as a Data Base
Take home new skills that enable you to construct and design a database that works for you. Methods of finding information from a database, such as the find command, data filters, data sorts, and sub-totals are explored. Learn about validating data and extracting information from your database by using functions such as Conditional Sum and V-Lookup. Prerequisite: Basic knowledge of Excel.
Course Details
| Date | Time | Day | Delivery Mode | Status |
| Jan 21, 2025 | 6-9:30 pm | Tues | In-Person (Belleville Campus) | REGISTER NOW |
$54.87 plus HST
Facilitator: Mike McClelland
Prerequisite: Excel 1 recommended
Excel 3: Excel Pivot Tables
Find out how to take your data analysis to the next level and save time with pivot tables and pivot charts. Easy to build, update and maintain, pivot tables are dynamic and fully customizable for your specific needs. In this class, you will learn how to create, edit, and manipulate pivot tables. Prerequisite: Basic knowledge of Excel
Course Details
| Date | Time | Day | Delivery Mode | Status |
| Jan 28, 2025 | 6-9:30 pm | Tues | In-Person (Belleville Campus) | REGISTER NOW |
$54.87 plus HST
Facilitator: Mike McClelland
Prerequisite: Excel 2 recommended
Excel 4: Excel Formulas and Functions
You will learn to spend less time inputting raw data and more time analyzing data. Discover how to automatically extract information from data tables, rank items in a list automatically, use the IF function to have Excel make decisions for you, and use the Forecast and Trend functions. Prerequisite: Basic knowledge of Excel.
Course Details
| Date | Time | Day | Delivery Mode | Status |
| Feb 4, 2025 | 6-9:30 pm | Tues | In-Person (Belleville Campus) | REGISTER NOW |
$54.87 plus HST
Facilitator: Mike McClelland
Prerequisite: Excel 3 recommended
Excel 5: Enhancing a Spreadsheet
Enhance your knowledge of Excel and learn how to add the wow factor to your spreadsheets. Discover the drawing, graphic and smart art tools. Learn how to create organization charts and title pages, as well as how to integrate graphics/pictures from the Internet into your spreadsheets.
COST $54.87 plus HST
Course Details
| Date | Time | Day | Delivery Mode | Status |
| Feb 11, 2025 | 6-9:30 pm | Tues | In-Person (Belleville Campus) | REGISTER NOW |
$54.87 plus HST
Facilitator: Mike McClelland
Prerequisite: Excel 4 recommended
Excel 6: Using Excel Charts
You will be introduced to the built-in tools that allow you to create dynamic charts from a basic spreadsheet. Primary focus is on development of line, bar, and pie charts, and their use in conveying a message to an audience. Other topics include charting multiple data streams, using data labels, modifying output of charts, rotating charts, and adding graphics from the Internet to charts. Prerequisite: Basic knowledge of Excel
Course Details
| Date | Time | Day | Delivery Mode | Status |
| Feb 18, 2025 | 6-9:30 pm | Tues | In-Person (Belleville Campus) | REGISTER NOW |
$54.87 plus HST
Facilitator: Mike McClelland
Prerequisite: Excel 5 recommended
Excel 7: Introduction to Excel Macros
Gain a better understanding of the power of automation in Excel using Macros. Start off with basic macros that help improve personal productivity. Then discover more powerful decision-making macros and how to create personal menus. Prerequisite: Basic knowledge of Excel.
Course Details
| Date | Time | Day | Delivery Mode | Status |
| Feb 25, 2025 | 6-9:30 pm | Tues | In-Person (Belleville Campus) | REGISTER NOW |
$54.87 plus HST
Facilitator: Mike McClelland
Prerequisite: Excel 6 recommended
For Questions?
Contact Krista McConnell at kmcconell@loyalistcollege.com or 613-969-1913 Ext 2467