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
Course Material
The training material will be handed out at the beginning of the course.
Certificate
At the end of the training, the participant will receive a certificate of attendance delivered by the House of Training.
Location
L-1611 Luxembourg
Luxembourg