Cette formation est proposée sous forme de formation présentielle.

Description

Objectives

After the training the participant shall be able to:

  • create and manage tables
  • format and manipulate data
  • create and print charts from Excel data
Programme
Excel environment
  • The Excel environment: Quick Access toolbar, ribbon and tabs

  • Customise Quick Access toolbar and the ribbon

  • Live Preview and Paste Preview

Manage spreadsheets
  • Add, rename, delete a worksheet

  • Move and copy a sheet

  • Define a tab colour

  • Change the height or width of the formula bar

Manage Tables
  • Enter and validate data

  • Manage rows and columns: add, resize, delete, hide / show

  • Find / Replace data

  • Copy / paste data

Document Management
  • Create / open / save a document

  • Headers and footers

  • The « Page Layout » view

Calculate
  • Enter and copy formulas

  • Smart tags

Functions
  • Insert Function using the wizard

  • Insert function manually, semi-automatic formula input

Format table
  • Format cells

  • Using styles

  • Predefined conditional formats

Present data with a graph (Chart)
  • Create a chart

  • Change / format a Chart

  • Use the chart styles

  • Create and use a chart template

  • Sparklines

Analyse the data tables
  • Create a data table (Insert Table)

  • Sort and filter data tables

  • List filters with search box

  • Sort and filter by font or fill color

  • The Flash Fill

Target audience

Anyone who wishes to learn how to create and manage tables in Excel 365.

Prerequisites

Knowledge of the Windows work environment


Conditions

Course Material

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

Certificate

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

Location
Key Job S.A.
65, Avenue de la Gare
L-1611 Luxembourg
Luxembourg
Calculate the itinerary

Sessions et horaires

Télécharger le planning (PDF)

  • Mon 22.07.2024

    09:00 à 16:00

    6H

    Excel 2013, 2016, Office 365 - Fundamentals

    Key Job S.A.

  • Tue 23.07.2024

    09:00 à 16:00

    6H

    Excel 2013, 2016, Office 365 - Fundamentals

    Key Job S.A.

Télécharger le planning (PDF)

  • Thu 12.09.2024

    09:00 à 16:00

    6H

    Excel 2013, 2016, Office 365 - Fundamentals

    Key Job S.A.

  • Fri 13.09.2024

    09:00 à 16:00

    6H

    Excel 2013, 2016, Office 365 - Fundamentals

    Key Job S.A.