Excel : Advanced functions

world

Goals


- Know the main functions of Excel

- Be able to perform calculations and use functions

- Know how to handle graphs and pivot tables

Program

Using a referent cell ($)
Basic
formulas Conditional formulas
Date and time
functions Other functions
Formula audits

Sorting, sorting options
Automatic filters

Custom filters

Select data
Choose a chart type according to needs
Insert a title, legend, data labels
3D charts
Modify values
Modify chart type

Structure of a PivotTable
The PivotTable and PivotChart wizard
Edit a PivotTable
Format a PivotTable

Convert and consolidate
Data validation
Scenario analysis

Adding and modifying comments
Protect your workbook and sheets
Using the Microsoft OneDrive service

Objectives of a macro
Displaying the Developer tab in the ribbon
Recording a macro
Running a macro
Running a macro via shortcuts (in ribbon, button, etc.)
Managing macros
Viewing the code of a macro

Duration

2 days

Price

£ 750

Audience

Everyone

Prerequisites

Have followed the course « Excel: Fundamentals » or have equivalent knowledge

Reference

BUR99-F

  

Sessions

Contact us for more informations about session date

In accordance with the program, with adaptation to any specific requests. Perfect timing in relation to my needs, the implementation will be immediate. Trainer very familiar with his subject, and who knows how to contextualize, and find relevant examples.
Stephane P.
Stephane P.
Correct environment, clear, understandable, welcoming trainer. Very interesting, enriching. training The training will be useful for the tables we use. Very good trainer, attentive to our needs, clear in his remarks.
Nathalie L.
Nathalie L.
Trainer adapted to all it is perfect. Very interesting trainer who manages to capture our attention on the length.
Sylvia D.
Sylvia D.
The exercises and simulation exercises are fully in line with the demands and expectations of this training. Kevin is an available trainer, pedagogue, attentive who transmits his knowledge and knowledge perfectly well.
Valerie N.
Valerie N.
Trainer: very dynamic, very clear explanations, knows how to get to the level of trainees, knows how to repeat information in different ways so that everyone understands. Knows how to set his own pace. Great oral fluency, good interpersonal skills, knows not to be overwhelmed by certain trainees who wish to work on their own example.
Sophie O.
Sophie O.
Intensive training with little time for customized needs. Trainer: Explains well, puts you at ease Very good responsive sales department. Called back immediately to identify needs etc. Immediately returned the doc to Pole emploi. Bemol, not informed of the place and time of training the day before afternoon. Thank you !
Catherine P.
Catherine P.
Very good group and good atmosphere. lacked the 1st refresher course for me Our management did not offer it to us. Kevin is a good trainer and explains very well he is very patient.
Brigitte V.
Brigitte V.
Very well organized; enriching. The training answered a lot of questions that we may have on a daily basis. Even if the level was high (confirmed); while I had asked intermediary. Nothing to say; very good trainer.
Michael M.
Michael M.
Very good - equipment in good working order. Very good, pedagogical, didactic, and adapted to each one. perfect answers to the professional needs of the daily life, possibility to ask precise questions, and to obtain answers just as precise. Trainer: very good, easy to access, pedagogue, mastery of the subject.
Alix C.
Alix C.
The working environment is very good. The choice was excellent regarding the different exercises chosen. This training was additional information. The trainer was available throughout this training to provide additional information to the exercises. It should be applied for professional and personal use.
Corinne R.
Corinne R.
Précédent
Suivant