TRAINING EXCEL PIVOT TABLES Geneva, Vaud, Valais, Neuchatel, Fribourg, Zurich

Our course on pivot tables in Microsoft Excel

Participants
Open to everyone.

Programme
Reminders:
The role and advantages of pivot tables.
Data sources.

Methodology

  • Analysis of data to be used:
  • Defining the objectives of a statistical analysis:

Creating:
Choosing the data source and fields.

Formulas for improving the quality of source data.

Combining data from several sources:

  • Using formula.
  • By installing the wizard to use tracks with labels.
  • By using MSQuery queries.

Using other sources:

  • Importing text files.
  • Data from a database.

Choosing the calculation type and logic:

  • Sum, count, average, maximum, minimum.
  • Ratio.
  • Variance.
  • Product.
  • Rank.

Aggregate function: semi-automatic, manual, simple and elaborate.

Adding calculated fields and calculated items.

Formatting:

  • Layout and format of crosstabs; managing levels.
  • Formatting numbers: customised formats.
  • Table styles: creating your own style.
  • Specific sorting.
  • Conditional formatting.

Exploitation :

  • Attaching segments to multiple pivot tables.
  • Creating and formatting pivot charts.
  • Creating tables from crosstabs.
  • Creating conventional charts using a crosstab.
  • Filling the crosstab with juxtaposed formulae.

Course requirements

Routine use of basic Excel.

Practical exercises

This training course on Excel pivot tables, which is based on realistic simulation exercises and a comparison of different practices, will equip participants with techniques that can be used directly.

Course diploma / certificate

A certificate is obtained at the conclusion of the course on Excel pivot tables.

Similar types of training courses:

Our trainings can be provided tailor-made for your organization or organized in-company.

Are you looking for an in-company training? Download our training catalog.

If you are rather interested in tailored training…
Please fill in the form below, we will gladly give you more information about our tailored trainings:

All our courses can be delivered in English, French, German, Swiss German, Italian, or Spanish.

All our services are available in Switzerland: Geneva, Zürich, Vaud, Neuchâtel, Fribourg and Valais.