Using Microsoft EXCEL to manage and analyse data - TOSA certification

Upon completion of the course, learners will be able to demonstrate their data management skills in Microsoft Excel, specifically:

in accounting and finance to:

• draw up budgets,
• carry out financial projections,
• produce reports
• conduct market analyses

in logistics to:

• optimising supply chains,
• managing stock and tracking shipments

in sales and marketing to:

• analysing market data,
• monitoring campaign performance,
• managing customer databases,

in project management for:

• track resources, tasks and deadlines,
• generate progress reports

The candidate acquires an increasingly enhanced level of mastery and autonomy according to the 5 levels proposed for each of the following areas:

Environment and methods: Becoming autonomous and efficient in the daily use of Excel

• 1.1 Knowing and using the editing tools: Cut, copy, paste, text/cell formatting, auto-completion and semi-automatic input to quickly structure your data
• 1.2 Knowing the software environment and using the main features: Discovering the interface, keyboard shortcuts and advanced features and becoming more efficient
• 1.3 Organising workbooks, sheets and tables: Creating sheets, managing workbooks, applying formatting for clear, professional documents
• 1.4 Knowing and customising the different display modes: Zoom, margins, headers, grids... to optimise readability

Calculations and formulas: Moving from manual calculations to intelligent automation

• 2.1 Using calculation functions in formulas: Arithmetic operations, logical conditions, cell references and time functions to simplify your analyses
• 2.2 Using calculation functions specific to database management: Using INDEX, EQUIV, and cross-references to extract strategic data
• 2.3 Managing formulas: Combining several functions, mastering relative/absolute references for reliable and scalable calculations

Formatting: Transforming raw figures into powerful visual aids

• 3.1 Creating, using and modifying numerical formats: Percentages, currencies, dates... Present your data in a professional and appropriate way
• 3.2 Formatting workbook data (formulas, text and graphics): Advanced styles, tables, themes and graphic objects for attractive documents
• 3.3 Apply and manage conditional formatting: Highlight trends and anomalies with simple or formula-based rules to facilitate visual analysis

Data management: Import, clean, analyse and present your professional data

• 4.1 Using data management tools : Clean, format, filter and sort for ready-to-use data
• 4.2 Creating and managing graphs : Customise your colours, labels and axes and ensure they update automatically for impactful presentations
• 4.3 Create and manage pivot tables: Add, sort and filter fields to summarise complex data and produce detailed reports

• TOSA certification

More information about this certification (RS7256, exact wording of the diploma, name of the certifier, certification registration date) by clicking here.

• All audiences

Know the basics of using an office environment and mathematical operations and functions.

8 people

• Mixed training

The course combines face-to-face and distance learning. Learning takes place through a mix of sessions at the centre, virtual classes, online resources and regular support from the trainer.

• Room equipped with networked computer workstations
• Plateforme Learning Management System

To help us improve the quality of our service, you can send us your suggestions or complaints using the form available on our website.

For participants with disabilities: training and certification arrangements can be adapted where necessary, with support from the disability liaison officer.

Participant satisfaction is assessed during and at the end of the training programme.

Interviews and remedial action with the educational liaison officer and/or the company liaison officer take place during the training programme.

Assessment takes place prior to the start of the training programme.

Education Nationale certified teachers, Bac +3 trainers with significant experience in adult education, professional lecturers.

To obtain certification, candidates must achieve the Basic level of TOSA in each of the four domains.

Candidates achieve one of five levels in each of the four areas:

• Initial (TOSA score of 1 to 350 points), a certificate of attendance
• Basic (TOSA score of 351 to 550 points),
• Operational (TOSA score of 551 to 725 points),
• Advanced (TOSA score of 726 to 875 points),
• Expert (TOSA score of 876 to 1,000 points) 

Test format:

• Adaptive algorithm: the difficulty of the questions adapts to the candidate’s level throughout the test.
• IRT (Item Response Theory) scoring: score out of 1,000.
• Question types: Real-world scenarios using Microsoft Excel (data manipulation questions in Access) encountered in a business setting, and interactive activities (linking, drag-and-drop, clicking on areas, drop-down lists, etc.), multiple-choice questions.
• Test format: 35 questions – 60 minutes

Interview by appointment.

Positioning test by appointment.

Training is available between 15 and 45 days before the start of the course, depending on the funding body. Please contact us.

The use of Excel encompasses professions requiring cross-disciplinary skills where the software has become essential (self-employment, sales, skilled trades, etc.).

Apply the techniques learnt during the training course in the context of one’s professional duties.

Access for people with disabilities

Transport

Métro line 2 or 1: St Charles station
TER : Hyeres - Gare d Aubagne
On foot 25 min

- In the interests of efficiency and cost-effectiveness, the TOSA tests can be configured to tailor your course as closely as possible to your level and your professional ambitions. Taking into account your starting level (positioning) and the business objectives targeted to individualise your course.

- Tests offered halfway through and at the end of the learning course to assess your progress as accurately as possible and to prepare you for certification.

- Detailed progress reports on the software's 3 skill areas.

- The cost of passing the certification is included in the course fees.

- Free additional activities offered remotely.

- Certification adding to the employability of trainees at the end of the course.

- The opportunity to make your own decision to take this course, thanks to the Personal Training Account. 

1st training session, we have no Quality indicators.