Cette formation est proposée sous forme de formation à distance. En savoir plus

Description

Objectives
  • Manage your spreadsheets in an efficient way
Programme
  • Manipulate large tables
    • Definition
    • Rules for building a list
    • Freeze panes, repeat headers …
    • Format as table
      • Table name
      • Add a totals row
    • Moving & selecting in an efficient way
    • Data validation
    • Find/replace data
  • Conditional Formatting
    • Apply a conditional formatting to cells
    • Create a rule
    • Manage the formatting rules: edit, delete
  • The flash fill
    • Automatically extract or combine data
    • Start flash fill automatically/manually
  • Managing sheets
    • Add, rename, delete a sheet
    • Move & copy a sheet
    • Set a color to the sheet tab
  • Create and manage links
  • Keyboard shortcuts
Prerequisites
  • Basic Excel skills

Conditions

Course Material

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

Location
Classe virtuelle
A distance
Calculate the itinerary

Sessions et horaires

Télécharger le planning (PDF)

  • Wed 12.06.2024

    13:30 à 17:00

    3H30

    Excel 2016 Productivity

    Classe virtuelle