This course is addressed to anyone who wishes to learn how to create and manage electronic tables. Whether for statistics or accountability, MS Excel is the table manager by excellence.

In the case of tailor-made training, this training can also be given as a refreshment in an accelerated form.

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 (font, borders, alignments, number format, cell width and height, add or delete rows and columns, autoformat)

Page setup and printing

• Orientation, adjust, header and footer, print area, …