CartConfirm registration and payPersonal FileQuit
Mia Registration Portal
Courses
Computer & Technology
Courses

Emploi Quebec
Emploi Quebec (Online registration only)

Languages
English
French
German
Italian
Japanese
Spanish
Korean
Russian
Arabic

Confucius Institute in Quebec
Chinese Language Courses

Photography
Courses

General & Professional Interests
Courses

Testing Center
TEF/TEFAQ
HSK

EQ Excel - Intermediate 

Services Québec

Cost 60.00$
Age from 16 years
Available places 2
Duration 30 hours


Online registration is closed. Please add your name to the Waiting list so that you will be contacted when the course is next available.


Waiting list


EQ Excel - Intermediate
(922060)
From Jan 22nd to Mar 26th, 2019
Tuesday 18:00 to 21:00, room 5B.3 Laboratory - Computer
Group number W19-922060


Prerequisite: Excel Beginner, or equivalent knowledge

Required Material: Students must bring a USB Drive to class

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


Courses subsidized by Emploi-Québec

Eligibility:

You are eligible to take these courses if you are:
  • a seasonal worker who is not currently working, but retains ties with his/her employer;
  • self-employed;
  • overqualified for the position you currently hold and the course is relevant to your area of study.
You are not eligible to take these courses if you are:
  • employed in the public or para-public sector;
  • a full-time student;
  • unemployed and/or receiving employment insurance or welfare;
  • receiving CSST (worker's compensation) from the SAAQ.

Maximum of two (2) courses per person.
Maximum of three (3) registrations per establishment.





Back