TRAINING EXCEL PIVOT TABLES Geneva, Zürich and Vaud

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:

• Training Introduction to Word (Geneva, Zürich and Vaud)
• Training Advanced Word (Geneva, Zürich and Vaud)
• Training Word: large documents (Geneva, Zürich and Vaud)
• Training Word tables (Geneva, Zürich and Vaud)
• Training Advanced Excel (Geneva, Zürich and Vaud)
• Training Introduction to Excel (Geneva, Zürich and Vaud)
• Training PowerPoint (Geneva, Zürich and Vaud)
• Training Outlook (Geneva, Zürich and Vaud)
• Training New features in Office 2013 (Geneva, Zürich and Vaud)