Excel – TCD

WHO IS IT FOR ?

Anyone needing to work with Excel data sets

how ?

Guided and independent practical case exercises. Work based on participants' own data sets if requested. Summary sheets provided. Support for specific data usage needs for 6 months

DURATION

1.00 day(s) 7:00 hours

HOW IT ADVANTAGES YOU

Learn how to use Excel's Pivot Table tool to generate statistical summaries from your data sets

ON THE PROGRAM

Discovering the Pivot Table Tool

- Learn how to create a Pivot Table

- Place items in rows/columns/filters/values

– Discover the specific commands of the PivotTable (Analysis menu, right-click and "field list")

– Use the various available functions (in particular the Sum and Count statistical functions)

- Generate percentages

- Extract data from the database using Pivot Tables

Going Further with Pivot Tables

- Create a “calculated field” for custom calculations

- Group items (group/expand/collapse)

- Improve the presentation of your Pivot Table (Design tab: styles, subtotals, totals, layout...)

- Refresh your Pivot Table (“Pivot Table Tools” and refresh/change data source)

Graphically Representing Your Summary

- Create a Pivot Chart

- Choose the right chart type (line, bar, pie, combo charts...)

– Discover the specific features of this type of graph (Analysis menu, “list of fields”, “field buttons”, built-in filters, expand/collapse groups)

Creating a Dashboard

- Effectively build an overview of your data analysis

– Insert “segments” and a “timeline” to analyze the entire dashboard based on filter criteria

You wish to participate in a training course

Reviews from our employees

Available trainings

Softskills

Developing human and interpersonal skills to communicate more effectively, manage, assert oneself, and handle complex situations in a professional context.

Tools

Training in the effective use of office and collaborative software and applications to enhance productivity and the quality of everyday work.

Training program

Supporting learners in mastering structured tools and approaches to organise, manage, and enhance their work with precision and effectiveness.

Languages

Supporting learners to improve their foreign language skills in order to communicate confidently and effectively in an international professional context.

Sustainable Development

Raising awareness and equipping participants to integrate environmental and social issues into their professional practices and strategic decisions.