Description
Introduction
This training focuses on the use of Microsoft Excel. It allows users to consolidate their knowledge and improve their use of the tool. Participants become more comfortable working with spreadsheets. It supports a more efficient use of Excel.
Objectives
At the end of this training, the participant will be able to :
Create and manage tables
Format and manipulate data
Know how to create and print charts from Excel data
Programme
Format table
Formating cells and using styles (Refresh)
Calculate
Entering and copying formulas
Relatives / absolute references
Functions
Inserting a function manually, formula autocomplete
Inserting a function using the wizard
Main functions (reminder)
Statistical functions (Countif, Sumif, Countifs, Sumifs, etc.)
Text function
Date functions
Conditional formatting
Applying predefined conditional formatting
Customizing conditional formatting
Using range names
Creating and using a range name
Modifying and deleting a range name, defining its scope (file, worksheet)
Data tables
Creating a data table (Format as Table)
Creating formulas using references to a data table
Presenting data as a chart
Creating a chart
Modifying / formatting a chart
Using chart styles
Creating and using a chart template
Sparklines
Analyzing data
Sorting
Filtering
Remove duplicates
Sheet View
Introduction to Pivot Tables
Verify data
Use auditing tools
Evaluate a formula
Conditions
Support de cours
-
Des supports de cours seront disponibles après les modules respectifs
-
Die Kursunterlagen werden nach den jeweiligen Modulen zur Verfügung gestellt
-
Course materials will be made available after the respective modules
Certificate
At the end of the training, participants will receive a certificate of attendance issued by the House of Training.
Location
L-1611 Luxembourg
Luxembourg
Sessions et horaires
Vous souhaitez rester à jour sur notre offre de formation ?
Inscrivez-vous à la newsletter