CH128

MS Office - MS Project - Windows 8

The Essentials of MS Excel for Managers

Course
duration
1 day
regular
Rate
$350
preferential
Rate
$295 A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies who do a certain amount of business with Technologia. To know more, please check the FAQ's section on «Registration and rates».

Cities and Dates(Public sessions in French only)		participant(s)
Montreal - 2007 / 2010 version	03 June 2013	-+
Montreal - 2007 / 2010 version	24 September 2013	-+
Montreal - 2007 / 2010 version	16 December 2013	-+
Montreal - 2007 / 2010 version	12 March 2014	-+
Montreal - 2007 / 2010 version	02 June 2014	-+

Return to Catalog Add to cart

Next Previous

Accreditation Partnerships

6 PDU

Article "MS PowerPoint : il faut savoir où travailler!" (in French only)
Article "MS Word : une bonne sélection et des touches magiques!" (in French only)

This Course is also offered private training.If you have a group and would like this course to take place at your location, please consult our Private Training section to know more or to get in touch with our sales department.

Practical courses

Course and trainers' evaluations

Objectives

To provide the knowledge and skills required to make use of the fundamental features of Excel to increase productivity and autonomy.

Target Audience

Managers.

Prerequisites

Basic knowledge of Excel.

Content

Indispensable keyboard shortcuts
Organizing the data in order to work efficiently with Excel
Setting up the page efficiently: using the fill handle, and special cut and paste techniques
The various addressing modes: A1, $A$1, $A1 and A$1
Essential features
Automating layout: custom formats and conditional formatting
Cross-sheet and cross-file formulas
Creating graphics
Updating multiple tabs simultaneously
Choosing a good analysis tool: pivot tables, filters and subtotals
Using scenarios
Input control: protection and validation of information

Note

Note: The course is given using Excel 2013, but the features described are available in Excel 2007 and Excel 2010 as well. The version of the course given with Excel 2003 is available upon demand.

Customer Testimonials

Evaluations

% overall satisfaction for this course

91%

% Participants who would recommend this course

100%

« Well-designed course. The limited number of participants allows the trainer to closely follow-up on students and meet their individual needs. »

Pascal M., Adjoint administratif, ER Gestion Rénovation

Next Previous

Trainers for this Course

Richard Tremblay Has trained more than five thousand people and given more than 600 training sessions. Has over ten years experience with Office suite and MS Project.

95% Trainer
evaluation