EQ Excel – Intermediate

ImportantThis course will be given online using Zoom video conference.There are no in-person classes.

Prerequisite: Excel Beginner, or equivalent knowledge

Intermediate Excel builds upon beginner skills with the introduction of management tools to import and work with rows of data to provide meaningful reports and information for business decisions. We will also look at using more complex formulas and logic to create more versatile worksheets.

The hands-on, in-class method allows the student to develop proficiency and confidence working in Excel.

• Importing data from an outside source
• Managing data using tables
• Finding and replacing
• Sorting and filtering data
• Searching for data using VLOOKUP & HLOOKUP
• Enforcing accurate data input
• Protecting workbook data
• Analyzing data with PivotTables
• Visualizing information with PivotCharts
• Cleaning data using text functions – UPPER, LOWER, PROPER, TRIM
• Calculating based on conditions
• Consolidating data
• Setting named ranges
• Creating conditional formulas – IF, AND, OR
• Using functions to check for error

Required Material: Students must bring a USB Drive to class

Course Price: $60.00

Fall 2021

Day Sessions

Sep 25 - Dec 04Sat

Saturday, Sep 25 - Saturday, Dec 04

DayTimeRoom Number
Saturday13:30 - 16:30VIR-Non-CR

Additional Information

Teacher: Yves Anglade
Course Number: 922060
Registration Start Date: Thursday, Aug 19, 2021
Group Schedule Info: No Class Saturday, October 9th. Statutory holiday.
Maximum Class Size: 9
Total Hours: 30
Status: Course Full.

Please contact the CTD office for more information on how to register.
Consult the complete course offering at montezdeniveau.ca

Return to all Emploi Quebec courses

Other Categories

Last Modified: September 15, 2021