Excel : Advanced functions + VBA and Passing of the TOSA certification

world

Goals


- Be able to perform calculations and use functions

- Know how to handle graphics and pivot tables

- Use VBA

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

4 days

Price

£ 1425

Audience

Excel users

Prerequisites

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

Reference

BUR100-F

  

Objectives of the VBA language
Presentation of VBA
Some definitions
Use of VBA
Principle of operation of a macro

Modifying the code of a macro
Language syntax
Variables
Arrays
Constants
Operators

The Application object
The Workbook object
The Worksheet object

The Range object

Operating principles
Condition structures (If, Select Case)
Multiple conditions (And / Or)
Presentation of loops
Looping according to a counter (For Next)
Looping according to a condition (Do Loop)

Synthesis
Questions / Answers

Review of the important elements Revisions before certification
Passing of the TOSA certification on Excel

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