Events

Excel 2013/2016 - fundamentals

450 €

at 1.8 KM
House of Training Follow

Training
Business
Strategy
Technology
Digital
IT
Productivity
Office

thu. 17 Oct.

Objectives

After the training the participant shall be able to:
create tables and manage the tables’ calculations, formatting and page layout
use Excel efficiently
put into practice learned tips and tricks
Programme

Introduction
Understanding the Excel environment (purpose, specific vocabulary…)
Manipulating cells and worksheets (selecting techniques, renaming, moving and deleting sheets…)
Entering data (text, numeric, using the fill handle, the custom lists...)
Calculate
Creating formulas
Using functions (autosum, average, square root, round…)
Using the absolute, relative and mixed references
Formatting
Formatting tables (fonts, borders, alignments, number format, cell width and height, add or delete rows and columns, autoformat)
Charts
Creating and modifying
Page setup and printing
Orientation, adjust, header and footer, print area…
Databases
Sorting and using autofilters
Tips and tricks
Exercises

Target audience
Anyone who wishes to learn how to create and manage electronic tables.

Certificate
At the end of the training, the participant will receive a certificate of attendance delivered by the House of Training.

Course material
The training material will be handed out at the beginning of the course.