FR
EN
LU
DE
Details
Goals
Be able to create and manage tables. Formatting and manipulating data. Be able to create and print charts based on Excel data.
Prerequisite
Good knowledge of the Windows environment.
Contents
Excel presentation
- Screen components
- Excel environment : Quick access toolbar, Ribbon, tabs
- Customising the Quick access toolbar and the Ribbon
- Live Preview and Paste Preview
Managing worksheets
- Adding, renaming, deleting a sheet
- Moving and copying a sheet
- Defining a tab colour
Table management
- Entering and validating data
- Managing rows and columns : adding, resizing, deleting, hiding/showing
- Searching/replacing data
- Copying/ Pasting data
Document management
- Creating/Opening/Saving a document
- Formatting and printing a table, header and footer management
- The Page Layout view
Calculating
- Introducing and copying formulas
- Interactive tags
Functions
- Inserting a function by using the Wizard
- Inserting a function manually, the auto-complete drop down list
Formatting a table
- Formatting cells
- Using styles
- Using predefined conditional formats
Charts
- Creating a chart
- Modifying/formatting a chart
- Using chart styles
- Creating and using a chart template
- Sparklines
Analysing data tables
- Creating a data table
- Sorting and Filtering data tables
To go further
These courses
may be of interest to you
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!
You have added a training to your shopping card
- En
2.00 Jours
440€ VAT excl. / participant