Étiquette : Advanced

Project Management: Initiation + Advanced

Goals


- Train consultants or company staff in the project management methodology, involved in IT projects for customers or in an internal structure

- Acquire best practices, in order to guarantee the quality of deliverables and monitoring of results

Program

Feasibility study
Specifications
Synoptic of the process
Implementation approach
Planning
Budget estimate
Development cycles

The project approach
Organization
Clarify the framework of the project
Build the organization chart of the tasks
Choose the development model
Anticipate the risks
Set up a team

Establish a provisional schedule
Establish a provisional budget
Make a launch meeting with the client
Write the Project Quality Plan (PQP)

Development cycle
Reception and control of deliverables
Management
Control costs
Control quality
Control risks
Control communication
Control requests and evolutions
Project assessment or how to capitalize

Module 1: the project manager’s toolbox   
Module 2: control complexity Illustration from standard
Microsoft Project software and overview of
existing tools

Duration

4 days

Price

£ 2550

Audience

Managers, Project managers

Prerequisites

Mastery of the basic concepts of project management

Reference

GES100271-F

Reminder of the principles of project management
Manage project schedules
Manage tasks
Control the schedule of tasks
Optimize resources

Manage costs
Analyze the project and optimize
Communicate
Monitor the project
Capitalize

Evaluate the dimension of the project
Identify the impacts on the processes
Control contractual relationships
Make effective reporting
Define multi-project dashboards
Allocate technical and functional resources between projects
Control advanced planning and scheduling techniques
Know the key points to reduce certain delays
Identify common pitfalls
Apply best practices
Define priority criteria
Make trade-offs

Choose indicators and units of work
Organize and consolidate progress Prepare management decisions
Prepare dashboards
Renegotiate deadlines and budgets
Validate the relevance of project deliverables
Re-frame deviations if necessary
Control software delivery
Know the fundamentals of an IT contract

Sessions

Contact us for more informations about session date

Project Management: Advanced

Goals


- Train consultants or company staff in the project management methodology, involved in IT projects for customers or in an internal structure

- Acquire best practices, in order to guarantee the quality of deliverables and monitoring of results

Program

Reminder of the principles of project management
Manage project schedules
Manage tasks
Control the schedule of tasks
Optimize resources

Manage costs
Analyze the project and optimize
Communicate
Monitor the project
Capitalize

Evaluate the dimension of the project
Identify the impacts on the processes
Control contractual relationships
Make effective reporting
Define multi-project dashboards
Allocate technical and functional resources between projects
Control advanced planning and scheduling techniques
Know the key points to reduce certain delays
Identify common pitfalls
Apply best practices
Define priority criteria
Make trade-offs

Choose indicators and units of work
Organize and consolidate progress Prepare management decisions
Prepare dashboards
Renegotiate deadlines and budgets
Validate the relevance of project deliverables
Re-frame deviations if necessary
Control software delivery
Know the fundamentals of an IT contract

Duration

2 days

Price

£ 1367

Audience

Managers, Project managers

Prerequisites

Mastery of the basic concepts of project management

Reference

GES100276-F

Sessions

Contact us for more informations about session date

Excel: Using advanced formulas – Condition, search and text

Goals


- Understanding Conditions in Excel Formulas

- Applying Lookup Formulas to an Array

- Understanding Formula Errors

Program

Use condition formulas

Use the SI formula
Nest several SI
Check several conditions in an SI formula

Lab: Applying Conditions to a Data Table

Use search and text formulas

Search
formulas: VLOOKUP, HLOOKUP Text formulas: LEFT, STXT, SEARCH …

Workshop: Applying these formulas to a typical table

Handle formula errors

Recognize a formula error
Analyze the detected error
Evaluate a formula

Duration

0.25 day

Price

£ 2495

Audience

All

Prerequisites

Have followed « Excel: statistical formulas » or have equivalent knowledge

Reference

BUR100974-F

Sessions

Contact us for more informations about session date

PowerPoint Initiation + Advanced and passing of the TOSA certification

Goals


- Learn to create presentations with PowerPoint

Program

PowerPoint presentation
Different uses of the software
Presentation tips

Description of the ribbon
Interface management
Create a new slide show
Using slide show templates

Add / remove slides Slide
layouts
Group your slides into sections
Move a slide

Reserved areas
Inserting and formatting text
Inserting and customizing shapes
Inserting and modifying images
Creating a photo album
Inserting tables
Using WordArt
Graphics and organization charts
Organizing inserted content

Use slide themes
Add a background
Create your own theme

Animating content
Personalizing your animation
Timing of animations (start, duration, delay)
Transitions between slides
Timing of transitions

Launching the slideshow mode
Creating a personalized slideshow
Configure the slideshow
The other display modes
Inserting a header and footer
Adding comments

Adding hypertext links
Adding an action on an object
Inserting multimedia content: audio and video
Printing the document
Managing the slide master
Creating its presentation template

Duration

2 days

Price

£ 750

Audience

Everyone

Prerequisites

Knowledge of Word and Excel

Reference

BUR557-F

  

Compare two presentations
Protect a slide show
Check that there are no problems
Share your presentation
Customize the interface

Definition of presentation objectives
Creation and organization of the plan
Layout of the presentation
Creation of the mask
Creation of standard slides (new part, contents)
Creation of the presentation and animations
Proofreading and corrections

Workshop: Creation of a presentation for your personal or professional project

Synthesis
Questions / Answers

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

Sessions

Contact us for more informations about session date

Very good environment pleasant room and above all. perfect competent animator. I got the answers to my expectations now I just have to do it !! good trainer, attentive, good pace of speaking and very good computer skills.
Guylaine D.
Guylaine D.
Very good. Really good. a personalized course: what more could you ask for?
Marie-chantal D.
Marie-chantal D.
Very pleasant and rich training with a trainer who listens to our questions and needs. Organization very available and attentive to our requests.
Isabelle R.
Isabelle R.
Two days = very intense to remember everything! need to quickly apply perhaps offer a "booster shot" at 3 or 6 months to take stock of achievements and areas for improvement. This training was necessary in the context of my professional activities. As of tomorrow, I will therefore apply all the points seen in training. Thanks to Kevin for his calm and patience.
Marie-Yvette A.
Marie-Yvette A.
Rhythm that allowed the learning of tools. Listening trainer.
Eric F.
Eric F.
Training content corresponding to my expectations. Pleasant, dynamic and attentive trainer.
Christophe H.
Christophe H.
Précédent
Suivant

Word : Fundamentals + Advanced functions + VBA and Passage of the TOSA certification

Goals


- Discover the new features of Office

- Know the main features of Word

- Be able to write a simple letter

- Know how to send a mail merge

- Work in a group

- Introduction to VBA programming

- Know the word objects

Program

Presentation of Word
Description of the ribbon
The ruler
Windows
Display mode
Show / hide formatting marks

Create
Open, save, close
Use recent documents
Create a document based on a template
Save a document in Word 97-2003 format

Select text
Move around the document
Move and duplicate text
Find a character string
Perform a deep search
Replace one string with another
Use automatic spell checking
Replace formatting

The styles for a layout
Add, modify, delete a Style

How to use themes?
Mix themes
Printing and printing options

Design Resize
Insert, move or delete a row
Insert, move or delete a column
Define formatting and wrapping

Margins
Orientation format Page
numbering
Change the format of page numbers Page
borders
Custom header and footer
Print

Duration

5 days

Price

£ 1725

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR410-F

  

Advice and Methodology for creating an attractive document
Application
A simple letter and its envelope
A simple report on 2 pages

Using WordArt
Putting the company logo on a document
Positioning photos
Using the header and footer
Create a new document from existing documents

Create and manage a document on several columns

Prepare Word to manage your templates
Create a template
Use, edit a template
Use templates on Office.com

Print
Fax
Send by email
Send by email in PDF format

Microsoft’s OneDrive service
Creating a OneDrive account
Using the OneDrive service

Create a table of contents
Create a custom table of contents
Update a table of contents
Save a custom table of contents
Define an index entry
Insert the index table
Update an index table

Create a table of figures

Create a form
Insert controls into a form
Use the merge wizard
Prepare to merge
Data source
Main document
Merge

Create a comment
Show / hide comments
Manage comments
Make a document available to several users
Merge documents

Customize the Quick Access Toolbar
Customize the Ribbon

Copy Excel data to Word
Insert an Excel spreadsheet into Word
Create hyperlinks to other applications
Save as HTML

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

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
Text, numeric or date data types
Arrays
Constants
Operators

The Application object
The Document
object
The Paragraphs object
The Range object The Characters 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)

Presentation of the form
Customize a form
Events of form objects
Running / closing a form

Synthesis
Questions / Answers

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

Sessions

Contact us for more informations about session date

Word : Fundamentals + Advanced functions

Goals


- Discover the new features of Office

- Know the main features of Word

- Be able to write a simple letter

- Know how to send a mail merge

- Work in a group

Program

Presentation of Word
Description of the ribbon
The ruler
Windows
Display mode
Show / hide formatting marks

Create
Open, save, close
Use recent documents
Create a document based on a template
Save a document in Word 97-2003 format

Select text
Move around the document
Move and duplicate text
Find a character string
Perform a deep search
Replace one string with another
Use automatic spell checking
Replace formatting

The styles for a layout
Add, modify, delete a Style

How to use themes?
Mix themes
Printing and printing options

Design Resize
Insert, move or delete a row
Insert, move or delete a column
Define formatting and wrapping

Margins
Orientation format Page
numbering
Change the format of page numbers Page
borders
Custom header and footer
Print

Duration

3 days

Price

£ 1125

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR503-F

   

Advice and Methodology for creating an attractive document
Application
A simple letter and its envelope
A simple report on 2 pages

Using WordArt
Putting the company logo on a document
Positioning photos
Using the header and footer
Create a new document from existing documents

Create and manage a document on several columns

Prepare Word to manage your templates
Create a template
Use, edit a template
Use templates on Office.com

Print
Fax
Send by email
Send by email in PDF format

Microsoft’s OneDrive service
Creating a OneDrive account
Using the OneDrive service

Create a table of contents
Create a custom table of contents
Update a table of contents
Save a custom table of contents
Define an index entry
Insert the index table
Update an index table

Create a table of figures

Create a form
Insert controls into a form
Use the merge wizard
Prepare to merge
Data source
Main document
Merge

Create a comment
Show / hide comments
Manage comments
Make a document available to several users
Merge documents

Customize the Quick Access Toolbar
Customize the Ribbon

Copy Excel data to Word
Insert an Excel spreadsheet into Word
Create hyperlinks to other applications
Save as HTML

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

Sessions

Contact us for more informations about session date

Calm and pleasant environment. Competent and attentive trainer. responds well to demands.
David R.
David R.
Rich course and good logic. The support seems very well done at first glance. Adding a small exercise book to introduce the concepts by repetition would be a plus, but not vital. I think it allowed me to fill in gaps so very well at this level even though I already knew a lot. Adequacy with the training plan in any case. Trainer: Very friendly and pleasant teacher to listen to. Do not let yourself be sidetracked by what is not obvious and master your plan well.
Marie-Annick P.
Marie-Annick P.
Thanks for the training
Elena D.
Elena D.
Précédent
Suivant

Word : advanced functions

Goals


- Have an in-depth use of Word

- Know how to direct mail

- Work in a group

Program

Advice and Methodology for creating an attractive document
Application
A simple letter and its envelope
A simple report on 2 pages

Using WordArt
Putting the company logo on a document
Positioning photos
Using the header and footer
Create a new document from existing documents

Create and manage a document on several columns

Prepare Word to manage your templates
Create a template
Use, edit a template
Use templates on Office.com

Print
Fax
Send by email
Send by email in PDF format

Microsoft’s OneDrive service
Creating a OneDrive account
Using the OneDrive service

Create a table of contents
Create a custom table of contents
Update a table of contents
Save a custom table of contents
Define an index entry
Insert the index table
Update an index table

Create a table of figures

Create a form
Insert controls into a form
Use the merge wizard
Prepare to merge
Data source
Main document
Merge

Create a comment
Show / hide comments
Manage comments
Make a document available to several users
Merge documents

Customize the Quick Access Toolbar
Customize the Ribbon

Copy Excel data to Word
Insert an Excel spreadsheet into Word
Create hyperlinks to other applications
Save as HTML

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

Word users

Prerequisites

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

Reference

BUR105-F

  

Sessions

Contact us for more informations about session date

Rich course and good logic. The support seems very well done at first glance. Adding a small exercise book to introduce the concepts by repetition would be a plus, but not vital. I think it allowed me to fill in gaps so very well at this level even though I already knew a lot. Adequacy with the training plan in any case. Trainer: Very friendly and pleasant teacher to listen to. Do not let yourself be sidetracked by what is not obvious and master your plan well.
Marie-Annick P.
Marie-Annick P.
Thanks for the training
Elena D.
Elena D.
Précédent
Suivant

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

Goals


- Discover the new features of Office

- Know the main features of Excel

- Be able to perform calculations and use functions

- Know how to handle graphics and pivot tables

- Introduction to VBA programming

Program

Presentation of Excel
Description of the ribbon
Workbooks and worksheets
Rename, insert, move, delete a worksheet
Move around in the workbook (using the keyboard, menus, mouse)

The different ways of selecting cells
Modifying the height and width of rows / columns
Inserting rows and columns
Formatting the content of the cell (font, colors, etc.)
Borders
Alignment in the cell
Merge cells
Apply a format cell

Creating tables
Automatic formatting
Creating a custom style

The formula bar
Addition, subtraction, multiplication, division
Use of parentheses
Percentage format
Copy calculations

Layout Page
breaks
The printing area
Printing and printing options

The different display modes
Show / hide information
Zoom
Freeze the panes

Duration

5 days

Price

£ 1725

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR407-F

   

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

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

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

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

Excel : Fundamentals + Advanced functions

Goals


- Discover the new features of Office

- Know the main features of Excel

- Be able to perform calculations and use functions

- Know how to handle graphics and pivot tables

Program

Presentation of Excel
Description of the ribbon
Workbooks and worksheets
Rename, insert, move, delete a worksheet
Move around in the workbook (using the keyboard, menus, mouse)

The different ways of selecting cells
Modifying the height and width of rows / columns
Inserting rows and columns
Formatting the content of the cell (font, colors, etc.)
Borders
Alignment in the cell
Merge cells
Apply a format cell

Creating tables
Automatic formatting
Creating a custom style

The formula bar
Addition, subtraction, multiplication, division
Use of parentheses
Percentage format
Copy calculations

Layout Page
breaks
The printing area
Printing and printing options

The different display modes
Show / hide information
Zoom
Freeze the panes

Duration

3 days

Price

£ 1125

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR502-F

  

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

Sessions

Contact us for more informations about session date

Good. Interesting course. Examples adapted to my professional demands. Trainer: Excellent, attentive. Enriching, very attentive trainer.
Daniel R.
Daniel R.
For my part, I prefer training outside the workplace (ie in the premises of the training organization). This allows you to be 100% focused on your own training and cut from your workplace where you may be called upon. For my part, the pace of the training is very (too?) Sustained and we have to go very quickly. Not always the time to take notes. Either we do not take notes or we lose track of what is shown on the video projector. Fortunately, the level of the group was quite homogeneous.
Sandrine B.
Sandrine B.
Exactly what I needed. Trainer: Very available to answer our questions.
Nadine M.
Nadine M.
Very good. Basic training but quite elaborate ... Trainer: S adapts to the intern.
Sylvie K.
Sylvie K.
Very interesting training, which corresponded to my expectations and above all very profitable since there were only 2 of us so we were able to progress well but remains to be practiced ...
Nadia D.
Nadia D.
Very complete course in relation to the choice of internship duration. Many questions were unanswered until now, but thank you Dawan, this is no longer the case! Trainer: Thank you to Kevin for his availability, listening and sympathy. Pleasant and fun training, it was very good!
Jennifer G.
Jennifer G.
The pace was very sustained but the trainer was able to take the time to come back to me personally to help me and give me more explanations. Trainer: very suitable and very understanding, very sympathetic, perfect!
Carole G.
Carole G.
Especially not to suppress the exercises because it is by practicing that one sees the most the comprehension. THANK YOU for this training !
Catherine B.
Catherine B.
Précédent
Suivant

Excel : Advanced functions

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

Office Automation Advanced : Excel + Word + Powerpoint

Goals


- Be able to perform calculations and use formulas with Excel

- Know how to handle graphics and pivot tables

- Have an in-depth use of Word

- Work with reference tables

- Carry out a direct mail; Insert multimedia content on Powerpoint

- Customize the slide master

Program

Use of a referent cell ($)
Reminder on the basic formulas (SUM, AVERAGE, MAX …)
Formulas with condition (IF, NB.SI, SUM.SI …)
Date and time formulas ( TODAY, WEEKDAY …)
Text formulas (SMALL, LEFT, CONCATENATE …)
Search formulas ( VLOOKUP, HLOOKUP )

Workshop: Realization of a summary document with the main Excel formulas

Create named areas and integrate them into formulas
Find antecedents and dependencies in formulas
Check formulas for errors
Change the way your workbook is calculated

Select the data to integrate into the graph
Choose a type of graph according to needs (histogram, curve, sector in 2D or 3D)
Define a quick layout for its graph
Add additional information to the graph (axis title, data labels, curve trend …)
Choose the visual aspect of your graphic via the styles

Apply table updates to associated charts
Change the type of chart
Move a chart within its workbook
Customize the style of its chart
Integrate a chart into an external document (Word, PowerPoint)

Workshop: Generate a graph according to your needs

The principle of a pivot table
Define which calculation and label fields will be
Select the source of its pivot table
Place the fields to analyze
Apply a style to the pivot table

Integrate multiple calculations
Define grouping and sorting criteria
Insert segments
Integrate custom calculation fields

Workshop: Highlight the desired statistics from your table

Integrate subtotals into a table
Convert and consolidate
Data validation
Scenario analysis

Adding and modifying comments
Protect your workbook and sheets

Duration

2 days

Price

£ 750

Audience

Excel users

Prerequisites

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

Reference

BUR100429-F

  

Insert a table (define a number of rows and columns)
Manage the table layout (add / remove cells)
Apply a style to its table
Merge or split cells

Insert and customize a picture
Embed an inline picture
Add shapes to your document
Using WordArt
Add a SmartArt
Create and customize a graphic

Workshop: Enrich your document with several illustrations

Split paragraphs into columns
Configure spaces between these columns
Display a separator line

Prepare Word to manage your templates
Use existing templates
Get a template from Office.com
Create a custom template

Insert and configure a table of contents
Update its table of contents
Insert a footnote
Add citations
Insert captions to illustrations
Add a table of illustrations
Define entries in the index
Insert the index table and put it up to date

Workshop: Integrate several reference tables into your document

Define the type of mail merge (label, envelope, letter …)
Select the source of the recipients
Match the fields between the source and Word
Filter the recipients of a mail merge
Prepare your mail
merge template Insert merge fields
Define rules
Preview the results
Finish and merge

Workshop: Prepare a standard letter for several recipients

Create a comment
Show / hide comments
Manage comments
Enable track changes
Compare two Word documents
Restrict changes

Workshop: Revision of a document

Presentation of Microsoft’s OneDrive service
Creating a OneDrive account
Save a file in your OneDrive space
Share a file or a folder
Define the action rights per user

Workshop: Share a document and work with others on it

Copy Excel data to Word
Insert an Excel spreadsheet into Word
Create hyperlinks to other applications
Save as HTML

Workshop: Import a table and a chart from Excel

Integrate shortcuts into the Quick Access toolbar
Create a tab with your favorite tools

Insert tables
Customize table layout
Charts and flowcharts
Insert audio and video

Insert text from Word
Recover table from Excel
Embed chart from Excel

Create a link to a website
Define a contact link
Add internal navigation links
Use PowerPoint actions

Usefulness of the slide master
Display and customize a layout
Create a new mask
Other types of mask

Compare two presentations
Protect a slide show
Check that there are no problems
Share your presentation
Broadcast your slide show online

Presentation of Microsoft’s OneDrive service
Creating a OneDrive account
Save a file in your OneDrive space
Share a file or a folder
Define the action rights by user

Workshop: Share a presentation and work with others on it

Integrate shortcuts into the Quick Access toolbar
Create a tab with your favorite tools

Revisions
Questions / Answers
Passing the TOSA certification

Passing the certification (if requested by the trainee)

Sessions

Contact us for more informations about session date

Office Automation Advanced : Powerpoint

Goals


- Insert multimedia content

- Customize the slide master

Program

Insert tables
Customize table layout
Charts and flowcharts
Insert audio and video

Insert text from Word
Recover table from Excel
Embed chart from Excel

Create a link to a website
Define a contact link
Add internal navigation links
Use PowerPoint actions

Usefulness of the slide master
Display and customize a layout
Create a new mask
Other types of mask

Compare two presentations
Protect a slide show
Check that there are no problems
Share your presentation
Broadcast your slide show online

Integrate shortcuts into the Quick Access toolbar
Create a tab with your favorite tools

Definition of presentation objectives
Creation and organization of the plan
Layout of the presentation
Creation of the mask
Creation of standard slides (new part, contents)
Creation of the presentation and animations
Proofreading and corrections

Workshop: Creation of a presentation for your personal or professional project

PowerPoint Revisions
Questions / Answers
Passing the PCIE certification

Passing the certification (if requested by the trainee)

Duration

1 day

Price

£ 375

Audience

PowerPoint users

Prerequisites

Have followed the « PowerPoint: Initiation » course or have equivalent knowledge

Reference

BUR1161-F

  

Sessions

Contact us for more informations about session date

Office Automation Advanced : Word

Goals


- Have an in-depth use of Word

- Work with reference tables

- Conduct a mail merge

Program

Insert a table (define a number of rows and columns)
Manage the table layout (add / remove cells)
Apply a style to its table
Merge or split cells

Insert and customize a picture
Embed an inline picture
Add shapes to your document
Using WordArt
Add a SmartArt
Create and customize a graphic

Workshop: Enrich your document with several illustrations

Split paragraphs into columns
Configure spaces between these columns
Display a separator line

Prepare Word to manage your templates
Use existing templates
Get a template from Office.com
Create a custom template

Insert and configure a table of contents
Update its table of contents
Insert a footnote
Add citations
Insert captions to illustrations
Add a table of illustrations
Define entries in the index
Insert the index table and put it up to date

Workshop: Integrate several reference tables into your document

Define the type of mail merge (label, envelope, letter …)
Select the source of the recipients
Match the fields between the source and Word
Filter the recipients of a mail merge
Prepare your mail
merge template Insert merge fields
Define rules
Preview the results
Finish and merge

Workshop: Prepare a standard letter for several recipients

Create a comment
Show / hide comments
Manage comments
Enable track changes
Compare two Word documents
Restrict changes

Workshop: Revision of a document

Copy Excel data to Word
Insert an Excel spreadsheet into Word
Create hyperlinks to other applications
Save as HTML

Workshop: Import a table and a chart from Excel

Integrate shortcuts into the Quick Access toolbar
Create a tab with your favorite tools

Passing the certification (if requested by the trainee)

Duration

2 days

Price

£ 750

Audience

Word users

Prerequisites

Have followed the « Word: Initiation » course or have equivalent knowledge

Reference

BUR1183-F

 

Sessions

Contact us for more informations about session date

Office Automation Advanced : Excel

Goals


- Be able to perform calculations and use formulas

- Know how to handle graphs and pivot tables

Program

Use of a referent cell ($)
Reminder on the basic formulas (SUM, AVERAGE, MAX …)
Formulas with condition (IF, NB.SI, SUM.SI …)
Date and time formulas ( TODAY, WEEKDAY …)
Text formulas (SMALL, LEFT, CONCATENATE …)
Search formulas ( VLOOKUP, HLOOKUP )

Workshop: Realization of a summary document with the main Excel formulas

Create named areas and integrate them into formulas
Find antecedents and dependencies in formulas
Check formulas for errors
Change the way your workbook is calculated

Select the data to integrate into the graph
Choose a type of graph according to needs (histogram, curve, sector in 2D or 3D)
Define a quick layout for its graph
Add additional information to the graph (axis title, data labels, curve trend …)
Choose the visual aspect of your graphic via the styles

Apply table updates to associated charts
Change the type of chart
Move a chart within its workbook
Customize the style of its chart
Integrate a chart into an external document (Word, PowerPoint)

Workshop: Generate a graph according to your needs

The principle of a pivot table
Define which calculation and label fields will be
Select the source of its pivot table
Place the fields to analyze
Apply a style to the pivot table

Integrate multiple calculations
Define grouping and sorting criteria
Insert segments
Integrate custom calculation fields

Workshop: Highlight the desired statistics from your table

Integrate subtotals into a table
Convert and consolidate
Data validation
Scenario analysis

Adding and modifying comments
Protect your workbook and sheets

Passing the certification (if requested by the trainee)

Duration

2 days

Price

£ 750

Audience

Excel users

Prerequisites

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

Reference

BUR100429-F

 

Sessions

Contact us for more informations about session date

Crystal Reports : Initiation + Advanced

Goals


- Improve performance on Crystal Reports All versions

- Create reports

- Advanced functions

Program

Database concepts
Prototype development
Concept of Workbench

Creation of reports with the wizard or not
Connection to the data source
Selection of tables
Presentation of the development interface
Vocabulary
Using the wizard for creating reports
Creating reports without the wizard
Formatting fields
Report property
Recording

Practical workshop: Creating a report without the wizard

Using the selection
wizard Outer joins

Workshop: Record selection

Sorting records
Grouping data
Calculations
Summary

Practical workshop: Sorting and grouping

Adding graphic elements (lines, frames, images)
Using and formatting special fields

Practical workshop: Formatting the report

Creating and formatting sections

Practical workshop: Formatting sections

Definition and creation of formulas
Boolean type
formulas If Then Else type formulas
Calculations on dates and numbers
Handling character strings

Practical workshop: Simple formulas

Trends
Conditional formatting of data 

Workshop: Conditional formatting

Using the chart wizard
Creating the chart located in a Group or in the Report Header
Discovering the different tabs
Selecting the chart type
Example of chart by group
Displaying Legends and Data Labels
Formatting axis labels
Graph options
Formatting of the legend

Practical workshop: The Graphs

Export in other formats (pdf, html, xls …)
Export of the document on a Crystal server

Practical workshop: Distribution of reports

Duration

4 days

Price

£ 1878

Audience

Consultants, developers, business intelligence project managers

Prerequisites

SQL language

Reference

BUS100047-F

Using the Repository Explorer
Saving Files to the Repository
Adding Objects or Images to the Repository
Editing Repository Objects
SQL Commands

Using functions and operators
Using Crystal language and syntax (presentation)
Functions: Strings
Nested
functions Mathematical and Boolean
functions Miscellaneous functions

Practical workshop: Miscellaneous and nested functions

Using the Project Manager: The Workbench
Using Variables and Tables

Variables
Differences between Visual Basic and Crystal Report
syntax SWITCH function (Visual or Crystal syntax)

Practical workshop: Declaration and use of variables

Model expert
Building a model without a data source

Practical workshop: Using models

Add Parameter Fields
Conditional Formatting of Fields

Lab: Creating a Simple Parameter

Creating a crosstab
Modify the options of the
crosstab wizard Customizing a crosstab without an assistant
Using calculated fields in a TC (New)

Practical workshop: Cross tables

Section management

Multi-column management

Cumulative total fields

Practical workshop: Cumulative total

Export in other formats (pdf, html, xls …)
Export of the document on a Crystal server

Practical workshop: Distribution of reports

Practical workshop: Alert report 

Practical workshop: Report N Best

Practical workshop: Conditional management of dynamic images 

Practical workshop: Inserting Xcelsius elements

Sessions

Contact us for more informations about session date

Update of my own requests, useful to my company. Trainer: top! explains in detail. stops to return to pre-existing gaps. Clear and concise.
Myriam G.
Myriam G.

Crystal Reports : Advanced

Goals


- Improve performance on Crystal Reports All versions

- Create reports

- Advanced functions

Program

Using the Repository Explorer
Saving Files to the Repository
Adding Objects or Images to the Repository
Editing Repository Objects
SQL Commands

Using functions and operators
Using Crystal language and syntax (presentation)
Functions: Strings
Nested
functions Mathematical and Boolean
functions Miscellaneous functions

Practical workshop: Miscellaneous and nested functions

Using the Project Manager: The Workbench
Using Variables and Tables

Variables
Differences between Visual Basic and Crystal Report
syntax SWITCH function (Visual or Crystal syntax)

Practical workshop: Declaration and use of variables

Model expert
Building a model without a data source

Practical workshop: Using models

Add Parameter Fields
Conditional Formatting of Fields

Lab: Creating a Simple Parameter

Creating a crosstab
Modify the options of the
crosstab wizard Customizing a crosstab without an assistant
Using calculated fields in a TC (New)

Practical workshop: Cross tables

Section management

Multi-column management

Cumulative total fields

Practical workshop: Cumulative total

Export in other formats (pdf, html, xls …)
Export of the document on a Crystal server

Practical workshop: Distribution of reports

Practical workshop: Alert report 

Practical workshop: Report N Best

Practical workshop: Conditional management of dynamic images 

Practical workshop: Inserting Xcelsius elements

Duration

4 days

Price

£ 943

Audience

Consultants, developers, business intelligence project managers

Prerequisites

SQL language

Business function

Reference

BUS100045-F

Sessions

Contact us for more informations about session date

Update of my own requests, useful to my company. Trainer: top! explains in detail. stops to return to pre-existing gaps. Clear and concise.
Myriam G.
Myriam G.

Business Objects BI 4.2 : Webi Initiation + Advanced

Goals


- Create simple WebI documents using BI Launch Pad

- Implement the query editor to feed its documents with the relevant data of your choice

- Enhance and format your business data with graphs

- Go further with functions

- Merge dimensions

- Create complex queries

Program

What is business intelligence?
What is Business Objects  ?
Other Business Objects software
The question: who does what?
The specificity of Business Objects  : the
Vocabulary semantic layer

View documents
Manage documents (rename, delete, file)
Schedule execution and delivery of documents
Change portal preferences
Create my InfoView (my home page)
Improved search

Know the elements available in a universe
Presentation of the query editor
Presentation of the data formatting interface
Modify an existing document / add data and display them
Managing the reports of a document
Create simple vertical, horizontal tables
Create forms
Create cross tables
Create charts

Create your query filters (express or advanced)
Use the different operators (« Equal to », « In list », « Corresponds to the model » …)
Query filter with prompt (dynamic choice of the values ​​of the criterion)
Query with prompt: purge data and automatic refresh, configuration of the operation of the prompt
Combine query filters: AND operator, OR operator, combine AND and OR operators
Concept of contexts
Properties of a query

Create sections
Create table breaks, table
formatting Cell
formatting Report formatting
Create fixed filters
Create dynamic filters by input controls
Create ranking
Apply conditional formatting

Create a query filter
Use the « Equal to »
operator Use the « In list »
operator Use the « Match the model
 » operator Use the « between » operator
Create a query filter with a prompt
Apply multiple query filters
Connect filters by « and »
Connect filters by « or »
Manage the priorities between the filters
Concept of context

Create variables
Create a simple calculation
Transform calculations into a variable

Duration

4 days

Price

£ 1887

Audience

Users, Business Intelligence Project Manager

Prerequisites

Spreadsheet knowledge

Reference

BUS989-F

Create simple graphs – practice
Turn a table into a graph – practice
Properties of graphs – practice
Stock market chart – practice
Bubble chart – practice
Keyword cloud chart – practice

Formatting cells (reminder)
Pre-programmed cells – Practice
Complete the data with your calculations, create variables
Create a simple calculation and transform it into a variable – practice
Use the functions
The functions and the writing rules
Functions – practice

Reminder on query filters
Combining query filters
Managing priorities between query filters
Using complex operators
Going beyond the limits of complex operators
Combining queries (Minus)
Combining queries (Intersection)
Combining queries (Union)
Usefulness of sub- queries
Create a subquery (InList, ALL)

Add a new request to a document
Automatic
synchronization Manual synchronization
Multi requests in a document: automatic synchronization or not
Delete synchronization
Practice: multi request document and synchronization

Limit of automatic calculations
Benefit of extended automatic syntax in formulas
Use the « where » operator to specify a context
Use the « in » operator to specify a context
Interpretation of the « #VALEURMULTI » error
Calculation context and context d ‘display
Use the « ForAll »
operator Use the « ForEach » operator

Passing the certification (if provided for in the funding)

Sessions

Contact us for more informations about session date

The content corresponded to my expectations. The course and timing were very precise and adapted to the duration. The required level was well in relation to my situation. I found Mr. Lefloch excellent in his role as trainer. His communication is fluid and pleasant, punctuated with relevant examples and illustrations. From a technical point of view, he perfectly masters his field. I will be sure to promote your business to anyone in need of this type of education.
Marcel C.
Marcel C.
Course progression is appropriate for both initiates and the uninitiated. Interesting exercises, application adapts to the chapters seen previously, the corrections? and if necessary reminders, are clear. Total adequacy with my professional needs, updates of certain functions, the deepening of the requests carried out on BO will serve me to develop and finalize certain results that I had left in suspense for lack of knowledge. The concepts provided at the end of the internship, in particular the contexts, are well presented and will for my part be used to deepen the BO possibilities. Trainer: Very good assistance, listening, communication.
Murielle A.
Murielle A.
Building very accessible by public transport. Pleasant and well-equipped premises. Very competent and very pleasant trainer at the interpersonal level.
Myriam C.
Myriam C.
Very pleasant environment. Very rich course, and good alternation between theory and practice.
Alexandre M.
Alexandre M.
Trainer: Listening, very pedagogue, a big congratulations.
Dalila S.
Dalila S.
Pleasant trainer, educator, available and with a good command of the tool.
Remy L.
Remy L.
Précédent
Suivant

Business Objects BI 4.2 : Webi Advanced

Goals


- Go further with functions

- Merge dimensions

- Create complex queries

Program

Create simple graphs – practice
Turn a table into a graph – practice
Properties of graphs – practice
Stock market chart – practice
Bubble chart – practice
Keyword cloud chart – practice

Formatting cells (reminder)
Pre-programmed cells – Practice
Complete the data with your calculations, create variables
Create a simple calculation and transform it into a variable – practice
Use the functions
The functions and the writing rules
Functions – practice

Reminder on query filters
Combining query filters
Managing priorities between query filters
Using complex operators
Going beyond the limits of complex operators
Combining queries (Minus)
Combining queries (Intersection)
Combining queries (Union)
Usefulness of sub- queries
Create a subquery (InList, ALL)

Add a new request to a document
Automatic
synchronization Manual synchronization
Multi requests in a document: automatic synchronization or not
Delete synchronization
Practice: multi request document and synchronization

Limit of automatic calculations
Benefit of extended automatic syntax in formulas
Use the « where » operator to specify a context
Use the « in » operator to specify a context
Interpretation of the « #VALEURMULTI » error
Calculation context and context d ‘display
Use the « ForAll »
operator Use the « ForEach » operator

Passing the certification (if provided for in the funding)

Duration

2 days

Price

£ 943

Audience

Users, Business Intelligence Project Manager

Prerequisites

Spreadsheet knowledge

Reference

BUS991-F

Sessions

Contact us for more informations about session date

The content corresponded to my expectations. The course and timing were very precise and adapted to the duration. The required level was well in relation to my situation. I found Mr. Lefloch excellent in his role as trainer. His communication is fluid and pleasant, punctuated with relevant examples and illustrations. From a technical point of view, he perfectly masters his field. I will be sure to promote your business to anyone in need of this type of education.
Marcel C.
Marcel C.

Business Objects XI R3 : Webi Initiation + Advanced

Goals


- Discover Webintelligence XI

- Use data

- Generate graphs

- Create reports

- Go further with functions

- Merge dimensions

- Create complex queries

Program

What is business intelligence?
What is Business Objects  ?
Other Business Objects software
The question: who does what?
The specificity of Business Objects  : the
Vocabulary semantic layer

Connect to Infoview
Navigation
The homepage
Set InfoView and WebIntelligence
View / edit a document WebIntelligence
Save a public document in my files
Export a document to Excel or PDF
Configure  » My Infoview « 
Use with the Infoview

Create a new WebI document
Know the elements available in a universe
The java query editor
Description of the training universe
Create a query and run it
To the report! Manipulate data
Duplicate a report (manage document reports)
Transform a vertical table into a crosstab
Transform a vertical table into a graphic
Print a document
Save a document
Create a personal folder
Organize your documents

Handling blocks
The report editor
Create several blocks
Insert an object in an existing table
Modify the structure of a crosstab
Display the structure
Delete a column
Delete a table

Create a chart
Turn a table into a chart
Change the structure of a chart
Format a chart
Change properties

Create a query filter
Use the « Equal to »
operator Use the « In list »
operator Use the « Match the model
 » operator Use the « between » operator
Create a query filter with a prompt
Apply multiple query filters
Connect filters by « and »
Connect filters by « or »
Manage the priorities between the filters
Concept of context

The challenges of the multi-query
Create a new document
Add a second query
Introduction to the insertion
mode Choose the insertion mode of the new block
Name the queries and rerun them
Manage the queries
Presentation of merging dimensions

Create a new document with several blocks
Insert a break
Insert a simple calculation
Insert a sort
Insert a custom sort
Insert / Remove an express filter
Apply a global filter
Manage the report filters
Insert a section
Perform a calculation in a section
Insert a new block in a section
Modify the master
Insert alerters
Manage alerters
Insert a classification

Format tables
Modify the « general » and « display » properties of a table
Modify the « appearance » properties of a table
Modify the « page » and « position » properties of a table
Modify the « break » and « sorts » of a table
Format cells
Modify the « general » and « display » properties of a cell
Modify the « appearance » properties of a cell
Modify the number format of a cell
Modify the « break » properties « of a cell
Modify the » page « propertiesof a cell
Format sections
Modify the properties of a section

Insert a column in a table to place a calculation
Presentation of the formula editor
Create a formula
Transform a formula into a variable
Use functions (examples)
Manage variables

Define the scope of analysis
Explore in a table
Explore in a chart
Freeze an exploration level
Modify the scope of analysis
Insert exploration filters

Duration

4 days

Price

£ 1887

Audience

Users, Business Intelligence Project Manager

Prerequisites

Spreadsheet knowledge

Reference

BUS879-F

Reminders on formulas and variables
Create a formula
Transform a formula into a variable
Manage variables
User response function on a multi-query document
Replace function
Use of logical test Si
function
Use the if function to create groupings
Cumulative sum
function Date functions

Reminder on multi-query documents
Automatic synchronization
Display in a table of data coming from separate sources
Usefulness of synchronization
Case of objects that cannot be merged, problem solving

Reminder on query filters
Combine query filters
Manage priorities between query filters
Use complex operators (« at a time »)
Use complex operators (« except »)
Go beyond the limits of complex operators
Combine queries (« minus « )
Combine queries ( » intersection « )
Combine queries ( » union « )
Usefulness of subqueries
Create an » all « subquery
Create an » any « subquery

Limit of automatic calculations
Benefit of extended automatic syntax in formulas
Use the « where » operator to specify a context
Use the « in » operator to specify a context
Interpretation of the « #MULTIVALUE » error
Use the « ForAll operator « 
Use the » ForEach « operator

Sessions

Contact us for more informations about session date

Business Objects XI R3 : Webi Advanced

Goals


- Go further with functions

- Merge dimensions

- Create complex queries

Program

Reminders on formulas and variables
Create a formula
Transform a formula into a variable
Manage variables
User response function on a multi-query document
Replace function
Use of logical test Si
function
Use the if function to create groupings
Cumulative sum
function Date functions

Reminder on multi-query documents
Automatic synchronization
Display in a table of data coming from separate sources
Usefulness of synchronization
Case of objects that cannot be merged, problem solving

Reminder on query filters
Combine query filters
Manage priorities between query filters
Use complex operators (« at a time »)
Use complex operators (« except »)
Go beyond the limits of complex operators
Combine queries (« minus « )
Combine queries ( » intersection « )
Combine queries ( » union « )
Usefulness of subqueries
Create an » all « subquery
Create an » any « subquery

Limit of automatic calculations
Benefit of extended automatic syntax in formulas
Use the « where » operator to specify a context
Use the « in » operator to specify a context
Interpretation of the « #MULTIVALUE » error
Use the « ForAll operator « 
Use the » ForEach « operator

Duration

2 days

Price

£ 943

Audience

Users, Business Intelligence Project Manager

Prerequisites

Spreadsheet knowledge

Reference

BUS881-F

Sessions

Contact us for more informations about session date

Django : Advanced

Goals


- Develop a robust web application with the Django framework

Program

Framework structure
Django installation packages and dependencies

Access to data with Django
The ORM Django: configuration, features
Mapping of entities: management of keys, fields
Management of concurrency
Mapping of associations
Management of inheritance
Request the database  
Management of the cache
 
Workshop: implementation of a data access layer with Django

Site administration: objects, media, options
Customization of the interface
Sending emails
Authentication management
Internationalization (I18N)
Interconnection with social networks
Testing and deployment of the application

Workshop: I18N of the application and authentication management

Passing of the certification (if foreseen in the financing).

Duration

2 days

Price

£ 1018

Audience

Python Developers

Prerequisites

Have taken the Django Initiation course or equivalent concepts

Reference

PYT100604-F

Sessions

Contact us for more informations about session date

Django : Initiation + Advanced

Goals


- Develop a robust web application with the Django framework

Program

Pattern MVC: structure, interest
Django framework: presentation, versions, documentation
Django vs other python web frameworks (pylons, turbogears, web2py)
Development environment
Django installation packages and dependencies
Web server configuration

Workshop: Installing Django (environment, dependencies)

Structure of a project
Controls / Essential components
Templating with Django: principle
Definition of modifiable regions
Inheritance of templates
Construction of views
Generic views

Workshop: Construction of a template and implementation of forms

Creation of forms and data retrieval
Validation of entries
Use of jQuery, yui
Data export (pdf, csv, …) Upload
management
Persistence contexts :
– use of the session
– global application variables
– use of cookies
– cache control
– browser-side persistence context exploitation: sessionStorage, localStorage
AJAX requests
URL routing

Workshop: Building a complete site with Django

Access to data with Django
The ORM Django: configuration, features
Mapping of entities: management of keys, fields
Management of concurrency
Mapping of associations
Management of inheritance
Request the database  
Management of the cache
 
Workshop: implementation of a data access layer with Django

Site administration: objects, media, options
Customization of the interface
Sending emails
Authentication management
Internationalization (I18N)
Interconnection with social networks
Testing and deployment of the application

Workshop: I18N of the application and authentication management

Passing of the certification (if foreseen in the financing).

Duration

5 days

Price

£ 2564

Audience

Python Developers

Prerequisites

Mastery of object programming in Python

Reference

PYT100590-F

Sessions

Contact us for more informations about session date

Trainer: Very good knowledge of the field and very good ability to transmit it to students.
Olivier F.
Olivier F.

Advanced Python : ORM

Goals


- Implement a data access layer with an ORM

Program

– Pattern DAO (Data Access Object)
– ORM Frameworks: functionalities, interest
– Python ORMs: SQLAlchemy, Django ORM, PonyORM, SQLObject, Peewee, …
– Mapping of tables and management of primary keys (simple, compound)
– Mapping of database types, column properties
– Concurrency management: optimistic (versioning), pessimistic
– Relationship management: OneToMany / ManyToOne, OneToOne, ManyToMany
– Cascades configuration –
Collection management
– Inheritance mapping
– Loading strategies: Lazy or Eager

Workshop: Realization of a global mapping diagram of a database

– Object request language
– Basic selections, filters
– Complex joins
– Aggregation, chain functions, …
– Lazy / Eager load management

Workshop: Performing CRUD (Create Read Update Delete) operations – complex requests

– Entity life cycle and validation
– Interceptors, Event-listeners
– Advanced configuration: performance and functionalities
– Use of the cache
– Websockets servers in Python

Workshop: Implementation of interceptors and cache management.

Workshop: Implementation of a chat room using websockets.

Passing of the certification (if foreseen in the financing).

Duration

2 days

Price

£ 1477

Audience

Python Developers

Prerequisites

Have followed the course "Python: Initiation + Deepening" or equivalent concepts

Reference

PYT100615-F

Sessions

Contact us for more informations about session date

Advanced Python : Web Services

Goals


- Building an API in Python

Program

– Presentation of Web Services (WS): operation, interest, interoperability
– Service oriented architecture (SOA): components, technologies
– Technologies: REST architecture, Websockets
– Web service platforms
– Choice of implementation
– Design and documentation: Swagger
– Web services test tools

Workshop: Installation of the development and execution environment, choice of a WebService implementation, description of a service

– REST architecture: components, call methods
– Flask or Django: presentation of tools for REST services
– Sending of parameters, validations
– Type of response, format
– Error
handling – Deployment of a RESTful service
– Query of web services REST (Python / Javascript)

Workshop: Creation and query of a REST API

– Security levels
– Authentication management in a web service
– Rights management
– Message level cryptography
– Message signatures
– Available security standards

Workshop: global API security

Passing of the certification (if foreseen in the financing).

Duration

3 days

Price

£ 1708

Audience

Python Developers

Prerequisites

Have followed the course "Python: Initiation + Deepening" or equivalent concepts

Reference

PYT100614-F

Sessions

Contact us for more informations about session date

Advanced Python : Web Services + ORM

Goals


- Build an API in Python and implement a data access layer with an ORM

Program

– Presentation of Web Services (WS): operation, interest, interoperability
– Service oriented architecture (SOA): components, technologies
– Technologies: REST architecture, Websockets
– Web service platforms
– Choice of implementation
– Design and documentation: Swagger
– Web services test tools

Workshop: Installation of the development and execution environment, choice of a WebService implementation, description of a service

– REST architecture: components, call methods
– Flask or Django: presentation of tools for REST services
– Sending of parameters, validations
– Type of response, format
– Error
handling – Deployment of a RESTful service
– Query of web services REST (Python / Javascript)

Workshop: Creation and query of a REST API

– Security levels
– Authentication management in a web service
– Rights management
– Message level cryptography
– Message signatures
– Available security standards

Workshop: global API security

– Pattern DAO (Data Access Object)
– ORM Frameworks: functionalities, interest
– Python ORMs: SQLAlchemy, Django ORM, PonyORM, SQLObject, Peewee, …
– Mapping of tables and management of primary keys (simple, compound)
– Mapping of database types, column properties
– Concurrency management: optimistic (versioning), pessimistic
– Relationship management: OneToMany / ManyToOne, OneToOne, ManyToMany
– Cascades configuration –
Collection management
– Inheritance mapping
– Loading strategies: Lazy or Eager

Workshop: Realization of a global mapping diagram of a database

– Object request language
– Basic selections, filters
– Complex joins
– Aggregation, chain functions, …
– Lazy / Eager load management

Workshop: Performing CRUD (Create Read Update Delete) operations – complex requests

– Entity life cycle and validation
– Interceptors, Event-listeners
– Advanced configuration: performance and functionalities
– Use of the cache
– Websockets servers in Python

Workshop: Implementation of interceptors and cache management.

Workshop: Implementation of a chat room using websockets.

Passing of the certification (if foreseen in the financing).

Duration

5 days

Price

£ 2564

Audience

Python Developers

Prerequisites

Have followed the course "Python: Initiation + Deepening" or equivalent concepts

Reference

PYT100613-F

Sessions

Contact us for more informations about session date

Python Advanced

Goals


- To be able to predict, develop, test, deploy a complete and complex application in Python

Program

General overview
Python reminders

File handling
Parsing Xml, JSON
Log management with Python
Code documentation and HTML rendering generation
Use databases with Python, DBAPI

Workshop: Handling of files and operations linked to an SQLite database.

Graphics libraries in Python
Tkinter vs PyQT or other
graphics Widgets
Menus
Positioning of components
Window
management Event management

 Workshop: Implementation of a complete graphical interface of an application

Passing of the certification (if foreseen in the financing).

Duration

2 days

Price

£ 1091

Audience

All

Prerequisites

Have followed the Python initiation course or have equivalent knowledge

Reference

PYT251-F

Sessions

Contact us for more informations about session date

Very good teacher, pedagogue with good examples; very good support delivered at the end of the training .
Olivier Z
Olivier Z

Python Initiation + Advanced

Goals


- Know the possibilities and limits of Python

- Master the essential syntax of Python

- Be able to create and maintain complete and complex applications in Python

Program

History, alternatives
About Python 2 and Python 3
Presentation and installation of Python in a Windows or Linux environment
Implementation of Python: access to the terminal
Assisted development environments; association with known tools and practical editors

Workshop: Setting up a development environment

Basic syntax, in direct interpretation and in script
Declare variables in Python, internal types and their use
Use operators and expressions
Presentation and detail of control structures: tests, loops
Use loops and tests to perform algorithms
Use tables, various algorithms for processing big data
Types of data and advanced operations (sets, dictionaries, scheduling, etc.)
Exception management

Workshop: Multiple algorithms to master the basic syntax.

Interest of code structures in the project and for the group of projects
Create and organize functions
Return of functions, absence of return, multiple returns and interest in a complex algorithm
Namespaces, manipulation
Creation of function libraries, documentation
Operations strings number of characters
Calculate with Python
Manage dates, times, time intervals with Python
Various functions required

Workshop: Building a library of functions

Different programming styles, contributions of the object
Object and classes
Management of attributes and methods
Instantiation, destruction
Encapsulate data and use properties
Aggregation of objects
Single and multiple inheritance
Polymorphism
Introspection
Use of interfaces
UML modeling: class diagrams, d ‘objects

Workshop: UML design of an application and implementation of business classes

File handling
Parsing Xml, JSON
Log management with Python
Code documentation and HTML rendering generation
Use databases with Python, DBAPI

Workshop: Handling of files and operations linked to an SQLite database.

Graphics libraries in Python
Tkinter vs PyQT or other
graphics Widgets
Menus
Positioning of components
Window
management Event management

 Workshop: Implementation of a complete graphical interface of an application

Passing of the certification (if foreseen in the financing).

Duration

5 days

Price

£ 2564

Audience

All

Prerequisites

No

Reference

PYT211-F

Sessions

Contact us for more informations about session date

Trainer: Excellent teacher, clear, able to adapt to different audiences, able to adapt to different audiences, in an atmosphere that is both studious and friendly.
Natacha M.
Natacha M.
Many aspects of python practice have been discussed, moreover, relevant to our needs. It was perfect
Luc J.
Luc J.
Very complete nickel. Trainer: RAS, and thanks for the beer!
Simon D.
Simon D.
great to be able to work under linux I remember the very logical sequence of the Instructor course : thank you, it adapts very well to the public
Marianne T.
Marianne T.
Trainer: great!
Christophe B.
Christophe B.
Very good teacher, pedagogue with good examples; very good support delivered at the end of the training .
Olivier Z
Olivier Z
expert trainer -> must perhaps work on the "popularization" of the subject to better adapt to his audience (lack of diagrams, etc.) but generally a trainer attentive to our questions and our needs
Geraldine L.
Geraldine L.
Sufficient technical resources for training Considering the size of the reference medium, it is undoubtedly very good. Trainer: Pace sometimes too fast Sometimes speaking too quickly
Jean-loup R.
Jean-loup R.
Sufficient technical resources for training Considering the size of the reference medium, it is undoubtedly very good. Trainer: Pace sometimes too fast Sometimes speaking too quickly
Jean-loup R.
Jean-loup R.
Satisfactory work environment The course is very interesting. However, for a person who has never done programming, it would be relevant to offer a programming initiation day before attacking a language; This training allowed me to have tracks adapted to my needs. Trainer: He has a fairly advanced technical mastery. At the communication level, for a beginner, more popularization is needed.
Malika T.
Malika T.
A week is a bit quick to deal with all of this, but it's enough to get a good overview and start getting involved in Python projects. Nothing to say, excellent training center, and I think very hard of Dawan for my next training needs.
Vincent M.
Vincent M.
Very interesting course which perfectly met my expectations. Perfect!!! Maybe spend more time on database management which is just covered at the end of the training a few hours. Trainer: Very good, attentive and patient. very knowledgeable and able to answer all questions.
Frederic V.
Frederic V.
Précédent
Suivant

Talend Open Studio Data Integration : Initiation + Advanced

Goals


- Understand the data integration process

- Master the Talend Open Studio tool and the component library

Program

Data
integration issue Operational and Business Intelligence Integration
ETL (Extract Transform Load) tools available
Talend Open Studio: presentation, licenses, link with Eclipse
Support available: documentation, community, etc.

Workshop: Installation and presentation of the Talend Open Studio environment

Talend perspectives and views
Using the Business Modeler
Jobs: grid, palette of components
Main flows (main)
The notion of schema: types of columns
First components: input, output, flow generation

Practical workshop: creation and execution of a simple job, generation of content in a file

Input components (tFileInput, tMysqlInput,…)
Generation of content (tRowGenerator, tFixedFlowInput, …)
Outputs and display (tLogRow, tFileOutput, tMysqlOutput,…)
Logic and chaining of components
Step by step monitoring of execution traces of the Reject
management job
Simple transformations (filter, sort, replace, join)

Practical workshop: generation of content in a database, extraction and processing of data for display in console

Job versions and statuses
Metadata: properties and schemas.
Schema discovery for CSV files
Retrieving database schemas
Job updates from metadata

Practical workshop: inserting data sources and targets in the repository metadata

Use variables in a job (tSetGlobalVar)
Setting up a context local to the job
Context groups in the repository
Metadata as contexts

Practical workshop: use a variable in a job, contextualize the parameters of a metadata, create a test and production context

The ETL component par excellence
Managing inputs: main, secondary flows, naming of flows
Managing outputs: the integrated editor of tMap
Filtering data: input, output
Joint outputs, capture of output rejects, internal join
The expression editor
Performances

Practical workshop: multi-source, multi-destination extraction with a tMap, on a complete example

Parallel executions of sub-jobs
Talend triggers
Chaining of sub-jobs and components (OnSubjobOK, OnComponentOK)
Management of component errors, sub-job (OnComponentError, OnSubjobError)
Start and end component (tPreJob, tPostJob)
Catch and throw errors: tWarn, tDie, tLogCatcher

Practical workshop: assemble several jobs into one, factorize error management to generate a report file

Duration

5 days

Price

£ 2568

Audience

System administrators / BDD, Project managers, Developers

Prerequisites

Knowledge of Java

Reference

BUS305-F

Differentiate between main streams from iterate streams
Loops and programming via tLoop, tForeach
Switch from a main stream to an iterate stream, and vice versa (tFlowToIterate, tIterateToFlow) Job
synchronization with tWaitForFile, tWaitForSocket, tWaitForSQL

Lab: parallelize subjobs, synchronize jobs with external event

Use of advanced components: Java or regular expressions
The specificity of XML feeds in Talend
Code reuse: routines

Workshop: Using the tJavaRow, tJavaFlex components, using the embedded Java editor, deploying a custom routine

Reminders on debugging traces
Using the Java Debug mode: Debug perspective, step-by-step mode
Visualization and hot modification of variables

Workshop: Basic / advanced task debugging

Reminder on the contexts
Export of jobs for execution on a server
Passage of context between jobs, at runtime
Use of a file to load the context (tContextLoad)

Workshop: Deployment of tasks and dynamic loading of the context

Use of advanced components: Java or regular expressions
Creation of specific logs
Management of XML flows
Reuse of code

Workshop: Use of the tJavaRow, tJavaFlex components – creation of logs with tCatch, tDie … – use of the embedded Java editor

Essential concepts for extending Talend Open Studio
Creation of the component mockup with tJavaFlex / graphical interface
Discover the Talend forge and its community components
Integration into Talend Open Studio of the plugins created or downloaded

Workshop: Creation of a simple component via tJavaFlex, integration of components from the Talend forge

Sessions

Contact us for more informations about session date

I had been using Talend for a year without prior training. I had insisted with my management to follow this training and I do not regret it at all. Thanks to this, I will be able to immerse myself in all my achievements and review my way of coding, because there is really a way to do much better than what I was proposing until now.
Gilles D.
Gilles D.
Everything to get off to a good start on Talend and be able to put small jobs into production quickly. Very well constructed training. The exercises allow you to have a clear vision of what you can do with the Trainer tool : A bit fast flow which does not allow you to have a second of inattention otherwise you are quickly lost! Excellent training, very interesting.
Stéphane D.
Stéphane D.
The practicals are very well thought out and the logical continuation of the training is very relevant. I was surprised by the support left to the trainees: the Talend approved book. It's a change from paper course materials from a powerpoint that you then leave at the bottom of a drawer. Thanks for this book. The trainer's speech rate is a bit fast at times. But he takes the time to re-explain if necessary and his teaching skills are excellent. He never left us lost. Thank you for this excellent training!
Jean-baptiste M.
Jean-baptiste M.
Maybe a little intense. I would perhaps have appreciated that it went a little slower to have more time for personal note taking and to ensure a good understanding. I dread the application alone after the training a bit. I will be able to correct my errors in my already created Talend Jobs. I will also be able to configure and industrialize my work and thus save more time. Trainer who masters are subject. He is very educational and transmits his taste for the tool. Maybe just a bit fast but mostly due to the pace of the training which I found fast and dense for me. Very Good Training which corresponds exactly to my expectations. Very good and very nice trainer.
Karine C.
Karine C.
Ideal training room for a small group. Close to Lyon Part-Dieu train station. The course is wide and follows a very interesting progression for learning the subject. Perfect correspondence with my needs (initiation to techno and improvement in order to master design issues and / or Talend Open Studio DI projects) Listening trainer, relevant to these examples.
Brice S.
Brice S.
Many applications in prospect. Trainer: In Switzerland we have a slightly slower flow of words !! But we ended up getting used to it. Thank you.
Thomas A.
Thomas A.
An interesting internship allowed me to deepen my knowledge. Listening, competent, available trainer. I had the answers to my questions. it allowed me to progress in the use of Talend.
Aziza O.
Aziza O.
Trainer: friendly, speech a little too fast at times.
Loic B.
Loic B.
At the end of this training, Talend seems to be a reasoned choice for my work.
Frédéric D.
Frédéric D.
Perfect training. Nothing to say, on the contrary.
Serge G.
Serge G.
Précédent
Suivant

Talend Open Studio Data Integration : Advanced

Goals


- Understand the data integration process

- Master the Talend Open Studio tool and the component library

- Create long-lasting ETL processes with Talend

Program

Differentiate between main streams from iterate streams
Loops and programming via tLoop, tForeach
Switch from a main stream to an iterate stream, and vice versa (tFlowToIterate, tIterateToFlow) Job
synchronization with tWaitForFile, tWaitForSocket, tWaitForSQL

Lab: parallelize subjobs, synchronize jobs with external event

Reminders on debugging traces
Using the Java Debug mode: Debug perspective, step-by-step mode
Visualization and hot modification of variables

Workshop: Basic / advanced task debugging

Reminder on the contexts
Export of jobs for execution on a server
Passage of context between jobs, at runtime
Use of a file to load the context (tContextLoad)

Workshop: Deployment of tasks and dynamic loading of the context

Use of advanced components: Java or regular expressions
Creation of specific logs
Management of XML flows
Reuse of code

Workshop: Use of the tJavaRow, tJavaFlex components – creation of logs with tCatch, tDie … – use of the embedded Java editor

Essential concepts for extending Talend Open Studio
Creation of the component mockup with tJavaFlex / graphical interface
Discover the Talend forge and its community components
Integration into Talend Open Studio of the plugins created or downloaded

Workshop: Creation of a simple component via tJavaFlex, integration of components from the Talend forge

Duration

2 days

Price

£ 1025

Audience

System administrators / BDD, Project managers, Developers

Prerequisites

Knowledge of Talend and Java

Reference

BUS876-F

Sessions

Contact us for more informations about session date

ASP.NET Core MVC : Initiation + Advanced

Goals


- Master the development of ASP.Net MVC Core applications with the Razor view engine and a data access layer driven by Entity Framework

Program

Pattern MVC: architecture, contributions
Creation of web applications .Net
.NET Core vs .NET Framework
ASP.Net MVC: presentation, versions, technologies used
Structure of an ASP.Net MVC project, choice of view engine
Global configuration: dependencies , bundles, filters, global configuration class
Available resources (documentation)

Workshop: Creation of an ASP.NET MVC Core project, detail of the structure

ASP.NET controller: implementation,
Route naming : default configuration, syntax
Passing and retrieving parameters in controller actions
Parameter mapping and routing modification in the RouteConfig
Choice of the result type of the action: ActionResult, FileContentResult,. ..
Download management

Workshop: Creating controllers, routing and retrieving parameters

Management of redirects from the controller: to a view, to an action, to a stream
Razor view engine: presentation, syntax
Templating views: _ViewStart (default template), custom _Layout
Access to bundles: styles, scripts
Creation of views: association with a template, structure of the
Bootstrap page : responsive design grid, main classes, available components
Management of CSS of the view
Creation of model classes, sending in the controller and retrieving in the view
Creation of forms: basic controls, restoration of values ​​after Postback
Validation of entries: management in the model and display of errors
Generation of views associated with a model with the
Internationalization of the view
Management of HTTP sessions, access in the view
Manipulation of global variables
Creation and retrieval of cookies
Management of the upload
Management of asynchronous AJAX requests
View debug: helpers (ServerInfo , ObjectInfo)

Workshop: Implementation of a complete MVC CRUD, validation of entries and imports / exports

Authentication management: available methods, selection criteria
Implementation of an authentication strategy, management of roles
Authentication filters
Security of forms against
AntiForgeryToken injections : interest, implementation

Workshop: Implementation of an authentication strategy, secure forms against injections

Setting up a cache
Traffic analysis
Resource management (Minify, Bundle) in a Razor view
Publishing the application

Workshop: Setting up a cache, multiple optimizations of the application

Architecture and technologies of access to data
Object relational mapping
Presentation of the framework, tools
Entity framework vs other ORMs (NHibernate)
Entity Data Model vs Code First
Context and connection chain

Workshop: Setting up the Entity Framework in a project in Visual Studio

Definition of the context class (DbContext), life cycle
Log management
Definition of model classes and addition in the context
Database initializers Available
conventions, additions, management of datetime2
Mapping of tables: Attributes and Fluent API
Management of primary keys: simple, compound
Concurrency management: Concurrency Check, Timestamp
Mapping of calculated columns
Relations: OneToMany / ManyToOne, OneToOne, ManyToMany Inheritance
mapping strategies: TPH, TPC, TPS
Generation of CRUD actions in a controller
Backup management in asynchronous mode

Workshop: Creation, modification of a complete data model

Migrations: definition, interests
Activation of migrations, initial migration
Adding a migration and modification of the code: SQL queries
Applying a migration: update or regression of version
Going into production at a specified migration

Workshop: Creation of database manipulation with migrations

Understand the execution of queries
Management of connections
Control of transactions
Passage of an existing connection
Methods available from the DbContext: Creation, update and deletion
Management of association loads: Lazy vs Eager
Generation of stored procedures for the entities of the model and use
Optimizing the context cache, mistakes to avoid

Workshop: Updating data and modifying the model

Overview of available data retrieval methods
Using LINQ to Entities, errors to avoid
Queries with Entity SQL
Stored procedures and handling multiple results
Queries and changes to data using ADO.Net commands
Using DataSets
Using LINQ to SQL
Managing performance

Workshop: Writing multiple queries and processing results – pagination management / creation of views

Build Optimized Solutions Using Object Services
Using Design-
Generated Entity Framework Views Performance Monitoring
Perform Asynchronous Data Changes
Offline Data Caching Using XML

Workshop: Query optimizations, offline data monitoring and caching

Duration

5 days

Price

£ 2750

Audience

.Net Developers (C # or VB.Net)

Prerequisites

Mastery of the object (C # or VB.Net), knowledge of HTML / CSS / JS

Reference

.NE100926-F

Sessions

Contact us for more informations about session date

PowerPoint : Initiation + Advanced

Goals


- Create complete presentations

- Make transitions and animations

- Know how to synthesize ideas

Program

Presentation of PowerPoint and the other tools of the Office suite
Examples of realization with PowerPoint

Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Structure of a file (slideshows, sections, slides)
Create a new slide show
Using slide show templates

Add / remove slides Slide
layouts
Group your slides into sections
Move a slide

Placeholders
Insert and format text
Insert and customize shapes
Insert and customize images
Create a photo album
Insert tables
Use WordArt
Graphics and flowcharts
Insert audio and video
Organize inserted content

Use slide themes
Add a background
Create your own theme

Animating content
Personalizing your animation
Timing of animations (start, duration, delay)
Transitions between slides
Timing of transitions

Launching the slideshow mode
Creating a personalized slideshow
Configure the slideshow
The other display modes
Inserting a header and footer
Adding comments

Adding hypertext links
Adding an action on an object
Inserting multimedia content: audio and video
Printing the document
Managing the slide master
Creating its presentation template

Compare two presentations
Protect a slide show
Check that there are no problems
Share your presentation
Broadcast your slide show online

Integrate shortcuts into the Quick Access toolbar
Create a tab with your favorite tools

Definition of presentation objectives
Creation and organization of the plan
Layout of the presentation
Creation of the mask
Creation of standard slides (new part, contents)
Creation of the presentation and animations
Proofreading and corrections

Workshop: Creation of a presentation for your personal or professional project

Passing of the certification (if foreseen in the financing).

Duration

2 days

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR1120-F

Sessions

Contact us for more informations about session date

PowerPoint : Advanced

Goals


- Insert multimedia content

- Customize the slide master

Program

Adding hypertext links
Adding an action on an object
Inserting multimedia content: audio and video
Printing the document
Managing the slide master
Creating its presentation template

Compare two presentations
Protect a slide show
Check that there are no problems
Share your presentation
Broadcast your slide show online

Integrate shortcuts into the Quick Access toolbar
Create a tab with your favorite tools

Definition of presentation objectives
Creation and organization of the plan
Layout of the presentation
Creation of the mask
Creation of standard slides (new part, contents)
Creation of the presentation and animations
Proofreading and corrections

Workshop: Creation of a presentation for your personal or professional project

Revisions on PowerPoint
Questions / Answers
Passing the PCIE or TOSA certification

Passing of the certification (if foreseen in the financing).

Duration

1 day

Price

£ 2495

Audience

PowerPoint users

Prerequisites

Have followed the « PowerPoint: Initiation » course or have equivalent knowledge

Reference

BUR1193-F

Sessions

Contact us for more informations about session date

ASP.NET Web Forms Advanced

Goals


- Discover the different ASP.NET programming techniques for an Internet or Intranet site

Program

Reminders of ASP.NET databases ASP.NET
languages

Internationalization (dates, texts, currencies …)
General configuration and summary of administration
Pages – a menu in a page
Information on security with ASP.NET and IIS
Deployment of an application
Application of these principles to the case study

About CSS with ASP.NET: the essential decoration of the site
Themes and master pages: organization of the presentation and time savings
Automatic validation of forms
Other points of javascript with ASP.NET
Example: the whole presentation of a dynamic site

Access to files from code-behind
Databases: SQL reminders and types of databases
Databases: business access to the database, reading, modification
Databases: advanced presentation (DataGrid and GridView, DataList , etc.)
XML: where and why
Presentation of access to XML from code-behind and web services
Multiple examples of persistent data in a dynamic site

Duration

2 days

Price

£ 995

Audience

All

Prerequisites

Have taken the "ASP.NET initiation" course or have equivalent knowledge

Reference

.NE64-F

Sessions

Contact us for more informations about session date

Individual course, the trainer has adapted.
Jean marc P.
Jean marc P.

ASP.NET Web Forms Initiation + Advanced – 10264A

Goals


- Develop with ASP.NET Web database management applications

- Discover the different ASP.NET programming techniques for an Internet or Intranet site

Program

Technical choices and installation of tools
Operating principle
Architecture of an ASP.NET page
.NET programming languages ​​and their recent versions

Handling the Visual environment
Summary of VB.NET and C # syntaxes
Creating a simple project
Retrieving form data – why a dynamic website
An example: mailing and contact form
Principle of events

Common and common properties and events
The component toolbox
Form and general layout
components Complex components (calendars, views, imagemap, etc.)
Presentation of additional toolbox items (data, validation, etc.), including the display of databases
Case study: creation of multiple and various pages of a dynamic site

Principle of operation and general architecture of the pages
Detailed syntax of C # and VB.NET
Object-oriented programming: summary of what is needed for ASP.NET
Complete the dynamic site: forms and calculations, the job of the application

Handling of character strings and dates
Generalist lists and libraries of .NET
The lifecycle of the ASP.NET page
The ViewState, sessions and cookies
Increased persistence: the application, the cache
All request information and of responses
Additions to the case study: application status and user recognition

Internationalization (dates, texts, currencies …)
General configuration and summary of administration
Pages – a menu in a page
Information on security with ASP.NET and IIS
Deployment of an application
Application of these principles to the case study

About CSS with ASP.NET: the essential decoration of the site
Themes and master pages: organization of the presentation and time savings
Automatic validation of forms
Other points of javascript with ASP.NET
Example: the whole presentation of a dynamic site

Access to files from code-behind
Databases: SQL reminders and types of databases
Databases: business access to the database, reading, modification
Databases: advanced presentation (DataGrid and GridView, DataList , etc.)
XML: where and why
Presentation of access to XML from code-behind and web services
Multiple examples of persistent data in a dynamic site

Duration

5 days

Price

£ 2495

Audience

All

Prerequisites

Notions of C # or VB.NET - Good knowledge of the object, XHTML and CSS

Reference

.NE65-F

Sessions

Contact us for more informations about session date

Very complete course. Perfectly matches our needs.
Laurent T.
Laurent T.
As always, the 'dawan' trainings are very pleasant to follow. Each time you learn a lot of things.
Pascal D.
Pascal D.
Individual course, the trainer has adapted.
Jean marc P.
Jean marc P.
no complaints. perfect well suited to my expectations great patience of the trainer and knows how to adapt. satisfied
Michel B.
Michel B.
Perfect fit. I got the answers to all my questions that the training did not cover directly.
Francois K.
Francois K.
Trainer: Very friendly and has deepened the training on topics associated and necessary for the realization of my project.
Olivier R.
Olivier R.
Really very prepared trainer and able to personalize the learning according to our needs. By mastering very well different technos and languages, he can always advise the best choice to take according to the needs.
Matteo G.
Matteo G.
Excellent trainer who adapts very well to needs.
Jean Guillaume M.
Jean Guillaume M.
Perfect
Yann R.
Yann R.
Précédent
Suivant

ASP.NET MVC Advanced

Goals


- Master the development of ASP.Net MVC applications with the Razor view engine and a data access layer driven by Entity Framework

Program

Controllers and MVC models
Types of results
Object manipulation: session, request, response, cookies
Routing management in the application
Forms management

Workshop: MVC chaining with session manipulation

Setting up a cache
Traffic analysis
Resource management (Minify, Bundle) in a Razor view
Publishing the application

Workshop: Setting up a cache, multiple optimizations of the application

Architecture and technologies of access to data
Object relational mapping
Presentation of the framework, tools
Entity framework vs other ORMs (NHibernate)
Entity Data Model vs Code First
Context and connection chain

Workshop: Setting up the Entity Framework in a project in Visual Studio

Definition of the context class (DbContext), life cycle
Log management
Definition of model classes and addition in the context
Database initializers Available
conventions, additions, management of datetime2
Mapping of tables: Attributes and Fluent API
Management of primary keys: simple, compound
Concurrency management: Concurrency Check, Timestamp
Mapping of calculated columns
Relations: OneToMany / ManyToOne, OneToOne, ManyToMany Inheritance
mapping strategies: TPH, TPC, TPS
Generation of CRUD actions in a controller
Backup management in asynchronous mode

Workshop: Creation, modification of a complete data model

Migrations: definition, interests
Activation of migrations, initial migration
Adding a migration and modification of the code: SQL queries
Applying a migration: update or regression of version
Going into production at a specified migration

Workshop: Creation of database manipulation with migrations

Understand the execution of queries
Management of connections
Control of transactions
Passage of an existing connection
Methods available from the DbContext: Creation, update and deletion
Management of association loads: Lazy vs Eager
Generation of stored procedures for the entities of the model and use
Optimizing the context cache, mistakes to avoid

Workshop: Updating data and modifying the model

Overview of available data retrieval methods
Using LINQ to Entities, errors to avoid
Queries with Entity SQL
Stored procedures and handling multiple results
Queries and changes to data using ADO.Net commands
Using DataSets
Using LINQ to SQL
Managing performance

Workshop: Writing multiple queries and processing results – pagination management / creation of views

Build Optimized Solutions Using Object Services
Using Design-
Generated Entity Framework Views Performance Monitoring
Perform Asynchronous Data Changes
Offline Data Caching Using XML
Using Sync Framework

Workshop: Query optimizations, offline data monitoring and caching

Duration

2 days

Price

£ 1950

Audience

.Net Developers (C # or VB.Net)

Prerequisites

Have taken the ASP.NET MVC Initiation training or equivalent concepts

Reference

.NE100921-F

Sessions

Contact us for more informations about session date

ASP.NET MVC Initiation + Advanced

Goals


- Master the development of ASP.Net MVC applications with the Razor view engine and a data access layer driven by Entity Framework

Program

Pattern MVC: architecture, contributions
Creation of web applications .Net
ASP.Net MVC: presentation, versions, technologies used
Structure of an ASP.Net MVC project, choice of view engine
Global configuration: dependencies, bundles, filters, class of global configuration
Available resources (documentation)

Workshop: Creation of an ASP.Net MVC project, detail of the structure

ASP.Net controller: implementation,
Route naming : default configuration, syntax
Passing and retrieving parameters in controller actions
Parameter mapping and routing modification in RouteConfig
Choice of the type of result of the action: ActionResult, FileContentResult,. ..
Download management

Workshop: Creating controllers, routing and retrieving parameters

Management of redirects from the controller: to a view, to an action, to a stream
Razor view engine: presentation, syntax
Templating views: _ViewStart (default template), custom _Layout
Access to bundles: styles, scripts
Creation of views: association with a template, structure of the
Bootstrap page : responsive design grid, main classes, available components
Management of CSS of the view
Creation of model classes, sending in the controller and retrieving in the view
Creation of forms: basic controls, restoration of values ​​after Postback
Validation of entries: management in the model and display of errors
Generation of views associated with a model with the
Internationalization of the view
Management of HTTP sessions, access in the view
Manipulation of global variables
Creation and retrieval of cookies
Management of the upload
Management of asynchronous AJAX requests
View debug: helpers (ServerInfo , ObjectInfo)

Workshop: Implementation of a complete MVC CRUD, validation of entries and imports / exports

Authentication management: available methods, selection criteria
Implementation of an authentication strategy, management of roles
Authentication filters
Security of forms against
AntiForgeryToken injections : interest, implementation

Workshop: Implementation of an authentication strategy, secure forms against injections

Setting up a cache
Traffic analysis
Resource management (Minify, Bundle) in a Razor view
Publishing the application

Workshop: Setting up a cache, multiple optimizations of the application

Architecture and technologies of access to data
Object relational mapping
Presentation of the framework, tools
Entity framework vs other ORMs (NHibernate)
Entity Data Model vs Code First
Context and connection chain

Workshop: Setting up the Entity Framework in a project in Visual Studio

Definition of the context class (DbContext), life cycle
Log management
Definition of model classes and addition in the context
Database initializers Available
conventions, additions, management of datetime2
Mapping of tables: Attributes and Fluent API
Management of primary keys: simple, compound
Concurrency management: Concurrency Check, Timestamp
Mapping of calculated columns
Relations: OneToMany / ManyToOne, OneToOne, ManyToMany Inheritance
mapping strategies: TPH, TPC, TPS
Generation of CRUD actions in a controller
Backup management in asynchronous mode

Workshop: Creation, modification of a complete data model

Migrations: definition, interests
Activation of migrations, initial migration
Adding a migration and modification of the code: SQL queries
Applying a migration: update or regression of version
Going into production at a specified migration

Workshop: Creation of database manipulation with migrations

Understand the execution of queries
Management of connections
Control of transactions
Passage of an existing connection
Methods available from the DbContext: Creation, update and deletion
Management of association loads: Lazy vs Eager
Generation of stored procedures for the entities of the model and use
Optimizing the context cache, mistakes to avoid

Workshop: Updating data and modifying the model

Overview of available data retrieval methods
Using LINQ to Entities, errors to avoid
Queries with Entity SQL
Stored procedures and handling multiple results
Queries and changes to data using ADO.Net commands
Using DataSets
Using LINQ to SQL
Managing performance

Workshop: Writing multiple queries and processing results – pagination management / creation of views

Build Optimized Solutions Using Object Services
Using Design-
Generated Entity Framework Views Performance Monitoring
Perform Asynchronous Data Changes
Offline Data Caching Using XML
Using Sync Framework

Workshop: Query optimizations, offline data monitoring and caching

Duration

5 days

Price

£ 2750

Audience

.NET Developers (C # or VB.Net)

Prerequisites

Mastery of the object (C # or VB.Net), knowledge of HTML / CSS / JS

Reference

.NE1257-F

Sessions

Contact us for more informations about session date

Advanced C # : Building a Multitasking Graphical Application with WPF

Goals


- Know how to create a graphical interface for C # or VB.net application with WPF

Program

Windows Presentation Foundation and other .Net 3
WPF libraries versus Windows Forms
Development environment: Visual Studio, Expression Blend
Structure of a WPF project

Workshop: creation of a WPF application – structure study and resource management

An automatically created window
Choice of window type: Window vs Page
Complete XAML syntax
Main controls and their properties
Positioning
management in WPF Event management
Validation of user controls
Creation of custom controls and use

Workshop: creation of a navigation system for various windows with WPF

Drawing, brushes, brushes, transformations …
Animations from drawing, and fluidity
Animations
Free forms, from graphic models
The style system
Advice for graphic designers

Workshop: use and application of styles

Feedback on resources in a WPF application
Data links for display
Data modification by automatic link
Assessment against a
Pattern MVVM database : principles, implementation, management of actions

Workshop: Data binding – implementation of the MVVM pattern

Multi-threading and synchronization
Asynchronism
Parallelism

Workshop: introduction of parallelism in processing – management of background tasks

Duration

5 days

Price

£ 2495

Audience

.NET Developers

Prerequisites

Have taken the C # training: Programming in an object or equivalent concepts

Reference

.NE101054-F

Sessions

Contact us for more informations about session date

Excel Expert : Power Query, Power Pivot and Power BI + Charts, Forms and Complex Functions

Goals


- Import and manage source data external to Excel

- Master the use of Power Query / Power Pivot

- Bring a broader perspective of the use of Excel functionality

- Use complex functions, form controls, etc.

Program

The role of Power Query
Complementary tools to Power Query

Excel and csv sources
Importing an Access database

Data transformation
Splitting a column
modifying data types and transposing
Refreshing data relative to the source
Inserting or deleting rows and / or columns
Aggregating data in a column
Using the Filter, sorting and grouping of lines
Create a parameterized function in M ​​language

Merge and add
« Uncross » lists of data

Workshop: importing, transforming and combining data from external sources

Understanding PowerPivot as a Tool
Benefits and Features
Different Versions of PowerPivot
Data to Use with PowerPivot
Description of the PowerPivot Tab in Excel
Using the PowerPivot Manager
Configuring the Import of External Data
Managing the Data Imported from the PowerPivot interface

Creation of pivot tables connected to the PowerPivot
Handling of a pivot table
Use of a pivot table under the table tool
Management of the pivot table options

Using sorting and filtering
Using segments for filters
Using calculations in the PivotTable
Setting up measures (functions, ratio, spreads, progress, charts)
Using grouping and defining value slices

Lab: Generate Pivot Tables with PowerPivot from External Sources

Loading PowerPivot tables from Excel
Access to relational databases: SQL Server, Access, ODBC etc.
Managing connections and updates
Using the Diagram view
Creating relationships between tables
Managing PowerPivot settings on multi tables
Designing the display and creating perspectives
Managing multi table data from PowerPivot

DAX functions, Excel functions and calculation in the pivot table
Design calculated fields
Implement intelligent date management
Formatting data

Comparison of two workbooks
Analysis of a workbook (Structure, formula, cells, ranges, warning)
Display of links between workbooks, worksheets and cells
Clean up excess formatting to decrease file size and increase their execution speed
Password management

Introducing the tool
Converting a table to a graph
Inserting new views
Choosing a theme
Presenting data with mosaics
Creating multi-view reports
Loading data from heterogeneous sources and organizing them among themselves

Presentation of Power Map
Modifying the appearance of the map
Adding a scene
Exploitation of geographic and temporal data
Exporting the Power Map map to a video or to another application

Workshop: Presentation of data geographically

Understanding the different Power BI modules
Acquiring data with Power Query (CSV, Excel, Access)
Using Power Pivot for connecting to data and
Creating relationships
Using Power View for adding visuals
Using PowerMap for a cartographic presentation
Publication and distribution of reports

Duration

5 days

Price

£ 2495

Audience

Seasoned Excel Users, Analysts, Decision Makers

Prerequisites

Have followed the Excel Advanced training or have equivalent concepts

Reference

BUR100247-F

Custom number format
Management of hours and their formats
Custom lists

Grouped histogram combined with stacked histogram
Using the shifted function in a graph
Enriching a graph with control buttons to make it more dynamic

Nesting of functions (index function with
Equiv, Shift function, Indirect …) Matrix formulas (Transpose, Sumprod, If in matrix …)
Complex nesting of date functions
Other examples of nesting of functions for complex needs

Sorting with a specific order
Sorting with conditional formatting
Advanced filter with specific criteria

Cascading drop-down menu
Validation rules with formulas (no duplicate, Uppercase, etc.)
Specific validation options

Customization of icon sets, color shades, etc.
Use of functions under conditions

Target value
Solver
Scenario management

Button, Drop-down menu, checkbox…
Parameters specific to the controls
Binding of controls with calculation formulas

Workshop: setting up a form

Sessions

Contact us for more informations about session date

Excel Expert : Power Query, Power Pivot and Power BI

Goals


- Import and manage source data external to Excel

- Master the use of Power Query / Power Pivot

Program

The role of Power Query
Complementary tools to Power Query

Excel and csv sources
Importing an Access database

Data transformation
Splitting a column
modifying data types and transposing
Refreshing data relative to the source
Inserting or deleting rows and / or columns
Aggregating data in a column
Using the Filter, sorting and grouping of lines
Create a parameterized function in M ​​language

Merge and add
« Uncross » lists of data

Workshop: importing, transforming and combining data from external sources

Understanding PowerPivot as a Tool
Benefits and Features
Different Versions of PowerPivot
Data to Use with PowerPivot
Description of the PowerPivot Tab in Excel
Using the PowerPivot Manager
Configuring the Import of External Data
Managing the Data Imported from the PowerPivot interface

Creation of pivot tables connected to the PowerPivot
Handling of a pivot table
Use of a pivot table under the table tool
Management of the pivot table options

Using sorting and filtering
Using segments for filters
Using calculations in the PivotTable
Setting up measures (functions, ratio, spreads, progress, charts)
Using grouping and defining value slices

Lab: Generate Pivot Tables with PowerPivot from External Sources

Loading PowerPivot tables from Excel
Access to relational databases: SQL Server, Access, ODBC etc.
Managing connections and updates
Using the Diagram view
Creating relationships between tables
Managing PowerPivot settings on multi tables
Designing the display and creating perspectives
Managing multi table data from PowerPivot

DAX functions, Excel functions and calculation in the pivot table
Design calculated fields
Implement intelligent date management
Formatting data

Comparison of two workbooks
Analysis of a workbook (Structure, formula, cells, ranges, warning)
Display of links between workbooks, worksheets and cells
Clean up excess formatting to decrease file size and increase their execution speed
Password management

Introducing the tool
Converting a table to a graph
Inserting new views
Choosing a theme
Presenting data with mosaics
Creating multi-view reports
Loading data from heterogeneous sources and organizing them among themselves

Presentation of Power Map
Modifying the appearance of the map
Adding a scene
Exploitation of geographic and temporal data
Exporting the Power Map map to a video or to another application

Workshop: Presentation of data geographically

Understanding the different Power BI modules
Acquiring data with Power Query (CSV, Excel, Access)
Using Power Pivot for connecting to data and
Creating relationships
Using Power View for adding visuals
Using PowerMap for a cartographic presentation
Publication and distribution of reports

Duration

3 days

Price

£ 2495

Audience

Seasoned Excel Users, Analysts, Decision Makers

Prerequisites

Have followed the Excel Advanced training or have equivalent concepts

Reference

BUR100227-F

Sessions

Contact us for more informations about session date

VB.Net Expert

Goals


- Acquire advanced notions in VB.Net for the creation of web services, efficient graphical interfaces with WPF and a powerful persistence layer

Program

Development and deployment of .Net applications
Contributions of the different versions of VB.Net
Architecture and best practices

Genericity: methods, classes and interfaces
Anonymous methods 
Advanced object: indexers, initialization / destruction, interfaces, reflection
Introduction to parallelism
Asynchronous programming

Workshop: Use of abstraction, common interfaces and polymorphism – Complex collections

Handling of XML in VB.Net: creation, parsing, transformations
Web services: presentation, architecture and protocols
Summary of SOAP and WSDL
Principles of WCF (Windows Communication Framework)
Assemblies, contract and implementation of a service
Hosting of the service (console, IIS , windows service)
Consumption of a service

Workshop: Implementation and consumption of a WCF web service

WPF (Windows Presentation Foundation): presentation,
WPF architecture compared to Winforms
Introduction to XAML, construction of windows
Event management
Main controls and positioning
Interractivity and data management

Workshop: creation of a complete management application with WPF

Reminders of database access with ADO.Net
Overview of ORM
Entity Framework frameworks: functionalities,
LINQ architecture : presentation, syntax and generation of requests
Managing associations
Calling stored procedures

Lab: High-performance implementation of a data access layer with Entity Framework

Duration

5 days

Price

£ 2475

Audience

VB.Net Developers

Prerequisites

Have followed the "VB.Net Initiation + Deepening" training or equivalent knowledge

Reference

.NE663-F

Sessions

Contact us for more informations about session date

Windows Server 2016 Remote Desktop Services Advanced

Goals


- Implement High Availability for Remote Desktop Services

Program

Remote Desktop Services Roles
Upgrade Order RD Connection Broker Service
Upgrade License Server Upgrade
RDS Licensing Compatibility
Upgrading Session Host Servers and Virtualization Hosts
Upgrading RD Services Web and RD Gateway

Workshop: Migration of the RDS deployment to a new broker

High availability and load balancing of session host servers
High availability of Web access Terminal Server
DNS Round Robin and network load-balanced cluster
Multi-name and multi-domain certificates
High availability of TS Gateway access
High availability of RD Broker service
Internal and external DNS infrastructure
High availability of the license server

Workshop: Implementing high availability on a complete RDS infrastructure

Usefulness of IP address virtualization
« Per session » and « By program » modes IP address
allocation methods

Workshop: Implementing IP address virtualization

Duration

2 days

Price

£ 1285

Audience

System administrators

Prerequisites

Knowledge of Windows Server 2016, Remote Desktop Services 2016 and Active Directory basics

Reference

WIN101195-F

Sessions

Contact us for more informations about session date

Visual Basic.Net – Advanced

Goals


- Learn to develop complex applications with Visual Basic.Net

- To create basic management interfaces and to take advantage of .NET libraries

Program

Developments in the .NET framework
VB.Net reminders

Presentation of the object for the ideal structuring of the code and notions of UML
Attributes and methods
Constructors, life cycle, general memory management
The aggregation of objects
Creation of properties, visibility, encapsulation
Inheritance in the application

Workshop: Implementation of several business classes

Use of namespaces and creation
Abstract classes and interfaces
Polymorphism: interest, use
Event mechanisms
Creation and use of processes
Examples of modeling for complex applications

Workshop: Organization of an application based on complex objects – advanced use of graphic controls

ADO.NET: access to any database
Communication with .NET: the web and other protocols
Presentation of additional useful elements available and VB.Net evolutions
Creation and use of
Multithreading and synchronization processes

Workshop: Complete Case Study – A Business Agenda in VB.Net

Passing of the certification (if foreseen in the financing).

Duration

2 days

Price

£ 995

Audience

All

Prerequisites

Good knowledge of Visual Basic.Net

Reference

.NE174-F

Sessions

Contact us for more informations about session date

The trainer has excellent listening skills. The exchanges are of high quality and adapted to the needs of the intern
Lahoucine D.
Lahoucine D.
Very competent trainer. The course was very enjoyable to take. I learned a lot by taking this course. I have rarely had the opportunity to have been able to take such a good course.
Pascal D.
Pascal D.
Trainer: Bravo to Mohamed. Very professional and friendly. Course explained clearly with practical and concrete examples.
Laurent T.
Laurent T.
nothing to say lack of time to do more exercises Trainer: excellent teacher
Bertrand L.
Bertrand L.
Précédent
Suivant

Windows Server 2012 Remote Desktop Services Advanced

Goals


- Implement High Availability for Remote Desktop Services

Program

Remote Desktop Services Roles
Upgrade Order RD Connection Broker Service
Upgrade License Server Upgrade
RDS Licensing Compatibility
Upgrading Session Host Servers and Virtualization Hosts
Upgrading RD Services Web and RD Gateway

Workshop: Migration of the RDS deployment to a new broker

High availability and load balancing of session host servers
High availability of Web access Terminal Server
DNS Round Robin and network load-balanced cluster
Multi-name and multi-domain certificates
High availability of TS Gateway access
High availability of RD Broker service
Internal and external DNS infrastructure
High availability of the license server

Workshop: Implementing high availability on a complete RDS infrastructure

Usefulness of IP address virtualization
« Per session » and « By program » modes IP address
allocation methods

Workshop: Implementing IP address virtualization

Duration

2 days

Price

£ 1285

Audience

System administrator

Prerequisites

Knowledge of Windows Server 2012, Remote Desktop Services 2012 and Active Directory basics

Reference

WIN101194-F

Sessions

Contact us for more informations about session date

Windows Server 2008 Administration Initiation + Advanced

Goals


- Learn to install and administer Windows Server

- Manage users

- Discover NTFS

- Configure a network printer

- Manage Windows Server security

- Protect and monitor your server

- Install and configure Terminal Server

Program

Preparing for Installation
Installing Windows 2008 Server
Upgrading to Windows 2008 Server

Understanding User Accounts
Items Required for New User Accounts
Creating a User Account
Setting Criteria for Passwords
Setting Properties for Passwords
Customizing User Settings Using User Profiles ‘user
Management of user data by creating home directories

Overview of groups
Development of a security group creation policy
Use of predefined groups

Types of disk storage available in Windows Server
Partitioning a basic drive
Creating volumes on a dynamic drive
Performing common tasks to manage disks

Description of NTFS permissions
Applying NTFS permissions by Windows Server
Assigning NTFS permissions
Compressing data on an NTFS partition
Configuring disk quotas on NTFS volumes

Description of shared folders
Creating shared folders
Combination of NTFS permissions and shared folders: SMB, NFS, iSCSI
Setting up shared folders using the DFS system
Using the FSRM file server resource manager

Understanding Printing in Windows Server
Adding a Printer
Configuring a Network Printer
Configuring Support for a Web Browser Printer
Special Feature of Windows 2008 Print Server

Duration

5 days

Price

£ 1956

Audience

Network and systems administrators

Prerequisites

Network knowledge

Reference

WIN801-F

Windows Server Security Overview Windows Server Security
Policies
Implementing Security Policies
Auditing Access to System Resources

Classic network security tools
Implement an audit policy
Windows firewall configuration with advanced security: incoming and outgoing traffic rules

Practical work
Auditing file access. Administer the Windows firewall with advanced security. Creating rules with Netsh. Import a security template from another server

Monitoring system resources
Monitoring event logs
Optimizing performance
Troubleshooting monitoring and tuning issues

Installing, configuring and managing a DHCP server
Securing DHCP
Netsh commands for DHCP
Diagnosing and troubleshooting DHCP problems

Practical work
Installing, configuring and testing a DHCP server

Reminder on the WINS system
Reminder on the functioning of DNS
New features of DNS in Windows 2008
High availability for the DNS service
Troubleshooting and diagnostic tools

Practical work
Install and configure a DNS server. Perform functional checks with nslookup

Understanding Terminal Services
Planning the Installation
Configuring a Terminal Server
Installing Terminal Services
Installing the License Manager
Connecting to a Terminal Server
Installing Applications on a Terminal Server

Sessions

Contact us for more informations about session date

Windows Server 2008 Administration Advanced

Goals


- Learn to install and administer Windows Server

- Manage users

- Discover NTFS

- Configure a network printer

- Manage Windows Server security

- Protect and monitor your server

- Install and configure Terminal Server

Program

Windows Server Security Overview Windows Server Security
Policies
Implementing Security Policies
Auditing Access to System Resources

Classic network security tools
Implement an audit policy
Windows firewall configuration with advanced security: incoming and outgoing traffic rules

Practical work
Auditing file access. Administer the Windows firewall with advanced security. Creating rules with Netsh. Import a security template from another server

Monitoring system resources
Monitoring event logs
Optimizing performance
Troubleshooting monitoring and tuning issues

Installing, configuring and managing a DHCP server
Securing DHCP
Netsh commands for DHCP
Diagnosing and troubleshooting DHCP problems

Practical work
Installing, configuring and testing a DHCP server

Reminder on the WINS system
Reminder on the functioning of DNS
New features of DNS in Windows 2008
High availability for the DNS service
Troubleshooting and diagnostic tools

Practical work
Install and configure a DNS server. Perform functional checks with nslookup

Understanding Terminal Services
Planning the Installation
Configuring a Terminal Server
Installing Terminal Services
Installing the License Manager
Connecting to a Terminal Server
Installing Applications on a Terminal Server

Duration

2 days

Price

£ 857

Audience

Network and systems administrators

Prerequisites

Network knowledge

Reference

WIN803-F

Sessions

Contact us for more informations about session date

Visual Basic.Net – Initiation + Advanced

Goals


- Learn to develop with VB.NET

- To create basic management interfaces and to manipulate objects of the .NET platform

Program

Presentation of .NET
The languages ​​of the .NET framework
Evolutions of VB / VB.Net, platforms supported
Development environment
Types of projects: console, library, WinForms, WPF, WCF, …
Minimum structure of a VB.Net program
Compilation, execution and debugging

Workshop: Manipulating the development environment – examples of VB.Net programs

Variables: declaration, common types (Common Type System)
Organization in memory (primitive types / reference types)
Operators
Type conversion: implicit / explicit cast
Conditional
instructions Iteration instructions, loops

Workshop: Multiple examples of applications

Operating principle
Creation of arbitrary
arrays Multidimensional arrays and traversal

Workshop: Declaration and manipulation of tables

Introduction to procedural: definition, interest
Types and returns of functions
Passing parameters:
– by value (ByVal)
– by reference (ByRef)
– variable arguments (ParamArray)
Overloads of methods (Overloads)
Optional parameters (Optional)
Recursion: definition, implementation

Workshop: Breakdown of the application

Exception mechanism, types
Catch and handle an exception (try / catch / finally)
Throwing exceptions (throw)

Workshop: Management of data entry errors, escalation of exceptions

Notions on classes
Character strings, dates, …
Various lists and collections, algorithms
Access to files and streams

Workshop: Manipulation of collections and flows

WinForms: presentation, components and displays
Structure of a project, references
Creation of windows
Use of controls and management of events
Organization of the application

Workshop: a directory application

Presentation of the object for the ideal structuring of the code and notions of UML
Attributes and methods
Constructors, life cycle, general memory management
The aggregation of objects
Creation of properties, visibility, encapsulation
Inheritance in the application

Workshop: Implementation of several business classes

Use of namespaces and creation
Abstract classes and interfaces
Polymorphism: interest, use
Event mechanisms
Creation and use of processes
Examples of modeling for complex applications

Workshop: Organization of an application based on complex objects – advanced use of graphic controls

ADO.NET: access to any database
Communication with .NET: the web and other protocols
Presentation of additional useful elements available and VB.Net evolutions
Creation and use of
Multithreading and synchronization processes

Workshop: Complete Case Study – A Business Agenda in VB.Net

Passing of the certification (if foreseen in the financing).

Duration

5 days

Price

£ 2475

Audience

All

Prerequisites

Common use of a programming language

Reference

.NE173-F

Sessions

Contact us for more informations about session date

The trainer was able to respond perfectly to training requests as well as to questions raised during the lessons. The content, although dense, could be dealt with in full, while ensuring the proper integration of the various points discussed.
Olivier D.
Olivier D.
Good trainer with a good technical mastery of the subject.
Mathieu S.
Mathieu S.
Very competent trainer. The course was very enjoyable to take. I learned a lot by taking this course. I have rarely had the opportunity to have been able to take such a good course.
Pascal D.
Pascal D.
nothing to say lack of time to do more exercises Trainer: excellent teacher
Bertrand L.
Bertrand L.
Trainer: Bravo to Mohamed. Very professional and friendly. Course explained clearly with practical and concrete examples.
Laurent T.
Laurent T.
nothing to say lack of time to do more exercises Trainer: excellent teacher
Bertrand L.
Bertrand L.
Course completed by elements used in the product that will be supported
Michaël W.
Michaël W.
Support not used courses adapted to the needs permanently Adapted courses and example according to the problems to come personalized courses to the training team Excellent trainer Always attentive Impressive technical level A big thank you to the trainer for this enriching week.
Stéphane F.
Stéphane F.
I appreciated the adaptation of the examples of the course to the needs of the participants. All the concepts of interest to me were discussed during the training. Patient trainer, pedagogue and listening to us.
Xavier M.
Xavier M.
Very available and prepared trainer. He was able to adapt to everyone's requirements and make the course interesting.
Matteo G.
Matteo G.
Trainer: Thank you
Mustafa I.
Mustafa I.
Very good trainer.
Bruce G.
Bruce G.
Précédent
Suivant

C # – Advanced

Goals


- Know how to develop complex applications with C #

- Create basic management interfaces and manipulate objects of the .NET platform

Program

.NET overview and different versions
C # reminders

Understanding Windows Forms (WinForms) Understanding
WPF Building
Windows and Communicating
Using Controls
Binding Controls with Data
Using User Controls
Using Tasks

Workshop: a directory application

Use of namespaces and creation
Abstract classes and interfaces
Polymorphism: interest, use
Event mechanisms
Examples of modeling for complex applications

Workshop: Organization of an application based on complex objects – advanced use of graphic controls

ADO.NET: access to any database
Communication with .NET: the web and other protocols
Presentation of additional useful elements available and C # evolutions
Creation and use of
Multithreading and synchronization processes

Workshop: Complete Case Study – A Business Agenda in C #

Passing of the certification (if foreseen in the financing).

Duration

2 days

Price

£ 995

Audience

C # Developers

Prerequisites

Have followed the C # initiation training or equivalent knowledge

Reference

.NE143-F

Sessions

Contact us for more informations about session date

Good content to see the extent of the planned courses Bonus training in relation to my skills and needs. Nothing to report, excellent trainer.
Antoine L.
Antoine L.

C # – Initiation + Advanced

Goals


- Know how to develop in C#

- Create basic management interfaces and manipulate objects of the .NET platform

Program

Presentation of .NET
The languages ​​of the .NET framework
Particularities of C #
Evolutions of C #, platforms supported
Development environment
Types of projects: console, library, WinForms, WPF, WCF, …
Minimum structure of a C # program
Compilation, execution and debugging

Workshop: Manipulating the development environment – examples of C # programs

Variables: declaration, common types (Common Type System)
Organization in memory (primitive types / reference types)
Operators
Type conversion: implicit / explicit cast
Conditional
instructions Iteration instructions, loops

Workshop: Multiple examples of applications

Operating principle
Creation of arbitrary
arrays Multidimensional arrays and traversal

Workshop: Declaration and manipulation of tables

Introduction to procedural: definition, interest
Types and returns of functions
Passing of parameters:
– by value
– by reference: (ref, out)
– variable arguments (params)
Method overload
Recursion: definition, implementation

Workshop: Breakdown of the application

Exception mechanism, types
Catch and handle an exception (try / catch / finally)
Throwing exceptions (throw)

Workshop: Management of data entry errors, escalation of exceptions

Notions on classes
Character strings, dates, …
Various lists and collections, algorithms
Access to files and streams

Workshop: Manipulation of collections and flows

Understanding Windows Forms (WinForms) Understanding
WPF Building
Windows and Communicating
Using Controls
Binding Controls with Data
Using User Controls
Using Tasks

Workshop: a directory application

Presentation of the object for the ideal structuring of the code and notions of UML
Attributes and methods
Constructors, life cycle, general memory management
The aggregation of objects
Creation of properties, visibility, encapsulation
Inheritance in the application

Workshop: Implementation of several business classes

Use of namespaces and creation
Abstract classes and interfaces
Polymorphism: interest, use
Event mechanisms
Examples of modeling for complex applications

Workshop: Organization of an application based on complex objects – advanced use of graphic controls

ADO.NET: access to any database
Communication with .NET: the web and other protocols
Presentation of additional useful elements available and C # evolutions
Creation and use of
Multithreading and synchronization processes

Workshop: Complete Case Study – A Business Agenda in C #

Passing of the certification (if foreseen in the financing).

Duration

5 days

Price

£ 2475

Audience

All

Prerequisites

Common use of a programming language

Reference

.NE144-F

Sessions

Contact us for more informations about session date

Recent equipment and pleasant premises. The contact at reception with the trainer has always been warm. The course was brilliantly adapted for me by the trainer. He was able to provide very comprehensive content while meeting my different needs. Trainer: Perfect!
François L.
François L.
Very satisfied with the course, with its scope. Dense training for me not having the practice of object programming. Good match. The trainer responded with patience and courage to the various questions asked, while ensuring the progression and logic of the course.
Hélène F.
Hélène F.
The training took place in excellent conditions. The welcome was impeccable, the equipment impeccable. Very dense and rich C # initiation and in-depth training. Perhaps a little too much sometimes for the neophite, but very interesting. The course perfectly matches my future needs. Trainer: Mohamed has a perfect command of his subject and knows how to make his course come alive. I admire his patience and kindness in addition to his professionalism.
Christian A.
Christian A.
Very good introduction to C #. All the parts are correctly detailed with a theoretical part followed by a practical part. Clear explanations and interesting practical exercises. Trainer: Listening, adapts to everyone to progress at their own pace.
Corentin C.
Corentin C.
Impeccable conditions, reassuring environment and high performance computer. Everything is gathered for a great training! A deepening focused on my shortcomings, adapted to my needs. I come out of it much more efficient and with self-confidence regarding the various subjects discussed. Exactly what I was looking for, a powerful training in .NET with an approach that is both very professional and fun in the examples. Trainer: I hope we will meet again one day, Mohamed Derkaoui brought me a lot throughout this training. A big thanks to him. Thank you again to Mohamed for his involvement this week, I come out of the training with good skills and especially with a big smile! 🙂
Axel D.
Axel D.
Good progress in the course Good start to understand C # Trainer: Availability and re-explanation of exercises very appreciated
Monique P.
Monique P.
4 years of .NET practice previously, the training was not really adapted to my profile, I only followed it for the initiation to WPF Trainer: Very good interpersonal skills, clear explanations
Jules M.
Jules M.
Distance training difficult to judge the state of the room But the means implemented are correct for distance training. The support looks quite rich and I think it will allow me to review and deepen all of the points seen this week. The trainer being attentive the whole was of a very good level. Trainer: Nothing to say, Mr Derkaoui is an excellent technician, teacher, conscientious and respectful of his students. I warmly thank him for his patience and kindness.
Patrice R.
Patrice R.
Very intense course. Fast pace the first days then allowing to take the time to use the concepts seen the following days. Training well organized in terms of timetables and content. The program has been adjusted to suit our needs. The Trainer (Mr. Derkaoui) has perfectly adapted to our needs by remaining attentive and by using the various elements within his reach (current application, technical notes) in order to systematically propose examples related to our needs. He was able to respond with great clarity to all of our questions, sometimes in areas bordering on the framework of the training initially planned.
Simon O.
Simon O.
very good environment and good atmosphere Very didactic, speed adapted to each one, very pleasant to follow Exactly the basics which I needed Trainer: very pleasant, very competent
Mathieu M.
Mathieu M.
Précédent
Suivant

Word: Initiation + Advanced + VBA Macros

Goals


- To be able to produce a structured letter

- To know how to manage the layout of a document

- To carry out a mail merge

- To work with reference tables

- To learn about VBA language on Word

Program

Presentation of Word and the other tools of the Office suite
Examples of realization with Word

Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Structure of a file (pages, sections, paragraphs …)
Display the ruler, paragraph marks and gridlines

Create a document
Open, save and close
Use recent documents
Create a document based on a template
Save a document in Word 97-2003 format

Enter text
Move around the document
Select text to edit
Move and duplicate text
Change text formatting
Manage paragraph alignment
Use automatic spell checking

Search for a character string
Launch an in-depth search
Replace one string with another
Replace formatting

Define a hierarchy at the style level
Apply a predefined style to a text
Create a new text style

Workshop: Apply a style to all of its text content

Duration

5 days

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR1119-F

Choose the theme of your document
Apply a variant of the active theme
Customize the colors, fonts and effects of a theme

Apply a watermark
Set a page color
Apply a border to the page

Define the type of document (classic, book, booklet)
Choose and customize the margins
Specify the size of the sheets and the orientation
Include predefined headers and footers
Insert the company logo
Add page numbering
Modify the format page numbers
Customize headers and footers
Insert page breaks
Split your document into several sections

Define the pages to print
Configure the printer options
Print your document

Workshop: Create a layout for printing a book

Insert a table (define a number of rows and columns)
Manage the table layout (add / remove cells)
Apply a style to its table
Merge or split cells

Insert and customize a picture
Embed an inline picture
Add shapes to your document
Using WordArt
Add a SmartArt
Create and customize a graphic

Workshop: Enrich your document with several illustrations

Split paragraphs into columns
Configure spaces between these columns
Display a separator line

Prepare Word to manage your templates
Use existing templates
Get a template from Office.com
Create a custom template

Insert and configure a table of contents
Update its table of contents
Insert a footnote
Add citations
Insert captions to illustrations
Add a table of illustrations
Define entries in the index
Insert the index table and put it up to date

Workshop: Integrate several reference tables into your document

Define the type of mail merge (label, envelope, letter …)
Select the source of the recipients
Match the fields between the source and Word
Filter the recipients of a mail merge
Prepare your mail
merge template Insert merge fields
Define rules
Preview the results
Finish and merge

Workshop: Prepare a standard letter for several recipients

Create a comment
Show / hide comments
Manage comments
Enable track changes
Compare two Word documents
Restrict changes

Copy Excel data to Word
Insert an Excel spreadsheet into Word
Create hyperlinks to other applications
Save as HTML

Workshop: Import a table and a chart from Excel

Integrate shortcuts into the Quick Access toolbar
Create a tab with your favorite tools

Objectives of a macro
Display the Developer tab in the ribbon
Record a macro
Run a macro
Run a macro via shortcuts (in ribbon, button, etc.)
Manage macros

Objectives of the VBA language
Presentation of the VBA
Using the VBA Operating
principle of the VBA

See and modify the code of a macro
Language syntax
Variables
Constants
Operators
Integrating a VBA function in an Access macro

The Application object
The Document
object
The Paragraphs object
The Range object The Characters 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)

Introducing the form
Integrating form controls in Word
Linking a macro to a form event

Integrate Excel’s VBA objects
Drive an Excel file from Word
Import Excel data into Word

Revisions on Word
Questions / Answers
Passing the PCIE certification

Passing of the certification (if foreseen in the financing).

Sessions

Contact us for more informations about session date