Cours Microsoft Excel 2010 and Time Management English

Imprimer Retour

Objectif

Microsoft Excel 2010 and Time Management is a course that will allow you to create Excel workbooks specific to time management, to work with data formatted as dates and hours, to manage people (absences, holidays, extra-hours) and timetables. This course on Microsoft Excel 2010 and Time Management has been created for Excel users that need to work with data related to time, but also for those who want to find tricks and tips to work faster and improve their knowledge of MS Excel 2010.

Contenu

  • What does “time management in Excel” mean?
  • How to enter a date?
  • How to enter time?
  • Encoding of date and time
  • Formats
  • Computations using dates
  • Working with hours
  • Time-related functions: date & time, logical, information, lookup & reference, statistical,…
  • Validation (dropdown list)
  • Customized formatting
  • Conditional formatting
  • Subtotals
  • View options
  • Data protection

Langue du cours

EN

Support de cours

  • Training material in supplement

15.- CHF

Durée

1 jour(s)

Prix

650.- CHF

Nos cours collectifs

Aucune session programmée

Conditions générales de vente