Target audience

This course is for people wishing to initiate the establishment of computer tables. Whether accounting or statistics, MS Excel spreadsheet is the best.

Objectives

Acquire the tools to create and manage data in tables and graphs.

Requirements

-

Methodology

Excel Basic is based on theoretical Excel manual, but main part of the training is dedicated to practical exercises with personalized assistance from the trainer.

Content

• Environment (start and stop, windows)
• File Management (opening and closing an Excel workbook, registration)
• Using Excel (travel, selection, undo, redo, width, height, cut-copy-paste, copy, AutoComplete)
• Handling a file (rename a sheet, delete the contents of a cell, deleting a sheet, move, add a row / column, deleting a row / column)
• Formatting cells (character attributes, number formats, formatting, automatic formatting, copy the formatting)
• Calculations (the four basic operations, AutoSum, core functions, assistant function)
• The absolute reference
• Function date (dates and times)
• The IF function
• Graphs (creation and modification of a graph)
• Layout (layout table, margins, headers and footers)
• The print (print preview, printing options)

Diploma / Certificate

A certificate is awarded upon completion of training "Excel: Basic"

Print version

Format PDF

Duration and Price

Durée sur demande
Prix: sur demande

Questions ?

Contact us
Tél. +41 22 732 51 11
Lu-Ve 8h30 to 17h00