Course Microsoft Excel 2010 and Time Management English

Imprimer Retour

Goal

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.

Content

  • 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

Course Language

EN

Course material

  • Training material in supplement

Duration

1 day(s)

Our group lessons

Availability on request

General conditions of sales

If you have any difficulties with physical access or require any assistance please contact our teams.