Description

Complete, this training gives you mastery of the essential features of Excel (2019 versions) to set up reliable analyses, be efficient and save time. Evaluate your level of knowledge in Excel “Improvement.

Who is this training for ?

For whom ?

Any Excel 2019 user

Prerequisites

Have basic knowledge of Excel 2019 or older versions

Training objectives

Acquire effective and judicious use of Excel.

Save time in the construction and presentation of tables and graphs.

Use a list of data and analyze it with dynamic cross tables.

Making your calculations more reliable and analyses.

Training program

• Use time-saving tools
  • Define conditional formatting rules.
  • Make it easier and control input with data validation.
• Build simple and sophisticated calculation formulas
  • Master the copying of formulas: relative (A1), absolute ($A$1) or mixed (A$1, $A1) references.
  • Facilitate the creation of formulas: use names.
  • Set up simple, complex, nested conditions: IF, OR, AND, ISEMPTY ...
  • Calculate statistics: NBVAL, NB, NB.IF, MEDIAN , ...
  • Relate data with the VLOOKUP function.
  • Calculate dates, times: MONTH.SHIFT, END.MONTH, ...
  • Manipulate text: LEFT, RIGHT, STXT, NBCAR, ...
• Build elaborate charts
  • Making a successful graph: reminder of the steps to follow.
  • Combine several types of graphs into one.
  • Compare series of different orders of magnitude.
  • Use Sparkline Charts
• Use a list of data
  • Put the data in table form.
  • Apply multi-criteria and custom sorting.
  • Query, extract data with automatic filters.
  • Remove duplicates.
• Set up pivot tables
  • Set up 1, 2 or 3-dimensional pivot tables.
  • Group information by period, by slice. Filter, sort, hide data.
  • Add ratios, percentages.
  • Insert a pivot chart.
  • Evaluation of the transfer of acquired knowledge to validate implementation in a work situation