Navigate through Excel like a pro
Excel software is a powerful management tool but it is often not used to its full potential! The training we offer is much more than a simple Excel course. We have designed it for a wide range of users, from those who need to create spreadsheets and workbooks to those who need to master the use of existing documents. Whether you create your own workbooks or work with existing ones, you will discover tools to develop your own methodology. Hence you will improve work habits by saving time and optimizing the use of Excel to suit your specific needs!


OBJECTIVES
> To have a mastery of Excel at your fingertips
> To review Excel commands and learn how to use them most efficiently
> To discover unfamiliar commands and use them skilfully
> To learn tips and tools from the pros

WHO IS THIS TRAINING COURSE FOR
Everyone who needs to master Excel in order to efficiently collect, manipulate, analyze and present data; supervisors, managers, directors, junior or middle management, administrative assistant, etc.


Recognized by the Faculty of Continuing
Education at the University of Montreal
The educational quality of this syllabus has been approved by the Chair of Continuing Education of the Faculty of Continuing Education at the University of Montreal 0.7 UFC

OBJECTIVES
  • Developing a personalized and efficient data management methodology
  • Creating and using templates
  • Discovering unknown functions and learning to use them with confidence
  • Reviewing the Excel commands to develop individual methodologies
  • Producing visually communicative documents
  • Personalizing the user interface
  • Creating shortcuts for quick access to preferred filing locations
  • Modifying workbook options
  • Improving visual presentation and ergonomics of worksheets
  • Speeding up data entry
  • Manipulating data efficiently
  • Demystifying Excel Pivot Tables
  • Creating personalized number formats
  • Efficiently searching and replacing data entries
  • Obtaining printed documents that correspond to your needs
  • Learning tips and tools from the pros

QUALITEMPS APPROACH
Our Excel guide is a unique reference guide. It contains a large number of applications and formulas.
It serves as a practical reference guide which users of all levels appreciate having at their side.


DETAILED TRAINING COURSE CONTENTS
  • Personalization of the user interface
  • Personalizing and moving the toolbar
  • Quick access toolbar
  • Displaying the spreadsheet tab in the ribbon
  • Reducing and restoring the ribbon
  • Customizing the quick access toolbar
  • Opening, creating and using personalized lists
  • Modifying File creating options
  • Improving the appearance of a worksheet
  • How to work efficiently in Excel
  • Key commands to know
  • Options for hiding or displaying as required
  • How to Split sheets and freeze panes
  • Reproducing a cell format or a cell
  • Reproducing the format of a worksheet
  • Using and saving worksheet templates
  • Saving specific parameters of a worksheet template
  • Getting familiar with quick data entry
  • Navigating efficiently through a workbook
  • Shortcuts
  • Effective use of Cut and Paste with various options
  • Using the Fill command
  • Copying a Microsoft Word table into an Excel worksheet
  • Copying Excel worksheet data into Microsoft Word
  • Copying a contact list from Microsoft Outlook into an Excel worksheet
  • Recording Macros
  • Modifying the Quick Access icon
  • Efficiently manipulating data
  • Search and Replace tool
  • How to select cells according to given criteria
  • Conditional formatting
  • Managing rules in Excel
  • Deleting or modifying an existing rule
  • Managing rule execution order
  • Copying a conditional formatting rule
  • Excel operators and order of operations
  • Relative, absolute and mixed references
  • Accessing the information data relative to a workbook or its cells
  • Manipulating data and formulas
  • Copying formulas
  • Converting formulas into values
  • Displaying formulas in cells instead of the corresponding calculated values
  • Formatting numbers
  • Creating personalised number formats
  • Using charts to manage, analyse and present data
  • Creating a chart
  • Sorting and filtering chart data
  • Formatting options parameters
  • Applying a style to a range of cells
  • Using Pivot tables to combine data
  • Working with Pivot tables
  • Creating a Pivot table
  • Using personalized printing Macros
  • Selecting the information to be printed
  • Modifying the appearance of printed documents
  • Optimizing files
  • Boosting teamwork

PEDAGOGICAL APPROACH
  • Guided practical exercises performed on individual computer stations
  • Theoretical lecture
  • Interactive discussion

TRAINING COURSE MATERIAL
  • Excel step by step illustrated User Guide
  • Individual computer stations are made available for participants for the course
  • Our Mobile classroom: 15 computers are available for classroom courses, each computer is programmed so that every functionality can be displayed full screen. This way, participants work in a setting similar to their own work environment. Our mobile classroom gives us the possibility to offer training sessions in the enterprise, onsite.


      Training

      Date

      City

      Location

      Excel à votre service
      26 february 2020
      Français
      Montréal
      Directions
      Excel à votre service
      27 february 2020
      Français
      Online
       
      Excel à votre service
      12 march 2020
      Français
      Longueuil
      Directions
      Excel à votre service
      18 march 2020
      Français
      Québec
      Directions
      Excel à votre service
      20 march 2020
      Français
      Sherbrooke
      Directions
      Excel à votre service
      24 march 2020
      Français
      Laval
      Directions
      Navigate through Excel like a pro
      25 march 2020
      Montréal
      Directions
      Navigate through Excel like a pro
      16 april 2020
      Montréal
      Directions
      Excel à votre service
      7 may 2020
      Français
      Online
       
      Excel à votre service
      8 may 2020
      Français
      Québec
      Directions
      Excel à votre service
      20 may 2020
      Français
      Montréal
      Directions
      Excel à votre service
      2 june 2020
      Français
      Laval
      Directions
      Excel à votre service
      4 june 2020
      Français
      Longueuil
      Directions
      Excel à votre service
      14 july 2020
      Français
      Montréal
      Directions
      TRAINERS


      Mélanie Drainville

      Marlène Villeneuve

      Jean-Luc Dion

      Jean-Philippe Claude




      Newsletter
      Stay tuned for new services and training