21 hours

EXCEL LEVEL II

ADVANTAGES

AMELIORATION DES COMPETENCES

At the end of your training, a certificate - acquired and monitoring levels - you are issued - recognized by employers and will be new assets to your CV

LEARN ABOUT YOUR CAREER

Essential for the simulation exercises.

STUDENT CARD

You can apply to our training center. Guests enjoy benefits including acquisition of Adobe products, Mac …

TRAINING INFO

PUBLIC

Every person, administrative, commercial, technician, private person

PREREQUISITES

This course is for people with a good knowledge of computers.

TRAINER - TRAINING MANAGER

Jean PONS – speaker

EDUCATIONAL RESOURCES - METHOD

1 PC or Mac computer by trainee (photocopies, notebook, pen, wallet, graphics tablet, wall screen, mural, color laser printer) - Practical exercises situation

EVALUATION OF LEARNING

course Entry : skills assessment by QCM (multiple choice question)
Course End : Sheet émargement
Validating acquired by QCM (multiple choice question)

CALENDAR OF SESSIONS

see specifications

NUMBER OF PARTICIPANTS

Group of 6 persons.
2 possible simultaneous sessions
Details : View quote

DURATION

see specifications

HOURS (SESSIONS ACCORDING)

from 9:00 to 12:00 and 14:00 to 19:00

PLACE OF TRAINING

ACTIVMEDIA – 5 Rue Massena - 06000 NICE

PROGRAMME

graphic objects

  • The Drawing toolbar
  • The various objects
  • Trait / ellipse / rectangle
  • Autoshape
  • Text zone
  • Selection / moving objects - Formatting Objects
  • Superposition
  • Group Objects
  • Linking objects to cells
  • Print objects

Data Validation

  • View an input message
  • Entry restrictions
  • Set restrictions
  • Fill a small cell
  • Display a warning after entering

The lists

  • Creation
  • Adding Forms
  • Displacement in the grid
  • Modification / deletion of records - Calculated fields
  • filters
  • The elaborate filters
  • The database functions
  • Subtotals

Customize Toolbars

  • Delete button
  • Add a new button - Add a macro button
  • Edit Button Image

Pivot table

  • -Choose database concept of -Presentation graphic elements table -presentation