• Your selection is empty.

    Register the diplomas, courses or lessons of your choice.

Introduction to Excel

  • School / Prep

    ENSMAC

Internal code

PA5EXCEL

Description

At the end of this TD cycle, apprentices will be able to :
- Use the basic functions of a spreadsheet program such as MS Excel, as well as a number of more advanced functions (Solver, Macros, TCD)
- Present work carried out on a spreadsheet program such as MS Excel to a colleague in a clear and precise manner
- Create and transmit to a colleague a scientific report of high quality, at least in terms of form, using a word processing program such as MS Word
- Master EXCEL tools for measuring production activities and optimizing processes.

Read more

Teaching hours

  • TDMMachine Tutorial24h

Syllabus

The introductory Excel module comprises 2 parts:
I - Introduction to the Excel spreadsheet and getting to grips with it. Use of Excel in the form of projects based on experimental data: exercises concern the identification of kinetic parameters (rate constants, reaction orders), thermo-physical quantities (thermodynamic model parameters, transfer coefficients) or controls (casting or operating temperature profiles), etc... Rapid presentation of results directly on computer (Clémentine BOSCH-BOUJU, Adeline PERRO, 12h)
II - Macros and DCT (Clémentine BOSCH-BOUJU, Adeline PERRO, 12h)

Read more

Further information

Engineering Sciences and Techniques

Read more

Bibliography

EXCEL, WORD and POWERPOINT online help

Read more

Assessment of knowledge

Initial assessment / Main session - Tests

Type of assessmentType of testDuration (in minutes)Number of testsTest coefficientEliminatory mark in the testRemarks
Continuous controlMinutes0.15
Continuous controlMinutes0.5
ProjectReport0.35