Calendrier

Mai 2012 Juin 2012
Lu Ma Me Je Ve Sa Di
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31

Search

Search

Liste des cours

Request a course date

Excel 2 2003
Download PDF

Prochaines Dates:
Jeu, 06. Déc. 2012
Mer, 24. Oct. 2012
Jeu, 06. Sep. 2012
Mar, 22. Mai. 2012
Mer, 18. Juil. 2012

Choisissez une date:


Mode:

Durée:
1 day

Emplacement:
Ottawa

Langue du cours:
EE

Nombre maximal de participants:
10 students

Prix:
$ 185

Clientèle cible et pré-requis:
This Course is designed for participants who know the basics of Excel. Knowledge of Excel Introduction and Windows experience.

Objectifs du cours:
Upon completion of the course, you will be familiar with the following: Advanced formulas, using range names in formulas, managing worksheets within workbooks, using advance formatting techniques, creating and printing charts as well as sorting data in alphanumeric order.

Aperçu du cours:

ABSOLUTE/ RELATIVE RANGE
  • Creating and using an Absolute Range
USING RANGE NAMES
  • Creating a Range Name
  • Jumping to a Named Range
  • Using Range Names in Formulas
ADVANCED FORMULAS
  • Using some of the Logical Formulas
  • Using some of the Financial Functions
  • Date Formulas
  • Linking Formulas
MANAGING WORKSHEETS
  • Copying / Moving Worksheets
  • Moving Data between Worksheets
  • Copying Data between Worksheets
  • Renaming Worksheet Tabs
  • Consolidation Worksheets
ADVANCED FORMATTING
  • Using Styles
  • Templates
  • Conditional Formatting
  • Autoformat
Chart
  • ChartConcepts
  • Creating Charts
  • Editing Charts
  • Printing Charts
DATA SORT
  • Sorting Lists
  • Sorting in Ascending/Descending Order
  • Sorting using multiple fields
DATABASE
  • Enabling AutoFilter
  • Using AutoFilter to Filter a Custom List

    N'oubliez pas que nous bâtissons les horaires en fonction de vos demandes. Visitez la liste de cours, et appellez-nous au (613) 235-6161 ou envoyez-nous un courriel à training@compuease.ca: