Excel beginner

Inter and intra-company training

Who is the training for?

Tout public.

Level reached

Beginner

Duration

1,00 day(s)

1 day of 6h with a break of 1h. Timetable to be defined with the students.

Language(s) of service

EN FR

Next session

Prerequisites

No excel base required.
Requires a computer with Microsoft Excel 2016 or Excel 365.

Goals

  • Master the basics of Excel. Be able to make tables with simple formulas.
  • Know how to present figures and design charts.
  • Integrate results into Word files and PowerPoint presentations.

Contents

  • Table layout. Fonts, lines, colors, dimensions, merging cells, grouping and hiding rows and columns.
  • Sum, count, average, lookup, if formulas.
  • Histograms, pie charts, curves, combined charts.
  • Renaming sheets, moving them, hiding them, locking them.
  • Integrate a table and a graph into a Word file, resize it.
  • Create dynamic links between files.
  • Integrate Excel with PowerPoint.

Points covered

  • Design, present and print a simple table
  • Harnessing the power of calculation: formulas and functions
  • Illustrate numbers with graphs
  • Organizing sheets and workbooks
  • Link with Word and PowerPoint

Teaching methods

Practical exercises carried out together step by step with the trainer.
Possibility to adapt the exercises to the client's environment.

Certificate, diploma

Certificate of participation issued at the end of the course.

Mode of organisation

Takes place at the client's premises or by videoconference (Teams or Zoom).

Organization contact details

Frédéric Michotte

These courses might interest you