Étiquette : Intermediate

OneNote : Collaborative work

Goals


- Create, organize and share your notes

- Access your notes from devices (Computer, phone, tablet)

Program

Screen management and handwritten note input
Recording audio notes
Title styles
Quick text input and canvas management
Bullets and enumerations (creation and grouping + customization)
Comfortable movement in texts
Handwriting
Application and Removal of indicators
Management of indicators

Use of text search (direct keyboard writing or OCR)
Search for indicators
Management of markers Note Flags
Audio and Video search

Publish / Unpublish a SharePoint / OneDrive notebook
Share a notebook
View page history and filter by authors
Simultaneous note taking
OneNote Web App (OneNote Services)
OneTastic and macros

Workshop: Sharing and collaborative work 

Duration

0.25 day

Price

£ 225

Audience

Everyone

Prerequisites

Knowledge of Office office tools

Reference

BUR100910-F

Sessions

Contact us for more informations about session date

Word: Knowing how to manage a long document

Goals


- Make good use of paragraph styles

- Use useful features to handle a long document

- Insert tables and illustrations in your document

Program

Set up paragraph styles

Understand the interest of styles
Use predefined styles
Create and apply your custom style

Workshop: Create title styles on several levels

Handling a long document

Insert page breaks and section breaks
Implement page numbering
Manage headers and footers
Use the automatic table of contents tool

Workshop: Set up the necessary functionalities on a long document

Enhance your document with other content

Create and manipulate a table
Insert and format an image
Quickly insert screenshots
Organize all the inserted content
Integrate an Excel table with or without link

Workshop: Insert illustrations in your document

Duration

0.25 day

Price

£ 2495

Audience

Office 365 users

Prerequisites

Know how to use the basic functions of Word (insert text, format)

Reference

BUR100917-F

Sessions

Contact us for more informations about session date

OneNote : Organize yourself in your note-taking

Goals


- Knowing how to organize yourself in your note-taking

- Create and share notebooks

Program

Understand how it works
Create personal and shared notebooks
Understand sections, pages and subpages
Use OneNote software and retrieve notebooks

Workshop: Create a notebook shared between all participants

Insert a note
Embed a file in a notepad
Add media and links
Use the indicators
Highlight certain notes

Workshop: Take notes over an Excel file

Duration

0.25 day

Price

£ 225

Audience

Office 365 Users

Prerequisites

Have knowledge of the Office 365 environment

Reference

BUR100879-F

Sessions

Contact us for more informations about session date

Word: Insert text and apply formatting

Goals


- Handle text well in Word

- Know how to apply simple formatting

- Manage paragraph layout

Program

Handling text with Word

Insert paragraphs and line breaks
Display and understand hidden symbols
Shortcuts to quickly select your text

Apply formatting to its text

Change the font type, size and color
Use basic formatting (bold, italics, underline)
Apply borders to certain paragraphs
Highlight text
Duplicate formatting

Apply a layout to its paragraph

Use indents and spacing
Change the alignment
Manage line spacing and spaces between paragraphs
Use common styles
Apply formatting combining themes and styles among those offered in Word

Workshop: Change the layout of certain paragraphs

Handling bulleted lists

Choose and insert a bulleted list
Define a hierarchy between the bullets
Create a personalized bulleted list on several levels

Duration

0.25 day

Price

£ 2495

Audience

Office 365 users

Prerequisites

Have knowledge of the Office 365 environment

Reference

BUR100916-F

Sessions

Contact us for more informations about session date

Excel: statistical and usual functions

Goals


- Know the usual functions of Excel

- Know how to use these functions and apply them to a large volume of data

Program

Use usual and statistical functions

NBVAL, NBVIDE, NBCAR … ROUND, ROUNDUP, ENT … SUM.SI, NB.SI … SUM.SI.EN, NUM.SI.EN … TODAY NOW RANK Name manager 

Workshop: Apply functions to specific data

Duration

0.25 day

Price

£ 2495

Audience

All

Prerequisites

Have followed Excel: Create simple calculation tables or have equivalent knowledge

Reference

BUR100918-F

Sessions

Contact us for more informations about session date

Excel: Introduction to Macros (VBA)

Goals


- Know how to use the macro recorder

- View the VBA code of a macro

Program

Introduction to Macros

Operation of the macro recorder

– The basics to know (Naming, keyboard shortcuts …)
– The Personal Macro workbook
– Relative movement
– Launch a Macro (Create a button, a quick access command, etc.)
– Read the code generated by the recorder

Workshop: Create a Simple Formatting and Calculation Macro in a Table

Duration

0.25 day

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR100990-F

Sessions

Contact us for more informations about session date

Excel: Create simple calculation tables

Goals


- Know how to structure a simple calculation table

- Know how to use basic calculations

Program

Create calculation tables

Formulas and calculation operators + – * /% … <> <= <> … & Use the fill handle Cell formats Use absolute references Basic functions: Sum, Average, NB, Max, Min

Workshop: Realization of a calculation table

Duration

0.25 day

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR100980-F

Sessions

Contact us for more informations about session date

Excel : Pivot tables

Goals


- Master the creation of dynamic tables with Excel

Program

Build pivot tables

Review the design of basic TCDs (placement of fields)
Integrate multiple calculations
Define grouping and sorting criteria
Insert segments
Integrate custom calculation fields
Generate a pivot chart

Duration

0.25 day

Price

£ 2495

Audience

Office 365 users

Prerequisites

Proficiency in basic Excel functions

Reference

BUR100969-F

Sessions

Contact us for more informations about session date

Excel : Manage data tables

Goals


- Create a functional data table

- Apply specific sorts and filters

- Use conditional formatting

Program

Create a data table

Format Table
Set Table Style Options
Apply Totals

Workshop: Transform a range of data into a table

Use a data table

Use sorting at one or more levels
Apply filters (classic or advanced)
Calculate subtotals

Workshop: Working with the data of a table

Highlight certain data

Apply conditional formatting
Create a custom formatting rule
Use sorts and filters with formatting

Duration

0.25 day

Price

£ 2495

Audience

All

Prerequisites

Have followed « Excel: Creating and handling tables » or have equivalent knowledge

Reference

BUR100975-F

Sessions

Contact us for more informations about session date

PowerPoint Initiation + Advanced and passing of the TOSA certification

Goals


- Learn to create presentations with PowerPoint

Program

PowerPoint presentation
Different uses of the software
Presentation tips

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

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

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

Use slide themes
Add a background
Create your own theme

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

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

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

Duration

2 days

Price

£ 750

Audience

Everyone

Prerequisites

Knowledge of Word and Excel

Reference

BUR557-F

  

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

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

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

Synthesis
Questions / Answers

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

Sessions

Contact us for more informations about session date

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

Excel: Create and manipulate tables

Goals


- Know how to use table styles

- Create custom table styles

- Use automatic sorts and filters

Program

Apply table styles

Use predefined styles
Define style options
Create a custom style

Workshop: Create a style using a graphic charter and save it

How to handle a table in Excel

Move around in a large table
Quickly select the desired cells
Automate a series of numbers or dates
Reorganize your table with sorting
Use automatic filters to display only certain data
Freeze cells for a large table

Workshop: Using sorts and filters on your tables

Duration

0.25 day

Price

£ 2495

Audience

All

Prerequisites

Know how to use the basic functions of Excel (fill a cell, format)

Reference

BUR100919-F

Sessions

Contact us for more informations about session date

Stream: Stream videos to a corporate channel

Goals


- Know how to create groups and video channels

- Import and configure your videos

Program

Get started with Microsoft Stream

Familiarize yourself with the interface
Create a group or channel
Upload a video
Watch a video

Workshop: Create your channel and upload videos to it

Manage video options

Generate and edit automatic transcripts
Make video content indexable Search
effector
Invite collaborators
Upload video

Workshop: Configure the videos of your channel according to your needs

Duration

0.25 day

Price

£ 2495

Audience

All

Prerequisites

Have knowledge of the Office 365 environment

Reference

BUR100889-F

Sessions

Contact us for more informations about session date

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

Goals


- Discover the new features of Office

- Know the main features of Word

- Be able to write a simple letter

- Know how to send a mail merge

- Work in a group

- Introduction to VBA programming

- Know the word objects

Program

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

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

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

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

How to use themes?
Mix themes
Printing and printing options

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

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

Duration

5 days

Price

£ 1725

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR410-F

  

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

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

Create and manage a document on several columns

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

Print
Fax
Send by email
Send by email in PDF format

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

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

Create a table of figures

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

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

Customize the Quick Access Toolbar
Customize the Ribbon

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

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

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

Modifying the code of a macro
Language syntax
Variables
Text, numeric or date data types
Arrays
Constants
Operators

The Application object
The Document
object
The Paragraphs object
The Range object The Characters object

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

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

Synthesis
Questions / Answers

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

Sessions

Contact us for more informations about session date

SharePoint: Define access rights and navigation

Goals


- Define access rights

- Create specific authorizations

- Control site navigation

Program

Reminders

Working with collaborators on a team site
The main content in a SharePoint site How
access rights work

Define access rights

Give access to the entire SharePoint site
Set permission levels
Create groups with specific permissions
Grant access to specific content
Enable guest access to someone outside the organization

Workshop: Create a group of collaborators with access only to specific content

Manage site navigation

Use the « Quick Launch » bar or the tree view
Create a page with navigation web parts
Highlight content on a page
Filter and sort the content to display on a page

Workshop: Create a page with content adapted to a group of collaborators

Duration

0.25 day

Price

£ 2495

Audience

All

Prerequisites

Have followed the first module on SharePoint or have equivalent knowledge

Reference

BUR100914-F

Sessions

Contact us for more informations about session date

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

Goals


- Have an in-depth use of Word

- Know how to direct mail

- Work in a group

- Introduction to VBA programming

- Know word objects

Program

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

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

Create and manage a document on several columns

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

Print
Fax
Send by email
Send by email in PDF format

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

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

Create a table of figures

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

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

Customize the Quick Access Toolbar
Customize the Ribbon

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

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

Duration

4 days

Price

£ 750

Audience

Word users

Prerequisites

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

Reference

BUR212-F

  

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

Modifying the code of a macro
Language syntax
Variables
Text, numeric or date data types
Arrays
Constants
Operators

The Application object
The Document
object
The Paragraphs object
The Range object The Characters object

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

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

Synthesis
Questions / Answers

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

Sessions

Contact us for more informations about session date

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

SharePoint: Manage a team site

Goals


- Knowing the different types of SharePoint site

- Knowing how to create web pages

- Inserting web part content

Program

Get started with SharePoint Online

SharePoint site types
Familiarize yourself with the interface
Configure site access rights
Define the appearance of the site

Workshop: Create a SharePoint site and activate sharing

Embed content

Insert a list
Import a document library
Create news
Add an external application

Manage the pages of the site

Define home page content
Create and publish web pages
Define page layout via sections
Insert web part content

Workshop: Create web pages on your site

Duration

0.25 day

Price

£ 2495

Audience

All

Prerequisites

Have knowledge of the Office 365 environment

Reference

BUR100875-F

Sessions

Contact us for more informations about session date

Word : VBA and Passage of the TOSA certification

Goals


- Introduction to VBA Programming

- Knowing Word Objects

Program

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

Modifying the code of a macro
Language syntax
Variables
Text, numeric or date data types
Arrays
Constants
Operators

The Application object
The Document
object
The Paragraphs object
The Range object The Characters object

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

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

Synthesis
Questions / Answers

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

Duration

2 days

Price

£ 750

Audience

Advanced Word users

Prerequisites

Good knowledge of Word

Reference

BUR206-F

  

Sessions

Contact us for more informations about session date

Teams: Meeting facilitation

Goals


- Add tabs in a team channel

- Create a wiki

- Share content in a meeting

- Know the shortcuts

Program

Differences between conversation, meeting, team, and channel
Interacting with your contacts
Schedule and start a meeting

Mention a specific member
Use the different types of message in a conversation
Use the predefined tabs
Add a tab to a document / website / video …
Create a wiki

Workshop: Create a team channel between participants and use the tools

Share your desktop or window
Create and share a whiteboard
Share a document
Use meeting notes
Blur your background
Record a meeting
Divide the participants of a meeting into a group via rooms

Workshop: Create a meeting between participants and use the tools

Quickly find a contact
Use predefined Microsoft Teams commands

Duration

0.25 day

Price

£ 2495

Audience

Office 365 users

Prerequisites

Have followed the first module on Teams or have equivalent knowledge

Reference

BUR101341-F

Sessions

Contact us for more informations about session date

Teams: Knowing how to use all communication tools

Goals


- Add tabs in a team channel

- Create a wiki

- Share content in a meeting

- Know the shortcuts

Program

Differences between conversation, meeting, team, and channel
Interacting with your contacts
Schedule and start a meeting

Mention a specific member
Use the different types of message in a conversation
Use the predefined tabs
Add a tab to a document / website / video …
Create a wiki

Workshop: Create a team channel between participants and use the tools

Share your desktop or window
Create and share a whiteboard
Share a document
Use meeting notes
Blur your background
Record a meeting
Divide the participants of a meeting into a group via rooms

Workshop: Create a meeting between participants and use the tools

Quickly find a contact
Use predefined Microsoft Teams commands

Duration

0.25 day

Price

£ 2495

Audience

Office 365 users

Prerequisites

Have followed the first module on Teams or have equivalent knowledge

Reference

BUR100878-F

Sessions

Contact us for more informations about session date

Teams : Create your own teams and launch a videoconference

Goals


- Understand how Microsoft Teams works

- Add and organize contacts

- Create and set up a team

- Schedule and start a meeting


Program

Understand how it works and its vocabulary Set up your
account
properly Define your shortcuts

Add contacts to your account
Organize your contacts using groups
Start a conversation with a contact
See a contact’s activity

Workshop: Register your contacts in several groups

Join or create a team
Configure your team properly
Add a channel to a team
Start a conversation in a channel

Workshop: Create teams and channels according to your needs

Check availability through the calendar
Schedule a meeting
Start a meeting without scheduling it
Start a meeting from a conversation

Workshop: Planning and initiating meetings between participants

Duration

0.25 day

Price

£ 2495

Audience

Office 365 Users

Prerequisites

Have knowledge of the Office 365 environment

Reference

BUR100915-F

Sessions

Contact us for more informations about session date

OneDrive : Knowing how to organize for collaborative work

Goals


- Knowing how to organize your documents with OneDrive

- Knowing how collaborative work works

- Knowing how to configure your workstation with OneDrive

Program

Understanding how it works
Differences between web app and software app
Connection between OneDrive and other Office apps

Personal space VS shared space
Create folders
Add and import documents
Access shared libraries

Workshop: Define a tree structure and create sharing folders between participants

Activate sharing options
Methods to open a document (view, review and edit)
Add comments to a document
Access the version history on a document

Workshop: Work together on the same document

Install and configure OneDrive
Synchronize a local folder with its OneDrive profile
Activate software sharing

Workshop: Install OneDrive and activate synchronization

Duration

0.25 day

Price

£ 2495

Audience

Office 365 users

Prerequisites

Have knowledge of the Office 365 environment

Reference

BUR100876-F

Sessions

Contact us for more informations about session date

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

Goals


- Discover the new features of Office

- Know the main features of Excel

- Be able to perform calculations and use functions

- Know how to handle graphics and pivot tables

- Introduction to VBA programming

Program

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

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

Creating tables
Automatic formatting
Creating a custom style

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

Layout Page
breaks
The printing area
Printing and printing options

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

Duration

5 days

Price

£ 1725

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR407-F

   

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

Sorting, sorting options
Automatic filters

Custom filters

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

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

Convert and consolidate
Data validation
Scenario analysis

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

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

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

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

The Application object
The Workbook object
The Worksheet object

The Range object

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

Synthesis
Questions / Answers

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

Sessions

Contact us for more informations about session date

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

Goals


- Be able to perform calculations and use functions

- Know how to handle graphics and pivot tables

- Use VBA

Program

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

Sorting, sorting options
Automatic filters

Custom filters

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

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

Convert and consolidate
Data validation
Scenario analysis

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

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

Duration

4 days

Price

£ 1425

Audience

Excel users

Prerequisites

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

Reference

BUR100-F

  

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

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

The Application object
The Workbook object
The Worksheet object

The Range object

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

Synthesis
Questions / Answers

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

Sessions

Contact us for more informations about session date

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

Excel : VBA and Passage of the TOSA certification

Goals


- Introduction to VBA

- Knowing Excel Objects

Program

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

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

The Application object
The Workbook object
The Worksheet object

The Range object

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

Synthesis
Questions / Answers

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

Duration

2 days

Price

£ 750

Audience

Advanced Excel users

Prerequisites

Good knowledge of Excel

Reference

BUR98-F

  

Sessions

Contact us for more informations about session date

Trainer: Very attentive and does not hesitate to break the course to return.
Philippe S.
Philippe S.
Trainer: Very good reactivity, was able to answer specific questions.
Christophe P.
Christophe P.
Excellent pedagogical approach. Subject perfectly mastered and willingness of the speaker to adapt to the degree of understanding of the trainee. Trainer: Didier Gonnard for VBA: perfect!
Franck S.
Franck S.
Training meeting my expectations. Competent and friendly team and trainer.
Arnaud L.
Arnaud L.
Great, the trainer adapted to my needs. trainer who listens and is available.
Yann G.
Yann G.
Fields too wide to be covered in a few days ... would require 15 days of training!
Stéphane Yann L.
Stéphane Yann L.
Pleasant environment. Good training but more training hours are needed to master the good basics. Trainer: Pleasant and available. Satisfactory training. Thank you !
Latif D.
Latif D.
Précédent
Suivant

Skype for Business 2019: how to use

Goals


- Learn about using Skype

- Share information with Skype

Program

Skype, the strong link in communication
Available offers
Authentication and discovery of the interface
Configuration of Skype for Business 2019: profile information, audio / video devices

Workshop: Configuring Skype 2019 and overview of features

Adding contacts
Using search and viewing the contact card
Contact links
Managing contact groups

Workshop: Managing contacts in the tool

Initiating an instant conversation
Adding elements during a conversation: people, sound / video
Switch between several conversations
Managing the history of a conversation
Audio / video conversations
Cloud voicemail

Workshop: Using instant messaging

Online meeting / conference
Participatory management
Views and animation

Workshop: Meeting planning and facilitation

Sharing the Windows desktop, presentation, or application
Sharing files and managing permissions: Attachments, OneNote
Using the whiteboard
Organizing surveys

Workshop: File sharing and authorization management.

Duration

1 day

Price

£ 2495

Audience

Everyone

Prerequisites

Knowledge of Windows and Office

Reference

BUR100817-F

  

Sessions

Contact us for more informations about session date

OmniPage

Goals


- Scan a document from a scanner or from a photo

- Produce a PDF document with formatted text that conforms to the original

- Produce a fully reformatted PDF or Word document

Program

Printing screen, pixels, pixel / area ratio, dot / area ratio, printing methods
understanding the difference between resolution and definition.
Understand how the different characteristics of the source (resolution, distortions and perspectives, typography, shading, paper and printing defect) can influence OCR. 
Learn to optimize the quality of the source.

The different panels, the basic commands, the display modes of the text editor, the toolbars, the OPD format.

Using the scanner and camera to import documents in various formats.

The various editing tools and their use to improve the efficiency of character recognition and to clean up the document background for export to formatted PDF.

Define the image, text and exclusion zones, the order of the zones for reformatting, manage the columns.

Manual proofreading and correction of errors, use of the spell checker and user dictionary.

Use of TruePage formatting modes, Layout tools. Plain Text, Formatted Text.

The level of formatting, export options to PDF and Word formats, single-page document and multi-page document, quality control in an external PDF reader, test print and word search.

Using the workflow, automating and configuring options.

Duration

2 days

Price

£ 2495

Audience

Everyone

Prerequisites

Knowledge of the Windows environment. Basic use of a word processor. Handling a Scanner and Camera

Reference

BUR100339-F

  

Sessions

Contact us for more informations about session date

Skype 2016 Use

Goals


- Learn about using Skype

- Share information with Skype

Program

Skype: presentation, features
Offers
Installation
Connection management
Interface discovery
Skype 2016 settings
Customization of profile: activity, photo
Audio and video device settings
Creation of contacts
Inter-contact link Group
management
Search for contacts
Display of maps

Workshop : Configuring Skype and handling the interface – Managing contacts

Tool features
Starting an instant conversation and adding contacts
Sharing audio and video
Managing multiple conversations Conversation
history

Workshop: Using instant messaging

Organization of online meetings
Scheduling
Meeting options
Attendance and / or facilitation
View
management Participant management
Recordings
Microsoft Teams meetings (if Office 365 subscription)

Workshop: organization and participation in an online meeting

Application or desktop
sharing PowerPoint presentation sharing
Handling management
File sharing: attachments, notes
Sharing rights
Using the whiteboard
Question and answer
sessions Poll

Workshop: Sharing documents and using available tools

Duration

1 day

Price

£ 2495

Audience

Everyone

Prerequisites

Knowledge of Windows and Office

Reference

BUR100575-F

  

Sessions

Contact us for more informations about session date

IPhone / iPad: Use of Apple mobiles or tablets

Goals


- Master the use of an iPhone / iPad for professional use

Program

Switching on, charging, switching
on Phone desktop structure
Open, quit an application
Delete an application
Organization of applications: grouping in a folder
Managing blockages of an application

Workshop: Organization of mobile applications – visualization of multi-tasking applications

Locking the device with a password
Setting the date / time
Changing the screen brightness
Keyboards management; suggestions
Mobile network management: manual or automatic
Connection to a wireless network
Device reset
Notifications (alerts)

Workshop: Setting up the mobile and managing notifications

Consult the directory
Add contacts, associate photos
Synchronize contacts with Google Contacts or other

Workshop: Definition of contacts and synchronization

Consulting the calendar
Adding an appointment to its calendar
Managing alerts

Workshop: Consulting the agenda and adding appointments

Configuration of an email account (Hotmail, Gmail, Yahoo, etc …)
Setting of the number of messages displayed
Changing the signature of the email
Folders, Reading messages, opening attachments
Writing, replying or forwarding a message
Organization of messages: folders, deletion, …

Workshop: Setting up and using an email account

Writing and organizing notes
Sending by email

Workshop: Writing and sending notes

Consulting websites, multi-tabs
Performing a search
Adding bookmarks to favorites, viewing
Browsing history management

Workshop: Internet browsing and management of favorites

Find, install a third-party application
Settings, uninstall
Social network applications: Twitter, Facebook, …

Workshop: Installation of third-party applications

Take a photo or video
Settings: resolution, zoom, effects
Send as an attachment by message or email, compression

Workshop: Taking photos, videos and sending

Application permissions
Back up content

Workshop: Security management and data synchronization

Duration

1 day

Price

£ 2495

Audience

Everyone

Prerequisites

Office automation concepts

Reference

BUR885-F

  

Sessions

Contact us for more informations about session date

Prezi

Goals


- Learn how to create presentations with Prezi Next

Program

Introducing Prezi
Different uses of the software
Other software

Presentation tips: time, scenario, useful tips
Start well, finish well
The plan
Put the images forward

Practical workshop: Prepare your plan with Mindmapping

Creation of a user account
Configuration of the account

Practical workshop: Account creation

Presentation
Mouse function
Managing models
Modifying the model
Adding text
Drawing
Adding a graphic

Practical workshop: Choice of a model and modification

Adding and modifying frames and arrows
Inserting and formatting text
Integrating these elements into the path
Configuring the path
Managing movements
Adding a transition effect

Practical workshop: Prepare a plan, manipulation of frames and sequencing

Inserting images
Editing an image
Inserting shapes
Editing a shape
Embed videos, Youtube
Embed audio
Import external files (PDF, PowerPoint, videos …)
External link

Practical workshop: Creating a complete presentation

Creating a theme
Using a theme
3D background
Creating a custom theme

Prezi’s sharing options
Co-publishing sharing
Printing your work
Online recording
Export
Embed in a site

Screen ratio management
Activating and using keyboard shortcuts
Using presentation mode

Use
Synchronisation
Folder

Practical workshop: Creation of a presentation for your personal or professional project

Synthesis

Duration

1 day

Price

£ 375

Audience

Everyone

Prerequisites

Basic computer skills

Reference

BUR762-F

  

Sessions

Contact us for more informations about session date

Nice idea of ​​support in usb key! thank you very much. I think i will make some nice dynamic presentations! Trainer: I arrived with lots of questions, I left without! excellent thank you again thank you for the welcome, for the clear and precise explanations!
Véronique B.
Véronique B.
Very pleasant and performance-enhancing, to work on screens and machines of this quality. Simple and production-oriented course Trainer: Mr. Plisson also produces with the PREZI software, I greatly appreciated his expertise and his availability to meet my needs.
Vincent N.
Vincent N.
Well located, pleasant place. Well-constructed course with a logical sequence. The paper support is very good. Answer to all my questions. Listening, sympathetic, patient and professional trainer.
Ophelia A.
Ophelia A.
Précédent
Suivant

Google Fundamental Apps + Websites + Administration

Goals


- Learn to use Google application

- Master the administration and configuration of Google Apps

- Learn how to create and upload a website with Google Sites

Program

Overview of Google applications: architecture, services
Benefits of Google Apps
Data security and confidentiality
Google accounts and single sign-on

Creating an account
Organizing folders
Managing conversations
Managing attachments: viewing, printing
Tags, filters and searches
GTalk instant messaging: voice / video, telephone, conference
Archiving

Workshop: Using a Google email account and advanced settings

Presentation of Google Contact Contact
management: creation, modification, deletion Group
management
Contact sharing
Restoring deleted contacts
Merge duplicates

Workshop: Organization of contacts

Google Calendar: interface presentation, features
Recording an appointment
Availability search
Event management: creation, searches
Definition of reminders
Calendar management: creation, shared resources, publication
Data export
Access management

Workshop: organization of a person / professional agenda

Google Documents: presentation, functionalities
Creation of documents
Import, export
Management of models
Creation of forms
Sharing of documents and collections
Collaborative work
Version management
Publishing
Storage capacities

Workshop: Document management – Creation of forms and collection of results

Google Apps Marketplace: available applications, operation
Activation of applications
Access to Google Apps from a mobile

Overview of Google applications: architecture, services
Data security and confidentiality
Administration tasks

User
management Group
management Access management
Synchronization with an LDAP (Microsoft Active Directory) server
Reporting
Domain setting
Account information
Appearance management

Workshop: Multiple administration tasks

Messaging (GMail)
Instant messaging (GTalk)
Google Calendar
Google Sites
Google Docs
Video
Google Contact
Mobile access

Workshop: Administration of the various Google services

Website: components, creation and uploading (domain)
Panorama of Google applications: architecture,
Google services Sites: interest, operation
Data security and confidentiality
Google accounts and single sign-on

Creation of a site
Management of the theme, customization options
Colors and fonts
Management of the pages: creation, available templates
Integration of content: photos, videos, documents
Integration of an agenda
Creation and management of forms
Upload of files
Access management
Versions of
Collaborative work page

Workshop: Creation and publication of a complete website

Integration of a search bar
Integration of advertisements with Google Adsence
Creation of scripts
Audience monitoring with Google Analytics Google
tools for webmaster: sitemap, referencing
Registration in other search engines
Google domain management, site mapping with a personal domain

Workshop: SEO, website monitoring

Duration

5 days

Price

£ 2495

Audience

Everyone

Prerequisites

Notions of office automation and website creation

Reference

BUR739-F

  

Sessions

Contact us for more informations about session date

Google Apps: Administration

Goals


- Master the administration and configuration of Google Apps

Program

Overview of Google applications: architecture, services
Data security and confidentiality
Administration tasks

User
management Group
management Access management
Synchronization with an LDAP (Microsoft Active Directory) server
Reporting
Domain setting
Account information
Appearance management

Workshop: Multiple administration tasks

Messaging (GMail)
Instant messaging (GTalk)
Google Calendar
Google Sites
Google Docs
Video
Google Contact
Mobile access

Workshop: Administration of the various Google services

Duration

1 day

Price

£ 2495

Audience

System administrators, Google Apps applications

Prerequisites

Notions of administration and knowledge of web services

Reference

BUR698-F

  

Sessions

Contact us for more informations about session date

NICT architectures

Goals


- Know the principles and challenges of new IT architectures

Program

Introduction

Some glossary elements
Classifications of computer communication architectures

Classifications, current state

Multiple contexts of use; mobility, desktop virtualizations, etc.
Summary of language classification Common
themes for reflection: light / heavy client, master / server, SQL / NoSQL, etc.

Main technologies

Relationships between languages, communities, modules and
Java suppliers :
.Net standards and evolutions : languages, tools, possibilities,
PHP implementations : current state,
Python limits : particular niches,
Ruby community , Smalltalk, COBOL, …: overview , issues
Consequences of language and supplier choices
Inter-communication in the real world
Other shared technologies (HTML, XML, etc.)

The Web and its evolution

Technological bases and first use, Web pages Web
2.0, Web 3.0, new mechanisms and their consequences
Ready-to-use tools and the community web
Web services: interest, challenges, alternatives
Classification of SOA, by mode of action, by supplier
Jobs around the Web and the consequences on architecture
Feedback on mobility

Virtualization

Interests associated with virtualization – rationalization, simplification, availability, security
Major market players, comparison, evolution
Elements of implementation, SDN
Material and architectural consequences of virtualization of client workstations, servers, various equipment

Various distributed architectures

Replication, grids and cloud computing: distinction, base, current players
Application of distributed architectures to software components
Outsourcing, SaaS: degrees, costs, control, quality
Specific study of the internationalization of an architecture

Implementation methods

Developments in IT methods
Documentation, modeling of new architectures
Adaptation of risk management methods and usual production methods
Assessment and feedback on specific cases

Duration

2 days

Price

£ 1485

Audience

Project manager, software architects, IS directors

Prerequisites

Computer architecture concepts

Reference

GES677-F

 

Sessions

Contact us for more informations about session date

Google Sites: Free websites and wikis

Goals


- Learn how to create and upload a website with Google Sites

Program

Website: components, creation and uploading (domain)
Panorama of Google applications: architecture,
Google services Sites: interest, operation
Data security and confidentiality
Google accounts and single sign-on

Creation of a site
Management of the theme, customization options
Colors and fonts
Management of the pages: creation, available templates
Integration of content: photos, videos, documents
Integration of an agenda
Creation and management of forms
Upload of files
Access management
Versions of
Collaborative work page

Workshop: Creation and publication of a complete website

Integration of a search bar
Integration of advertisements with Google Adsence
Creation of scripts
Audience monitoring with Google Analytics Google
tools for webmaster: sitemap, referencing
Registration in other search engines
Google domain management, site mapping with a personal domain

Workshop: SEO, website monitoring

Duration

2 days

Price

£ 2495

Audience

Everyone

Prerequisites

Office automation concepts

Reference

BUR699-F

  

Sessions

Contact us for more informations about session date

Urbanization of information systems

Goals


- Learn how to build the backbone of an IS (business architecture, urban planning and systems architectures) in order to make it flexible and thus increase the responsiveness of the company or organization

- Measure changes and anticipate changes in information systems

- Identify the different architectures and move towards a suitable scenario

- Understand the state of the art of the market: the best approaches and current IT technologies

Program

The 4 principles used: structuring, modeling, factorization, transformation
The basic principles of an IS
The structuring of an IS (the model)
The importance of the organization
The top-down and bottom-up approaches
The 3 main stages to achieve an efficient IS
How to map the existing IS
How to build the target IS
The approach by components
Examples of integration of the existing IS into the target IS
The convergence plan of the existing IS towards the target IS
The actors of the IS and their missions
The main definitions in an IS: consistency, cohesion, flexibility,
agility, breakability, stability, performance, scalability
Management approaches: COBIT, ITIL, CMMI, agile methods, UnifiedProcess, TOGAF; MDA
What is IS urbanization?
The positioning of these approaches
The needs of companies or organizations
The modeling of strategic needs
The blueprint for the IS strategy
How to determine the needs of a company: decision-making IS
Big Data
Expression of needs and monitoring of requirements

Practical work

What is business architecture and why to optimize it
Identify and analyze business processes with their factorization
Identify and analyze business objects with their factorization
The business process model Business
architecture: best practices
Standards: BPA, BPM, BPMN, BPEL, MDM, BRM, BAM, PPM
Find the target business architecture based on business or organization needs

Practical work

What is IS urbanization and why urbanize?
The main urbanization levers and projects
How to align the IS on the target
The calculation of Return Of Investment in an urbanization process
The division of the IS into zones, districts, blocks, blocks
The main urban planning rules and the main patterns
The different communication modes
SOA (Service Oriented Architecture)
WOA (Web Oriented Architecture) with the ROA implementation
Comparison SOA – ROA
Business Event Processing
Mainframe integration
Rules of functional architecture
How to build the target functional urban plan from target business architecture

Practical work

Technical town planning and tools
Communication tools: XML language and its derivatives
Communication tools: MOM, MOT, ETL, EAI, ESB
Tools for: performance, service reliability, security (encryption, authorization services, strong authentication, LDAP directories, Liberty Alliance, Open-ID, data integrity, network security)
Tools for exploitability, Virtualization with different modes, Cloud computing
How to build the cilable technical urban plan which must ensure the technical base of the target IS

Practical work

The correspondence table between the 3 urban planning
Good practices in application planning
Standards: 3-tier software architecture; free software, Open Source, freeware, design patterns, Web Application Servers, the JEE model, the Microsoft .Net model, the PHP model, other languages ​​(Java One, Scala, Ruby, Groovy, Beanshell), webservices with SOAP and REST protocols
Presentation level: HTML5 objectives, heavy and rich clients, portals, mashup techniques, Web 2.0 and 2.1,
Frameworks, Framework standards, Spring, Hibernate, Other frameworks Market trends
How to build the target application urban plan from the functional and technical targets

Practical work

Why architect systems?
How to build systems architectures, functional architecture, technical
architecture Software architecture, implementation, architectures of mobile applications: OS, types of application and communication, persistence, publication, frameworks, security, development
Example of town planning for mobile terminal applications

Practical work

Study of the urban planning and architectural problems of the trainees – The end of the course is dedicated to the way of using this approach to solve the urban planning and architectural problems that the trainees encounter in their company or their organization.

Duration

3 days

Price

£ 1910

Audience

IS town planners, IS architects, project directors, project managers, analysts, designers and in general any IT specialist interested in the backbone of an Information System (business architecture, town planning and systems architectures)

Prerequisites

Computer skills

Reference

GES676-F

Sessions

Contact us for more informations about session date

Very good trainer, explanations and precise answers to questions
Fawzi L.
Fawzi L.

Information systems architecture

Goals


- Know the general principles for the creation, management and analysis of information systems

Program

Introduction

Scope of action of the architect
Architecture and architect in the IT project sequence
Particular variations: software, network

Software architecture

Main modern development technologies
Application and data: theory and distribution elements
Types of programming and associated modeling
Types of applications; the example of distributed architectures
Multiple types of distributed architectures; standards, specific solutions

Distributed architectures: lines of work

Functional consequences of distribution
Performance and performance measurement
Security of distributed applications Distributed
architecture for communication with the exterior

Duration

2 days

Price

£ 1485

Audience

Project manager, software architects, IS directors

Prerequisites

Computer skills

Reference

GES675-F

 

Sessions

Contact us for more informations about session date

TOGAF®

Goals


- Prepare the TOGAF® Foundation (Part 1) and Certified (Part 2) exams

- Identify opportunities for successful IT / business alignment

- Apply a process to create architectures through the TOGAF® architecture development method

- Create an organization

- Specific architectural skill set

Program

TOGAF® as an enterprise architecture framework
Explain the role and purpose of The Open Group
Outline the structure of the TOGAF® document
Browse the TOGAF® Certification for People program

Separate enterprise architecture into domains
Categorize architectural transformations for different parts of the business

Create architectures with Architectural Development Method (ADM)
Establish enterprise architecture aptitude
Associate TOGAF® with other repositories

Become aware of the basic structure of ADM
Adapt ADM
Define the architectural scope
Detail a framework for managing architectural requirements

Establish requirements for architectural work
Confirm architectural principles
Define enterprise architecture team and organization

Determine the value propositions of the target architecture
Develop an architectural work statement

Describe the target business architectures
Address the application and data domains through the architecture of information systems
Adapt the application components to the underlying technologies with the technological architectures

Design transition architectures that provide continued business value
Develop implementation and migration plans
Prioritize work packages and projects

Govern and manage Architecture contracts
Trigger new ADM cycles

ADM iteration
Create ADM process hierarchies

Provide advice on architectural security
Govern a service-oriented architecture

Fill the architecture and solution continuums
Store standardized elements in the architecture repository
Exploit the enterprise continuum for reuse

Analyze the architectural landscape through partitioning
Aggregate and integrate content

Model the Foundation architecture with the TRM (Technical Reference Model), explore
the III-RM (Integrated Information Infrastructure Reference Model)

Establish a sustainable practice
Define an architecture committee

Detail architecture compliance analyzes
Practice architecture governance

Duration

5 days

Price

£ 3383

Audience

Architects, CIOs, IT project managers

Prerequisites

Knowledge of the TOGAF® 9 model is useful but not compulsory

Reference

GES100289-F

 

Sessions

Contact us for more informations about session date

Computer for beginners: Windows + Internet + Office

Goals


- Understand the Windows environment

- Navigate in the explorer

- Discover the Internet and emails

- Know the basics of Office tools (Word, Excel, PowerPoint)

Program

What is an environment?
History and versions

The motherboard
The processor
The hard disk
The RAM
The network card

The graphics card

Windows versions
How Windows looks
The desktop
The Start menu
The user directory
The workstation
The context menu (right click)

What is Windows Explorer?
What is a file?
What is an extension?
What is a file?
What is software?
The file tree

Open window
Minimize / Maximize window
Move window
Put two windows side by side

Create simple text files
Organize them with folders
Rename a file / folder
Move or duplicate an existing file
Delete a file

Anti-virus
WordPad
Paint
Calculator
Windows Media Player
Email and Internet browser
Paid software

Duration

5 days

Price

£ 375

Audience

Everyone

Prerequisites

No prerequisites

Reference

BUR100108

 

Perform a search (file, software …)
Create shortcuts
Use a USB key
Use the task manager
Compress a file

Access the control panel
Change the appearance (background, screen saver)
Manage computer users
Activate parental controls
Uninstall software
Install a printer
Configure Windows updates

What is Internet
History
Tools: web browsers, messaging, others

What is the web?
What is a web browser?
What is a web address (URL)?
What is a hyperlink?
Introducing a small website

The address bar
The search field
The standard buttons (home, update)
The favorites
The history
The options

Presentation of a search engine Search the
internet Search
results
Advanced search
Directories

What is an email address?
Presentation of an e-mail
Write an e-mail
Read a message
Reply to an e-mail
Delete an e-mail
Classify your e- mails

Spam management

Searching for the weather
forecast Searching for current affairs News
portals
Online encyclopedia
Presentation of discussion forums

Searching for a business website
Searching for legal information about a business
Searching for contact details of a business
Obtaining information on discussion forums

Word processing software: Word
Spreadsheet: Excel
Presentation software: PowerPoint
Messaging software: Outlook
Versions of the Office suite
Tool interface (Ribbon, Quick Access Toolbar)

Structure of a file (document, page, paragraph)
Create a new document
Open an existing document
Move around the document
Insert pages

Enter text
Apply formatting (font, color …)
Change text alignment
Apply a text style

Manage the page layout (margins, orientation, size)
Add headers and footers (logo, page number …)
Define the pages to print
Start printing

Workshop: Realization of a simple mail

Structure of a file (workbook, sheet, cell)
Create a new workbook
Open an existing workbook
Move in the workbook
Insert sheets

Enter content in a cell
Apply formatting (font, color …)
Add borders
Apply a table style

The formula bar
Integrating calculations into a table Calculating
the sum or the average of a column

Workshop: Making a simple painting

Structure of a file (slide show, slide, content)
Create a new slide show
Open an existing slide show
Move in the slide show
Insert slides

Insert text
Insert images
Insert shapes
Format inserted content

Start your presentation
Define the slides to display
Introduction to transitions

Workshop: Realization of a simple slideshow

Revisions
Questions / Answers
Passing the PCIE or TOSA certification

Passing the certification (if requested by the trainee)

Sessions

Contact us for more informations about session date

Very interesting. This met my expectations Trainer: pleasant, attentive, always with solutions to my questions.
Annie B.
Annie B.

Computer for beginners : Windows + Internet

Goals


- Know how to use Windows

- Navigate in Windows Explorer

- Create files or directories

- Discover the Internet, the Web, emails

Program

What is an environment?
History and versions

The motherboard
The processor
The hard disk
The RAM
The network card

The graphics card

Windows versions
How Windows looks
The desktop
The Start menu
The user directory
The workstation
The context menu (right click)

What is Windows Explorer?
What is a file?
What is an extension?
What is a file?
What is software?
The file tree

Open window
Minimize / Maximize window
Move window
Put two windows side by side

Create simple text files
Organize them with folders
Rename a file / folder
Move or duplicate an existing file
Delete a file

Anti-virus
WordPad
Paint
Calculator
Windows Media Player
Email and Internet browser
Paid software

Duration

3 days

Price

£ 1125

Audience

Computer beginners

Prerequisites

No prerequisites

Reference

BUR542-F

  

Perform a search (file, software …)
Create shortcuts
Use a USB key
Use the task manager
Compress a file

Access the control panel
Change the appearance (background, screen saver)
Manage computer users
Activate parental controls
Uninstall software
Install a printer
Configure Windows updates

What is Internet
History
Tools: web browsers, messaging, others

What is the web?
What is a web browser?
What is a web address (URL)?
What is a hyperlink?
Introducing a small website

The address bar
The search field
The standard buttons (home, update)
The favorites
The history
The options

Presentation of a search engine Search the
internet Search
results
Advanced search
Directories

What is an email address?
Presentation of an e-mail
Write an e-mail
Read a message
Reply to an e-mail
Delete an e-mail
Classify your e- mails

Spam management

Searching for the weather
forecast Searching for current affairs News
portals
Online encyclopedia
Presentation of discussion forums

Searching for a business website
Searching for legal information about a business
Searching for contact details of a business
Obtaining information on discussion forums

Passing the certification (if requested by the trainee)

Sessions

Contact us for more informations about session date

Very interesting. This met my expectations Trainer: pleasant, attentive, always with solutions to my questions.
Annie B.
Annie B.

Computer for beginners : Office

Goals


- Know the basics of Office tools (Word, Excel, PowerPoint)

Program

Word processing software: Word
Spreadsheet: Excel
Presentation software: PowerPoint
Messaging software: Outlook
Versions of the Office suite
Tool interface (Ribbon, Quick Access Toolbar)

Structure of a file (document, page, paragraph)
Create a new document
Open an existing document
Move around the document
Insert pages

Enter text
Apply formatting (font, color …)
Change text alignment
Apply a text style

Manage the page layout (margins, orientation, size)
Add headers and footers (logo, page number …)
Define the pages to print
Start printing

Workshop: Realization of a simple mail

Structure of a file (workbook, sheet, cell)
Create a new workbook
Open an existing workbook
Move in the workbook
Insert sheets

Enter content in a cell
Apply formatting (font, color …)
Add borders
Apply a table style

The formula bar
Integrating calculations into a table Calculating
the sum or the average of a column

Workshop: Making a simple painting

Structure of a file (slide show, slide, content)
Create a new slide show
Open an existing slide show
Move in the slide show
Insert slides

Insert text
Insert images
Insert shapes
Format inserted content

Start your presentation
Define the slides to display
Introduction to transitions

Workshop: Realization of a simple slideshow

Revisions
Questions / Answers
Passing the PCIE or TOSA certification

Passing the certification (if requested by the trainee)

Duration

2 days

Price

£ 750

Audience

Everyone

Prerequisites

No prerequisites

Reference

BUR1000137-F

Sessions

Contact us for more informations about session date

Computer for beginners : Basic software

Goals


- Know how to use common office automation and desktop publishing software

Program

Passing the certification (if requested by the trainee)

Duration

1 day

Price

£ 375

Audience

Computer beginners

Prerequisites

Know the basic operations of PC and Windows

Reference

BUR541-F

 

Sessions

Contact us for more informations about session date

Computer for beginners : Windows

Goals


- Know how to use Windows

- Navigate in Windows Explorer

- Create files or directories

Program

What is an environment?
History and versions

The motherboard
The processor
The hard disk
The RAM
The network
card The graphics card

Windows versions
How Windows looks
The desktop
The Start menu
The user directory
The workstation
The context menu (right click)

What is Windows Explorer?
What is a file?
What is an extension?
What is a file?
What is software?
The file tree

Open window
Minimize / Maximize window
Move window
Put two windows side by side

Create simple text files
Organize them with folders
Rename a file / folder
Move or duplicate an existing file
Delete a file

Anti-virus
WordPad
Paint
Calculator
Windows Media Player
Email and Internet browser
Paid software

Perform a search (file, software …)
Create shortcuts
Use a USB key
Use the task manager
Compress a file

Access the control panel
Change the appearance (background, screen saver)
Manage computer users
Activate parental controls
Uninstall software
Install a printer
Configure Windows updates

Passing the certification (if requested by the trainee)

Duration

2 days

Price

£ 750

Audience

Everyone

Prerequisites

No prerequisites

Reference

BUR100135-F

 

Sessions

Contact us for more informations about session date

Mac OS X

Goals


- Discover Mac OS X, configure the network, use Applescript

Program

About Mac OS X
Specifics of Mac

Explore the Mac OS X interface Apple menu
File systems

Creating aliases
Installing software
Customizing the interface

Network configuration
File sharing
Connections to other workstations
Installing network printers
Configure your network connection

Installation AppleEvents
programming
environment
First scripts
Syntax
Object-oriented programming
Handlers
Finders
Automating tasks

Duration

3 days

Price

£ 2495

Audience

IT specialists – SME network administrators

Prerequisites

Network knowledge

Reference

BUR397-F

  

Sessions

Contact us for more informations about session date

LibreOffice : Macros

Goals


- Know the macros possibilities in Libre Office

- Be able to create, modify and maintain macros

Program

History and versions
LibreOffice: fork of OpenOffice
Different components of LibreOffice: description, presentation, possibilities
Summary of differences with VBA (Microsoft Office)

Documents, libraries, modules and macros
Creation of a simple macro and presentation of the language
The macro editor: creation, edition, debugging

Variables and data maintenance
Adaptation and repetition thanks to tests and loops
Organization by functions
Various additional elements of the syntax and introduction to the object

Practical workshop: some calculation macros in Calc

General manipulations of the document
Events available to Basic
Principles of the API, resources at our disposal

Calc (spreadsheet): access to sheets
Calc: cells (value, formatting, sorting)
Calc: advanced functions
Writer (word processor): access to text and formatting
Draw and Impress: additional possibilities

Practical workshop: macros of all shapes in the various tools of LibreOffice

Duration

3 days

Price

£ 2495

Audience

All

Prerequisites

Good knowledge of OpenOffice or LibreOffice

Reference

BUR108-F

Sessions

Contact us for more informations about session date

Calc : the spreadsheet

Goals


- Know the main features of LibreOffice Calc

- Be able to create and modify tables with LibreOffice

Program

Presentation of Calc
Various components of LibreOffice: description and presentation
Functional comparisons with Microsoft Office Excel
Workbooks and worksheets
Rename, insert, move, delete a worksheet
Move around in the workbook (using the keyboard, menus, the mouse)

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

Use styles
Create, modify, delete a style

Layout Page
breaks
Printing and printing options

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

The formula bar
Addition, subtraction, multiplication, division
Use of parentheses
Percentage format
Copy calculations
Use of a referring cell ($)

Basic formulas
Date and time functions
Text formulas

Sorting, sorting options
Automatic
filters Custom filters

Select data
Choose a chart type as needed
Insert title, legend, data labels
Modify values
Modify chart type

Insert subtotals
Create and modify a pilot table
Validate data
Consolidate

Duration

2 days

Price

£ 2495

Audience

All

Prerequisites

No

Reference

BUR106-F

Sessions

Contact us for more informations about session date

Impress + PCIE certification

Goals


- Create complete presentations

- Make transitions and animations

- Know how to synthesize ideas

Program

Presentation of Impress and the other tools of the LibreOffice / OpenOffice suite
Examples of implementation with Impress

Description of the interface (Menu, Toolbars)
Structure of a file (slide shows, sections, slides)
Create a new slide show
Use of slide show templates

Add / remove slides Slide
layouts
Move a slide

Placeholders
Insert and format text
Insert and customize shapes
Insert and customize images
Create a photo album
Insert tables
Use the FontWork gallery
Embed a diagram
Insert audio and video
Organize inserted content

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

Launching the slide show mode
The other display modes
Inserting header and footer
Adding comments
Managing the slide master

Revisions on Impress
Questions / Answers
Passing the PCIE certification

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

Duration

1 day

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR1125-F

Sessions

Contact us for more informations about session date

Computer for beginners : Internet

Goals


- Navigate in the explorer

- Discover the Internet and emails

Program

What is Internet
History
Tools: web browsers, messaging, others

What is the web?
What is a web browser?
What is a web address (URL)?
What is a hyperlink?
Introducing a small website

The address bar
The search field
The standard buttons (home, update)
The favorites
The history
The options

Presentation of a search engine Search the
internet Search
results
Advanced search
Directories

What is an email address?
Presentation of an e-mail
Write an e-mail
Read a message
Reply to an e-mail
Delete an e-mail
Classify your e- mails

Spam management

Searching for the weather
forecast Searching for current affairs

News portals
Online encyclopedia
Presentation of discussion forums

Searching for a business website
Searching for legal information about a business
Searching for contact details of a business
Obtaining information on discussion forums

Passing the certification (if requested by the trainee)

Duration

1 day

Price

£ 375

Audience

Everyone

Prerequisites

Know how to use a PC

Reference

BUR100136-F

 

Sessions

Contact us for more informations about session date

Writer + Passing PCIE certification

Goals


- Know the main Writer tools

- Be able to produce a structured letter

- Know how to manage the layout of a document

Program

Description of the interface (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

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

Description of the interface (Menu, Toolbars)
Structure of a file (slide shows, sections, slides)
Create a new slide show
Use of slide show templates

Add / remove slides Slide
layouts
Move a slide

Placeholders
Insert and format text
Insert and customize shapes
Insert and customize images
Create a photo album
Insert tables
Use the FontWork gallery
Embed a diagram
Insert audio and video
Organize inserted content

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

Launching the slide show mode
The other display modes
Inserting header and footer
Adding comments
Managing the slide master

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

Duration

2 days

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR107-F

Sessions

Contact us for more informations about session date

MS Project 2013 (Course MS55054A – Exam 74-343)

Goals


- Have a precise methodology for project planning and monitoring

- Know how to use Project to plan a project and monitor its progress

- Master the essential functionalities of MS Project 2013

Program

Explore the new features of Project 2013
Access the primary views available using the
Choose Views ribbon that display the task, resource, or assignment information
Relate project characteristics to the 5 steps for building a project plan 

Create a new project and prepare it for data entry
Enter project
tasks Classify tasks
Define resources
Estimate task duration and assign resources
Monitor project progress 

Practical workshops: Create a basic project with a model – Create a basic project

Use several methods to create a new project from an Excel file and a SharePoint task list
Establish one or more calendars to constrain the availability of resources 

Build and use a summary and subtasks 
Understand and use milestones
Develop WBS outline
Evaluate WBS
Understand and use WBS models

Practical Workshops: Handling WBS – Monitoring the project plan 

Understand the different types of relationships between tasks
Understand and use several methods to create relationships
Determine and display the task sequence
Understand and use « lag », « lead », « delay »

Practical Workshops: Show the sequence

Define the types of resources
Define the individual resources that will be used for the project
Note the cost (s) of using each type of resource
Note the availability limit for each type of resource by establishing a resource calendar and define the maximum units of this resource

Practical Workshops: Calendar of resources and availability

Enter estimates for duration and costs for each task
Describe the relationship between work, units and duration
Assign tasks to resources using the team planner view

 Practical workshops: Work, duration and manpower

Identify the critical path of the project
Understand and identify the constraints of the task
Create milestones
Use the task inspector to solve the initial schedule

Practical Workshops: Calculate an initial schedule

Learn how to set up a course of action
Learn to enter and track project performance data
Learn to apply different monitoring methods
Learn to perform variant analysis on a project 

Printing, view, formats, sorting, filters, grouping, custom fields, report

Practical workshops: Use the grouping function – Create reports in the 2013 project

Learn to use common resources between multiple projects
Learn to relate tasks between multiple projects
Learn to create a consolidated view of multiple projects

Learn to Customize the Ribbon and Quick Access to the Toolbar
Learn to Customize WBS Numbering
Learn the Concepts of Formulas and Graphical Indicators 
Learn the Purpose of the Global Template and Organizer
Learn to Use the Deadline Task

Practical Workshops: Recording a macro in a 2013 Project

Duration

3 days

Price

£ 1272

Audience

Project manager, Planner, Decision-maker

Prerequisites

Basic knowledge of MS Project

Reference

GES1253-F

 

Sessions

Contact us for more informations about session date

Git

Goals


- Set up a software configuration solution based on Git

- Manage the versions of the projects of the data warehouse

Program

Source control management (SCM) principles
History, local, centralized and distributed control
How snapshots work, compare with differences
Installation (Linux, MacOS, Windows)
Manual access: man / help
Initial Git configuration: preferences, user profile
Initializing a local repository

Workshop: Installing e Git – Creating a project

Concepts, working directory, index and repository
Check the status of the working copy: status
Index your modifications: add
Ignore files: .gitignore
Validate your modifications: commit
Delete and move files

Workshop: contributions and validations

View the modifications: log
Customize the format: stat, pretty,…
Filter by date, author, commit message, modified content, …
View and export a difference (native format, external tool)
Label its validations: light and annotated labels
Search with git-grep

Rewrite the last validation
Deindex a file
Reset a file

Branch principle, the HEAD pointer
Create a branch
Switch between branches, detached mode
Merge branches: fast-forward, three sources
Manage merge conflicts
External merge tool: mergetool (emerge, vimdiff, meld, …)
View the existing branches, those which have been merged
Delete a branch Branch
management strategies: long branch, thematic, …

Remote
repository, remote branches, branch tracking View and inspect remote repositories
Add, rename, remove remote repositories
Pull, push and delete a remote branch

Warning: the dangers of overwriting
Rebase a portion of a branch
When to rebase and when to merge

Check in your work in progress
Create a branch from a delivery
Clean up your working directory

Configure default editor, automatic exclusions, …
Create and use aliases
Graphical tools: Git-Gui, GitKraken, SmartGit, …
Create filters: smudge and clean
Client side hooks: pre-commit, pre-rebase, post-rewrite …
Server side hooks: pre-receive, update, post-receive

Principle of submodules
Declare, pull and update a submodule
Modify and manage conflicts on an external library
Problems with submodules

Protocols: local, HTTP, SSH, Git
Creation of a bare repository, user accounts
Single git user , SSH keys and git-shell
Git daemon

Workshop: Setting up a Git server

A simple and light server: GitWeb
A more complete platform: GitLab
GitLab: user configuration
GitLab: project exploration, activity monitoring, wiki
GitLab: issue manager, web hooks, code review
A turnkey hosted service : GitHub
GitHub: account creation and configuration
GitHub: contribution rules
GitHub: maintenance of a project

Workshop: Retrieving and exploring a GitLab

Git and the Project Lifecycle
Git and Continuous Integration: GitLab Example

Duration

2 days

Price

£ 1272

Audience

Developers

Prerequisites

System administration concepts

Reference

GES705-F

 

Sessions

Contact us for more informations about session date

A good balance between theory and practice Exactly what I lacked to better manage my developments Very good training. There I learned everything I need about git and how to track a development project.
Malika L.
Malika L.
The content of the course in full adequacy with our needs. Trainer: Very good knowledge of the subject. Good ability to retrieve information on specific points or questions. Good adaptation according to our needs
Sandrine V.
Sandrine V.
Trainer: Very good teacher, with a good rhythm which lets us assimilate knowledge..
Baptiste L.
Baptiste L.
The course went well. The exercises offered were also interesting The trainer is attentive to questions and our needs. He made the whole team involved.
Mor salla F.
Mor salla F.
The course was well conducted by the trainer with a logical continuation to better understand the functioning of GIT. Trainer: Nothing to say, excellent pedagogy and very attentive
François G.
François G.
Précédent
Suivant

Calc + PCIE certification

Goals


- Know the main Calc tools

- Be able to perform calculations and use formulas

- Know how to handle diagrams and data tools

Program

Presentation of Calc and the other tools of the LibreOffice / OpenOffice suite
Examples of implementation with Calc

Description of the interface (Menu, Toolbars)
Structure of a file (workbooks, sheets and cells)
Create a workbook

Adding a sheet to the workbook
Rename a sheet
Move a sheet (on the same workbook or in another)
Identify a sheet using a tab color

The different ways to select cells
Insert rows and columns
Change the height and width of rows / columns

Format the content of a cell (font, colors …)
Apply borders
Manage alignment in a cell
Merge several cells

Use the predefined styles
Create and manage a custom style

Workshop: Making a simple painting

The formula bar
Addition, subtraction, multiplication, division
The value of parentheses
Applying a calculation to an entire column

Duration

2 days

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR1124-F

Manage the page layout (margins, header and footer, etc.)
Scale your table
Manually manage page breaks
Define a print area
Define print options then print

Manage the display in your workbook

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

Workshop: Production of a summary document with the main formulas

Create named areas and integrate them into formulas
Find antecedents and dependents to formulas
Check formulas for errors

Apply a sort on one or more columns
Modify the sort options
Apply filters on a table
Use special filters

Select the data to integrate into the diagram
Choose a type of diagram according to needs (histogram, curve, sector in 2D or 3D)
Add additional information to the diagram (title of axes, data labels, etc.) Apply updates from a table to associated diagrams
Change the type of diagram
Customize the visual of its diagram

Workshop: Generate a diagram according to your needs

Apply conditional formatting
Integrate subtotals into a table
Ungroup or consolidate a spreadsheet
Manage data validity
Find a target value
Use the solver

The principle of a pilot table
Define which calculation and label fields will be
Select the source and destination of its pilot table
Place the fields to be analyzed
Configure the options

Workshop: Highlight the desired statistics from your table

Adding and modifying comments
Enable tracking of changes
Protect your workbook and sheets

Reviews on Calc
Questions / Answers
Passing the PCIE certification

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

Sessions

Contact us for more informations about session date