Excel 2013/2016 - Advanced
Cette formation est proposée sous forme de formation présentielle et à distance. En savoir plus
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
-
Chambre de Commerce Luxembourg7, rue Alcide de Gasperi
L-1615 Luxembourg
Luxembourg - Calculer l'itinéraire
lun. 14.06.2021 à 08h30
Excel 2013/2016 - Advanced
-
Chambre de Commerce Luxembourg
lun. 14.06.2021 à 13h30
Excel 2013/2016 - Advanced
-
Chambre de Commerce Luxembourg
mar. 15.06.2021 à 08h30
Excel 2013/2016 - Advanced
-
Chambre de Commerce Luxembourg
mar. 15.06.2021 à 13h30
Excel 2013/2016 - Advanced
-
Chambre de Commerce Luxembourg