Events

Excel 2016/2019 Level 1

700 €

at 10 KM
Business Training Luxembourg Follow

Training
Accounting
English
French
Office

thu. 18 Jun.

fri. 19 Jun.

thu. 16 Jul.

fri. 17 Jul.

wed. 22 Jul.

thu. 23 Jul.

mon. 17 Aug.

tue. 18 Aug.

thu. 20 Aug.

fri. 21 Aug.

thu. 17 Sep.

fri. 18 Sep.

mon. 21 Sep.

tue. 22 Sep.

thu. 15 Oct.

fri. 16 Oct.

mon. 19 Oct.

tue. 20 Oct.

* Training aims :
Being able to create tables and manage them in terms of calculation, formatting, and layout.

* Content:

- Introduction
- Understanding the environment of Excel 2013/2016
(purpose, specific vocabulary, ...)
- Manipulate cells and spreadsheets
(contiguous, dis contiguous, rename selections,
move, delete sheets…)
- Enter data (alphabetical, numeric,
use the fill handle, personalized lists, etc.)
- Calculate
- Create formulas
- Use functions (automatic sum, average,
root, rounded,…)
- Use absolute relative and mixed references
- Formatting
- Format tables (characters, borders,
the alignments, the format of the numbers, the width and the
cell height, add or remove rows and
columns, automatic formatting)
- Graphics
- Creation and modification
- Layout and printing
- Orient, adjust, header and footer, printing area
- Data base
- Sort and use automatic filters
- Tips and tricks
- Exercises

Good to know

- Training in French: 22.07-23.07,17.09-18.08,21.09-22.09, 19.10-20.10

- Training in English: 18.06-19-6.16.07-17.07, 20.08-21.08, 17.09-18-09, 15.10-16.10

- Prerequisite: Know the Windows environment and master file management

- Price: 300 EUR

- Target audience: This course is intended for people wishing to learn about the establishment of computer tables. Whether accounting or statistics, MS Excel 2013/2016 is the ultimate spreadsheet.

+ info