Using Microsoft Excel to manage and analyse data - TOSA certification

Data management skills on Microsoft Excel are particularly in demand include accounting and finance (to draw up budgets, make financial projections, produce reports and carry out market analysis), logistics (to optimise supply chains, manage stocks and track shipments), sales and marketing functions (to analyse market data, track campaign performance and manage customer databases), project management (to track resources, tasks and deadlines, and generate progress reports). However, the use of Excel software also includes professions requiring cross-disciplinary skills where the use of the software becomes a necessity (self-employment, sales, crafts, etc.).

To obtain the certification, it is necessary to obtain the TOSA Basic level in each of the 4 areas.

The candidate achieves one of 5 levels in each of the domains:

• Initial (TOSA from 1 to 350 points),
• Basic (TOSA from 351 to 550 points ),
• Operational (TOSA from 551 to 725 points),
• Advanced (TOSA from 726 to 875 points),
• Expert (TOSA from 876 to 1000 points)

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

• Personalised course

• Room equipped with networked computer workstations

Positioning prior to entry into training.

Interviews, remediation with the educational referent and/or company referent during training.

Taking into account beneficiary satisfaction during and at the end of training.

For beneficiaries with disabilities: possible adaptation of training and certification methods, support by the TH referent.

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

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

Tests at the end of training (One-off assessment)

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.

Apply the techniques taught in training to your professional assignments.

Access for people with disabilities

Transport

Tramway lines 2 and 3: République-Dames station
Or Metro line 2: Joliette station

- 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.

School added value:

• Coworking environment providing a computer workstation for digital training times

• Place accessible to people with disabilities

• Our indicators can be consulted at : cliquez ici