Technologia
Registration

Develop its professional efficiency

Efficient Time and Priority Management (CH107)

MONTREAL: July 8-9, 2009 (French)  /  September 14-15, 2009 (French)  /  November 18-19, 2009 (French)  /  January 11-12, 2010 (French)  /  March 8-9, 2010 (French)  /  May 5-6, 2010 (French)  /  July 14-15, 2010 (French)

QUEBEC CITY: October 19-20, 2009 (French)  /  February 11-12, 2010 (French)  /  June 21-22, 2010 (French)

GATINEAU: November 23-24, 2009 (French)  /  May 27-28, 2010 (French)

Enhancing professional ethics (CH176) NEW COURSE

MONTREAL: December 18, 2009 (French)  /  March 24, 2010 (French)  /  May 28, 2010 (French)

QUEBEC CITY: December 4, 2009 (French)  /  March 17, 2010 (French)  /  May 19, 2010 (French)

GATINEAU: December 14, 2009 (French)  /  March 1, 2010 (French)  /  May 21, 2010 (French)

Develop your Leadership Skills (CH106)

MONTREAL: September 21-22, 2009 (French)  /  November 30-December 1, 2009 (French)  /  February 15-16, 2010 (French)  /  April 26-27, 2010 (French)  /  July 5-6, 2010 (French)

QUEBEC CITY: November 10-11, 2009 (French)  /  March 15-16, 2010 (French)

GATINEAU: November 25-26, 2009 (French)  /  April 29-30, 2010 (French)

Read Fast and Absorb the Essence (CM110)

MONTREAL: June 17-18, 2009 (French)  /  October 26-27, 2009 (French)  /  February 1-2, 2010 (French)  /  April 12-13, 2010 (French)  /  July 7-8, 2010 (French)

QUEBEC CITY: October 5-6, 2009 (French)  /  March 22-23, 2010 (French)

Internet Search and File Management (CH168) NEW COURSE

MONTREAL: October 26, 2009 (French)  /  January 18, 2010 (French)  /  April 22, 2010 (French)  /  July 12, 2010 (French)

Effectively Working Remotely (CH169) NEW COURSE

MONTREAL: November 25, 2009 (French)  /  March 26, 2010 (French)  /  July 16, 2010 (French)

QUEBEC CITY: October 30, 2009 (French)  /  April 7, 2010 (French)

Problem-Solving Techniques (CH126)

MONTREAL: June 18, 2009 (French)  /  October 26, 2009 (French)  /  January 15, 2010 (French)  /  March 17, 2010 (French)  /  June 30, 2010 (French)

QUEBEC CITY: November 6, 2009 (French)  /  May 21, 2010 (French)

Improving Your Decision-Making Skills (CH125)

MONTREAL: October 27, 2009 (French)  /  February 19, 2010 (French)  /  May 13, 2010 (French)  /  July 9, 2010 (French)

QUEBEC CITY: April 8, 2010 (French)

Improving Your Skills in Business Relationships (CH158)

MONTREAL: October 16, 2009 (French)  /  February 5, 2010 (French)  /  May 11, 2010 (French)

QUEBEC CITY: April 15, 2010 (French)

Business Etiquette and Protocol (CH147)

MONTREAL: October 15, 2009 (French)  /  February 4, 2010 (French)  /  May 10, 2010 (French)

QUEBEC CITY: April 14, 2010 (French)

Taking Notes and Writing Minutes (CM104)

MONTREAL: June 29-30, 2009 (French)  /  October 21-22, 2009 (French)  /  January 5-6, 2010 (French)  /  March 18-19, 2010 (French)  /  June 9-10, 2010 (French)

QUEBEC CITY: November 2-3, 2009 (French)  /  February 23-24, 2010 (French)

The Effective Executive Assistant (CH116)

MONTREAL: September 14-16, 2009 (French)  /  November 18-20, 2009 (French)  /  February 15-17, 2010 (French)  /  May 19-21, 2010 (French)

QUEBEC CITY: November 4-6, 2009 (French)  /  June 28-30, 2010 (French)

GATINEAU: October 19-21, 2009 (French)  /  April 6-8, 2010 (French)

Better Time Management with MS Outlook (CH133)

MONTREAL: October 8, 2009 (French)  /  December 17, 2009 (French)  /  February 18, 2010 (French)  /  June 3, 2010 (French)

Efficiently Managing Information with MS Outlook (CH134)

MONTREAL: October 7, 2009 (French)  /  December 16, 2009 (French)  /  February 17, 2010 (French)  /  June 2, 2010 (French)

QUEBEC CITY: June 19, 2009 (French)  /  November 20, 2009 (French)  /  May 10, 2010 (French)

Transition to MS Office 2007: Updating Your Skills (CH156)

MONTREAL: September 16, 2009 (French)  /  December 14, 2009 (French)  /  April 1, 2010 (French)  /  June 17, 2010 (French)

The Fundamentals of MS Word 2003 / 2007 for Managers (CH127)

MONTREAL: October 6, 2009 (French) (Version 2003)  /  December 15, 2009 (French) (Version 2007)  /  February 16, 2010 (French) (Version 2007)  /  June 1, 2010 (French) (Version 2007)

The Fundamentals of MS Excel 2003 / 2007 for Managers (CH128)

MONTREAL: October 5, 2009 (French) (Version 2003)  /  December 11, 2009 (French) (Version 2007)  /  February 15, 2010 (French) (Version 2003)  /  April 19, 2010 (French) (Version 2007)  /  June 18, 2010 (French) (Version 2007)

MS Excel: Graphs and Dynamic Pivot Tables (CH166) NEW COURSE

MONTREAL: October 29, 2009 (French)  /  January 19, 2010 (French)  /  April 20, 2010 (French)  /  June 21, 2010 (French)

MS Excel Functions (CH167) NEW COURSE

MONTREAL: October 30, 2009 (French)  /  January 20, 2010 (French)  /  April 21, 2010 (French)  /  June 28, 2010 (French)

The Fundamentals of MS PowerPoint 2003 / 2007 for Managers (CH141)

MONTREAL: October 9, 2009 (French) (Version 2003)  /  December 18, 2009 (French) (Version 2007)  /  February 19, 2010 (French) (Version 2007)  /  June 4, 2010 (French) (Version 2007)

EFFICIENT TIME AND PRIORITY MANAGEMENT

Objective
To provide the knowledge and skills required to recognize the symptoms of problematic time management, implement appropriate solutions, identify time robbers and capitalize them.

Target audience
Any audience.

Prerequisites
None.

Topics covered

  • The Era of Speed, and its effects on behaviour
  • Magical thinking vs. reality
  • Energy: the key to superior performance
  • Tools for improved time management: communication, self-knowledge, analysis, micro-management, discipline and perseverance
  • The basic tool: the agenda
  • Log books and the end of Post-it notes
  • Establishment of priorities: short term, mid-term, long term, evaluation grid
  • The four quadrants of time management: urgent, not urgent, important, not important
  • Learning to delegate: resistances, development and win-win solutions
  • Symptoms of a management in crisis: evolving from a management of emergencies to planned management
  • Time robbers: elements that reduce efficiency, exploration grid to discover and eliminate them
  • A personal action plan for healthy time management

Note: this course is not intended for administrative or clerical personnel, whose needs are better addressed by Course 136.

Accredited course.
12 PDU

CH107 - 2 days

REGULAR FEE: $895

DISCOUNTED FEE: $750

MONTREAL: July 8-9, 2009 (French)  /  September 14-15, 2009 (French)  /  November 18-19, 2009 (French)  /  January 11-12, 2010 (French)  /  March 8-9, 2010 (French)  /  May 5-6, 2010 (French)  /  July 14-15, 2010 (French)

QUEBEC CITY: October 19-20, 2009 (French)  /  February 11-12, 2010 (French)  /  June 21-22, 2010 (French)

GATINEAU: November 23-24, 2009 (French)  /  May 27-28, 2010 (French)

ENHANCING PROFESSIONAL ETHICS

NEW COURSE

Objective
Becoming aware of and using one's core values, and knowing how to apply professional ethics in different situations, from the most basic to the most complex.

Target audience
Any audience.

Prerequisites
None.

Topics covered

  • The reason for ethics and the different contexts it applies to
  • Defining what may be perceived as a lack of ethics
  • Negative impact of a lack of ethics
  • Dilemmas and moral principles
  • Understanding and applying Kohlberg's model of moral judgment
  • Assessing one's own level of moral judgment in different situations
  • How paradigms, organizational, societal and personal values affect moral judgment
  • Resulting actions and decisions
  • Individual and group ethical behaviour

Accredited course.
6 PDU

CH176 - 1 day

REGULAR FEE: $475

DISCOUNTED FEE: $395

MONTREAL: December 18, 2009 (French)  /  March 24, 2010 (French)  /  May 28, 2010 (French)

QUEBEC CITY: December 4, 2009 (French)  /  March 17, 2010 (French)  /  May 19, 2010 (French)

GATINEAU: December 14, 2009 (French)  /  March 1, 2010 (French)  /  May 21, 2010 (French)

DEVELOP YOUR LEADERSHIP SKILLS

Objective
To provide the knowledge and skills required to analyze and develop the key skills needed to establish the values, the vision and the mission for an organization.

Target audience
Managers.

Prerequisites
None.

Topics covered

  • Traditional vs. evolutionary leadership : the human factors
  • Personality types: analytical, driver, amiable, expressive
  • Myself as a leader: my personality, my strengths, my weaknesses, my evolution and my self-motivation
  • Models for personal growth: at what stage am I in the process of attaining my objectives
  • Self-knowledge
  • Consistency: the key to integrity and transparency
  • Situational leadership: transition and crisis
  • Identifying the belief systems and values that influence decisions
  • Discover your vision, mission and passion
  • Personality types and assignment of tasks
  • The five main symptoms of a dysfunctional team
  • Feedback: positive re-enforcement vs. judgment, action-reaction

Accredited course.
12 PDU

CH106 - 2 days

REGULAR FEE: $895

DISCOUNTED FEE: $750

MONTREAL: September 21-22, 2009 (French)  /  November 30-December 1, 2009 (French)  /  February 15-16, 2010 (French)  /  April 26-27, 2010 (French)  /  July 5-6, 2010 (French)

QUEBEC CITY: November 10-11, 2009 (French)  /  March 15-16, 2010 (French)

GATINEAU: November 25-26, 2009 (French)  /  April 29-30, 2010 (French)

READ FAST AND ABSORB THE ESSENCE

Objective
To provide the knowledge and skills required to read faster and improve your understanding and retention of written information.

Target audience
Any audience.

Prerequisites
None.

Topics covered

  • Assess your reading speed, level of understanding and retention capability
  • The reading process and habits of the fast reader
  • Physiological and technical barriers: re-reading, mix-up of words, subvocalization and irregularity of rhythm
  • Psychological impediments to learning to read quickly: how to overcome them
  • Strategies based on your needs: searching for information, skimming for the essential, acquiring an overview and assimilating key information
  • Improve your perceptive capability and develop concentration
  • Simultaneously train your eyes and brain: ocular exercise and improvement of the field of view
  • Retention: reception, transfer, reactivation and mnemonic techniques
  • Specific concerns related to electronic media

Accredited course.
12 PDU

CM110 - 2 days

REGULAR FEE: $895

DISCOUNTED FEE: $750

MONTREAL: June 17-18, 2009 (French)  /  October 26-27, 2009 (French)  /  February 1-2, 2010 (French)  /  April 12-13, 2010 (French)  /  July 7-8, 2010 (French)

QUEBEC CITY: October 5-6, 2009 (French)  /  March 22-23, 2010 (French)

INTERNET SEARCH AND FILE MANAGEMENT

NEW COURSE

Objective
To provide the knowledge and skills required to improve your efficiency in searching for information on the Internet and managing the information that you find.

Target audience
Any audience.

Prerequisites
Basic knowledge of Windows.

Topics covered

  • Searching in the site directories: Yahoo, Toile du Québec
  • Searching with search engines: Google, Yahoo
  • Efficiently searching the Internet: syntax, tips and tricks
  • Using Internet Explorer functionalities
  • Managing favourites
  • Using hypertext links in various applications
  • Netiquette
  • Using the information you find: copy, paste and paste special
  • Viruses and security
  • Managing files, folders and shortcuts

CH168 - 1 day

REGULAR FEE: $350

DISCOUNTED FEE: $295

MONTREAL: October 26, 2009 (French)  /  January 18, 2010 (French)  /  April 22, 2010 (French)  /  July 12, 2010 (French)

EFFECTIVELY WORKING REMOTELY

NEW COURSE

Objective
To provide the knowledge and skills required to understand the features and capabilities of the latest software tools for collaboration and communication, and how they can help you to effectively work remotely.

Target audience
Anyone who frequently works remotely.

Prerequisites
None.

Topics covered

  • The evolution of collaborative tools in the enterprise
  • The various types of collaborative applications
  • Synchronous tools: instant messaging, chatrooms, telephony, audioconferencing, videoconferencing
  • Asynchronous tools: email, forums, portfolios, wikis, blogs and vlogs
  • Changing tracking tools in the Office suite

Accredited course.
6 PDU

CH169 - 1 day

REGULAR FEE: $475

DISCOUNTED FEE: $395

MONTREAL: November 25, 2009 (French)  /  March 26, 2010 (French)  /  July 16, 2010 (French)

QUEBEC CITY: October 30, 2009 (French)  /  April 7, 2010 (French)

PROBLEM-SOLVING TECHNIQUES

Objective
To provide the knowledge and skills required to implement a process for solving problems based on techniques for identifying the problem, gathering relevant facts and providing a sound analysis of the information prior to taking corrective action.

Target audience
Managers and anyone participating in problem-solving processes.

Prerequisites
None.

Topics covered

  • The rationale for the methodology: Introducing a framework for solving problems
  • The objectives of problem-solving: for whom and by whom
  • The statement of the problem: identify what exactly wrong
  • Diagnosis of the problem: What, where and when? What is its scope?
  • Identifying the potential causes: Using your knowledge and skills to identify the cause of the problem
  • Identifying the relevant factors: unique, specific or different components
  • Identify the change: potential impacts on the cause of the problem
  • Evaluating the potential causes

Accredited course.
6 PDU

CH126 - 1 day

REGULAR FEE: $475

DISCOUNTED FEE: $395

MONTREAL: June 18, 2009 (French)  /  October 26, 2009 (French)  /  January 15, 2010 (French)  /  March 17, 2010 (French)  /  June 30, 2010 (French)

QUEBEC CITY: November 6, 2009 (French)  /  May 21, 2010 (French)

IMPROVING YOUR DECISION-MAKING SKILLS

Objective
To provide the knowledge and skills required to make informed decisions by means of a systematic process based on setting objectives, analyzing alternatives, evaluating risks, and documenting each step.

Target audience
Managers and anyone participating in decision-making processes.

Prerequisites
None.

Topics covered

  • The rationale behind the methodology: introducing the decision-making framework
  • Goals of the decision-making process: why and by whom
  • Developing the objectives: results expected in the short and long term, resources to be used or maintained, and factors that influence the choices
  • Setting the objectives with respect to individuals, the organization, clients, products and services, and competitors
  • Classifying the objectives: mandatory or optional?
  • The weighting process: developing a decision matrix
  • Assessing the alternatives
  • Risk assessment: establish the potential adverse consequences
  • Making a decision: choosing an alternative that best fits the decision matrix with an acceptable level of risk

Accredited course.
6 PDU

CH125 - 1 day

REGULAR FEE: $475

DISCOUNTED FEE: $395

MONTREAL: October 27, 2009 (French)  /  February 19, 2010 (French)  /  May 13, 2010 (French)  /  July 9, 2010 (French)

QUEBEC CITY: April 8, 2010 (French)

IMPROVING YOUR SKILLS IN BUSINESS RELATIONSHIPS

Objective
To provide the knowledge and skills required to stand out in business by always leaving a good impression, by adjusting adroitly to the unexpected, by mastering the nuances of personal and business life, by projecting credibility and by using subtle techniques which distinguish yourself from the competition and allow you to handle professional relationships with aplomb.

Target audience
Any audience.

Prerequisites
None.

Topics covered

  • What are appropriate subjects for conversation in a business relationship?
  • Learn how to interrupt politely
  • How to broach, avoid and revisit subjects
  • Preparing for all eventualities, and handling difficult situations with tact and control
  • The notion of distance between the client and oneself: building a familiar and confident relationship with clients
  • Adapting one's language to that of the client: understanding cultural and generational differences
  • The use of voice to inspire confidence: detecting attitudes by means of vocal cues
  • Understanding the messages transmitted by one's intonation

Accredited course.
6 PDU

CH158 - 1 day

REGULAR FEE: $475

DISCOUNTED FEE: $395

MONTREAL: October 16, 2009 (French)  /  February 5, 2010 (French)  /  May 11, 2010 (French)

QUEBEC CITY: April 15, 2010 (French)

BUSINESS ETIQUETTE AND PROTOCOL

Objective
To provide the knowledge required to exhibit impeccable behaviour in one's professional relationships, to respect business protocols and etiquette, and to avoid blunders in delicate situations.

Target audience
Any audience.

Prerequisites
None.

Topics covered

  • The importance of the first meeting: introduction, handshake, personal space and language
  • Adopting a dress code suitable for the business occasion; norms of personal hygiene
  • Maintaining a polite demeanour: gestures, language and voice
  • Etiquette at the office, how to fit in with the hierarchy
  • Handling a business meal at a restaurant or in the office, good table manners
  • Behaviour at social functions: handling drinks, exchanging business cards
  • Formal occasions with well-defined protocols: greeting VIPs, respect for titles, precedence rules, cross-cultural skills
  • Tact and self-control: what to say and what not to say, how to make an apology and how to accept one

Accredited course.
6 PDU

CH147 - 1 day

REGULAR FEE: $475

DISCOUNTED FEE: $395

MONTREAL: October 15, 2009 (French)  /  February 4, 2010 (French)  /  May 10, 2010 (French)

QUEBEC CITY: April 14, 2010 (French)

TAKING NOTES AND WRITING MINUTES

Objective
To provide the knowledge and skills required to take notes in a synthetic way, to structure the ideas developed and to write the minutes of a meeting.

Target audience
Clerical workers, secretaries, administrative assistants or associates and any other individuals who provide administrative support.

Prerequisites
None.

Topics covered

  • Different types of minutes and their uniqueness as compared to other written documents
  • Objectively recording facts, discussions and decisions
  • Stress caused by note taking: tips and tools for handling it
  • Key steps in taking notes and editing minutes
  • The working relationship between the chair and the secretary of a meeting: strategies and methodologies
  • Reconciliation of the moral support, the participation to the discussion and note taking
  • Various techniques used to take notes: making a choice based on the objective and issues of interpretation
  • Essential techniques for taking notes without using shorthand
  • Organizing and structuring notes: choosing key words, consolidating scattered information, identifying the essential information et using titles and sub-titles
  • Strategies to use when meetings become very technical
  • Writing minutes: adapt the format and style to the target audience, respect the legibility rules, use visual benchmarks, arrange links between paragraphs and present elements that require an action as opposed to informative elements

CM104 - 2 days

REGULAR FEE: $795

DISCOUNTED FEE: $650

MONTREAL: June 29-30, 2009 (French)  /  October 21-22, 2009 (French)  /  January 5-6, 2010 (French)  /  March 18-19, 2010 (French)  /  June 9-10, 2010 (French)

QUEBEC CITY: November 2-3, 2009 (French)  /  February 23-24, 2010 (French)

THE EFFECTIVE EXECUTIVE ASSISTANT

Objective
To provide the knowledge and skills required to define the role and functions of the administrative support staff from the point of view of collaboration and skills development, and to promote healthy and efficient working conditions.

Target audience
Clerical workers, secretaries, administrative assistants or associates and any other individuals who provide administrative support.

Prerequisites
None.

Topics covered

  • The characteristics of a good executive assistant
  • The new clerical work and the evolution of technology
  • The administrative support staff: its role and responsibilities
  • The evolution of the role of the administrative support staff versus the increasing autonomy of managers equipped with technological tools
  • Determine and manage the expectations of your immediate superior
  • Getting a proactive and strategic vision of your role as a participant
  • Develop and maintain an efficient and harmonious relationship with your superior
  • Adapt your efforts to the distinctive personality of your superior
  • Evolving challenges for administrative support staff
  • The importance of team work and interpersonal relationships
  • Tools, tips and strategies for working effectively with different personalities
  • Develop your communications skills
  • How to better handle change
  • Supporting managers in planning and managing change
  • Managing time and priorities
  • Stress management

CH116 - 3 days

REGULAR FEE: $995

DISCOUNTED FEE: $850

MONTREAL: September 14-16, 2009 (French)  /  November 18-20, 2009 (French)  /  February 15-17, 2010 (French)  /  May 19-21, 2010 (French)

QUEBEC CITY: November 4-6, 2009 (French)  /  June 28-30, 2010 (French)

GATINEAU: October 19-21, 2009 (French)  /  April 6-8, 2010 (French)

BETTER TIME MANAGEMENT WITH MS OUTLOOK

Objective
To provide the knowledge and skills required to optimize time management and improve productivity using the task management, calendar, contact list and journal features of MS Outlook.

Target audience
Managers.

Prerequisites
Basic knowledge of Outlook.

Topics covered

  • Overview of the main productivity tools in Outlook
  • Interactions between the different features of Outlook
  • Managing tasks: creation, use, advancement, delegation, follow-up
  • Planning and managing meetings: organization, meeting requests, handling replies, private and group meetings
  • Using the calendar: display formats, sharing, printing
  • Managing contacts: the address book, classifying, sorting, grouping, distribution lists
  • Using the journal: creating entries, and associating them with contacts
  • Using notes
  • Creating customized displays
  • Automatic archiving of entries
  • Efficiently searching in folders

Note: The course is given using Outlook 2003, but most features described are available in Outlook 2000, 2002 and 2007 as well. A version of the course which uses Outlook 2007 is available on demand for privately arranged group sessions.

CH133 - 1 day

REGULAR FEE: $350

DISCOUNTED FEE: $295

MONTREAL: October 8, 2009 (French)  /  December 17, 2009 (French)  /  February 18, 2010 (French)  /  June 3, 2010 (French)

EFFICIENTLY MANAGING INFORMATION WITH MS OUTLOOK

Objective
To provide the knowledge and skills required to effectively manage e-mail with MS Outlook.

Target audience
Managers.

Prerequisites
Basic knowledge of Outlook.

Topics covered

  • Managing folders: creation, organization, sharing
  • Creating rules for automatically categorizing, answering deleting or filing messages
  • Handling spam
  • Techniques for automatically archiving messages
  • Efficiently searching messages and folders
  • Toolbars: customizing, creating and adding tools that make managing messages easy
  • Search tools and follow-up indicators
  • Using shortcuts to access frequently used folders, documents and Web addresses
  • Setting up effective working screens
  • Creating and using categories
  • Grouping facilities
  • Creating out-of-office messages and setting up automated replies

Note: The course is given using Outlook 2003, but most features described are available in Outlook 2000, 2002 and 2007 as well. A version of the course which uses Outlook 2007 is available on demand for privately arranged group sessions.

CH134 - 1 day

REGULAR FEE: $350

DISCOUNTED FEE: $295

MONTREAL: October 7, 2009 (French)  /  December 16, 2009 (French)  /  February 17, 2010 (French)  /  June 2, 2010 (French)

QUEBEC CITY: June 19, 2009 (French)  /  November 20, 2009 (French)  /  May 10, 2010 (French)

TRANSITION TO MS OFFICE 2007: UPDATING YOUR SKILLS

Objective
To provide the knowledge and skills necessary to rapidly master the new user interface and the new features of Word, Excel, PowerPoint and Outlook 2007.

Target audience
Managers.

Prerequisites
Knowledge of MS Office tools.

Topics covered

  • Office 2007: the new interface, the Office button, the ribbon, tabs, the quick access toolbar, zoom, the state bar, galleries, contextual menus and instant overview
  • Word 2007: the new interface, efficient formatting, themes, building blocks and inserting graphics
  • Excel 2007: the new interface, new worksheet calculation features, simplified table formatting, themes, conditional formatting, charts, dynamic pivot tables and layout
  • PowerPoint 2007: the new interface, themes, new drawing tools, customized layout, efficient formatting and animation
  • Outlook 2007: the new interface, management by categories and colour, RSS streams, new priorities, attachments and spam
  • The Windows Vista Explorer: new interface, indexed searches

CH156 - 1 day

REGULAR FEE: $350

DISCOUNTED FEE: $295

MONTREAL: September 16, 2009 (French)  /  December 14, 2009 (French)  /  April 1, 2010 (French)  /  June 17, 2010 (French)

THE FUNDAMENTALS OF MS WORD 2003 / 2007 FOR MANAGERS

Objective
To provide the knowledge and skills required to use the fundamental features of MS Word to rapidly create and edit all types of documents.

Target audience
Managers.

Prerequisites
Basic knowledge of Word.

Topics covered

  • Indispensable keyboard shortcuts
  • Designing and structuring the document onscreen
  • Efficiently using Find and Replace
  • Creating and modifying tables and using tabs
  • Using styles and creating simple forms
  • Automatic numbering and tables of contents
  • Inserting data, images and graphics from other tools
  • Creating and using templates
  • Collaborative sharing of documents: tracking changes and inserting comments
  • Protecting a Word document
  • Comparing documents

Note: The course is presented using Word 2003, but the features described are available in Word 2000 and Word 2002 as well. The course given with Word 2007 covers the new features available in Word 2007..

CH127 - 1 day

REGULAR FEE: $350

DISCOUNTED FEE: $295

MONTREAL: October 6, 2009 (French) (Version 2003)  /  December 15, 2009 (French) (Version 2007)  /  February 16, 2010 (French) (Version 2007)  /  June 1, 2010 (French) (Version 2007)

THE FUNDAMENTALS OF MS EXCEL 2003 / 2007 FOR MANAGERS

Objective
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.

Topics covered

  • 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: The course is given using Excel 2003, but the features described are available in Excel 2000 and Excel 2002 as well. The course given with Excel 2007 covers the new features of Excel 2007..

CH128 - 1 day

REGULAR FEE: $350

DISCOUNTED FEE: $295

MONTREAL: October 5, 2009 (French) (Version 2003)  /  December 11, 2009 (French) (Version 2007)  /  February 15, 2010 (French) (Version 2003)  /  April 19, 2010 (French) (Version 2007)  /  June 18, 2010 (French) (Version 2007)

MS EXCEL: GRAPHS AND DYNAMIC PIVOT TABLES

NEW COURSE

Objective
To provide the knowledge and skills required to use graphics and dynamic pivot tables with Microsoft Excel.

Target audience
Any audience.

Prerequisites
Basic knowledge of Excel.

Topics covered

  • Creating a dynamic pivot table
  • Modifying and organizing table fields
  • Creating new calculated fields
  • Modifying source data, and updating
  • Grouping functions for text and dates
  • Extracting the source data from a result
  • Formatting a dynamic pivot table
  • Creating a dynamic graph
  • Modifying and positioning a graph
  • Using different types of graphs
  • Using a secondary axis
  • Adding trend curves

Note: The courses given with Excel 2003 present features that are also available in Excel 2000 and Excel 2002. The version of the course with Excel 2007 presents the new features of Excel.

CH166 - 1 day

REGULAR FEE: $350

DISCOUNTED FEE: $295

MONTREAL: October 29, 2009 (French)  /  January 19, 2010 (French)  /  April 20, 2010 (French)  /  June 21, 2010 (French)

MS EXCEL FUNCTIONS

NEW COURSE

Objective
To provide the knowledge and skills required to make effective use of the many functions available with Microsoft Excel.

Target audience
Any audience.

Prerequisites
Basic knowledge of Excel.

Topics covered

  • Search functions: VLOOKUP, HLOOKUP, INDEX, MATCH
  • Database functions: DSUM, DAVERAGE, DCOUNT, DMAX, DMIN
  • Information functions: CELL, TYPE, ISERR, ISERROR, N
  • Logical functions: IF, AND, OR and the nesting of functions
  • Financial functions: PMT, FV, NPER, RATE
  • Date/time functions: TODAY, NOW, DATE, YEAR, MONTH, DAY, NETWORKDAYS
  • Statistical functions: COUNT, COUNTIF, COUNTIFS, COUNTBLANK, FREQUENCY
  • Text functions: RIGHT, LEFT, LEN, MID, SEARCH, FIND, CLEAN, VALUE, TEXT, CONCATENATE
  • Using matrix functions

Note: The course given with Excel 2003 covers features that are also available with Excel 2007, 2002 and 2000.

CH167 - 1 day

REGULAR FEE: $350

DISCOUNTED FEE: $295

MONTREAL: October 30, 2009 (French)  /  January 20, 2010 (French)  /  April 21, 2010 (French)  /  June 28, 2010 (French)

THE FUNDAMENTALS OF MS POWERPOINT 2003 / 2007 FOR MANAGERS

Objective
To provide the knowledge and skills required to make use of the fundamental features of PowerPoint to rapidly create and edit presentations.

Target audience
Managers.

Prerequisites
Basic knowledge of PowerPoint.

Topics covered

  • Fundamental techniques: editing efficiently, using models, modifying layouts
  • Creating a new presentation
  • Rapidly inserting content via a mode plan
  • Including external elements: images, photos, graphics and tables
  • Creating and editing graphics, tables and org charts
  • Using objects to enrich a presentation
  • Modifying the color scheme and the layout
  • Defining text and graphic areas
  • Using attractive animation effects
  • Essential shortcut keys in presentation mode
  • Printing handouts for the participants and slide notes for the presenter

Note: The course is given using PowerPoint 2003, but the features described are available in PowerPoint 2000 and PowerPoint 2002 as well. The course given with PowerPoint 2007 covers the new features in PowerPoint 2007..

Accredited course.
6 PDU

CH141 - 1 day

REGULAR FEE: $350

DISCOUNTED FEE: $295

MONTREAL: October 9, 2009 (French) (Version 2003)  /  December 18, 2009 (French) (Version 2007)  /  February 19, 2010 (French) (Version 2007)  /  June 4, 2010 (French) (Version 2007)

Know more. Worth more.
© Copyright 2009 - Groupe informatique Technologia inc. - Phone : +1 514.380.0380 - Toll free : + 1 877.380.8228