Training: Excel – Fundamentals

Ref. MOE-01
Duration:
1
 day
Exam:
Not certifying
Level:
Fundamental

Description

This Excel course will give you all the basics to create spreadsheets, sort them and make simple calculations.

Participant profiles

  • This training is intended for anyone who has to use the basic functionalities of Excel such as creating a spreadsheet in a quick and easy way

Objectives

  • At the end of the training, the participants will be able to :
  • Name and recognize the different components of a spreadsheet
  • Create a simple spreadsheet and format it
  • Perform simple calculations in a spreadsheet
  • Sort a spreadsheet
  • Create a simple graph and format it

Prerequisites

  • No prerequisites

Course content

Module 1: Basic features of Excel

  • Use of the ribbon
  • Workbooks and worksheets
  • Display and zoom options
  • Selecting parts of a worksheet
  • Columns and rows
  • Copying Data from a Cell
  • Using the copy handle
  • Shortcuts for data entry
  • Backstage mode

Module 2 : Formatting

  • Formatting cells (font, background color,…)
  • Use of the Brush tool
  • Width/height of rows and columns
  • Formatting of numbers
  • Layout of the spreadsheet for printing

Module 3: Formulas and Functions

  • Presentation of cell references
  • Inserting a simple formula
  • Inserting a function
  • Frequently used functions (SUM, AVERAGE, MAX, MIN, NB)
  • Relative and absolute references

Module 4: Using tables

  • Presentation of the Filter tool
  • Sort data in ascending/descending or alphabetical order
  • Filtering data

Module 5: Charts

  • Create a simple chart
  • Apply a predefined layout and chart style
  • Add or remove graphical elements

Documentation

  • Digital course material included

Lab / Exercises

  • Practice exercises will be given at the end of each module

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

  • As we care about the quality of our training, ITTA offers you an online skills assessment test before and after your course so that you can evaluate your progress
  • Explore all our Microsoft Office courses by clicking here
Prix de l'inscription
CHF 700.-
Inclus dans ce cours
  • Evaluation of your level before and after the training
  • Training provided by a certified trainer
  • Documentation in digital format
  • Achievement Badge

ven31Mai09:00ven17:00VirtuelAnnuléeVirtual Etiquettes de sessionMOE-01

ven31Mai09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 LausanneAnnulée Etiquettes de sessionMOE-01

ven31Mai09:00ven17:00VirtuelFeaturedVirtual Etiquettes de sessionMOE-01

ven31Mai09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 LausanneFeatured Etiquettes de sessionMOE-01

ven05juil09:00ven17:00VirtuelVirtual Etiquettes de sessionMOE-01

ven05juil09:00ven17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-01

ven09Aoû09:00ven17:00VirtuelVirtual Etiquettes de sessionMOE-01

ven09Aoû09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-01

ven13Sep09:00ven17:00VirtuelVirtual Etiquettes de sessionMOE-01

ven13Sep09:00ven17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-01

ven18Oct09:00ven17:00VirtuelVirtual Etiquettes de sessionMOE-01

ven18Oct09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-01

ven22Nov09:00ven17:00VirtuelVirtual Etiquettes de sessionMOE-01

ven22Nov09:00ven17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-01

ven27Déc09:00ven17:00VirtuelVirtual Etiquettes de sessionMOE-01

ven27Déc09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-01

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X