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.
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
- The basics of Excel
- Formatting
- Sorting / Filtering
- Conditional formatting
- The Charts
- The formulas
- Cell addressing
- Basic and statistical functions
- Advanced logic and search formulas
- 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.
