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.

Maximum total duration of 42 hours
The duration of the course is indicative and will be determined according to your profile.

• All audiences

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

8 people

10 people

Teaching method

• Fully classroom-based training

Teaching methods

• Personalised course

Equipment

• Room equipped with networked computer workstations

Monitoring and individualisation

Positioning upstream of training entry.

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

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

Examiners accredited DCL and TOEIC.

Trainers experienced in individualised learning.

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

Coursework assessments (CTE)

Total price including VAT : 1680.00 €
Hourly rate : 40.00 Hourly rate including VAT: €40.00
. This price is indicative and non-contractual. Depending on your status, this course can be fully financed. Contact us.

Positioning test by appointment.

Interview by appointment.

Depending on the funding body, training is available between 15 and 45 days before the start of the course. Please contact us for further information.

Contact us to register for a meeting.

Apply the techniques taught in training to your professional assignments.

Acquire additional skills by training to reach a higher level up to "Expert".

Access for people with disabilities

Accessible to people with disabilities
. The site has an entrance for people with disabilities or reduced mobility. An intercom is available to open this door.

Catering

The Lycée has a school canteen and cafeteria which are only open during school holidays. Private catering options are available nearby;

Transport

Cannes train station nearby, bus stop 2 minutes' walk away.

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

Our indicators can be consulted on the website : cliquez ici