Nouveau
  • Icon 09.12.2021
  • Icon 12 h
  • icon Formation présentielle
  • icon Formation à distance
  • icon Cours du jour
  • Icon English
  • Icon IF003CJ
440,00 EUR

*

(+3% TVA)

   Cette formation est proposée sous forme de formation présentielle et à distance. En savoir plus

In collaboration with


Key Job

Objectives


After the training the participant shall be able to:

  • create tables and manage them; to format and manipulate data; to create and print charts from Excel data.

Programme


Excel environment

  •     The Excel environment: Quick Access toolbar, ribbon and tabs

  •     Customize Quick Access toolbar and the ribbon

  •     Live Preview and Paste Preview

Manage spreadsheets

  •     Add, rename, delete a worksheet

  •     Move and copy a sheet

  •     Define a tab color

  •     Change the height or width of the formula bar

Manage Tables

  •     Enter and validate data

  •     Manage rows and columns: add, resize, delete, hide / show

  •     Find / Replace data

  •     Copy / paste data

Document Management

  •     Create / open / save a document

  •     Headers and footers

  •     The « Page Layout » view

Calculate

  •     Enter and copy formulas

  •     Smart tags

Functions

  •     Insert Function using the wizard

  •     Insert function manually, semi-automatic formula input

Format table

  •     Format cells

  •     Using styles

  •     Predefined conditional formats

Present data with a graph(Chart)

  •     Create a chart

  •     Change / format a Chart

  •     Use the chart styles

  •     Create and use a chart template

  •     Sparklines

Analyze the data tables

  •     Create a data table (Insert Table)

  •     Sort and filter data tables

  •     List filters with search box

  •     Sort and filter by font or fill color

  •     The Flash Fill

Target audience


Anyone who wishes to learn how to create and manage electronic tables.

Certificate


At the end of the training, the participant will receive a certificate of attendance delivered by the House of Training.

Lieu

Télécharger le planning PDF

jeu. 09.12.2021 à 09h00

icon 7H

Excel 2013, 2016, Office 365 - Fundamentals

  • icon Key Job S.A.

ven. 10.12.2021 à 09h00

icon 7H

Excel 2013, 2016, Office 365 - Fundamentals

  • icon Key Job S.A.

Vous souhaitez rester à jour sur notre offre de formation ?

Vous avez une question ?
Nous avons des réponses !