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.

16 people

• Mixed training

• Personalised course
• Individual benefit
• Group lessons
• Combined face-to-face and distance learning
• Services provided face-to-face and/or remotely
• Classroom examination

• Room equipped with networked computer workstations
• Plateforme Learning Management System
• Unmarked room with video projector

Positioning upstream of entry into training.

Taking into account the satisfaction of beneficiaries 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 training, professional speakers.

Trainers experienced in individualising learning.

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

Positioning test by appointment.

Interview by appointment.

The course is available between 15 and 45 days before it starts, depending on the funding body. Please contact us.

Contact us to register for a meeting.

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

Catering

Transport

- 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 do not have Quality indicators.

Our training courses are entirely individualised according to your objectives and a positioning at the start of the course.