Improve performance

Improve efficiency with Excel

Use Excel to save time on everyday tasks

PDF brochure

Business skills

Office software and data analysis

Who is it for?

Anyone

Place

– On the company's premises
– By video conference
– For people with disabilities, please contact us to discuss how the training can be adapted to your needs.

Duration

4 days (28h)

Prerequisites

None

Prices

€3,200 excluding tax (maximum of 6 participants)

Included

– Training files
– Skills acquisition grid
– Study of real cases from the company

You handle a lot of data manually and would like to save time on certain tasks?

Thanks to this customized training, you will learn to use Excel to:

  • perform calculations and visualize them as charts
  • lay at out reports efficiently
  • analyze the data with filters, lookup functions and dynamic pivot tables.

Goals

  • Review the basics of using Excel
  • Perform calculations and create charts
  • Lay out reports that can easily be updated
  • Manage and analyze data, in connection with an ERP
  • Be autonomous in using Excel

Course content

1. Excel basics

  • Standard operations
  • Performing calculations: example of cash-flow tracking
  • Create and customize a chart
  • Be autonomous: use Excel help and the internet

2. Managing data (with examples from your company)

  • (on request) Extract data from your ERP
  • Sort, filter and clean data
  • Conditional formatting and lookup functions
  • Analyze data: conditional calculations

3. Pivot tables: a powerful tool

  • Prepare and validate data
  • Analyze data: pivot tables
  • Illustrate the analysis: pivot charts
  • Prepare a report template that is easy to update

4. Adapt your use of Excel to the company’s needs

  • Optimize your files: size and ergonomics
  • Use Excel as a mail merge source

We study your needs with you beforehand, and adapt the content of the training to your needs, your data and the level of the participants.

Teaching staff

The trainer QuanauP has about twenty years of experience as a project manager, engineer, and quality manager in a demanding and highly international environment.

Method

  • Theoretical presentations and real examples
  • Provision of supporting documents
  • Assessment quiz on learning outcomes at the end of the training
  • Certificate of completion of the training

Discover our other training courses

The basics of project management

Getting off to a good start in your project management role

Find out more

Be at ease in English for professional use

Take part in professional exchanges in English!

Find out more

LEAN and continuous improvement: achieving rapid results

Improve individual and overall efficiency using practical tools tailored to your business

Find out more