In collaboration with:
Description
Objectives
After the training the participant shall be able to:
- create and manage tables
- format and manipulate data
- create and print charts from Excel data
Programme
Excel environment
The Excel environment: Quick Access toolbar, ribbon and tabs
Customise 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 colour
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
Analyse 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 tables in Excel 365.
Prerequisites
Knowledge of the Windows work environment
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, the participants will receive a certificate of attendance delivered by the House of Training.
Location
L-1611 Luxembourg
Luxembourg
Sessions and schedules
Would you like to stay up to date on our training offer?
Subscribe to our newsletter