Excel: Formulas, Graphs and Cross-Tabular Data

OPCO FinancedQualiopi-certified organisation

Learn how to use spreadsheets effectively with Microsoft Excel and make the most of its full potential. Format an Excel spreadsheet and create dashboards using automatic functions. Master charts and PivotTables to highlight and analyse your data.

DurationFrom 14 to 28 hours, from 2 to 5 days. Adjustable to suit your needs.
Terms and conditionsFace-to-face or online
AudienceEntrepreneur, Manager or Employee
PriceOn request, following a needs assessment · eligible for OPCO funding
Access time1 month (particularly taking into account the time required to put together funding applications), which may be reduced depending on the urgency of your request and the availability of our teams.
RegistrationOn request by email or telephone

Enquire about this course

Aims of the training course

  • Formatting the cells in a table
  • Add formulas that reference other cells
  • Using basic Excel functions
  • Create advanced calculation formulas
  • Analysing data with Pivot Tables
  • Create charts

Programme

  1. The basics of Excel
  2. Formatting
  3. Sorting / Filtering
  4. Conditional formatting
  5. The Charts
  6. The formulas
  7. Cell addressing
  8. Basic and statistical functions
  9. Advanced logic and search formulas
  10. Pivot Tables

Practical information

Prerequisites

Basic IT skills; a computer with internet access

Teaching method

A mix of theory, exercises and practical case studies, with the opportunity to apply what has been learnt to a personal project

Trainer

Expert consultant in the field of the web

Category of the action

Skills development

Assessment and grading procedures

Placement test / Assessment – Mid-course and end-of-course quizzes – Practical application / Training certificate / Certificate of completion

Accessibility for people with disabilities

We ensure the inclusion of people with disabilities within our organisation and constantly review our organisational structure and teaching practices. We are working to implement appropriate solutions and collaborate with disability support organisations to provide us with the best possible guidance when external support is required to help us identify the necessary measures to ensure a safe and inclusive learning experience for people with disabilities. To enable us to prepare as effectively as possible, please provide any information requiring adjustments to the organisation’s disability liaison officers – Candice Tissot and Timoté Ducatez – at agence@vaniseo.com, well in advance of the training. For any further information, we recommend the following organisations: AGEFIPH: 0 800 11 10 09 RHF PACA: 04 42 93 15 50

Performance indicators

Satisfaction rate and success rate: 100 per cent and 100 per cent

OPCO funding

Enquire about this course

We check your eligibility, put together the funding application with you and tailor the programme to your needs.

Phone and WhatsApp: 07 64 09 83 08 · formation@vaniseo.com

Get in touch

Please leave your contact details: we’ll get back to you shortly with the programme, dates and funding details.