Nouveau
  • Icon 14.11.2019
  • Icon 14 h
  • icon Cours du jour
  • Icon English
  • Icon IF032CJ
àpd. 450,00 EUR (+3% TVA)

Objectives


After the training the participant shall be able to:

  • optimize calculation operations

  • automate worksheets by using Formulas and Functions

  • analyze data by using Pivot tables

  • create customized charts

  • work with templates

  • record macros

Programme


  • Review tips & tricks to optimize calculation operations

    • Managing the principle of calculated cell addresses (Absolute, relative and mixed references)

    • Inserting functions by using the Assistant or by inserting manually (inserting text in a function, using criteria and equations, using range names, …)

    • Nesting functions

  • Manipulating categories of functions

    • Working with "Statistical functions" (Average, Max, Median, ...)

    • "Logical" functions

      • Using conditional formatting with values and formulas

      • Using logical functions (Countif, Sumif, If, And, Or, …)

    • Using "Text" functions (Left, Find, Upper, Concatenate, …)

    • Using Date and Time functions (Now, Today, Year, Month, Day, …)

  • Automating worksheets by using Formulas and Functions

    • Validating data in lists

    • Using and optimizing the "Vlookup" function

  • Introduction to databases

    • Using the vocabulary which is specific for databases

    • Learning to create a database file which enables an efficient analysis of the information

    • Managing personalized toolbars to analyse data

    • Tips to guarantee data integrity

    • Using range names

  • Simple analysis tools

    • Being able to sort: simple sort, sort criteria and first key sort order

    • Using the autofilters

    • Using Group and Outline to improve the visibility of data

  • Analyzing data by using Pivot tables

    • Knowing the features which are needed for the creation of pivot tables

      • Hiding elements

      • Using the integrated calculations (average, count, max, min…)

      •  Displaying subtotals

      • Updating data

    • Grouping items (manually, automatically)

    • Consolidating data from multiple tables

  • Creating customized charts

  • Working with templates

  • Recording macros

  • Tips and tricks

  • Exercises

Target audience


This course is addressed to good basic users, who wish to learn Excel furthermore in fields such as accountability, finances or science.

Course material


The training material will be handed out at the beginning of the course.

Certificate


By the end of the training, the trainee will receive a certificate of participation issued by the House of Training.

Lieu

Télécharger le planning PDF

jeu. 14.11.2019 à 08h30

icon 3H30

Excel 2013/2016 - Advanced

  • icon Chambre de Commerce Luxembourg

jeu. 14.11.2019 à 13h30

icon 3H30

Excel 2013/2016 - Advanced

  • icon Chambre de Commerce Luxembourg

ven. 15.11.2019 à 08h30

icon 3H30

Excel 2013/2016 - Advanced

  • icon Chambre de Commerce Luxembourg

ven. 15.11.2019 à 13h30

icon 3H30

Excel 2013/2016 - Advanced

  • icon Chambre de Commerce Luxembourg

Vous souhaitez rester à jour sur notre offre de formation ?

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