Au calendrier
Sélectionnez
En français
Sélectionnez un lieu
  • Durée: 0.5 jour
  • Prix régulier: CA$215.00
  • Prix préférentiel: CA$190.00

Excel Essentials

Schedule: 8:30 to 12:00 AM

You are familiar with Microsoft Excel but you know you could use it better? You want to learn how to effectively juggle the numbers without spending days in training? You don’t have time to waste but you want to be able to gain some?
Our « Excel Essentials » will help you find out the basic, intermediate and advanced features of this program while boosting your professional efficiency.
You will quickly learn how to take full advantage of Excel’s most useful and profitable options, so that you can use it wisely in your daily work. Upon the completion of this course, Excel will no longer hold any secrets for you, therefore allowing you to gain considerable time and avoid unnecessary frustrations.
LanguagesThese scheduled public sessions are offered in English or in French (FR). The educational material is in English.

Audience

This course is intended for new Microsoft Excel users and participants who wants to review its fundamentals.

Versions taught

2007 | 2010 | 2013 | 2016

Objectives

  • Introducing the many features that can boost productivity
  • Presenting essential tips and tricks to gain time with Microsoft Excel
  • Sharing effective and efficient work methods that meet the participants’ specific needs.

Contents

Key steps to prepare an effective and flawless document
The basic concepts of an effective worksheet
  • Formatting and data analysis
  • Basic commands
  • Identifying the pointers
  • Context menus
  • The Quick Access Toolbar
  • Moving throug a worksheet and a workbook
  • Selecting cells
  • Quick selection
  • Moving through a selected range of cells
  • Copying, moving or applying a color to a worksheet
Creating an Excel table and data entry
  • Insert or delete rows and columns
  • Wraping text in a cell
  • Formatting property for computable numbers
  • Using Auto Fill to copy data series
  • Paste special
  • Clipboard and copy/paste
  • Automatic completion of cell entries
  • Drop-down list
  • Creating a list of choice by data validation
  • Finding and replacing
Calculating and formulas
  • Basic formula syntax
  • Entering a formula
  • AutoSum
  • Managing dates and functions
  • Most popular date and time functions
  • Calculating seniority or birth date
  • Calculating difference between two dates
  • Determining the date of a future event
  • The IF function
  • Using nested functions
  • Using relative and absolute references in a formula
  • Using a name in a formula
Transforming data in a table
  • Ground rules for the creation of an effective data table
  • Creating a new table
Analyzing and using data
  • Sorting lists
  • Filtrering lists
  • Hiding columns in a worksheet
PivotChart and PivotTable
  • Creating a PivotTable
  • Analyzing data using PivotTable
  • Identifying data to analyze
  • Filtering results with slicers
  • Creating a slicer
Formatting
  • Customizing the cells’ appearance
  • Changing font and color
  • Changing number format
  • Modifying text alignment
  • Clearing cells formats
Saving and printing
  • Adding protection
  • Saving as a template
  • Layout and printing
  • Converting your file into a pdf

Savoir s’entourer des meilleurs

Sylvain Richer
Sylvain Richer
Formateur et conseiller en bureautique
Vulgarisateur hors pair et passionné par le transfert des connaissances, Sylvain est un formateur en efficacité professionnelle demandé et redemandé.
Sylvain Richer
Sylvain Richer
Formateur et conseiller en bureautique
Vulgarisateur hors pair et passionné par le transfert des connaissances, Sylvain est un formateur en efficacité professionnelle demandé et redemandé.
Pierre-Edouard Brondel
Pierre-Edouard Brondel
Formateur et conseiller en bureautique
Expert en pédagogie dans le domaine des technologies et de la bureautique cumulant plus de 25 ans d’expérience, Pierre-Édouard est d’abord et avant tout un passionné de capital humain.
Valère Drainville
Valère Drainville
Formateur et conseiller en efficacité professionnelle
Expert en collaboration et en efficacité professionnelle, Valère Drainville saura vous accompagner dans l’adoption et la gestion de vos outils de travail collaboratifs.