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.

Basics

• Correct data entry (text, numbers, with filling handle)
• Move around the worksheet
• Add or remove rows and columns
• Copy, move, and delete a range of cells
• Naming the Worksheet
• Copy, move, delete worksheets
• Saving the file
• Help in a New Way: "Tell Excel What You Want to Do"
• Create and edit lists, e.g. via Autocomplete
• Filter and sort in a list

Calculating with Excel

• Manually creating formulas
• Use simple functions: sum, average, min. and max.
• Absolute, relative and mixed references
• Calculating percentages

Formatting a table

• Apply automatic formatting
• Manual formatting: character formatting, frames, alignment, width and height
• Formatting cells with numbers or data

Page Formatting & Printing

• Control page orientation, margins, headline, and footer
• Check print view before printing (resize/make it fit a certain number of pages).
• Manage print settings: repeat print area, column or row titles on each page, etc.