EQ Microsoft Excel – Intermediate

Registration: Please contact CTD at eqctd@dawsoncollege.qc.ca to request the form.

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.

Content:
• 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
• Creating and managing Macros
• 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

Price: $60.00

Summer 2019

Day Sessions

May 25 - Aug 10Sat

Saturday, May 25 - Saturday, Aug 10

DayTimeRoom Number
Saturday09:30 - 12:302F.14

Additional Information

Teacher: Susan Ehret
Course Number: 922060
Registration Start Date: Monday, Apr 15, 2019
Group Schedule Info: No Class June 22nd & June 29th
Maximum Class Size: 12
Total Hours: 30
Status: Activity in Progress

Evening Sessions

May 23 - Aug 01Thu

Thursday, May 23 - Thursday, Aug 01

DayTimeRoom Number
Thursday18:00 - 21:002F.14

Additional Information

Teacher: Wasen Al-farhan
Course Number: 922060
Registration Start Date: Tuesday, Apr 16, 2019
Group Schedule Info: No Class June 6th.
Maximum Class Size: 12
Total Hours: 30
Status: Activity in Progress

Jun 11 - Aug 13Tue

Tuesday, Jun 11 - Tuesday, Aug 13

DayTimeRoom Number
Tuesday18:00 - 21:002F.24

Additional Information

Teacher: Wasen Al-farhan
Course Number: 922060
Registration Start Date: Tuesday, Apr 23, 2019
Maximum Class Size: 12
Total Hours: 30
Status: Activity in Progress
Consult the complete course offering at montezdeniveau.ca

Return to all Emploi Quebec courses


Other Categories

Last Modified: July 17, 2019