.png){kind=small}
A propos du cours
TRAINING - Microsoft Excel Advanced Training
Program :
The Microsoft Excel Advanced training alternates explanatory steps and practical exercises based most often on the following points:
Construct and use data lists, produce statistical reports and generate graphs.
Use functions to automate tables.
Create summary and consolidated tables.
Generate summary tables with the “pivot table reports” function
Training objectives
Use Excel's advanced functions and commands to optimize your tables.
Discover automation using macro commands.
Master the use of "database" type tables with management and synthesis tools.
Optimize your work with models and settings.
Beneficiary profile
For whom?
Users who need to design and operate complex spreadsheets and data lists with Excel.
Any user wishing to deepen their knowledge of Excel (tools and functions).
Staff required to develop specific applications on a spreadsheet.
Prerequisites?
Have completed the intermediate Microsoft Excel training.
Know pivot tables, master advanced calculation functions (conditional function, date and text function).
Duration and schedule
The training lasts 1 day from 8 a.m. to 5 p.m.
Training periods are adjusted throughout the year based on customer demand and availability.
Place
The client's premises.
Microsoft Excel Training Content
Training content
IMPROVED TABLE DESIGN
COMPLEX FUNCTIONS
MASTERING THE MANAGEMENT OF LISTS OR DATABASES
CONSOLIDATION OF MULTIPLE SHEETS
SIMULATION TOOLS
INTRODUCTION TO MACRO-COMMANDS
Monitoring of execution and evaluation of results
Attendance sheets.
Oral or written questions (MCQ).
Role plays.
Training evaluation forms.
Certificate of completion of the training action.
Technical and educational resources
Welcoming trainees in a room dedicated to training.
Projection of training support documents.
Concrete case studies.
Online availability of support documents following the training.
Rates
The price is €800 excluding VAT per person.
Accessibility
For people with disabilities, we will do everything possible to provide you with care or to redirect you. You can contact us at the following number: 0696 606 311