Étiquette : Intermediate

Decision-making dashboards

Goals


- Design and implement a dashboard system adapted to the specificities of the company

- Build and set up internal and external indicators

- Develop quality dashboards adapted to the company’s functions

- Analyze the different phases of the implementation of operational dashboards in the company

Program

Understanding the dashboard approach for the company and management
Steering data
Definition of an indicator, of a dashboard
Variables
Criteria and parameters of an indicator
The challenges of performance
Breakdown of the dashboard

Practical workshop  : Setting up a project team

Highlighting the message through the indicator
The different types of indicators
From the collection of needs to the operation
The management
dashboards
The project dashboard The performance measurement dashboard

Practical workshop  : Definition of a dashboard project by group

Definition of an indicator
The different types of indicators
Highlighting the message through the indicator
Collecting the needs of the various actors
Choosing and targeting the indicators according to the objectives and needs
Prioritizing the result and progress indicators management, management reporting

Practical workshop  : Definition of the types of indicators to be implemented

Actors – Document recipients
Objectives specific to each process
Applicants
Implementation method
 Choice of criteria and parameters
 Definition of objectives and alert thresholds
 Selection of key indicators and deployment of action plans

Practical workshop  : Definition of indicators

Unite your team around dashboards – decision-making tool
Build a spreadsheet with instructions for use
Communicate before posting
Entering information Using
dashboards to make decisions
Communicate on results
Analysis and reactions to deviations
Analyze results and plan improvement actions
Monitor the effectiveness of indicators and their dashboards
Optimize dashboards: circulation of information, evolution of indicators
Check the efficiency of processes from determined performance indicators

Practical workshop : how to set up communication around your dashboards

Duration

2 days

Price

£ 2123

Audience

Anyone who has to participate in the definition of a performance measurement system within the company

Prerequisites

Excel knowledge

Reference

BUS100048-F

Sessions

Contact us for more informations about session date

Data Warehouse and Decision Support Systems

Goals


- Build a multidimensional data model based on user needs

- Set up data administration flows

- Acquire a complete process for setting up a decision-making system

Program

Definition of decision-making needs, history
Role of the Decision-making Information System (SID) within the Information System
Study angles of the concept of decision-support system Decision-making
architecture based on a data warehouse

Presentation, evolution
Deployment models (Data Marts, Operational Data Store, Data Warehouse)
Metadata and flow management
Technical evolutions of RDBMS in the field of decision-making
Data Mining: presentation, tools
Decision-making portals
Construction of a Data Warehouse (approach, modeling, deployment)

Architecture of a SID and dictionaries (functional and technical)
Implementation of an adequate decision-making strategy
Panorama and typology of market offers:
– Back-office construction tools (RDBMS and Data Warehouse)
– Front-office rendering tools ( Reporting, Query, OLAP, Data mining)
– Analysis tools (server side / client side)

The components (actors, environment, decision-making criteria)
Technical study of the project and of what already exists
Organizational policies
Restitution tools and technical architectures
Modeling of tables: facts, dimensions, aggregates
Performance measurement

Duration

5 days

Price

£ 2568

Audience

Functional analysts, Managers, designers and project managers, Developers

Prerequisites

None

Reference

BUS303-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

Programming AutoCAD with .NET

Goals


- Understand the principles of interaction between AutoCAD and .NET

- Know how to plan, create and maintain a .NET module integrated into AutoCAD

Program

Exploration of the development environment
Reminders about .NET
Handling of AutoCAD and versions
Communication principle between .Net and AutoCAD
Disctinguer Interop of .Net libraries

Principle of an SDK
Import AutoCAD classes
Access AutoCAD objects using ObjectARX
The database of a DWG
Maintain transactions for the database

Workshop: a first module, display of a text in the AutoCAD drawing

Presentation of classes
Use of classes
The main classes of ObjectARX: use, create, search, read, delete graphic elements

Workshop: creation of multiple 2d and 3d shapes

Various tables: UCS, layers, …
Event retrieval
Data and file recording
AutoCAD palettes for user interfaces

Workshop: multiple additions to the created module

Duration

3 days

Price

£ 1995

Audience

All

Prerequisites

Knowledge of VB.NET or C #

Reference

.NE147-F

Sessions

Contact us for more informations about session date

Good trainer Thank you for the USB key.
Bruce G.
Bruce G.

Silverlight

Goals


- To be able to create, modify, maintain an application with Silverlight

- To know the usefulness, the context, the limits and alternatives to Silverlight

Program

Presentation
History, versions, specificities of Silverlight 3
Reminders of .NET
A minimal project – environment, start-up, debug

Code / presentation separation
Events in the application
Special events: the keyboard, mouse limits
Access the presentation from the code and modify

Practical workshop: an application filled at start-up 

Standard components for layout and user interaction
Graphics: drawing, paths, transformations, brushes, images
Repetitive graphics: styles and templates
Animations: storyboard – setup and control

Practical workshop: a dynamic and graphic application

File formats
Media objects
Video events
Timeline and association with events

Navigation via a menu (pages and frame)
Collaboration with the browser: progressive loading
The parameters and HtmlPage; another menu
Isolated storage

Practical workshop: several applications in the same page

HttpWebRequest: call of any page
Asynchronism (multithreading)
Web and WCF services

Practical workshop: complex communication between the application and its server

Use Linq, access to an XML file
The Datacontext, creation of data tables
Link in both directions, simplification of forms

Practical workshop: an application associated with a database table

Duration

5 days

Price

£ 2475

Audience

All

Prerequisites

Knowledge of VB.net or C #

Reference

.NE337-F

Sessions

Contact us for more informations about session date

ADO.NET Entity Framework (Code First)

Goals


- Master the implementation of an optimized access layer with Entity Framework (Code First)

Program

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

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

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

£ 1500

Audience

.NET Developers

Prerequisites

Good knowledge of C # or VB.Net

Reference

.NE1256-F

Sessions

Contact us for more informations about session date

ADO.NET Entity Framework

Goals


- Master the implementation of an optimized access layer with Entity Framework

Program

Architecture and data access technologies
Object relational mapping
Presentation of the framework,
Entity framework tools vs other ORMs (NHibernate)

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

Presentation, modifications of entity models
Introduction in VS. Schema of the EDMX file
Choice of a method (CodeFirst, ModelFirst)

Workshop: Creation, modification of a model

Overview of Available Data Retrieval Methods
Using LINQ to Entities
Queries with Entity SQL
The EntityClient Provider Stored
Procedures
Queries and Modifies Data
Using ADO.Net Commands Using DataSets
Managing Transactions
Using LINQ to SQL
Managing Performance and Management competition

Workshop: Writing multiple queries (related entities and updating loaded data)

Creating, updating, and deleting entity data
Tracking changes in the Entity Framework
Using plain old CLR Objects (POCO)
classes with Entity Framework POCO classes and lazy loading
Entity type extensions

Workshop: Updating data and modifying the model

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

3 days

Price

£ 2245

Audience

.NET Developers

Prerequisites

Good knowledge of C # or VB.Net, WinForms or WPF

Reference

.NE795-F

Sessions

Contact us for more informations about session date

Web Services REST with .NET

Goals


- Know how to create and consume REST web services with .NET

Program

Service Oriented Architecture (SOA): components, technologies
Presentation of Web Services (WS): operation, interest, interoperability
Technologies: SOAP protocol, REST architecture
Web service platforms
.NET APIs: WCF vs Web API

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

REST architecture: components, call methods
Error
handling ASP.NET Web API
Development of RESTful services
Xml, JSON serialization
Sending of parameters, validations
Type of response, format
Deployment of a RESTful service
Query of REST web services

Workshop: Creation and query of REST web services

OData: protocol presentation, syntax
Writing requests with OData and a .NET client
Volume optimization

Workshop: queries and joins with OData, comparison with Linq

Using IIS
Log management: TraceListener vs Log4Net

Lab: Logging in a Web API

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

Workshop: global security of the web application

Duration

3 days

Price

£ 2195

Audience

.NET Developers

Prerequisites

Know C # or VB.net

Reference

.NE100512-F

Sessions

Contact us for more informations about session date

WCF

Goals


- Knowing how to create and consume services with WCF

Program

Windows Communication Foundation and other communication namespaces
Older Windows Internal Systems
WCF General Principles
SOAP Summary
Quick .Net reminders

Essential assemblies
Contracts, interfaces and implementations
Hosting of the service (console, IIS, Windows service)
Customer: consumption of a service

Practical workshop: a complete client / server set

One-way, duplex and other synchronization elements
WCF security WCF
sessions and transactions
with the rest of the world

Practical workshop: improving our communication

Duration

2 days

Price

£ 1495

Audience

.NET Developers

Prerequisites

Know C # or VB.net

Reference

.NE568-F

Sessions

Contact us for more informations about session date

Development of universal applications (Universal Apps)

Goals


- Know how to create a universal application for Windows 10

Program

Universal Application Platform for Windows 10, Windows Phone, Hololens, Internet Of Things…
Responsive Design with Adaptive Triggers Adaptive
Code and extension SDK Cross
-platform tools and emulators

Workshop: Setting up the environment, activating developer mode, minimal structure of a project.

XAML: syntax, controls and positioning
Event
management Style and theme
management View management (Visual State Triggers) and orientation
Navigation
Application states
Emulation

Workshop  : Build an application with views adaptable to the type of terminal

Storage and import of files
Data
roaming Persistence in a local database
Asynchronous communication

Workshop: data persistence from the application

Native functions of the Windows 10 platform
Use of thumbnails (tiles)
Contracts, launchers and choosers
Management of notifications
Geolocation
Implementation of background tasks (asynchronous)
Publication in the Windows Store

Workshop: introduction of geolocation in the application and management of notifications .

Duration

3 days

Price

£ 2245

Audience

.NET Developers

Prerequisites

Mastery of object-oriented programming in .Net (C # or VB.Net)

Reference

.NE1046-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 : Charts, Forms and Complex Functions

Goals


- Bring a broader perspective of using Excel functionality

- Using complex functions, form controls, etc.

Program

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

Duration

2 days

Price

£ 2495

Audience

Seasoned Excel Users, Analysts, Decision Makers

Prerequisites

Have taken the Excel Advanced training or equivalent concepts

Reference

BUR100234-F

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

ADO : databases with .NET – 10265A-1

Goals


- Understand the possibilities of interaction between a .NET application and a database

- Use graphical and non-graphical components for ADO.NET

Program

Parallel histories of ADO and .NET
Generic database possibilities
SQL and .NET programming reminders
Special features of MSSQL databases

Preparation of a database
Creation of connection objects
Request for modification to the database
Read in the database
Parameterized request

Practical workshop: creation of a complete data manipulation application – a content manager

Advantages and disadvantages of an access with intermediate buffers
Commands and sets – general syntax
Various manipulations and observation of performance

A minimal component for display
Complete modification components

Duration

2 days

Price

£ 1275

Audience

All

Prerequisites

Knowledge of VB.NET or C #

Reference

.NE123-F

Sessions

Contact us for more informations about session date

Migration from VB6 to VB.Net – MS4340, MS4338, MS4337

Goals


- Learn how to migrate an application from VB6 to VB.Net

Program

Visual Basic .Net: a true object-oriented language
Improved error handling
Support for multi-threaded applications
Use of collections

Presentation of the update of visual Basic 6 applications
Porting code from Visual Basic 6 to Visual Basic.Net
Using the migration wizard
Using the Code Advisor

Definition and fundamentals of object-oriented programming
Use of objects and classes in Visual Basic
Class construction: declaration of properties, methods
Overloading procedures
Inheritance, polymorphism

Duration

2 days

Price

£ 1125

Audience

All

Prerequisites

Common use of Visual Basic 6

Reference

.NE125-F

Sessions

Contact us for more informations about session date

Exchange 2003 Administration

Goals


- Learn to install and administer Exchange

- Manage folders

- Understand message routing

- Monitor your Exchange server

Program

Exchange Fundamentals Exchange
Editions
Windows Integration
Administrative
Features Message Routing
Features Features for Users
Features for Developers

Exchange and Windows
Preparing to Install Exchange
Install Exchange
Default Folders and Default Permissions for Shared Folders
Troubleshoot Installation Problems

Understanding Administrative Utilities
Understanding Exchange System Manager
Managing Administrative Security
Creating and Configuring Administrative Groups
Using Exchange System Policies
Administering Exchange Address Lists

Information
Stores Storage Groups
ESE Engine Features in Exchange
Full Text Indexing Implementation

Creating recipient objects
Configuring recipient objects
Managing recipient objects Bulk
changes in the directory
Configuring policies

Understanding Public Folders
Setting Up Permissions for Public Folders
Managing Public Folder
Replication Public Folder Replication
Creating Public Information Store Policies

Understanding the SMTP Protocol
Configuring Multiple SMTP Domain Names
Configuring an SMTP Virtual Server
Configuring an SMTP Connector
Solving SMTP Connectivity Problems

Duration

5 days

Price

£ 1184

Audience

Windows system administrators

Prerequisites

Knowledge of Windows server administration

Reference

WIN665-F

Message routing and routing groups
Connecting routing groups
Determining link state
Message routing

Message flow architecture
Management of failed links
Message tracking

Integrating Internet Services with Exchange
Examining Client Connectivity and Security
Kerberos Authentication
Configuring and Securing Front-End and Back-End Servers
Configuring NNTP Services
Troubleshooting Client Connectivity Using Telnet

Introducing Microsoft Outlook Web Access
Examining Outlook Web Access Components and Their Role
Configuring an HTTP Virtual Server
Securing Outlook Web Access Communications

Instant Messaging Overview Instant Messaging
Components Instant Messaging
Installation and Configuration Instant Messaging
Operation and Notes
Practical Tips

Exchange
Monitoring Tools Monitoring Exchange Using the Performance
Monitor Console Monitoring Exchange Using the Monitoring and Status Tool
Logging and viewing diagnostic data

Sessions

Contact us for more informations about session date

Visual Basic 6 – MS1303

Goals


- Learn to develop with VB6, to use forms, to create basic management interfaces

Program

Visual Basic environment
Event programming
Files / Projects and Executable files

Terminology
Familiarization with the workspace

Managing forms Form
properties
Interacting with the user
Using the code window

Overview of Standard Controls
Using Advanced Standard Controls
Using ActiveX Controls
Validating Field-
Level Inputs Validating Code-Level Inputs

Using the menus
Using the toolbars
Using the status bars

Overview of variables
Declaration and scope of variables
Data types
Working with procedures
Conversion and formatting functions

Operators
Using If Then Statements
Using Select Case Statements
Using Do Loop
Using For Next Loops

Principles and interests
Use of classroom modules

Introduction to Objects
Properties, Methods and Events
Working with Objects

The different types of errors
Using break mode
Using step-by-step debugging
Using the Watch window
Using the Execution window

Relational Database Concepts
Using SQL
Overview of ActiveX Data Objects Data
Access Features Data
Manipulation

Overview of runtime errors
The Err object Error
recovery

Distributing an application

Duration

5 days

Price

£ 2375

Audience

All

Prerequisites

Common use of a programming language

Reference

.NE124-F

Sessions

Contact us for more informations about session date

2010 : Planning and Designing a Microsoft Lync Server 2010 Solution (Course MS10534 – Exam 70-665)

Goals


- Design the topology of a Lync Server 2010 solution

- Design the network architecture for a Lync Server 2010 infrastructure

- Know how to plan the migration to Lync Server 2010

Program

Overview of Lync Server 2010 Architecture
Overview of Key Features of Lync Server 2010
Overview of Lync Server 2010 Design Process
Identify Requirements and Update Lync Server 2010 Infrastructure Design
Planning for All Phases of Microsoft Framework Solutions

Planning Infrastructure Requirements for Lync Server 2010
Using Lync Server 2010 Planning Tools
Using Topology
Builder Planning Site Topology
Designing Site Topology Planning Server Infrastructure
Creating Design Documentation Using Microsoft Office

Lync Server 2010 Conferencing and External Capabilities
Dial-In Conferencing
Design Audio / Video and Web Conferencing
Instant Messaging and Presence Planning
Edge Services Design
DNS Implementation
Planning Implementation Planning of the PKI

Load balancing planning Load balancing
design

Mediation server
design Bypass media design

Introduction to the Lync Server 2010 Voice Architecture Lync Server 2010
Telephony Interoperability Options
Defining Number Manipulation
Defining Voice
Policies Designing the
Address Book Service voice routing solution in Lync Server 2010

Planning of media requirements
Planning of bandwidth based on usage
Planning of CAC (Call Admission Control)
Design of CAC

Duration

5 days

Price

£ 2134

Audience

IT professionals with experience in Lync Server 2010 technologies

Prerequisites

Knowledge of Active Directory deployment

Reference

WIN1225-F

Understanding Response Group Services
Planning Response Group
Services Designing Response Group Services

Planning rental services
Design rental services

Introducing Exchange Server 2010 Unified Messaging
Planning a Voicemail Solution with Lync Server 2010
Designing a Voicemail Solution with Lync Server 2010

Planning Site
Resilience
Designing Site Resilience Designing System Monitoring

Designing a Backup / Restore Strategy
Lync Server 2010 Backup and Recovery Considerations

Designing the Monitoring Server Topology
Designing the Archiving Server Topology

Understanding Coexistence and Migration
Designing a Migration Strategy
Planning Clients and Devices
Designing a Migration Strategy for Clients and Devices

Sessions

Contact us for more informations about session date

2010 : Deploy, Configure, and Administer (Course MS10533 – Exam 70-664)

Goals


- Know how to set up Microsoft’s unified communication solution: Lync Server 2010

- Deploy and manage Lync 2010 clients

- Configure and manage conferences

Program

Lync Server 2010 Features Server
Architecture and Roles
Administrative Tools

Prepare for Deployment
Design Process
Deploy Lync Server 2010

Practical Workshops: Preparing the Environment and Deploying Lync Server 2010

Managing Lync Server 2010
Role Based Access Control (RBAC)

Practical workshops: Configuration of users and rights

Preparing for Client
Deployment Lync 2010 Client Deployment
Preparing for Device
Deployment Deploying and Managing IP Phones

Practical Workshops: Client and Device Management 

The Edge Server Role
Topologies for External User Access
Preparing for External User Access
Edge Server Role Deployment Process

Practical workshops: Deployment of external user access

Lync Server 2010 Enterprise Voice Features
Preparing for Enterprise Voice
Deploying Enterprise Voice

Enterprise Voice configuration
Call Park
overview Announcement service overview

Practical Workshops: Implementing Enterprise Voice

Duration

5 days

Price

£ 2134

Audience

Computer systems and telecommunications systems professionals

Prerequisites

Knowledge of telephony concepts

Reference

WIN1224-F

Prerequisites for integrating Exchange Server 2010 SP1 UM with Lync Server 2010
Integration of Exchange Server 2010 SP1 UM with Lync Server 2010

Overview of the Response Groups Service and its application
Response Group Service components Response Group Service
management tools

Practical Workshops: Configure Microsoft Lync Server 2010 Response Group Service

Introduction to Conferencing in Lync Server 2010
Dial-In Conferencing in Lync Server 2010
Managing and Administering Conferencing Policies

Description of the archiving service
Description of the monitoring service
Configuration of archiving and monitoring

Practical Workshops: Configure and Use Archiving and Monitoring in Lync Server 2010

Options for High Availability
Backup and Restore Tools in Lync Server 2010
Exporting and Importing Lync Server Critical Data
Backing Up and Restoring Lync Server Critical Data

Practical workshops: Preparing for disaster recovery

Presentation of CAC functionalities CAC
implementation

Practical Workshops: Implementing Call Admission Control

Overview of emergency and localization service or LIS service
Deployment and configuration of emergency and localization service


Practical Workshops: Characteristics of Voice Resiliency with Lync Server 2010

Features available during different failure scenarios

Practical Workshops: Implementing Voice Resiliency in Lync Server 2010

Sessions

Contact us for more informations about session date

2013 : Business Voice and Online Services with Microsoft Lync Server 2013 (Course MS20337 – Exam 70-337)

Goals


- Design Microsoft Enterprise Voice

- Design and configure network services

- Configure Microsoft Enterprise Voice

- Plan and configure a Lync Online hybrid solution

Program

Characteristics of Enterprise Voice in Lync Server 2013
Architecture and Server Roles   
Site Topologies

Introduction to Voice Routing
Configure Enterprise Voice
Define Voice
Policies DID Assignment
How to Design Dial Plans

Practical Workshops: Preparation for Enterprise Voice – Analysis of the existing voice infrastructure – Configuration of the topology for Enterprise Voice – Configuration of dial plans and normalization rules – Configuration of voice routes – Configuration of voice policies and PSTN Uses – Check and test normalization rules – Test Trunk routing and translation rules – Configuration Inter-Routing Trunk

Overview of Exchange 2013
Unified Messaging Integrate Unified Messaging with Lync Server 2013

Practical Workshops: Designing Exchange Server 2013 Unified Messaging with Lync Server 2013 – Configuring Exchange Server 2013 UM to Work with Lync Server 2013 Enterprise Voice – Configuring Lync Server 2013 Interoperability with Exchange Server 2013 Unified Messaging – Testing and Verifying Integration

Call Park Service
Managing Calls for Unassigned Numbers
PSTN Conferencing
Response Group Service Overview
Implementing Response Group Service

Practical workshops: Implementing Enterprise Voice applications – Configuring a call park – Configuring the unassigned number functionality – Configuring agent groups and queues – Configuring workflows – Configuring the Response Group Service Behavior – Meet-Me Conferencing Configuration

Introduction to the information location server (LIS server)
Overview of the rules for handling digits for access to the E-911 service
Designing location strategies
Implementing LIS
Address discovery
User experience

Practical Workshops: Configuring the Lync Server 2013 Location Information service for emergency calls and E9-1-1 – Creating emergency routes and PSTN Uses – Configuration Number Manipulation for emergency numbers – Definition LIS Locations – Create an E9-1-1 gateway configuration – Emergency call verification through the E9-1-1 gateway – Create an alternate local path for emergency calls

Connection to PSTN
Connection to existing PBX
M: N
routing Reliable call routing

Planning of media prerequisites
Call
admission control Plan
media bypass call admission control

Practical workshops: Call Admission Control implementation – Configuration of CAC components – Verification of the application of the bandwidth policy

Introduction to Phones and Devices
Deploy Devices
Manage Analog Phones in Lync Server 2013

Introduction to Office 365 Architecture
Hybrid Scenarios
Lync Online Strategies
Integrate Lync Online and Lync On-Premise

Practical workshops: Configuring a hybrid deployment of Lync Server 2013 – Setting up Lync hybrid deployment with Lync Online – Preparing online services – Installing the directory synchronization tool – Checking the Lync hybrid deployment

Configure Online users for Enterprise Voice
Configure Lync Edge server to support Exchange UM Online
Enable users for Exchange UM Online

Practical Workshops: Configuring Enterprise Voice for Online and On-Premises Users – Configuring Lync On-Premises Deployment to Work with Lync Online – Testing Voice Calls Between Lync Online and at Deployment Premises

Voice Quality Concepts Explore
Lync Server Monitoring Components
Explore Server Monitoring Reports
RTP and RTCP Information Collected

Practical Workshops: Exploring Monitoring Server Reports – Examining the -to-Peer Detail Session Reports and Call Detail Reports

Voice Resilience in Lync Server 2013
Resilience in Data Centers
Resilience in Branches

Practical Workshops: Implementing Voice Resiliency in Lync Server 2013 – Configuring a standby server for branch offices – Testing and verifying resilience in Branches with a WAN, Pool and SBA – Testing and verifying central Site Resistance Voice

Duration

5 days

Price

£ 2134

Audience

IT and telecommunications consultants who design, plan, deploy and maintain solutions for unified communications, especially VOIP and online services

Prerequisites

Have experience in deploying Lync Server solutions

Have experience in telephony systems

Reference

WIN1091-F

Sessions

Contact us for more informations about session date

C # Advanced : Develop a desktop application

Goals


- Know how to develop complex applications with C #, create basic management interfaces and manipulate objects of the .NET platform

Program

Introducing Windows Forms (WinForms)
Introducing WPF
Windows Forms vs WPF
Application Structure and Resource Management
Window Creation and Communication
Using Controls
Event
Management Window Management and Communication

Workshop: Creation of a simple multi-window application

Binding controls with data
Using user controls
Managing user control events
Implementing background tasks

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

Workshop example: complete case study – a business agenda in C # 

The creation and use of
Multithreading and synchronization processes

Workshop: creation of an application launcher 

Genericity in C #
Basics of introspection in C #
Delegate methods

Workshop: analysis and dynamic use of a class 

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

Duration

5 days

Price

£ 2475

Audience

C# Developers

Prerequisites

Have followed the C # initiation training or equivalent knowledge

Reference

.NE101052-F

Sessions

Contact us for more informations about session date

VB.NET and C #, differences and migrations

Goals


- Know the two essential programming languages ​​of .NET.

- To be able to modify any .NET application from VB.NET to C # and vice versa.

- Know the difficulties and dead ends of this migration

Program

History, compared versions
Summary of possibilities and general differences
Make a choice, consequences and intermediate solutions

General syntax
Types, declarations, variables
Character strings and various access to the system
Conditions, loops, exceptions
Summary of transformations of an algorithm or a function

General summary of OOP with .NET
Imports and namespaces
Calls to methods, parameters, returns
Object life cycle
Inheritances, abstractions, interfaces Delegate
modules
, events
Comparisons, copies
Summary of OOP differences

Duration

2 days

Price

£ 1125

Audience

All

Prerequisites

Knowledge of C # or VB.NET

Reference

.NE227-F

Sessions

Contact us for more informations about session date

C # Expert

Goals


- Acquire advanced notions in C # 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 different versions of C #
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 C #: 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, service windows)
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
Interactivity 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

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

Duration

5 days

Price

£ 2475

Audience

C # Developers

Prerequisites

Have followed the "C # Initiation + Deepening" training or equivalent knowledge

Reference

.NE662-F

Sessions

Contact us for more informations about session date

Nothing to report, very good
Jean-philippe J.
Jean-philippe J.
No Pb Very good
Florent M.
Florent M.
Précédent
Suivant

2013 : Key Solutions for Microsoft Lync Server 2013 (Course MS20336 – Exam 70-336)

Goals


- Use and Deploy Lync Server 2013

- Use Lync Server 2013 Management Interfaces

- Configure Role Based Access Control

- Prepare Client Deployment

- Deploy and Manage IP Phones

- Design a Deployment Strategy for Lync 2013

Program

Lync Server 2013 Architecture
Overview Lync Server 2013 Core Capabilities Overview
Introduction to Lync Server 2013 Design Processes
Define Infrastructure Requirements and Update the Design
Plan for the Different Phases of Microsoft Framework Solutions

Plan infrastructure needs for Lync Server 2013
Use the Lync Server 2013 Planning Tool
Use the Topology Builder
Plan server infrastructure needs
Design documentation using Microsoft Office

Practical workshops: Preparation of the environment and deployment of a Lync Server 2013 Pool – Preparation for Lync Server 2013 – Configuration of a 2013 Lync topology server – Publication of the topology – Domain Name Server (DNS) configuration – Front deployment -End Server Role – Configuring Exchange Unified Messaging and Enabling Users (Lab Exercise Option)

Manage Lync Server 2013
RBAC Role Based Access Control

Practical Workshops: Configuring Users and Rights in Lync Server 2013 – Start Virtual Machines – Using Lync Server Management Shell – Configuring Role Based Access Control

Prepare for client deployment
Deploy and manage Lync 2013 clients
Prepare for device deployment
Deploy and manage IP phones

Practical Workshops: Managing Clients and Devices – Starting Virtual Machines – Creating and Assigning Customer Policies – Creating and Assigning Device Policies – Configuring a Device Update – Creating and Assigning Device Policies ‘mobile device

Intro to Conferencing in Lync Server 2013
Designing Audio, Video, and Web
Conferencing PSTN Conferencing in Lync Server 2013
Managing and Administering Conferences

Practical Workshops: Conferencing in Microsoft Lync Server 2013 – Lync Server 2013 Deployment Conferencing – Office Server Web App Installation

Lync Server 2013 Conferencing and External Access Capabilities
Plan Instant Messaging and Presence Federation
Design Edge Services

Practical Workshops: Design and deployment for external scenarios – Define the Edge server in the topology – Edge server deployment and remote access configuration – Edge server validation

Persistent Chat Architecture Overview
Designing Persistent Chat in Lync Server 2013
Deploying and Configuring Lync Server 2013 Persistent Chat

Practical workshops: Definition of a topology of persistent conversations – Installation of persistent chat and Compliance Service – Persistent configuration and use of Chat rooms

Describe the archiving service
Describe the monitoring service
Configure archiving and monitoring

Practical Workshops: Configuring and Using Archiving and Monitoring in Lync Server 2013 – Configuring Lync Archiving to Exchange 2013 – Configuring the Monitoring Server Role and Lync Server Monitoring Reports – Exploring Lync Server Monitoring Reports

Introduction to Lync Server 2013 Troubleshooting and Administration Tools
Understanding Lync Server 2013 Operational Tasks
Developing Lync Server 2013 Troubleshooting Techniques

Practical Workshops: Lync Server 2013 Administration and Maintenance – Examining Lync Server 2013 Maintenance / Operational Tasks (Paper-Based Lab) – Examining Lync Server 2013 Administration Tools – Enabling Centralized Logging Service – Introduction to Lync Server Analysis 2013 diaries and traces

High availability in Lync Server 2013
Configure high availability in Lync Server 2013
Plan and design load balancing

Hands-On Workshops: Configuring High Availability in Lync Server 2013 – Database Mirror Configuration 

Disaster Recovery in Lync Server 2013 Lync Server 2013
Backup and Restore Tools Lync Server 2013
Critical Data to Back Up and Restore
Lync Server 2013 Critical Data to Export and Import
Design Site Resilience

Overview of Coexistence and Migration Migration
Steps
Plan Clients and Devices
Design Migration Strategy for Devices and Clients

Practical workshops: Plan a migration to Lync Server 2013 (paper-based) – Create a migration plan – Document the migration phases

Duration

5 days

Price

£ 2134

Audience

IT consultants and telecommunications professionals who design, plan, deploy and manage unified communications solutions

Prerequisites

Have good knowledge of Windows Server 2008 R2 or the Windows Server 2012 environment

Have experience using PowerShell for remote administration

Have experience in managing and configuring databases

Have basic knowledge of Active Directory Domain Services (AD DS)

Reference

WIN1090-F

Sessions

Contact us for more informations about session date

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

Word: Advanced + VBA Macros

Goals


- Have an in-depth use of Word

- Work with reference tables

- Make a mail merge

- Discover programming via VBA

- Use Word VBA objects

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

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).

Duration

4 days

Price

£ 2495

Audience

Word users

Prerequisites

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

Reference

BUR1145-F

Sessions

Contact us for more informations about session date

Sharepoint 2019: Use and day-to-day management

Goals


- Discover SharePoint 2019 and understand its use

- Know how to use SharePoint 2019 management tools on a daily basis to be able to manage and feed your SharePoint 2019 sites

Program

SharePoint: presentation, functions
The contributions of SharePoint in companies
Concept of site and site collection
Presentation of SharePoint 2019 and its new interface
Understanding the navigation of a SharePoint site

Document libraries and lists
View on common specificities and different
Customization: Adding, modifying and deleting
Creation of models

Workshop: Using lists and libraries in Sharepoint. Using Templates

Principle of sites and site collection
Creation of a site
Customization of a site
Creation and configuration of themes
Navigation and traffic statistics

Workshop: Create a Sharepoint site and customize it

Presentation of site columns
Document organization
Metadata concept
Activity monitoring: alerts and RSS feeds

Workshop: Manage documents and define alerts

Understanding SharePoint 2019 Pages and Web Pages Page
Customization and Web Parts
Wiki Page Layout and Usage

Workshop: Create and customize pages by integrating Web Parts

Introduction
Using Standard Workflow
Creating a Workflow on SharePoint Designer 2010
The
Search Feature Search in SharePoint

Workshop: Create and use a workflow and search for content

Access Services
Quick site creation
Modern search
Office Web App
The corporate social network
Presentation of the SharePoint MarketPlace

Passing the certification (if provided for in the funding)

Duration

3 days

Price

£ 1956

Audience

Microsoft Solution Users

Prerequisites

Common Windows Use

Reference

WIN100806-F

Sessions

Contact us for more informations about session date

Word: VBA macros

Goals


- Discover programming via VBA

- Use Word’s VBA Microsoft objects

Program

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).

Duration

2 days

Price

£ 2495

Audience

Advanced Word users

Prerequisites

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

Reference

BUR1147-F

Sessions

Contact us for more informations about session date

Sharepoint 2016: Use and day-to-day management

Goals


- Discover SharePoint 2016 and understand its use

- Know how to use SharePoint 2016 management tools on a daily basis to be able to manage and feed your SharePoint 2016 sites

Program

SharePoint: presentation, functions
The contributions of SharePoint in companies
Concept of site and site collection
Presentation of SharePoint 2016 and its new interface
Understanding the navigation of a SharePoint site

Document libraries and lists
View on common specificities and different
Customization: Adding, modifying and deleting
Creation of models

Workshop: Using lists and libraries in Sharepoint. Using Templates

Principle of sites and site collection
Creation of a site
Customization of a site
Creation and configuration of themes
Navigation and traffic statistics

Workshop: Create a Sharepoint site and customize it

Presentation of site columns
Document organization
Metadata concept
Activity monitoring: alerts and RSS feeds

Workshop: Manage documents and define alerts

Understanding SharePoint 2016 Pages and Web Pages Page
Customization and Web Parts
Wiki Page Layout and Use

Workshop: Create and customize pages by integrating Web Parts

Introduction
Using Standard Workflow
Creating a Workflow on SharePoint Designer 2010
The
Search Feature Search in SharePoint

Workshop: Create and use a workflow and search for content

Office Web App
The corporate social network
Presentation of the SharePoint MarketPlace

Passing the certification (if provided for in the funding)

Duration

3 days

Price

£ 1956

Audience

Microsoft Solution Users

Prerequisites

Common Windows Use

Reference

WIN100241-F

Sessions

Contact us for more informations about session date

Sharepoint 2013: Use and day-to-day management

Goals


- Discover SharePoint 2010 and understand its use

- Know how to use SharePoint 2010 management tools on a daily basis to be able to manage and feed your SharePoint 2010 sites

Program

SharePoint: presentation, functions
The benefits of SharePoint in business
Concept of site and site collection
Understanding the navigation of a SharePoint site

Document libraries and lists
View on common specificities and different
Customization: Adding, modifying and deleting
Creation of models

Workshop: Using lists and library in Sharepoint. Using Templates

Principle of sites and site collection
Creation of a site
Customization of a site
Creation and configuration of themes
Navigation and traffic statistics

Workshop: Create a Sharepoint site and customize it

Presentation of site columns
Document organization
Metadata concept
Activity monitoring: alerts and RSS feeds

Workshop: Manage documents and define alerts

Understanding SharePoint 2010 Pages and Web Parts
Customizing Pages and Web Parts Understanding
and Using Wiki Pages

Workshop: Create and customize pages by integrating Web Parts

Overview of workflows
Using standard workflow
Creating a workflow on SharePoint Designer 2010
The search functionality
Search in SharePoint

Workshop: Create and use a workflow – find content

Duration

3 days

Price

£ 1956

Audience

Everyone

Prerequisites

Common Windows Use

Reference

WIN872-F

Sessions

Contact us for more informations about session date

Sharepoint 2010: Administration

Goals


- Know the use, setup and simple administration of a site created with SharePoint 2010

Program

MSF 2010 and MSS 2010 products and architectures
New features for administrators
SharePoint installation and configuration: hardware and software prerequisites
Presentation of installation modes
Web Applications Companions

Workshop: SharePoint 2010 installation and configuration

Notions of Web application, site collections
Restrictions and Quotas
Management of the metadata service

Workshop: Configuring services and managing applications

Presentation of functionalities
Farm and user solutions
Restrictions and limitations of user solutions Company
portal functionalities
Discovery of personal sites and user profiles
Presentation of Web Content Management

Workshop: Test of the different SharePoint functionalities. Define a personal site and manage user profiles

Scope, Keyword, and Content Indexing Definitions
Customizing Search Pages in SharePoint 2010
Overview of Excel Services, Performance Point Services, and Business Connectivity Services

Workshop: Setting up search and indexing options

Understanding SharePoint 2010 Authentication and Authorization
Managing Security and Accounts in SharePoint 2010
Monitoring and Logs
Backup and Restore

Workshop: Authorization setup and authentication management

Duration

3 days

Price

£ 1956

Audience

Everyone

Prerequisites

Windows administration concept

Reference

WIN213-F

Sessions

Contact us for more informations about session date

Trainer: Available, friendly and patient.
Cédric C.
Cédric C.

Sharepoint 2013: Use and day-to-day management

Goals


- Discover SharePoint 2013 and understand its use

- Know how to use SharePoint 2013 management tools on a daily basis to be able to manage and feed your SharePoint 2013 sites

Program

SharePoint: presentation, functions
The contributions of SharePoint in companies
Concept of site and site collection
Presentation of SharePoint 2013 and its new interface
Understanding the navigation of a SharePoint site

Document libraries and lists
View on common specificities and different
Customization: Adding, modifying and deleting
Creation of models

Workshop: Using lists and libraries in Sharepoint. Using Templates

Principle of sites and site collection
Creation of a site
Customization of a site
Creation and configuration of themes
Navigation and traffic statistics

Workshop: Create a Sharepoint site and customize it

Presentation of site columns
Document organization
Metadata concept
Activity monitoring: alerts and RSS feeds

Workshop: Manage documents and define alerts

Understanding SharePoint 2013 Pages and Web Pages
Customizing Pages and Web Parts Understanding and Using Wiki Pages

Workshop: Create and customize pages by integrating Web Parts

Introduction
Using Standard Workflow
Creating a Workflow on SharePoint Designer 2010
The
Search Feature Search in SharePoint

Workshop: Create and use a workflow and search for content

Office Web App
The corporate social network
Presentation of the SharePoint MarketPlace

Duration

3 days

Price

£ 1956

Audience

Everyone

Prerequisites

Common Windows Use

Reference

WIN873-F

Sessions

Contact us for more informations about session date

The trainer adapted the content of his course to the needs of the trainees. Trainer listens to the trainees.
Fares K.
Fares K.

Sharepoint 2013: Administration

Goals


- Know the use, setup and simple administration of a site created with SharePoint 2013

Program

What’s new in SharePoint 2013
Discovery of the new interface
Products and services
SharePoint installation and configuration: hardware and software prerequisites
SharePoint 2013 topologies
Presentation of administration tools

Lab: SharePoint 2013 installation and configuration. Using PowerShell

Notions of Web application, site collections
Restrictions and Quotas
Management of the metadata service

Workshop: Configuring services and managing applications

Presentation of functionalities
Farm and user solutions
Restrictions and limitations of user solutions Company
portal functionalities
Discovery of personal sites and user profiles
Presentation of Web Content Management

Workshop: Test of the different SharePoint functionalities. Definition of a personal site and management of user profiles

Scope, Keyword, and Content Indexing Definitions
Customizing Search Pages in SharePoint 2013
Overview of Excel Services, Performance Point Services, and Business Connectivity Services

Workshop: Setting up search and indexing options

Overview of SharePoint 2013 authentication and authorization
Managing security and accounts in SharePoint 2013
Monitoring and logs
Backup and recovery
Update SharePoint 2013
Installing language packs

Workshop: Authentication and authorization management

Duration

3 days

Price

£ 1956

Audience

Everyone

Prerequisites

Windows administration concept

Reference

WIN884-F

Sessions

Contact us for more informations about session date

PAL1: Professional Agile Leadership

Goals


- Understand the role of management in the implementation of agility in an organization

Program

Introduction

Agile manifesto and agile culture
Why agility?
Why use Scrum?

The Scrum framework

Principles and values,
Sprint and increment,
Roles (Scrum Master, Product Owner, development team),
Events (Sprint planning, Daily meeting, Sprint review and Sprint retrospective),
Artifacts (Product Backlog, Sprint Backlog, Definition of Done ),
Workshop:
Discovery of Scrum.

Agility at scale

Problems related to larger projects,
Some rules for making several teams work on the same project,
The Nexus framework,
Workshop:
Discussion on other extended agility approaches.

Agile Leader

Promote self-organized teamwork,
Develop software:
Practices that promote transparency,
Encourage collaboration,
Guarantee quality.
Deliver value:
Define value,
Planning and estimation in agile mode,
Monitoring of progress and delivery of value in a Scrum project.
Supporting cultural change in the organization:
Some good practices that promote the agile transition of an organization,
Feedback.
Workshop:
Serious game on team collaboration.

Preparation for PAL certification

Review of key points,
Mock exam and correction

Exam

The exam is taken on the last day, online and in English. It consists of a 60-minute MCQ, comprising 36 questions. A minimum score of 85% is required to pass the exam.

Duration

2 days

Price

£ 1595

Audience

Organization directors, Project and program directors, Managers, Team leader, Project manager, Project managers, Anyone involved in the implementation of agility.

Prerequisites

Have notions on the concepts of agility (Scrum, XP, Kanban, Lean), Correct level of written English.

Reference

Mé100563-F

 

Sessions

Contact us for more informations about session date

Excel and Powerpoint for sales people

Goals


- Acquire the fundamentals of Excel and PowerPoint as part of a commercial activity, define, monitor and revise a commercial action plan

- Create reporting

- Establish activity monitoring matrices

- Manage your client portfolio and your activity

- Create supports and slideshows with PowerPoint in complete autonomy

- Create complete presentations on Powerpoint

- Know how to synthesize your ideas

- Make transitions and animations on Powerpoint

Program

Format a cell Format a
table
Reminders of basic formulas: simple calculations, concatenation, percentages, …
Printing tools

Workshop: Create a simple sales table

Import of text and CSV files
Management of international parameters
Formatting of imported data
Use the convert tool on an Excel database

Workshop: Implementing your file via external data

The essential functions: SUM, AVERAGE, MAX, MIN, SUMPROD…
Conditional and logical functions: IF, AND, OR, NB.SI.EN, SUM.SI.EN …
Search functions: VLOOKUP, INDEX and MATCH
Complex functions: nested functions and matrix functions (SOMMEPROD…)

Workshop: Create a document serving as a dashboard

Manage the display of databases: freeze panes, split, new window …
Remove duplicates and create drop-down menus
Apply conditional formatting
Format in table
Use sorting and filter (simple and advanced)
Use the
Generate sparklines subtotal tool

Use the Pivot Tables: Setting up tables, grouping, filter, segment
Use the pivot charts
Use the links sheets or workbooks to summarize the sales of a particular product

Workshop: Create your reporting file

Adapt the result of a calculation via the target value
Perform simulations using the scenario manager
Constraints management using the solver

Workshop: Perform simulations according to customers

Date functions: TODAY, DATE, DATEDIF …
Complex calculations with date functions: OFFSET MONTH, WORKDAY SERIES, OPEN DAY (nesting of functions) …
Use predefined and personalized time formats

Workshop: Sound management planning

Adapt the result of a calculation via the target value
Carry out simulations using the scenario manager
Constraints management using the solver

Workshop: Carry out simulations according to the customers

Duration

4 days

Price

£ 2495

Audience

Sales representatives – Sales executives – Sales assistants

Prerequisites

Have followed the course « Excel: Fundamentals » or have equivalent knowledge, mastering the use of a PC

Reference

BUR100675-F

PowerPoint presentation, 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

Reserved areas
Insert and format text
Insert and customize shapes
Insert and customize images
Insert tables
Graphics and organization charts
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

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 commercial presentation 

Sessions

Contact us for more informations about session date

2010 : Configuring and Managing SharePoint 2010 (Course MS10174 – Exam 70-667)

Goals


- Prepare for the installation of SharePoint 2010

- Configure the logical components and fundamental services of a SharePoint implementation

- Configure services and applications

- Manage SharePoint search

Program

Evaluate the functionality of Microsoft SharePoint 2010
Preparing for SharePoint 2010
Installing SharePoint 2010
Advanced installation of SharePoint 2010

Practical Workshops: Install SharePoint 2010

Perform the initial configuration of the farm
Configure the logical structure of SharePoint
Explore the SharePoint web application and physical architecture

Practical workshops: Create the SharePoint 2010 intranet – Create a Web application – Create a collection site – Create database content

Configure Central
Administration Command-Line SharePoint Administration
Automate SharePoint Operations with Windows PowerShell

Practical Workshops: Automate SharePoint with Windows PowerShell – Administer SharePoint with Stsadm

Optimize content storage and access
Manage site content types and site columns
Configure the managed metadata service

Practical Workshops: Configure Metadata Management

Understanding SharePoint Standard Authentication
Understanding Federated Authentication

Practical Workshops: Configuring Client Authentication – Configuring Secure Store

Administering SharePoint groups
Implementing SharePoint roles and role assignments.
Securing and auditing SharePoint content
Configuring security for SharePoint content

Practical Workshops: Configuring Security for SharePoint Content 

Customize SharePoint
Deploy and manage solutions and features
Configure isolated solutions

Practical workshops: Administration of functionalities and solutions – Administration of isolated solutions – Administration of the developer dashboard

Securing the SharePoint Enterprise service
Securing and isolating Web
Services and service applications

Practical workshops: Administering SharePoint services – Configuring application security

Duration

5 days

Price

£ 2134

Audience

Windows Server 2008 administrators who want to learn how to administer SharePoint 2010 or SharePoint Online

Prerequisites

Knowledge of Active Directory administration and network infrastructure (DNS, TCP / IP)

Knowledge of security and authentication

Knowledge of the implementation, management and support of Windows Server 2008

Reference

WIN1198-F

Configure User Profiles
Implement SharePoint 2010 Social Network Features

Practical workshops: Configuration of the user profile – Configuration of « My Sites »

Search configuration Search
refinement

Practical Workshops: Configuring Research – Redefining Research

Implement Business Connectivity
Service
Implement Excel Services Implement PerformancePoint
Services
Implement InfoPath Services
Implement Visio Services
Implement Access Services Implement Office Web Apps

Install servers and farms
Upgrade to SharePoint 2010
Evaluate installations and upgrades
Configure SharePoint operation settings
Update SharePoint

Practical Workshops: Preparing SharePoint 2007 to evolve to SharePoint 2010 – Upgrade SharePoint 2007 to SharePoint 2010

Protecting and restoring content
Using backup and restore for disaster recovery
Implementing high availability solutions

Practical workshops: Set up the backup and restore strategy

Log monitoring
Configuring SharePoint Health Analyzer
Configuring Usage Reports and Web Analytics
Monitoring and Optimizing SharePoint Performance

Practical Workshops: Configure the diagnostic recording – Manage the recordings with the ULS viewer – Configure the « Health Analyzer » rules – Build the reports using the SharePoint Logging database

Sessions

Contact us for more informations about session date

Excel : For HR managers

Goals


- Manage and analyze employee information

- Improve recruitment management through various analyzes

Program

Formatting a cell
Formatting a table
Reminders on basic formulas: simple calculations, concatenation, etc.
Printing tools

Import of text and CSV files
Management of international parameters
Formatting of imported data
Use the convert tool on an Excel database

Workshop: Implementing your file via external data

The essentials: SUM, AVERAGE, MAX, MIN…
The conditional and logical functions: IF, AND, OR, NB.IF.EN, SUM.IF.EN …
The search functions: VLOOKUP, INDEX and MATCH
the functions of text: TEXT, LEFT, CAPITAL, DELETE …

Dates functions: TODAY, DATE, YEAR, MONTH, DATEDIF …
complex calculations with dates functions MONTH OFFSET, workdays, NB.JOUR.OUVRE (nested functions) …
Use predefined and custom formats pm
The negative hour formats and calculations

Workshop: create an hourly cost management table

Creation of the table structure
The information to be filled in (name, salary, entry date, etc.)
Apply conditional formatting
Format in a table
Sort and filter the employees
set up data validation: date, drop-down menu…
Entry message Entry restriction Alert message

Use the Pivot Tables: grouping, filter, segment
Produce statistics by centers, functions, seniority, salaries …
Calculations on: payroll, average, minimum and maximum salary …
Perform graphic representations: Age pyramid …

Workshop: Create different summary tables

Duration

2 days

Price

£ 2495

Audience

HR managers

Prerequisites

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

Reference

BUR955-F

Sessions

Contact us for more informations about session date

Excel : For sales managers

Goals


- Define a sales strategy

- Track sales and results

Program

Formatting a cell
Formatting a table
Reminders of basic formulas: simple calculations, concatenation, percentages, etc.
Make graphical representations of data
Printing tools

Workshop: Create a sales budget table

The essentials: SUM, AVERAGE, MAX, MIN…
The conditional and logical functions: IF, AND, OR, NB.IF.EN, SUM.IF.EN …
The search functions: VLOOKUP, INDEX and MATCH
Complex functions : nested functions and matrix functions (SUMPRODUCT …)

Workshop: Carry out individual follow-up of sales representatives

Date functions: TODAY, DATE, DATEDIF …
Complex calculations with date functions: OFFSET MONTH, WORKDAY SERIES, OPEN.DAY (nesting of functions) …
Use predefined and personalized time formats

Workshop: Sales planning management

Manage the display of databases: freeze panes, split, new window …
Apply conditional formatting
Format in table
Use sorting and filter (simple and advanced)
Use the subtotal tool
generate graphics sparkline

Use the Pivot Tables: Setting up tables, grouping, filter, segment
Use the pivot charts for sales analysis
Use the links between sheets or workbooks to summarize the sales of a particular product
Insert comments and objects on a leaf

Workshop: setting up analytical reports and assessments on activities and results

Adapt the result of a calculation via the target value
Perform simulations using the scenario manager
Constraints management using the solver

Workshop: Perform simulations according to customers

Duration

2 days

Price

£ 2495

Audience

Sales directors – Managers – Team leaders

Prerequisites

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

Reference

BUR954-F

Sessions

Contact us for more informations about session date

Professional Scrum With Kanban

Goals


- Have an exact understanding of the Scrum framework and the Kanban approach, their difference, Understand how Kanban practices can be used in a Scrum project, Have tools and indicators to improve the efficiency of your team’s practices, Prepare for certification Professional Scrum with Kanban 5PSK) from Scrum.org

Program

Introduction

History,
Agile Manifesto.

The Scrum framework

Principles and values
Sprint and increment
Roles (Scrum Master, Product Owner, development team)
Events (Sprint planning, Daily meeting, Sprint review and Sprint retrospective)
Artifacts (Product backlog, Sprint Backlog, Definition of Done)
Workshop:
Discovery by Scrum

Kanban theory, principles

Definition of a workflow
Kanban practices:
Viewing the workflow
Limiting the work in progress (WIP)
Managing the flow
Making the process explicit
Setting up feedback
loops Collectively improving
Workshop:
Building a Kanban flow

Scrum with Kanban

Some myths
When to combine Scrum and Kanban?
How to implement Scrum in Kanban teams?
Kanban practices to optimize flow
How to implement Kanban in Scrum teams?
Scrum events based on the
Service Level expectation flow

Workshops:

Illustration of practices by example

MCQ.

Metrics

Measure the work in progress (cumulative Flow Diagram)
Measure the cycle time
Measure the flow (Troughput)
Measure the age of the elements
Workshop:
Discussion on the use of metrics, advantages and risks.

Preparation for certification

Review of key points Mock
exam and correction.

Exam

The exam is taken on the last day, online and in English. This consists of a 60-minute MCQ, comprising 45 questions. A minimum score of 85% is required to pass the exam.

Duration

2 days

Price

£ 1595

Audience

Managers, Project managers, Project managers, Architects, Developers, Production engineers, Integrators, Anyone involved in the implementation of kanban.

Prerequisites

Have knowledge of the concepts of agility (Scrum, XP, Kanban, Lean), Correct level of written English.

Reference

Mé100606-F

 

Sessions

Contact us for more informations about session date

2010 : Design and develop applications (Course MS10232 – Exam 70-576)

Goals


- Evaluate access methods and data access

- Determine presentation methods, visuals, programming objects and multilingual strategies

- Create a strategy for the implementation and deployment of custom solutions

Program

Memory Server
Server CPU
Transfer and Client

Practical Workshops: Page Dimension and ViewState – Memory and Performance

Background SharePoint
Page Parts
Pages
Globalization and localization
Design for accessibility

Practical Workshops: Selection of Page Parts and Page Types

Basics of Lists and Libraries
Large Volume Strategies
SharePoint Data Management

Practical workshops: Time tracking and invoice management

Design data capture
Design integration

Practical Workshops: Creation of external lists and InfoPath Shape

Customer needs
Create sites

Practical Workshops: Incident response site – Expense reports

Multi-server
In and Out configurations of the
« getting work done » Sandbox
Working with Workflows

Practical workshops: Design an engineering system – Creation of a detection report

Understand the packaging life cycle
Establish design principles

Practical Workshops: Building a Business Solution document – Working with dependencies

Development for the enterprise
The role of Logging
Flexibility and configuration of applications

Practical Workshops: Operational registration – Team registration and configuration

Duration

5 days

Price

£ 2134

Audience

Developers and development project managers using SharePoint 2010

Prerequisites

Experience required in developing applications for SharePoint

Reference

WIN1201-F

Application lifecycle
Versioning strategy
Update

Design information architecture
Plan software limitations
Design navigation

Practical Workshops: Developing a structured site – Implementing a Farm-wide navigation

Introduction to « branding »
Themes
Master Pages
CSS
Overview of tools
Implementing SharePoint « branding »

Security in SharePoint
Use a different identity store
Take a deeper look at security requirements
Forms authentication

Practical Workshops: Solving a security problem

Optimize SharePoint pages
Analyze performance with the SharePoint dashboard
Optimize performance of access to SharePoint data

Test unit
Improve tests
Load tests

Sessions

Contact us for more informations about session date

Excel : For accountants

Goals


- Establish a provisional budget

- Analysis of the investment

Program

Format a cell Format a
table
Reminders on basic formulas: simple calculations, concatenation, percentages, etc.
Printing tools

Workshop: Establish an expense report

Import of text and CSV files
Management of international parameters
Formatting of imported data: number format, text format, etc.

Essentials: SUM, AVERAGE, MAX, MIN …
Conditional and logical functions: IF, AND, OR, COUNTIFS, SOMME.SI.ENS …
Dates functions: TODAY, DATE, YEAR DATEDIF …
The calculations and formats of hours
Accounting and financial functions: AMORLIN, VPM, INTER, PRINCPER…

Workshop: Create an amortization or loan schedule

Manage the display of databases: freeze panes, split, new window …
Apply conditional formatting
Format in table
Use sorting and filter (simple and advanced)
Use the subtotal
tool Validation tool data with drop-down menu

Text functions: TEXT, LEFT, STXT, CNUM, etc.
Use the convert tool
Search functions: VLOOKUP, INDEX and MATCH Pivot
tables: Setting up tables, grouping, filter, segment
Use standard graphics or graphics dynamic crosstabs for an accounting or financial analysis
Use the links between sheets or workbooks for inventory work

Workshop: setting up analytical reports and assessments on activities and results

Adapt the result of a calculation via the target value
Perform simulations using the scenario manager
Constraints management using the solver

Workshop: Perform simulations according to customers

Duration

2 days

Price

£ 2495

Audience

Accountants – Accounting assistants – accountants

Prerequisites

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

Reference

BUR953-F

Sessions

Contact us for more informations about session date

Excel : For sales people

Goals


- Define, monitor and revise a commercial action plan

- Create reports

Program

Format a cell Format a
table
Reminders of basic formulas: simple calculations, concatenation, percentages, …
Printing tools

Workshop: Create a simple sales table

Import of text and CSV files
Management of international parameters
Formatting of imported data
Use the convert tool on an Excel database

Workshop: Implementing your file via external data

The essential functions: SUM, AVERAGE, MAX, MIN, SUMPROD…
Conditional and logical functions: IF, AND, OR, NB.SI.EN, SUM.SI.EN …
Search functions: VLOOKUP, INDEX and MATCH
Complex functions: nested functions and matrix functions (SOMMEPROD…)

Workshop: Create a document serving as a dashboard

Manage the display of databases: freeze panes, split, new window …
Remove duplicates and create drop-down menus
Apply conditional formatting
Format in table
Use sorting and filter (simple and advanced)
Use the
Generate sparklines subtotal tool

Use the Pivot Tables: Setting up tables, grouping, filter, segment
Use the pivot charts
Use the links sheets or workbooks to summarize the sales of a particular product

Workshop: Create your reporting file

Adapt the result of a calculation via the target value
Perform simulations using the scenario manager
Constraints management using the solver

Workshop: Perform simulations according to customers

Duration

2 days

Price

£ 2495

Audience

Sales representatives – Sales executives – Sales assistants

Prerequisites

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

Reference

BUR952-F

Sessions

Contact us for more informations about session date

PSD certification preparation (scrum.org)

Goals


- Define the action of a developer in an agile project

- Learn good development and testing practices in an agile Scrum environment.

Program

Master the agile Scrum method

The Scrum framework / Guide
Lifecycle of a Scrum project
Roles defined by Scrum: Product Owner, Scrum Master, Team
Time boxes: Sprint planning, Sprint Review, Sprint Retrospective, Daily Scrum
Artifacts: Product Backlog, Sprint Backlog, Burndown chart
Rules and key principles of Scrum
Responsibilities / role

Workshop: analysis of the Scrum guide and XP practices

Analyze the product

Product vision analysis
Understanding the organization of roles (RACI)
Product backlog construction process
Writing user stories: form, INVEST specification
Complements of a user stories: operational constraints, models, ..
Writing of tests acceptance (Behavior Driven Development method)
Test automation tools

Workshops:
– Construction of a story map, identification of MMFs (Minimum Marketable Features).
– Construction of the roadmap.
– Writing user stories and three amigos workshops for acceptance tests.

Estimate and prioritize stories

Estimation techniques: ideal days vs story points
Implementation of the story points method
Reliability of the estimation
Factors for prioritization of needs
Prioritization methods: Kano vs MOSCOW vs Relative weights
Prioritization by themes: themes screening / scoring
Management of risks
Grouping and final order of stories in the product backlog

Workshops:
– Poker planning game for the estimation of stories.
– Calculation of the priority with the method of relative weights.
– Redesign of the product backlog.

Develop within an agile team

Practices XP (eXtreme Programming)
Daily Scrum meeting: approach, interest
development Standards
Technical Debt: classification, prioritization, planning
Architecture, refactoring, design patterns and Crosscutting Concerns
Tests in an agile environment unit, functional, integration, …
Techniques tests: TDD, BDD, ATDD
Treatment of anomalies
Management of the life cycle of an application (ALM)
Understanding the performance indicators: Burn Down and Burn Up chart
Presentation of progress monitoring: Kanban board, Parking Lots
Sprint review
Sprint retrospective

Workshops:
– Animation of a sprint planning meeting, division of stories into tasks.
– Test writing and automation
– Design patterns
– Sprint review: actors, demonstration, validation of stories.
– The art of retrospective. – Use of agile project management tools.

Understand the development environment

Mastering an SCM (Git or SVN): operation, main commands
Continuous integration: principles, use: Jenkins, GitLab CI
Continuous delivery: DevOps tools
Panorama of agile Scrum project management tools

Prepare for PSD certification

Overview of scrum.org certifications Scrum.org
PSD: presentation, certification process, duration
Details of the subjects covered by the certification:
– The Scrum Framework
– Scrum Theory and Principles
– Cross-functional, Self-organizing Development
– Analysis
– Emergent Architecture
– Programming
– Test First Development
– Standards
– ALM – Application Lifecycle Management

Workshops:
– Examples of Questions + Commented answers.
– Time management during the certification process.

Duration

1 day

Price

£ 1693

Audience

Developers working in an agile Scrum team

Prerequisites

Knowledge of the Scrum framework

Reference

Mé100105-F

 

Sessions

Contact us for more informations about session date

2010 : Infrastructure design (Course MS 10231 – Exam 70-668)

Goals


- Create a logical and service application architecture

- Design a security plan for SharePoint 2010

- Develop a maintenance and monitoring plan for the deployment of SharePoint 2010

- Develop a continuity plan for SharePoint 2010

Program

Identify business needs
Overview of the logical architecture of SharePoint 2010
Document your SharePoint environment
Document the logical architecture

Introduction to the Application Services
Architecture in SharePoint 2010 Application Services Architecture and Its Components
Topologies for Application
Services Projecting Application Services into the Logical Architecture

Principles of performance planning
Design and performance
Principles of capacity planning
Design and capacity

Choice of supported components for SharePoint deployments SharePoint
farm topologies
Associate the logical architecture with a physical architecture

Design security for a SharePoint 2010 solution
Plan for service accounts
Plan security for users and groups
Plan for SSL implementation

Authentication
Overview Introduction to Claims-Based Authentication
Selecting Authentication Methods

Metadata in SharePoint 2010
Overview of
Managed Metadata Content Types and Business Needs

Overview of Social Networking Features
Plan Social Networking Features in SharePoint 2010
Plan for User Profile Service

Overview of the SharePoint 2010 search architecture Search
topologies in SharePoint 2010
Capacity planning and performance for search
Match business needs with the design plan for Search

Overview of content management
Plan tasks for content management
Plan features and policies for content
management Plan for web content management

Overview of Business Intelligence Principles
Plan Data Access Using BCS
Plan SharePoint 2010 Business Intelligence Solutions
Plan Reports and Presentation

Duration

5 days

Price

£ 2134

Audience

SharePoint administrators with experience on version 2010 or earlier

Prerequisites

Have followed the training « Course MS10175 »

Have experience in the implementation of SharePoint

Reference

WIN1200-F

Governance overview
Key elements of the governance plan
Plan governance in SharePoint Server 2010
Implement governance features and policies in SharePoint Server 2010

Principles of maintenance and monitoring
Create a maintenance and monitoring plan for SharePoint 2010
Considerations for maintaining and monitoring related technologies

Overview of Business Continuity Management
Developing the Business Continuity Plan for a SharePoint 2010 Solution
Creating a Backup and Restore Plan

Identify Update Scenarios
Plan Your Update
Considerations for Updates

Sessions

Contact us for more informations about session date

Excel : For buyers

Goals


- Create a call for tenders

- Compare supplier offers

- Create a dashboard

Program

Format a cell Format a
table
Print tools

Workshop: Create a call for tenders

Import of text and CSV files
Management of international parameters
Formatting of imported data
Format as a table
Remove duplicates
Use the convert tool

Workshop: Implementing your file via external data

Reminders on the basic
formulas Conditional formulas: IF, AND, OR, NB.SI.ENS, SOMME.SI.ENS …
Search formulas: VLOOKUP, INDEX and MATCH Pivot
tables: setting up tables, grouping, filter, extractions
Creation of a graph for visual synthesis

Table with several hypotheses
Carry out simulations using the scenario manager

Workshop: Perform simulations according to suppliers

Links between sheets and workbooks
Date formulas: TODAY, YEAR, DATE …
Text formulas: LEFT, STXT, CONCATENATE
Create visual alerts: conditional formatting
Create drop-down menus

Workshop: Create a document serving as a dashboard

Duration

2 days

Price

£ 2495

Audience

Buyers – Purchasing department assistants

Prerequisites

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

Reference

BUR951-F

Sessions

Contact us for more informations about session date

2013 : Advanced Solutions for Microsoft SharePoint Server 2013 (Course MS20332 – Exam 70-332)

Goals


- Describe the main features of SharePoint 2013

- Plan and design a SharePoint Server 2013 environment

- Plan and configure social networking features

- Manage solutions in a SharePoint 2013 deployment

Program

Main components of the SharePoint 2013 architecture
New features in SharePoint 2013
Introducing SharePoint Server 2013 and SharePoint Online

Practical workshops: Review the main concepts of SharePoint 

Design database topologies for high availability and
disaster recovery Design SharePoint infrastructure for high availability
Plan for disaster recovery

Practical Workshops: Plan and execute backups and restores

Plan application services
Design and configure a service application topology
Configure service application federation

Practical workshops: Planning an application service – Federating application services between SharePoint Server Farms

Plan and configure BCS connectivity services
Configure the « Secure information store » service
Manage BDC (Business Data Connectivity) models

Practical workshops: Configure BCS and the « Secure information bank » service – Manage BDC models

Manage user profiles
Activate social interactions
Create communities

Practical workshops: Configure profile synchronization and « My Sites » – Configure the community of sites

Aggregate Tasks
Plan and Configure Collaboration Features
Plan and Configure Composite Features

Practical Workshops: Configure « Project sites » and the workflow

Plan Business Intelligence
Plan, deploy and manage Business Intelligence services
Plan and configure advanced analysis tools

Practical workshops: Configure Excel services – Configure PowerPivot and Power View for SharePoint

Configure search for an enterprise environment
Configure the search experience
Optimize search

Practical Workshops: Planning an Enterprise Search Deployment – Managing Search Relevance in SharePoint Server 2013

Duration

5 days

Price

£ 2134

Audience

IT professionals responsible for the installation, configuration, deployment and management of SharePoint Server 2013

Prerequisites

Have followed the training « Course MS20331)

Experience required in the management of Microsoft Windows 2008 R2 or Windows Server 2012

Reference

WIN1197-F

Plan content management
Plan and configure content discovery (eDiscovery)
Plan records management

Practical Workshops: Configure eDiscovery in SharePoint Server 2013 – Configure Records Management in SharePoint Server 2013

Plan and implement the web content management infrastructure
Configure navigation and catalog sites
Support multiple languages ​​and localization
Enable design and customization
Support mobile users

Practical workshops: Configure browsing and catalog sites – Configure device channels

Understand the architecture of SharePoint solutions
Manage « sandbox » solutions

Practical workshops: Managing solutions

Understand the architecture of SharePoint Apps
Provide and manage Apps and application catalogs

Practical workshops: Configure and manage SharePoint applications

Introduction to planning governance
Key elements of a governance plan
Plan governance in SharePoint Server 2013
Implement governance in SharePoint Server 2013

Practical workshops: Develop a plan for governance – Manage the creation and deletion of site

Prepare for the update and migration environment
Implement the update process
Manage site collection updates

Sessions

Contact us for more informations about session date

SAFe Scrum Master (SAFe SM)

Goals


- Understand the principles of the Scaled Agile Framework (version 4.5)

- Characterize the role of Scrum Master

- Understand and be able to implement a Program Increment

- Understand the concepts of coaching an agile team

- Prepare the “SAFe SSM” exam

Program

Scrum in the SAFe context

Agility Concepts,
The Agile Manifesto and Scaling,
The Fundamentals of Scrum,
SAFe Principles and Roles,
Agile Release Train (ART). 

The Scrum Master

His responsibilities towards the team,
His responsibilities in a SAFe context,
The expected skills. 

Planning a Program Increment (PI planning)

Preparation of the event,
Features and types of stories,
Design the planning of the PI,
Determine the objectives of the PI planning,
Control the risks
Improve the planning process of the increment

Facilitate the execution of the iteration

The role of the Scrum Master in planning,
Planning and monitoring the progress of the iteration,
Refine the Backlog,
Facilitate the review of the iteration and the system demo,
The role of the Scrum Master in daily quality,
Continuous deployment with DevOps,
Deliver on demand,
The metrics to use.

End a Program Increment

Performance measurement of the Program Increment,
Facilitate the inspection and adaptation workshop.

Coach an agile team

Serving leader,
The stages of forming a high-performance team according to Tuckmann,
Facilitating the events of the SAFe team,
Questions from a coach,
Developing team spirit and resolving conflicts.

Preparation for the "SAFe SSM" exam

Exam

On passing the exam is done offline in a month of training, online and in English. This consists of a 90-minute MCQ, comprising 45 questions. A minimum score of 73% is required to pass the exam.

Teaching methods and means

Theoretical, practical and participatory presentation, given in FR or EN, alternating:

Theoretical presentation,

Discussion around the organizational cases of the participants,

Simulation of a « PI planning »,

Practice exams with answers.

Are provided to trainees:

Support in EN presented by a certified instructor, note-taking paper format (black & white) or online access,

MCQ and mock exams in EN,

Requires a room equipped with PC (trainer and trainees), internet connections, a video projector and a whiteboard or flipchart.

Mode of exemption

 In face-to-face.

Duration

2 days

Price

£ 1595

Audience

Scrum Master, future Scrum Master, Agile Coaches, Anyone involved in the implementation of large-scale agility

Prerequisites

Have knowledge of the concepts of agility (Scrum, XP, Kanban, Lean), Have significant experience in an Agile team, Correct level of written English

Reference

Mé100485-F

 

Sessions

Contact us for more informations about session date

2013 : Developing Advanced Solutions for Microsoft SharePoint Server 2013 (Course MS20489 – Exam 70-489)

Goals


- Describe the main features of SharePoint 2013

- Plan and design a SharePoint Server 2013 environment that meets high availability and disaster recovery requirements

- Plan and implement a service application architecture for the deployment of SharePoint 2013

- Configure and manage Apps in a SharePoint Server 2013 environment

Program

Main components of the SharePoint 2013 architecture
New features in SharePoint 2013
Introducing SharePoint Server 2013 and SharePoint Online

Practical Workshops: SharePoint Concepts Basics Exam – Configuring SharePoint Server 2013 Farms – Creating and Configuring Site Collections and Sites

Design database topologies for high availability and
disaster recovery Design SharePoint infrastructure for high availability
Plan for disaster recovery

Practical workshops: Planning and performing backups and restores – Create a backup and restore plan – Test the backup and restore process

Plan application services
Design and configure a service application topology
Configure service application federation

Practical Workshops: Federating Applications Services between SharePoint Server farms – Planning an application service topology – Creating an application service instance – Establishing trust relationships between SharePoint Farms – Publishing and consuming service applications – Planning an application service architecture

Plan and configure BCS connectivity services
Configure the « Secure information store » service
Manage BDC (Business Data Connectivity) models

Practical workshops: BCS configuration and the Secure Information Store Service – Configuration of the business data connectivity service application – Configuration of the secure Information Store service – Configuration of a Target Application secure service store – Import and configuration of BDC models – Business Connectivity data model management

Manage user profiles
Activate social interactions
Create communities

Practical workshops: Configuration of a synchronization profile and My Sites – Configuration of the synchronization of a profile – My Sites configuration – Creation of a community infrastructure for the site – Configuration of the community participation of the site – Configuration of community sites

Aggregate Tasks
Plan and Configure Collaboration Features
Plan and Configure Composite Features

Practical workshops: Configuration of project sites – Creation of project sites – Configuration of project sites – Engage project teams – Configure Windows Azure Workflow and SharePoint Workflow Services – Create and test a workflow – Configure workflows

Plan Business Intelligence   
Plan, deploy and manage Business Intelligence services
Plan and configure advanced analysis tools

Practical Workshops: Configuration Excel Services – Provisioning Excel Services – Configuration of external data access – Configuration of data links – Configuration of PowerPivot for SharePoint – Configuration of Power View for SharePoint – Configuration of PowerPivot and Power View for SharePoint

Configure search for an enterprise environment
Configure the search experience
Optimize search

Practical workshops: Planning an Enterprise Search deployment – Planning a search solution – Configuration of a Thesaurus – Configuration of extractors and refiners – Configuration of spelling correction queries – Configuration Company name Extraction – Manage the relevance of searches in SharePoint Server 2013

Plan content management
Plan and configure content discovery (eDiscovery)
Plan records management

Practical Workshops: Configuring document management in SharePoint Server 2013 – Creating and configuring an eDiscovery center – Discovering and preserving content – Querying and exporting content – Configuring in place case management – Configuring eDiscovery in SharePoint Server 2013

Plan and implement the web content management infrastructure
Configure navigation and catalog sites
Support multiple languages ​​and localization
Enable design and customization
Support mobile users

Practical workshops: Configuration of browsing sites and Managed Catalog – Configuration of product catalog sites – Configuration of Cross-Site publication – Configuration of publish sites – Configuration of device channels – Configuration of device channels

Understand the architecture of SharePoint solutions
Manage « sandbox » solutions

Practical Workshops: Solution Management – Configuration of management of sandboxed solutions at farm level – Configuration of management of sandboxed solutions at site collection level – Deployment of Agricultural solutions

Duration

5 days

Price

£ 2134

Audience

IT professionals responsible for installing, configuring, deploying and managing SharePoint Server 2013 in a datacenter or in the cloud

Prerequisites

Have followed the training « The main solutions of Microsoft SharePoint Server 2013 »

Good experience in analyzing business needs for the implementation of a logical and physical design

Good experience in managing Microsoft Windows 2008 R2 or Windows Server 2012 and knowledge of IIS, security, configuration of Active Directory, management of remote applications with Windows PowerShell 2.0 as well as applications connected to SQL Server

Reference

WIN1098-F

Understand the architecture of SharePoint Apps
Provide and manage Apps and application catalogs

Practical Workshops: Configuring and managing SharePoint applications – Configuring a SharePoint server farm to support applications – Creating and configuring an enterprise application catalog – Deploying and monitoring Applications

Introduction to planning governance
Key elements of a governance plan
Plan governance in SharePoint Server 2013
Implement governance in SharePoint Server 2013

Practical workshops: Manage the creation of sites and deletion – Creation of a governance plan – Creation and policies of Publishing Site – Activation and self-service management Site creation – Development of a plan for governance

Prepare for the update and migration environment
Implement the update process
Manage site collection updates

Practical workshops: Realization of a database extension -Attach – Import the SharePoint 2010 Databases – Migration and upgrade of a service application – Migration and upgrade of a content database – Preparing Collections for site upgrade – Upgrading site collections – Managing upgraded site collections

Sessions

Contact us for more informations about session date

2013 : Key Solutions for Microsoft SharePoint Server 2013 (Course MS20331 – Exam 70-331)

Goals


- Describe the key features of Microsoft SharePoint 2013

- Design an information architecture

- Design logical and physical architectures

- Install and configure SharePoint Server 2013

- Create web applications and site collections

- Plan and configure service applications

- Manage users and permissions

- Configure authentication in SharePoint 2013

- Secure the deployment of SharePoint 2013

- Manage taxonomy

- Configure user profiles

- Configure search

- Monitor and maintain a SharePoint 2013 environment

Program

Key components of SharePoint deployment
New features in SharePoint 2013 SharePoint 2013
deployment options

Understand business needs
Organize information in SharePoint Server 2013
Plan for information discovery (eDiscovery)

Practical Workshops: Creating an information architecture – Identifying site columns and content types – Designing a corporate taxonomy

Identify business needs
Overview of the logical architecture of SharePoint Server 2013
Document your logical architecture

Practical Workshops: Designing a logical architecture – Planning a logical architecture – Producing a Logical Architecture diagram

Design physical components for SharePoint deployments
Design support components for SharePoint deployments SharePoint
farm topologies
Transpose logical architecture design to physical architecture design

Practical Workshops: Design of a physical architecture – Develop a physical Architecture Design diagram

Install SharePoint Server 2013
Configure SharePoint Server 2013 farm settings
Installation and configuration script

Practical Workshops: Deploying and configuring SharePoint Server 2013 – Configuring SharePoint Server 2013 farm settings – Provisioning a SharePoint 2013 server farm – Configuring Server 2013 SharePoint farm settings – Configuring outgoing Email – Configuring the integration with Office Web Apps Server 2013

Create web applications
Configure web applications
Create and configure site collections

Practical workshops: Creation and configuration of Web applications – Creation and configuration of site collections – Creation of a Web application – Configuration of a Web application – Creation of site collections – Creation of site collections in the new databases of content – Creation of a Warm-up script

Introduction to the Service Application Architecture
Create and Configure Service Applications

Practical workshops: Planning and configuration of service applications – Configuration of service applications for document conversion – Configuration of Proxy Service Request Groups

Permissions in SharePoint 2013
Manage access to content

Practical workshops: Fixing content in SharePoint sites – Creating a web application strategy – Creating and managing SharePoint groups – Creating custom permission levels – Managing permissions and inheritance – Managing the security site collection – Enable anonymous access to a site – User and group management

Authentication Overview
Configure Federated Authentication
Configure Server-to-Server Authentication

Hands-on Workshops: Configuring SharePoint 2013 to use federated identities – Configuring AD FS to make the web application a relying party – Configuring SharePoint to Trust AD FS as an identity provider – Configuring the web application to use the AD FS identity provider

Secure the platform
Configure farm level security

Practical Workshops: Hardening a SharePoint 2013 server farm – Configuring SharePoint and SQL Server to communicate on non-standard ports – Configuring firewalls for SharePoint Server farms – Configuring blocked file types – Configuring Web Security part – The implementation security audit – Firm configuration – Security level

Manage content types
Understand term stores and term sets
Manage term stores and term sets

Practical Workshops: Configuring Content Types Propagation – Creating Content Types for Propagation – Publishing Content Types Across Site Collections – Configuring the Managed Metadata Service – Creating Term Sets and Conditions – Consuming Term Sets

Duration

5 days

Price

£ 2134

Audience

IT professionals who want to learn how to install, configure, deploy and manage Microsoft SharePoint Server 2013 in a data center or in the cloud

Prerequisites

Experience required in the deployment and administration of SharePoint 2007 or 2010 server farms

Knowing how to manage Microsoft Windows 2008 R2 or Windows Server 2012

Knowing how to configure Active Directory for authentication and authorizations

Knowing how to manage a remote application using PowerShell 2.0

Knowing how to connect applications to SQL Server

Knowing how to implement claims-based security

Reference

WIN1097-F

Configure the user profiles service application
Manage user profiles and audiences

Practical workshops: My sites and audience configuration – Creation of a user of an application service profile – Directory import configuration – My sites configuration – Audiences configuration – User profiles configuration

Understand the architecture of the search service
Configure search
Manage search

Practical Workshops: Configuring the search experience – Configuring the search service application – Configuring a content source file share – Configuring a content source file share – Configuring a local SharePoint Source content – Creation of a Research Center – Optimization of Research Results – Personalization of the research experience

Monitor a SharePoint 2013 environment
Customize and optimize a SharePoint environment
Plan and configure the cache
Troubleshoot a SharePoint 2013 environment

Practical Workshops: Investigate Load Times – Configure Health Data Usage and Collection – Configure SharePoint Diagnostic Logging – Configure Health Analyzer Rules – Examine Usage and Health Data – Analyze SharePoint performance page – Monitoring a SharePoint 2013 Deployment

Sessions

Contact us for more informations about session date

SCRUM: PSPO II (Professional Scrum Product Owner)

Goals


- Deepen your understanding of Scrum principles. Master Scrum to know how to implement it in complex situations.

- Develop your human and technical skills to better fulfill the role of Product Owner.

- Prepare to take the Scrum.org “PSPO II” exam.

Program

Content

Agile and Scrum
Origin and Manifesto,
Reminders on the Scrum framework: Scrum
theory (Empirical process, values, pillars),
Major artefacts (Product Backlog, Definition of done, etc.),
Events,
Roles (Product owner, Development team, Scrum Master).

The Product Owner and the value

Define the elements that constitute the value of the product,
Optimize the ROI and the TCO,
The importance of the vision for the Product Owner,
Tools for the vision,
Notions of Minimum Viable Product and Minimum Marketable features, Product roadmap
,
Manage debt technique:
Identify it, Techniques for repayment of technical debt.

Management of the Product Backlog by the Product Owner

Content (types and characteristics of elements),
Refine the Product Backlog with the development team,
Write user stories (theories and practices),
Tools to prioritize the Product Backlog,
Example: story mapping,
Example of Product Backlog management in a tool (JIRA).

The Product Owner and the Release Plan

Estimation and velocity: Estimation
techniques (points and other units),
When to estimate?
Release planning (cone of uncertainty),
Manage the content of releases in the Product Backlog,
Progress follow-up and transparency,
Indicators to measure the value produced.

Scaling Scrum

Scrum of scrums,
Nexus:
The context and the working environment,
The roles,
The events.

Preparation for the PSPO II Professional Product Owner exam

Advice for the exam,
Mock exam with commented correction.

Duration

2 days

Price

£ 1595

Audience

Product Owner, Agile Managers.

Prerequisites

Have good knowledge of the Scrum framework, Have real experience in implementing Scrum, Have obtained the PSPO I certification (Scrum.org), Correct level of written English.

Reference

Mé100566-F

 

Sessions

Contact us for more informations about session date