Description

The originality and power of the dashboard lie in its ability to animate and manage the organization's various activities. A true anticipation tool, it integrates both financial and non-financial data. It puts successes and failures into perspective. This dashboard training is designed around a methodology that promotes the appropriation of concepts and their implementation.

Who is this training for ?

Training objectives

• Identify the key success factors of an activity
  
• Acquire the methodology to develop a dashboard: determine the relevant indicators of your activity; make them more readable to facilitate the formalization of an action plan
  
• Validate the relevance of your dashboard
  
• Create a management dynamic around the dashboard
  

Training program

Delimiting the role of the dashboard: the SAR method

• The objectives, the results to be achieved, the means of action.
• The performance and management indicators.

Select the relevant indicators: the DEFI method

• Case study scenario: identify the indicators (performance and management) within a service.
• Management through the action plan.
• Indicators of activity, quality, deadline, productivity, lighting, project.
• Scenario: Case study: identify indicators within a department.

Present the indicators to facilitate analysis

• The four design principles.
• The graphic representations to be favored.
• Synthetic and explicit comments.
• Study situation of Case: create a visual model.

Setting up a dashboard: the key steps

• Manage the project and involve users.
• Build the dictionary of indicators.

Use dashboard results

• Analyze gaps.
• Get reactions, decide on an action plan.

Workshop work on some dashboards provided by the participants (limited time)

Description

Dashboards are never completely satisfactory. A lack of methodology during design can result in dashboards that are difficult to understand, too cumbersome or not aligned with strategy. This dashboard training presents some best practices for improving existing dashboards: increasing the consistency of the dashboard structure; facilitate the reading and analysis of the results; accelerate the dynamics of decision-making.

Who is this training for ?

Training objectives

• Integrate the strategic dimension
  
• Make indicators consistent across the entire hierarchical chain
  
• Resolve dashboard design challenges
  
• Improve reading and analysis of results
  
• Facilitate the identification of action plans
  

Training program

Design a dashboard: reminder of the fundamentals

• Apply the five principles of dashboard design.
• Select the key indicators.
• Deploy the objectives, indicators and action plans .

Improving the dashboard: overcoming the main difficulties

• Validate the correlation points between performance and management.
• Define the right level of the analysis mesh in order to facilitate decision-making.
• Audit the consistency of indicators with the field of responsibility.
• Audit the quality of the information system.
• Ensure the perverse effects of reward systems.

Make dashboards more readable with compelling visuals

• Prevent classic errors.
• Use graphic possibilities.
• Know how to choose the right visual.

Building a strategic dashboard: the approach

• Ensure the consistency of the three levels of a management system.
• Integrate the different dimensions of performance: the balanced scorecard model.
• Design a scorecard strategic edge.

Workshop '

• Knowing how to present your table (limited time) Group work based on a few cases provided by the participants.

Description

Access is a relational database management system (RDBMS). This specificity makes Access a very powerful tool for querying, analyzing or relating data. Its backward and forward compatibility with Excel is also an asset. At the end of this training, you will master all the tools to efficiently and pertinently use your data in Access (version 2010, 2013 or 2016).

Who is this training for ?

Training objectives

Master the organization of data in Access to facilitate analysis.
Develop simple and complex queries.
Build reports to present analysis results.
Import and export data to use them effectively.

Training program

Master the organization of data under

• Access Reminder of basic notions: fields, tables, relationships.
• Methodology for creating and optimizing a relational schema.
• Define relationships and their properties.
• Create a junction table to manage 'many-to-many' relationships.
• Identify the benefit of creating a 'one-to-one' relationship.
• Define a single or multiple primary key.
• Check data consistency: referential integrity.

Develop simple and complex queries

• Reminder: queries selection, grouping, crosstab.
• Create queries based on queries.
• Define joins in queries.
• Add calculation formulas, use Access functions.
• Develop parameterized queries.
• Detect duplicates.
• Detect non -correspondence between tables.
• Add, delete or modify data in batches, dynamically generate a table: Action queries.
• Bring together data from several tables: Union queries.
• Manipulate SQL language: Select, Insert, Update...

Construct reports to present results

• Create and layout a column or tabular report.
• Sort and group data.
• Master the concept of sections, headers and footers group.
• Configure page breaks and breaks.
• Add calculation formulas.
• Insert graphics, images.
• Edit mailing labels.
• Building elaborate reports: the notion of subreport.

Import and export data

• Import/export data from Excel, txt, csv files.
• Attach Access tables, Excel workbooks.

Description

The Access interface, user-friendly and intuitive, allows anyone to easily build a database. However, to ensure effective use of Access, it is essential to understand the structure of a relational database and to use the different tools methodically. This training brings you these different approaches.

Who is this training for ?

Training objectives

Design and structure a relational database.
Develop queries.
Build forms and reports. Make it easier to use with simple macros.

Training program

Design and organize your database

• Organize and distribute your data between different tables.
• Create tables, define fields.
• Identify the index primary key.
• Define relationships, ensure referential integrity.
• Import, export, attach data.

Analyze your data: queries

• Create a query from one or more tables.
• Develop 'Selection' queries.
• Insert calculated fields.
• Group the data on a field, an expression.
• Add a totalization line: sum, average, ...
• Illustrate the result with a pivot chart.
• Act on data with 'Action' queries: update, add, delete.

Simplify entry: forms Generate simple forms.

• Apply filters and sorts.
• Insert controls: checkboxes, radio buttons, drop-down lists.
• Create query-based forms .
• Insert a subform.
• Use expressions in forms.

Highlight your results: the reports

• Create column or table reports.
• Add a logo, a header and a footer.
• Develop structured reports: sort, group.
• Add totals, subtotals.
• Highlight results: conditional formatting.
• Save a report as PDF.

Make it easier to use

• Customize navigation.
• Design a home menu.
• Create simple macros.
• Associate macros with buttons.

Description

This training will teach you how to develop management applications using Access using the VBA language. You will see how to create menus, dialog windows, messages, trigger events and use data.

Who is this training for ?

Training objectives

Use VBA language syntax to program the display of input forms
Program events to process user actions on forms and reports
Use data update instructions
Program processing to communicate with other applications
Manipulate the development environment to create a debugged and finalized application

Training program

The Visual Basic editor

• The Project Explorer. Code modules.
• The Properties window. Debugging tools.

Understanding the structure of the VBA language

• Writing rules and syntax.
• Variables and data types.
• Procedures and functions in VBA.
• Control and iterative structures.
• Objects, their properties and methods.
• Form and Control objects. Collections of objects.

Manage events

• The event categories of Access objects.
• The order of succession of events.
• Data update events.
• Event procedures.

Program an application

• The hierarchy between forms, reports and controls.
• The management of actions and procedures on objects.
• The creation of menus and toolboxes.
• The CommandBar object for managing the ribbon.
• The menu controls and event handlers.
• The options for starting an application.

Configure DAO/ADO objects

• Know the usefulness of DAO and ADO objects.
• Read data with the Recordset object.
• Modify data with the Execute method.

Dealing with errors

• The different types of errors.
• The different error management tools.

Communicate with external applications

• Reference an external library.
• Drive Word for a mail merge service.
• Drive Excel to export/import data.
• Import a text file into a table.
• Export a table to a text file.

Finalize the application

• Local installation, in client-server mode.
• The linked table manager.
• Database compaction.

Description

Create, modify, sign, send and track your documents on all your devices (desktop and mobile). This two-day Acrobat training allows you to create, modify, optimize, share and protect your documents. Beyond that, you will also learn how to create forms, as well as interactive and multimedia PDFs.

Who is this training for ?

Training objectives

Understand the different uses of the PDF format.
Convert, optimize and distribute your documents.
Organize and protect your documents.
Sign and track your documents.
Work on your mobile devices.

Training program

Create PDF files

• Convert documents and images to PDF files.
• Create PDF files from any application that allows printing.
• Create, protect from Microsoft Office applications.
• Combine multiple documents into a single PDF file.
• Convert web pages into interactive PDFs, including links.
• Add protection against copying and modification to your PDF files.
• Create a password-protected PDF.

Modifier des documents PDF

• Edit text and images.
• Export PDF files to an editable format (Word, Excel, PowerPoint).
• Add or delete pages, and sort them into a PDF file.
• Optimize PDF files to reduce their size.
• Add bookmarks, headers, numbers and watermarks.
• Transform scanned printed documents into editable PDF files.
• Add text to a PDF file.
• Rearrange, erase or rotate pages in PDF documents.
• Incorporate sound, video and interactive objects.

Sign and collect

• Complete, sign and submit forms electronically.
• Add comments to your PDF files.
• Collect electronic signatures and track responses.
• Convert printed or Word documents into PDF forms to complete.
• Consolidate different comments into a single PDF file.

Interact with PDF files

• Fill out forms, sign them and add comments to them.
• Work on touchscreen terminals.
• Store and share files online.
• Send and track documents online.

Description

Autocad offers multiple resources that are sometimes little known. This training will allow users who have mastered the basics of the software to discover new features of the drawing software and to improve their skills in Autocad.

Who is this training for ?

Training objectives

• Master advanced editing, drawing and layering options
  
• Use a library of dynamic blocks with attributes
  

Training program

Basic AutoCAD reminders

• Work methodology.
• Analysis of work habits.
• Advice, corrections and tips.

Create and customize toolbars

• Principle of macro commands.
• User profile management.

Manage layers in AutoCAD

• Quick layer controls
• Layer filters and groups
• Creating and updating layer states
• Layer filter tool selection

Use regions

• Creating regions.
• Boolean operations on regions.
• Region properties.

Create blocks and block attributes

• Principle and creation
• Management of object libraries
• Case of the editable cartridge
• Labeling and characteristics of blocks
• Extracting data to MS Excel

Use dynamic blocks

• Concept and creation
• Parameters and actions
• Examples of use cases

Uses of external references or xref

• Usage and exploitation
• Attach an external DWG /PDF/JPEG file
• Visibility and delimitation
• Management of xref layers

SCUs and views

• Creating and managing coordinate systems
• Toggle plan
• Creating and saving named views
• Introduction to geo-referencing

Hardware and software used

• For training courses carried out in the classroom, in our training centers, a computer and access to the software in the appropriate versions are provided
• For distance training courses, each participant must be equipped with the training software, on the computer which will be used to follow the virtual class

Description

This introductory AutoCAD training allows participants to become familiar with the most widely used CAD software. They will learn the fundamentals of creating technical drawings and plans.
 

Who is this training for ?

Training objectives

Acquire the essential basics of Autocad software to produce 2D plans and drawings.
Create and produce technical plans and drawings with Autocad.

Training program

Getting Started with AutoCAD

• Navigating the interface: screen areas, menus, and toolbars.
• Setting up and using the mouse.
• Entering and using commands.
• Understanding different file formats.

Creating Drawings with AutoCAD

• Start a new drawing project.
• Design an object using lines and hatching.
• Draw geometric shapes: circles, arcs, and ellipses.
• Use drawing aids: object snaps, grid, coordinate guides, and more.

Editing and Structuring a Drawing

• Use toolbars for editing operations.
• Modify object attributes.
• Build new elements from existing objects.
• Manage layers to organize the drawing.
• Create and use reusable blocks.

Managing Text and Styles in AutoCAD

• Add annotations and dimensions to the drawing.
• Configure styles for dimensions, tolerances, callouts, units, and more.
• Create multiline text and choose appropriate text styles and fonts.

Annotating and Composing Plans

• Create a layout plan (sheet).
• Work with model space and paper space.
• Manage scales and display settings.
• Build libraries of reusable resources.

Import and export files

• Import and export files in various compatible formats.
• Manage and save layouts.
• Prepare and edit plans for printing (printer/plotter).

Description

PCs, laptops, tablets, phablets, smartphones, WiFi, Bluetooth, ... we operate in a very connected professional world. You sometimes feel overwhelmed by this environment, you don't always know how to react in the event of a problem. This training allows you to acquire good practices and good reflexes to take full advantage of new technologies.

Who is this training for ?

Training objectives

Understand how new technologies work and master their use
Acquire good practices, good reflexes
Adopt a preventive approach
Analyze a malfunction to move towards an effective solution

Training program

Understand how a computer, tablet, smartphone works

• Identify the main components.
• Understand their impact on performance.
• Choose a suitable model.
• Clarify the vocabulary.

Understand how networks work

• Distinguish the role of the different servers (Messaging, Web, etc.).
• Understand the configuration of a network under Windows.
• Configure a wired connection ( ADSL, Ethernet, CPL...).
• Configure a wireless connection (Wifi, Bluetooth, G+/G).
• Stream multimedia content.

34Become familiar with the

• Mobile Internet and multimedia The different mobile OS.
• Configure a smartphone or tablet for Internet access.
• Handle multimedia files: compression, format , conversion.
• Share, save and store files online: data, photos, music, video.
• Understand the concept of the 'Cloud'.

Adopt a preventive approach

• Respect the rules: downloading, installing software, copying and using photos, press articles...
• Acquire good practices to protect your computer from a program or a malicious service: viruses, malware, spam, cookies, pop-ups...

Find a solution in case of a problem

• Analyze a malfunction before calling the Hotline.
• Diagnose common failures: starting the computer, connecting to a network, printing, installing or operating a peripheral. .

Description

Since its 2013 version, Excel has become a comprehensive tool for data management and analysis. It integrates a decision-making approach and makes it possible to produce professional and interactive dashboards. Four free add-ins to Excel 2013 and Excel 2016 work together to perform all the necessary operations: PowerQuery, PowerPivot, PowerView and PowerMap. Beyond getting started, this course will allow you to facilitate data manipulation, increase your analytical power tenfold and create appropriate visual reports. Thus the exploitation of data will be at the heart of Business.

Who is this training for ?

Training objectives

Import, connect and manipulate a large volume of data from heterogeneous sources using PowerQuery and PowerPivot
Analyze data and build a visual and interactive dashboard using PowerView and PowerMap
Broadcast and share the dashboard

Training program

Import and transform data with

• PowerQuery Import data from: a file (txt, csv, xls, ...); a folder; a database (Access, SQL Server, Oracle, SAP, ...); a site Web.
• Combine data tables by merging or appending.
• Transform data: Remove rows or columns.
• Replace, split, merge.
• Transpose, uncross a table.

Build the data model with

• PowerPivot Import data: Apply filters.
• Set connection properties.
• Build the relational data model: Define relationships and hierarchies.
• Complete the data: Use the main DAX functions Add new measures or calculated fields.
• Add a key performance indicator (KPI).

Analyze data and build the dashboard

• Build tables and pivot charts based on PowerPivot.
• Edit forecast sheets.
• Create a visual and interactive report in Power View: Insert tables synthesis, multiple graphs.
• Add filters.
• Create a geographic map D in Power Map Geolocate the data.
• Identify the different visualizations.
• Create the map and animate it using guided scenes.

3Broadcast and share the dashboard

• Protect and share the workbook.
• Generate the restitution PDF or PowerPoint file.
• Publish the workbook in SharePoint or Office.

Description

Excel is essential for establishing statistics, calculating and analyzing results, monitoring ratios and margins, representing them graphically, etc. This Excel training for beginners will provide you with the basics for efficiently constructing calculation tables and using their graphic representations. Evaluate your level of knowledge in Excel Beginner.

Who is this training for ?

Training objectives

Acquire the basics useful for good use of Excel (2019 versions)

Quickly design reliable calculation tables
Construct graphs to illustrate figures

Training program

Take your bearings

• Use the ribbon, the quick access bar, the status bar.
• Enter and copy the contents of cells.
• Build a calculation formula .
• Identify basic concepts

Design, present and print a simple table

• Format cells: present numbers, text, titles.
• Put data in table form.
• Sort and filter data.
• Define conditional formatting.
• Print the entire table or part of it, title, paginate.

Harnessing computing power: formulas and functions

• Calculate percentages, ratios, apply a rate.
• Perform statistics: AVERAGE, MIN, MAX.
• Apply a condition: IF.
• Consolidate several sheets with the SUM function.
• Automate the copying of formulas: absolute or relative references

Illustrate numbers with graphs

• Build a chart. Change type: histogram, line, pie.
• Adjust source data.

Organize sheets and binders

• Insert, move, copy one or more sheets.
• Modify several sheets simultaneously.
• Create dynamic links.
• Build tables of synthesis.

Links to Word and PowerPoint

• Insert an Excel table or graph in Word or PowerPoint.
• Evaluation of the transfer of acquired knowledge to validate implementation in a work situation

Description

Complete, this training gives you mastery of the essential features of Excel (2019 versions) to set up reliable analyses, be efficient and save time. Evaluate your level of knowledge in Excel “Improvement.

Who is this training for ?

Training objectives

Acquire effective and judicious use of Excel.
Save time in the construction and presentation of tables and graphs.
Use a list of data and analyze it with dynamic cross tables.
Making your calculations more reliable and analyses.

Training program

Use time-saving tools

• Define conditional formatting rules.
• Make it easier and control input with data validation.

Build simple and sophisticated calculation formulas

• Master the copying of formulas: relative (A1), absolute ($A$1) or mixed (A$1, $A1) references.
• Facilitate the creation of formulas: use names.
• Set up simple, complex, nested conditions: IF, OR, AND, ISEMPTY ...
• Calculate statistics: NBVAL, NB, NB.IF, MEDIAN , ...
• Relate data with the VLOOKUP function.
• Calculate dates, times: MONTH.SHIFT, END.MONTH, ...
• Manipulate text: LEFT, RIGHT, STXT, NBCAR, ...

Build elaborate charts

• Making a successful graph: reminder of the steps to follow.
• Combine several types of graphs into one.
• Compare series of different orders of magnitude.
• Use Sparkline Charts

Use a list of data

• Put the data in table form.
• Apply multi-criteria and custom sorting.
• Query, extract data with automatic filters.
• Remove duplicates.

Set up pivot tables

• Set up 1, 2 or 3-dimensional pivot tables.
• Group information by period, by slice. Filter, sort, hide data.
• Add ratios, percentages.
• Insert a pivot chart.
• Evaluation of the transfer of acquired knowledge to validate implementation in a work situation

Description

The spreadsheet's functionalities do not allow you to solve overly complex processes or automate all repetitive tasks. It is then necessary to use macro commands, i.e. programming in Visual Basic for Application (VBA). This training provides the basics for building reliable and efficient macros in Excel.

Who is this training for ?

Training objectives

Automate tables, calculations or data processing in Excel.
Master the basics of programming in VBA.
Record, modify and write VBA macros.

Training program

Save, edit and run a macro

• Use the macro recorder.
• Edit a recorded macro.
• Assign a macro to a button or object.
• Create a macro accessible from all workbooks

Program with Excel

• Write a macro directly in the Visual Basic editor.
• Integrate the notion of objects, methods and properties.
• Declare and use variables to optimize the code.
• Manage the cursor: position, movement, dynamic selection.
• Manipulate sheets, workbooks by macro.
• Transfer data from a sheet. in another.
• Create interactive macros: Inputbox, Msgbox.
• Perform tests: If... Then... Else, Select Case.
• Handle errors: On Error. Freeze the screen, deactivate Excel alert messages.
• Automatically trigger macros when opening a workbook, when closing it.
• Define simple event macros.

Manage a database by macro

• Master the database to program it.
• Extraction macros: use advanced filters to query and extract on multiple criteria.
• Consolidation macros: consolidate data from multiple workbooks.
• Create a custom form (UserForm) with input boxes, drop-down lists, radio buttons, check boxes
• Control data by. macro and transfer them to the spreadsheet

'Debug' a macro

• Execute step by step, set breakpoints.
• Check the variables, add spies.
• Evaluation of the transfer of acquired knowledge to validate the setting implemented in a work situation

Description

A logical continuation of the 'Excel Macros VBA - Level 1' training, this training will allow you to deepen your knowledge of VBA programming, optimize and organize the code to set up and maintain high-performance applications.

Who is this training for ?

Training objectives

Master the VBA programming language
Develop optimized and reliable VBA applications
Optimize and make existing applications more reliable

Training program

The fundamentals of VBA programming

• Objects: ActiveCell, Selection, ActiveSheet, Range...
• Methods and properties.
• Collections: Cells, WorkSheets, Charts, WorkBooks.
• Types of variables, their scope.
• Passing parameters from one procedure to another.
• Tests, loops, error handling.

Create add-in libraries

• Make a macro accessible from all workbooks (additional macros).
• Create a library of functions and procedures accessible from all modules (Reference Tools, Addins).

Develop event procedures

• Workbook events: open, save, close.
• Worksheet events: change the contents of a cell, select a cell.

Build elaborate forms

• Reminder about controls and their properties.
• Dynamically manage a drop-down list.
• Manage cascading lists.

Control external applications

• Control Outlook or Word with OLE Automation.
• Access data with ADO.

Description

Thanks to graphics, numbers turn into images! Nothing better to increase the readability of your numerical data, illustrate a trend or make a comparison. However, creating a successful graph cannot be improvised. The method proposed in this training allows you to build effective and impactful graphs in Excel 2016. Also learn to master the creation of elaborate graphs and discover the new graphs which considerably enrich the 2016 version of Excel.

Who is this training for ?

Training objectives

Acquire a method for designing and succeeding in a graph
Master its creation in Excel 2016
Build elaborate graphs
Use the new Excel 2016 charts

Training program

Creating a successful graphic: the steps to follow Define the message to be transmitted. Deduce the most effective graphic representation.

• Build the graph.
• Format the graph to strengthen its impact and make it easier to understand.

Customize a chart to enhance its impact

• Reminder on building simple graphs.
• Adapt the scale of the axes.
• Modify the order of plotting the series.
• Customize legend, titles.
• Insert free text, images.
• Ignore or interpolate missing data.
• Display a trendline.
• Automate the update of a chart by associating it with a dynamic data range.

Build elaborate charts

• Combine multiple chart types into one.
• Create a semicircle, gauge, or radar chart.
• Draw bubble matrices.
• Draw a pyramid of ages.

Exploit the new graphics

• Excel 0 Discover the new graphs and identify in which context to use them: Compartments.
• Sunbeams.
• Funnel.
• Graph cascade.
• Pareto chart.
• Geographic maps.

Description

Pivot tables allow you to quickly analyze a large volume of data by obtaining a summary table in just a few clicks. Reorganized as desired, they allow you to view the same information from different angles. This very powerful feature owes its success to its ease and flexibility of use. However, it requires carefully preparing the database to be analyzed.

Who is this training for ?

Training objectives

Prepare the database to facilitate analysis
Obtain summary tables in just a few clicks using dynamic cross tables
Illustrate the analysis with pivot charts
Format the report

Training program

Prepare the database

• Organize the data: the rules to follow.
• 'Clean' the imported data: remove unnecessary spaces, cell mergers.
• Put the data under table form to facilitate updates.
• Complete the data to refine the analysis: add information from another table dissociate or merge data.

Construct pivot tables and charts

• Set up a one-, two- or three-dimensional pivot table.
• Show, hide, sort information.
• Modify summary calculation: average , minimum, count.
• Display percentages, variance calculations or totals.
• Group information by numerical range.
• Dispatch a crosstab across multiple sheets.
• Filter data with segments or timeline.
• Associate a PivotChart.
• Refresh data.

Optimize their formatting

• Hide field headers.
• Apply a table style.
• Change report layout.
• Add sub -totals.
• Customize number format.
• Apply conditional formatting.

Description

Created in just a few clicks, pivot tables are essential for analyzing your data in Excel 2013 or Excel 2016. However, to import your data or format your reports, you often have the feeling of 'tinkering' and you don't don't always get the analysis you want. Based on concrete professional cases, this training day allows you to fully exploit the advanced functionalities of pivot tables and provides effective solutions to recurring problems.

Who is this training for ?

Training objectives

Optimize the management of source data from a pivot table.
Leverage advanced features to get the analysis you want.
Save time when presenting your pivot tables.

Training program

Manage multiple data sources

• Create a connection to an external data file (Access table or query, text file, etc.).
• Get started with the Power Query add-in to import and consolidate data from from different sources.
• Refer to discontinuous cell ranges across multiple sheets or workbooks.
• Relate multiple tables directly in Excel.
• Define dynamically source data to automate updates.

Leverage advanced features to get the analysis you want

• Use all the possibilities of the summary operator: percentages, accumulations, relative values, rankings, distinct total field.
• Add custom calculations: calculated field and calculated element.
• Use a crosstab value in a calculation formula.
• Dispatch a crosstab on several sheets by filtered element.
• Disconnect crosstabs to make them independent .
• Add graphs to illustrate the analysis.

Automate report presentation

• Create and use a custom table style.
• Apply formula conditional formatting to highlight data.
• Create custom formats to render explicit numeric values.
• Use very useful tips: Freeze the width of columns.
• Show columns or rows without data.
• Customize the display empty cells.
• Sort according to a custom order.
• Allow or not data extraction.

Description

Outlook 2013 offers a smoother interface that contains very useful tips. Using Outlook 2013 well means mastering the advanced features. It also means personalizing them and adapting them to your way of operating to better communicate and organize yourself. Find out how to use Outlook 2013 and OneNote 2013 wisely to save time every day.

Who is this training for ?

Training objectives

Adapt Outlook 2013 and OneNote 2013 to your activity to save time and be better organized
Optimize the management of your emails to cope with the daily flow
Manage your contacts, your calendar, your tasks
Centralize your notes and ideas in OneNote 2013
Use collective resources to facilitate collaborative work

Training program

Personalize

• Outlook 0 to adapt it to your activity Go directly to the essentials: personalize the ribbon, displays, favorites.
• Adapt Outlook to your activity: define fields, categories, indicators.
• Create templates to save time: standard messages, automatic sentences, standard paragraph blocks.

213Process a large volume of emails, organize yourself for greater efficiency

• Purge your inbox using the CAP method.
• Use tracking indicators and research tools.
• Create a data file to unclog your mailbox.
• Create rules to automatically filter and classify.
• Transform a message into an appointment or task.
• Save messages quick actions for common uses.
• Quickly collect information: voting buttons.
• Inform of its absence.

Manage your contacts Create and categorize your own contacts and distribution lists. Exchange business cards.

• Import, export contacts.
• Perform a mail merge.

Plan, organize and prioritize your activities

• Create one-off appointments or events, plan periodic elements.
• Assign colors to visualize and prioritize your activities.
• Organize your tasks by context and nature of activity.
• Define deadlines and set up reminders.

Centralize your notes and ideas in

• OneNote 0 Create and organize one or more notebooks.
• Enter and prioritize your notes: pages, subpages, indicators.
• Insert all types of notes: text, writing, diagrams, images, tables, files, web content, audio or video notes.
• Access your notes from your PC, your Smartphone or your tablet.

213Organize collaborative work

• Share calendars, contacts, OneNote notebooks.
• Organize meetings.
• Delegate and track tasks.

Description

Organization and communication tools, Outlook 2016 and OneNote 2016 greatly contribute to our individual and collective efficiency. However, despite many very useful features, Outlook is often poorly used and OneNote is little known. How to use them on a daily basis? This training has a dual objective. It allows you to acquire functional mastery of Outlook 2016 and OneNote 2016. It also provides you with solutions to adapt these two tools to your activity and better organize yourself.

Who is this training for ?

Training objectives

Adapt Outlook 2016 and OneNote 2016 to your activity to save time and better organize yourself.
Optimize the management of your emails to cope with the daily flow.
Manage your contacts, your calendar, your tasks.
Centralize your notes and ideas in OneNote 2016.
Exploit collective resources to facilitate collaborative work.

Training program

Personalize

• Outlook 0 to adapt it to your activity Go directly to the essentials: personalize the ribbon, displays, favorites.
• Adapt Outlook to your activity: define fields, categories, indicators.
• Create templates to save time: standard messages, automatic sentences, block of standard paragraphs.

216Process a large volume of emails, organize yourself for greater efficiency

• Purge your inbox using the CAP method.
• Use tracking indicators and research tools.
• Create a data file to unclog your mailbox.
• Create rules to filter and classify automatically.
• Save quick actions for common uses.
• Transform a message into appointment or task.
• Quickly collect information: voting buttons.
• Notify of absence.

Manage your contacts Create and categorize your own contacts and distribution lists. Exchange business cards.

• Import, export contacts.
• Perform a mail merge.

Plan, organize and prioritize your activities

• Create one-off appointments or events, plan periodic elements.
• Assign colors to visualize and prioritize your activities.
• Organize your tasks by context and nature of activity.
• Define deadlines and set up reminders.

Centralize your notes and ideas in

• OneNote 0 Create and organize one or more notebooks.
• Enter and prioritize your notes: pages, subpages, indicators.
• Insert all types of notes: text, writing, diagrams, images, tables, files, web content, audio or video notes.
• Access your notes from your PC, smartphone or tablet.

216Organize collaborative work

• Share calendars, contacts, OneNote notebooks.
• Organize meetings.
• Delegate and track tasks.

Description

This Illustrator training will allow you to put into practice the main functions of this vector drawing standard: creation of visual identity, cartography, illustration, coloring, layout... Evaluate your Illustrator skills.

Who is this training for ?

Training objectives

Learn the essential functions of Illustrator to produce quality vector images quickly and efficiently

Training program

Discover the diversity of uses of Illustrator

• Overview of the different applications: logo, illustration, ...
• Getting started with the interface: customization and shortcuts.

Create illustrations Geometric, shape merging and deformation tools.

• Contour customization.
• Conversion to symbol.

Enrich your creations

• The effects: D, artistic...
• The Pathfinders and the creation of complex shapes.
• The free path and the Pen tool; the gradient of shapes; clipping mask; image vectorization; outline shapes.

Succeed in your coloring

• The main color modes: CMYK, RGB
• Selecting and saving solid shades or gradients.
• Creating personalized patterns.

Highlight your titles and hooks

• Text entry and warping effects.
• Vectorization and character creation.

Layout your publications effectively

• Formatting paragraphs.
• The layout: columns, dressing and chaining.
• The use of guides, the grid.
• Management of lost funds; cutting lines.

Description

This InDesign training allows you to master this complete layout software to produce quality documents. Evaluate your level of knowledge about InDesign.

Who is this training for ?

Training objectives

Create complete, coherent, production-efficient models and prepare them for printing and digital publishing
Benefit from new page creation tools allowing flexible nesting of various media, texts, graphics, images in InDesign

Training program

Understanding InDesign Features

• InDesign in the Cloud environment: the panels; the interface...
• Manipulate and manage the blocks: placement, locking, alignment...
• The contextual control palette

Working with text and typography in InDesign

• Enter, select and modify text.
• The font binder.
• Master typography: spacing, approach, hyphenation, justification...

Manage blocks

• Chain blocks of text.
• Use multicolumn and automatic balances.
• Use assembly marks and commented marks.
• Use dynamic spacing and distribution.
• Understand the concept of page grid.

Format text and manage colors

• Import text: short; long with page generation.
• Master style sheets: paragraphs; characters; objects.
• Manage and create CMYK colors , RGB and spot colors.
• Save and share a color chart

Advanced layout: images, design, tables and layers

• Master the different image formats: Tiff/Psd/Png/Jpeg/EPS...
• Import images (prepared in Photoshop).
• Create or import tables (Excel).
• Optimize the management of blocks and layers

Create templates and prepare the document

• The Page Panel and Page Variations.
• Liquid Layout Basics.
• Creating and Using Templates.
• Organize the railway.
• Collect, distribute the document (PDF, SWF format).
• Reflection on new methods of distribution (Tablets...).
• Evaluation of the transfer of acquired knowledge to validate implementation in a work situation

Description

Layout without constraints, develop your creativity, while improving your efficiency in production... This is the objective of this advanced training in InDesign: by understanding the subtleties of this complete software, with learning the functions advanced, efficient management of long documents, your know-how will match your ambitions. Evaluate your level of knowledge about InDesign. Take the test to find out which internship is right for you: InDesign Test.

Who is this training for ?

Training objectives

Understand the subtleties of InDesign and increase its production efficiency.
Improve the management of long documents.
Better master the advanced functions of InDesign.

Training program

Gain in production

• Use InDesign editor mode to save time typing.
• Create custom glyph palettes.
• Use cloud or local libraries.
• Use the content fetcher.
• Master cascading, nested and object styles.
• Improve image management: manage clipping masks and advanced skins; directly edit images in Photoshop; automatically redistribute images by folder; create dynamic or static captions.
• Import Excel tables and manage dynamic linking.
• Discover GREP.

Improve the management of long documents under

• InDesign Create a book.
• Create subject and index tables.
• Manage the baseline grid and its options.

Improve distribution and ergonomics

• Use preflight.
• Create PDF files within the constraints of Print, Web and digital purposes.
• Integrate interactive elements into your layout page.
• Discover new digital distribution methods.

Description

Introductory DTP training is essential to familiarize yourself with DTP and create your first documents, before going further into using software.

Who is this training for ?

Training objectives

Getting started with DTP. Understand the technical environment of DTP.
Consider possible achievements in DTP. Better dialogue with agencies, studios, freelancers, and better understand business developments.
Evaluate the work that we can carry out and that which we must subcontract.

Training program

Understanding the DTP environment

• The graphics chain: overview of constraints and techniques.
• Discovery of the DTP environment, different types of documents (formats, folds, bleeds, etc.).
• Understanding color (the different color modes, RGB, CMYK, secure WEB...).
• The digital image (resolution, definition, BD, HD...) .
• The different file formats (Jpeg, PSD, Png, ...).
• The graphics chain and its constraints (devices, colors, photoengraving, digital...) .
• Common desktop publishing software.
• Define the objectives to be set for creating a document.
• Become familiar with the software interface.

Discover Photoshop DTP software

• Prepare photos, crop, modify, correct, choose the right recording format, create masks, approach photomontage.
• Size and processing of the image.
• Basic retouching.
• Layers and simple photomontage.
• Different recording formats. ,
• Illustrator Basic tools and techniques.
• Manipulation of existing objects and customization.
• Reminders about layers and colors.
• Create drawings, logos, transform objects, personalize your creations.
• InDesign Creation and manipulation of blocks.
• Enter and format text. Import (image, texts. ..).
• Manage styles.
• Manage skins.
• Layout the document and use layout rules

Create simple documents in DTP

• Gathering sources.
• Preparing the document according to the purposes.
• Producing simple and presentable documents (flyer, business card, etc.) .
• Prepare the files for printing, distribute on the Web.
• Evaluation of the transfer of knowledge to validate the implementation in a work situation

Description

Did you know that we spend on average 60% of our time in front of a computer? It is more difficult to quantify the loss of time linked to a lack of mastery of office tools... but it is considerable! This training 'which goes straight to the essentials' allows you to acquire effective use of Word, Excel and PowerPoint (versions 2010, 2013 and 2016) in 3 days. Access for one year to e-learning modules reinforces what you have learned in person and allows you to delve deeper into the functionalities of your choice at your own pace.

Who is this training for ?

Training objectives

Master the essential features of Word, Excel and PowerPoint (versions 2010, 2013 and 2016).
Save time through rational use of Word, Excel and PowerPoint.

Training program

Master the essentials of

• Word Present a document: alignments, indents, tabulations.
• Automate the management of repetitive formatting: styles.
• Build a structured document: hierarchical styles , automatic numbering, summary.
• Manage page breaks, headers and footers.
• Integrate images, graphs, tables.
• Use reusable content: QuickPart blocks.

Master the essentials of

• Excel Set up calculation formulas and master their copying.
• Identify and use the most useful functions among the many Excel functions.
• Link and consolidate data between multiple sheets.
• Create visual alerts with conditional formatting.
• Control entry with data validation.
• Use a list of data 'in tabular form'.
• Analyze data: sorting, filters, pivot tables.
• Illustrate figures with graphs.

Master the essentials of

• PowerPoint Apply or define a graphic line: themes and masks.
• Insert images, diagrams, a table or an Excel graph.
• Apply graphics effects 'animation to energize the slideshow.
• Design the associated documentation.

Remote activities Production of 3 e-learning modules on the version of your choice (2010, 2013 or 2016), to practice on subjects covered in training: 'Mastering

• Word' ; 'Master PowerPoint' ; 'Master Excel'.

Description

Mastering the use of Windows means ensuring good organization of your computer and saving time every day! Windows 10 has benefited from the experience of previous versions and offers a fluid and intuitive interface. Windows 10 also brings its share of new features and clever shortcuts. Come and discover them during this training day.

Who is this training for ?

Training objectives

Master the Windows 10 environment.
Personalize and organize your work environment to improve efficiency.
Share resources on the network and on OneDrive.
Adjust performance for optimized use.

Training program

Navigate the environment with ease

• Windows 0 Run, close an application.
• Manipulate windows (size, organization, activation, docking).
• Use tablet mode for a touch screen.
• Use shortcuts to gain speed.

1Customize the desktop

• Windows 0 to adapt it to your needs Customize the Start menu: locate shortcuts to the main programs; pin, detach, group thumbnails.
• Customize the taskbar: pin programs; for each program, pin files.
• Create multiple desktops to group features.

1Organize the archiving of your documents

• Launch File Explorer.
• Create a folder tree.
• Manage files (save, copy, move, rename, delete, recover).
• Use the search engine.

Use applications

• Windows 0 Edge: the new browser.
• Cortana: the intelligent personal assistant.

1Share resources

• Share a folder on the network.
• Share a folder or files on OneDrive.

Adjust performance Adjust visual effects, power settings.

• Use the task manager.
• Clean the disk.
• Run a system diagnostic.

Description

Share and co-produce documents, organize video conferences, participate in group conversations, chat, co-build a collaborative space dedicated to a team... All this, online and therefore accessible from a PC, a tablet or smartphone! All of these services are part of Office 365, Microsoft's online collaborative platform. This solution, attractive for small businesses, also meets the targeted needs of medium and large businesses. Come discover and practice, during these 2 days, the tools and services offered by Office 365.

Who is this training for ?

Training objectives

Discover the different tools offered by Office 365.
Identify the tools adapted to your needs and the needs of the team.

Training program

Take ownership of the Office 365 collaborative space Configure your profile.

• Personalize the home page.
• Access the different tools.

Create and share documents online:

• Office Online Access your OneDrive space.
• Create, modify documents online: Excel, Word, PowerPoint or OneNote.
• Share files and folders.
• Co-edit a document.
• Synchronize documents to work offline.
• Access your emails, contacts and calendars.

Communicate, collaborate:

• Skype for Business Plan, organize or participate in an online meeting.
• Make an audio or video call.
• Chat via instant messaging.
• Share a document, a program, the whiteboard.

Organize in project mode: Teams

• Create a team dedicated to a project.
• Participate in group conversations.
• Add channels to target specific topics.
• Create a team Wiki.
• Share documents, tools, applications.
• Manage a team schedule with Planner.
• Bring together 'team in videoconference.'}

Co-manage reference documents:

• SharePoint Online Access the SharePoint site.
• Share a document library.
• Co-manage a list of contacts or links.

Discover other very useful collaboration tools Forms: questionnaires, surveys.

• Sway: interactive presentations.
• Stream: video streaming.
• Yammer: corporate social network.

Description

Your slideshows lack dynamism and do not have the expected impact. You master your subject but your presentations are limited to a series of bulleted lists. So, stop! Come and discover how to make a successful slideshow. using simple and effective rules inspired by design and layout rules, put your ideas into images and transform your PowerPoint presentations into real visual supports.

Who is this training for ?

Training objectives

Strengthen the visual impact of your PowerPoint presentations: identify the key points of a successful slideshow and put them into practice; create effective and impactful visual supports.
This training is not intended to discover new PowerPoint features.

Training program

Clarify the role of the slideshow

• Clarify the objective.
• Distinguish between 'oral' content, the content of the slideshow and the content of the document to be left to the audience.
• Chase away common errors.

Visually translate each message

• Transform an idea into an image.
• Choose a suitable medium: diagram, graph, image, photo or video.
• Organize the information in clear and effective.
• Highlight numerical data and ensure their understanding.
• Exploit the impact of a photo: camera angle, framing, emotion.
• Capture attention with a video.

Give weight to words

• Respect typographic rules: universe, readability, coherence.
• Highlight important words: size, color, position.
• Choose catchy and meaningful titles .

Compose effective slides

• Position and size the different visual elements.
• Balance the text/image ratio.
• Take into account the influence of colors and shapes.
• Work on contrasts, white spaces, repetitions, alignments, transparencies.
• Simplify to increase efficiency.
• Add animations to energize.

Description

PowerPoint allows you to create clear and attractive presentations in just a few clicks. This two-day training course will provide you with the basics to use essential features efficiently and quickly.

Who is this training for ?

Training objectives

Construct methodically and quickly a PowerPoint presentation integrating text and illustrations (images, diagrams, tables, graphs).
Define the graphic line to standardize the layout of the slides.
Use animation effects to energize the slideshow and project it.
Create the associated documentation.

Training program

Design a presentation

• Identify the key points of a successful presentation.
• Proceed methodically: 5 steps.
• Develop your plan.

Standardize the graphic line

• Use themes to provide visual consistency.
• Modify theme colors, fonts and effects.
• Use masks to personalize the graphic universe .
• Insert a logo or graphic object in all slides.
• Change bullets on all slides.
• Apply a background style -plan.
• Manage headers and footers.

Organize slides

• Use slide sorter mode.
• Delete, move, duplicate, or hide slides.
• Organize slides into sections.
• Copy slides from one presentation to another.

Enrich the content of each slide

• Choose a layout that fits the slide content.
• Insert a photo and customize it.
• Create SmartArt diagrams or flowcharts.
• Build a table, draw a graph.
• Insert an Excel table or graph.
• Add decorative WordArt text.
• Position, align and distribute the different objects.
• Dissociate and group objects.

Energize the slideshow and project it

• Apply transition effects to one or more slides.
• Animate text, objects, diagrams.
• Run the slideshow with ease: navigate between slideshows slides, inhibit the screen, use presenter mode.

Create associated documentation

• Print different media, edit in pdf format.

Description

During this training, you will study Autodesk BIM software in order to produce a digital model. You will use the power of Revit tools to design a complete project. The study of families will also be covered during this course.

Who is this training for ?

Training objectives

Master the basics of the software in 2D and 3D
Carry out a project through to presentations

Training program

Take in charge

• Revit Templates.
• Interface settings.
• Keyboard shortcuts.
• The properties window.
• The project tree.

Create the building

• Architectural wall.
• Load-bearing wall.
• Modifying and creating a wall type.
• Duplicating a type.
• Layers.
• Materials.
• Raised profiles.
• Hollow profiles.
• The walls in situ.
• The curtain walls.
• The posts.

Arrange the building

• Access: doors; windows.
• Roofs: methods of creating roofs; go further with roofs.
• Floors and stairs : floors, slabs, floors; methods of creating stairs and railings.

Discover families The different types of families.

• Profiles.
• Creation of a door family.
• Creation of a window family.
• Family parameters.

Views and renderings

• Views D and D (plan, section, detail, isometric, etc.).
• Lighting.
• Sunshine study.

23Prepare to print

• The scales.
• The layout.

Description

Companies recognize it: working better together helps to obtain better results. Sites intended for members of a department or sites dedicated to a project, SharePoint 2016 has established itself as THE collaboration platform perfectly integrated into Microsoft Office. However, the success of a team site cannot be improvised. It is of course essential to master the functionalities of SharePoint 2016. It is also useful to obtain the support of each contributor and to share good practices. Discover, in this training, all the basics for creating and maintaining a SharePoint 2016 team site.

Who is this training for ?

Training objectives

Navigate your way around the SharePoint 2016 environment
Share information on a SharePoint 2016 team site
Create and customize a SharePoint 2016 team site to adapt it to the needs of a project, a team, or an organization
service
Get the team on board and guarantee the success of the site

Training program

Overview

• Understand the software architecture related to SharePoint 0.
• Identify the main components of a site.

216Navigating a site

• SharePoint 0 Find your way: the ribbon, the navigation pane, the top link bar, the current site.
• Access all content.
• Search informations.

216Share information

• Share lists: calendar, announcements, contacts, tasks.
• Share libraries of documents, images.
• Create, modify, move documents.
• Co-edit an Office document.
• Use metadata to classify a document.
• Manage versioning and use the approval mechanism.
• Keep informed: alerts and RSS feeds.

Adapt the site to the needs of the team

• Choose lists and libraries.
• Add columns, create specific displays.
• Personalize the home page.
• Use Wiki features.
• Add and configure Web Parts.
• Customize the appearance of the site, the startup, the navigation.

Manage security Use standard groups. Manage access rights at the level of a site, list or library. Rely on the notion of inheritance or set up unique access rights.

• Create and manage a specific group.

Guaranteeing the success of the team site: best practices

• Create the collaborative site: the steps to follow.
• Ask yourself the right questions to organize the documentary collection.
• Get the team on board.
• Identify strengths and limitations.

Description

Take advantage of these two days of training to go further with SharePoint 2016. Discover advanced features such as exchange through a social network, management of the life cycle of documents using Workflow or the in-depth understanding of document management.

Who is this training for ?

Training objectives

Exploit the advanced collaborative features of SharePoint 2016
Automate the circulation and validation of documents by exploiting Workflows
Identify interest and practice the functionalities of the social network
Secure access to site information.

Training program

Reminder on the components of a collaborative site

• SharePoint 0 Sites and site collections.
• Lists and libraries.
• Pages and web parts.

Take advantage of advanced document management features

• Use managed metadata.
• Define content types.
• Manipulate document sets.

Target the use of lists, libraries and

• WebPart Create specific libraries.
• Share information in Wiki page libraries.
• Manage a list of tasks related to a project.
• Distribute a survey and display the graphic summary of the responses.
• Import Excel data to populate a list.
• Set up 'linked lists'.
• Use targeted Web Parts.

Set up a standard workflow

• Operating principle of a Workflow (or workflow).
• Configure and administer a Workflow.
• Start a Workflow and follow the tasks step by step associated.

Use Social Network features

• Create your profile: personal information, news feed.
• Comment, evaluate, tag and share bookmarks.
• Create and maintain a blog, a news feed, a micro blog.
• Create a community.

Secure access rights

• The 3 levels of security management in SharePoint.
• Manage custom permission levels for collection administrators.

Work offline with

• Onedrive Synchronize your libraries in offline mode.

Description

Whatever your role or the sector of activity in which you work, using a computer is essential. Taking the time to learn about this tool means gaining productivity and comfort every day. This introductory training in Windows 10 and Office 2016 allows you to acquire the right reflexes to get started with your computer and discover the basic functions of Outlook, Word and Excel 2016.

Who is this training for ?

Training objectives

Take charge of your computer and office automation
Practice the Windows 10 environment
Learn about Outlook 2016, Word 2016 and Excel 2016

Training program

Take your bearings

• Clarify the vocabulary: processor, RAM, hard disk, ...
• Identify the role of the operating system.

Discover and practice the Windows 10 environment Finding your way around the environment.

• The Start menu and its dynamic tiles.
• The desktop and the taskbar.
• Open, close an application.
• Skip from one application to another.
• Manipulate windows (closing, opening, size, organization) Personalize your desktop: pin, detach, group Start menu tiles pin programs to the taskbar; .
• Organize your work: create and organize your folders; copy, move, rename, delete files.

To use

• Outlook 0 Principle of electronic messaging.
• Create and send a message.
• Check your inbox, reply, forward, delete.
• Attach a file to a message.

216First steps in

• Word 0 Enter text.
• Edit and correct a document.
• Present and format a document.
• Layout and print.
• Integrate an Excel table into a Word document: copy/paste principle.

216First steps in

• Excel 0 Build a table: enter numbers and labels; add calculation formulas; apply formats.
• Save and print.

Description

Sketchup, technical drawing software renowned for its simplicity and efficiency, offers an interesting alternative to the market leader Autocad. It allows you to create 2D plans and 3D objects with ease. This training will provide you with the essential foundations to master Sketchup.

Who is this training for ?

Training objectives

Use Sketchup to draw 2D plans and 3D objects
Master the tools for drawing and modifying objects, managing standard models

Training program

Get started with

• Sketchup Use layers.
• Drawing tools D: line, rectangle, arc, circle...
• Transformation tools D: extrusion.. .
• Modeling tools D: union, subtraction...
• Modeling from a photo.
• Move and modify functions.
• Displacement functions: rotation, translation, symmetry...
• Modification and duplication functions (linear and/or polar network).

Create groups and components

• Create a group, a component.
• Modify and update a component.
• Manage the structure of component groups.

Edit and dress elements

• Selection of elements (window, capture, path).
• The manipulation toolbar (copy, move, shift).
• Modification of attributes ( color, layer, style).
• Components (use, principle, explorer).
• Texts.
• Colors and materials (creation of textures) .
• The quotations toolbox.

Viewing plans

• The points of view.
• The visualization modes (wireframe, surface, colors, materials).
• The scenes.
• The animations.
• Discover photorealistic rendering software.

Hardware and software used

• For training courses carried out in the classroom, in our training centers, a computer and access to the software in the appropriate versions are provided
• For distance training courses, each participant must be equipped with the training software, on the computer which will be used to follow the virtual class

Description

By habit, you use the most common Word, Excel or PowerPoint features. Come and discover features that can do part of your work for you and save you a lot of time.

Hardware and software used

• For classroom training in our training centers, a computer and access to the software in the appropriate versions are provided.
• For distance learning, each participant must be equipped with the software for the training, on the computer that will be used to follow the virtual class.

Who is this training for ?

Training objectives

Acquire more effective practice with Word, Excel and PowerPoint to save time and become better organized
Know and use the most useful advanced functions of Word, Excel and PowerPoint

Training program

Quickly produce well-presented documents in Word

• Automate the layout of your documents to save time.
• Create templates and forms to make it easier for the team to organize.
• Create a targeted mailing (conditions and filters).
• Insert hypertext links to directly access information.
• Work with several people on the same document.

Optimize service management in Excel

• Organize your data and automate your tables.
• Use the very useful functions: format a table; pivot tables; filters and sorting.
• Optimize the budget management.
• Keep schedules (projects, vacations, training, etc.).
• Automate the presentation with conditional formatting.
• Represent visually numbers with a graph.

Create impactful presentations in PowerPoint

• Save time when making presentations.
• Create and structure a PowerPoint presentation.
• Format the presentation.
• Import Excel tables and graphs.
• Insert and rework images and diagrams.
• Customize the animation to energize the slideshow.

Make it easier to find documents

• Use the search functions to find all your documents.
• Index your documents to find them more quickly.

Hardware and software used

• For classroom training, in our training centers, a computer and access to the software in the appropriate versions are provided.
• For distance training, each participant must be equipped with the software for the training, on the computer which will be used to follow the virtual class.

Description

The preponderance of data in the company through 'Big Data' makes it essential to represent this data graphically so that it is more readable and understandable. Classic or more original graphics, maps, chronologies and development of infographics are the tools of 'Dataviz'. Today, these tools are made accessible through professional software or web applications.

Who is this training for ?

Training objectives

Structure information in order to represent it graphically
Discover Datavisualization tools
Choose a graphic representation based on the data and the message to be transmitted
Present the figures in a more original and better adapted way

Training program

Methodological approach to data visualization

• Identify the types of data available (numeric, categorical, dates, location).
• Collect and enrich the data (Open Data, Social Data, etc.).
• Prepare and aggregate data (Data Preparation).
• Acquire graphic grammar and formatting best practices.

Overview of tools

• Data visualization Microsoft Excel 0 / 0: new capabilities and limitations.
• Professional Data visualization software: Microsoft Power BI Desktop, Tableau Software Public.
• Online applications ('Software As A Service'): RAW Chart.

213216Choose the graph according to the data and the message to be transmitted

• Represent time series (Curves and Trends, Sparklines).
• Represent proportions (Waterfall, Treemap, Nightingale, Venn Diagram, Marimekko, Gauge).
• Represent relationships (Correlogram, Boxplot, Bubble chart, Point cloud, 'Trendalyzer' bubble cloud).
• Represent spatial distribution (Geographic maps, Choropleth maps, Heatmap).
• Represent a corpus of text by a word cloud (Tag Cloud).

Go to infographics Think about the design of a visual element: font, choice of colors. Define a guideline for visual storytelling.

• Prioritize information.
• Distribute and share an infographic.

Description

Using Word well cannot be improvised. Mastery of basic functionalities is useful to be efficient in a word processor. This Word training (2019 versions) will allow you to acquire good practices from the start.

Who is this training for ?

Training objectives

Learn the basics of creating and formatting letters or reports in Word

Apply the first Word automations to save time

Insert tables and illustrations

Training program

Acquire the basic principles

• Finding your way around the screen: ribbon, quick access bar, status bar.
• Create a document with method: enter, save, present.
• Preview and print.

Present a document well

• Choose the fonts and their attributes: bold, underlined, italic, color.
• Air out the document: line spacing, spacing, indents.
• Frame a title, l 'shade.
• Create bulleted or numbered lists.
• Save time: apply, edit styles, copy formatting.

Edit a document

• Modify a document occasionally.
• Show/Hide formatting marks.
• Delete, move, recopy text.
• Correct a text: check spelling, look for synonyms.
• Convert a document to pdf.

Design a note, a letter

• Position the address, references.
• Present the body of the text.
• Layout and print.

Build a report type document Define and number the titles.

• Change the presentation of the document: apply a new set of styles, modify colors, fonts and theme effects.
• Add a cover page.
• Insert a summary, a table of contents.
• Define page breaks.
• Number the pages.

Insert illustrations

• Insert an image, decorative WordArt text.
• Illustrate a process, a cycle with a SmartArt diagram.

Insert a table

• Create and position a table.
• Add, delete rows or columns.
• Apply a table style.
• Modify the borders, frames.

Description

The TOSA® certification included in this training allows you to assess your level of mastery in Word 2010 or 2013 or 2016. The TOSA® certification and the training that prepares you for it are eligible for the OFPPT. Do you waste a lot of time creating and formatting your reports, reports or memoirs? Discover Word features designed to quickly create quality documents. Also discover the rules of layout and typography in order to produce professional documents that are easy to read.

Who is this training for ?

Training objectives

Quickly produce long, structured documents in Word by exploiting multiple automations.
Acquire the basic rules of layout and typography to produce quality professional documents.
Get organized to be efficient, save time.

Training program

Get started creating a document

• Analyze the information to process it properly.
• Identify the objectives.
• Identify the characteristics of the document to be produced.
• Determine the key messages to convey.
• Prepare the plan.

Acquire the rules of layout and typography

• Measure the impact of layout on reading ability.
• Identify the elements that facilitate rapid reading.
• Margin a document effectively.
• Apply typographic rules.
• Balance the presentation of the text and the space between words, lines.
• Place illustrations (diagrams, graphics, shapes , photos, images).

Master the construction of structured documents

• Work with styles and the navigation pane.
• Automatically format and number headings.
• Add a cover page.
• Generate and personalize the table of contents.
• Define headers and footers.
• Manage page breaks: paragraphs and joined lines, widowed or orphan lines, page breaks ...
• Make it easier to view the document on screen.

Master the automations useful for developed documents

• Master the concept of sections and manage section breaks.
• Mix layouts in the same document: portrait or landscape.
• Create a single-sided document back: manage even and odd pages.
• Insert bookmarks and references.
• Insert footnotes or endnotes.
• Create a keyword index.
• Use fields to display variable information: display the name of the current chapter in the header or footer, the name of the author...

Use time-saving tools

• Use a template for each document type.
• Create style sets and assign keyboard shortcuts.
• Save QuickParts content blocks for reuse in any document.

Description

PowerPivot is the BI tool integrated into Excel 2013 allowing you to go beyond the limits of the spreadsheet and analyze large volumes of data (OLAP cubes, data warehouses, flat files and Excel tables). In this internship, you will learn how to extract data, manipulate it, and present it with PowerPivot.

Who is this training for ?

Training objectives

Connect to various data sources (OLAP cubes, data warehouses, flat files and Excel tables)
Associate tables from different sources to make coherent sets
Perform calculations and design indicators with the DAX language
Use Excel to design crosstabs, graphs and dashboards

Training program

PowerPivot Overview

• Benefits and features.
• The different versions of PowerPivot and what's new in PowerPivot 2013.
• Which data should I use with PowerPivot?
• Comment restore the data in Excel in a synthetic form?

Data restitution: Excel as interface

• Create PivotTables and PivotCharts.
• Define measures in TCDs: functions, ratio, deviations, progression.
• Define levels of chronological grouping, define ranges of values.
• Use segments to dynamically qualify data.
• Use timelines to filter analyses.

Working with heterogeneous data sources

• Load PowerPivot tables from Excel.
• Access relational databases: SQL Server, Access, ODBC etc.
• Manage connections and updates .
• Use the Diagram view.
• Define relationships between tables.
• Refer to another table.
• An alternative to the Search function.
• Arrange displays and create perspectives.

Calculation in the cube

• DAX functions, Excel functions and calculation in the TCD.
• Sort and filter data.
• Organize columns and eliminate unnecessary information.
• Create calculated columns.
• Convert and format data.
• Prepare grouping levels.
• Design calculated fields.
• Carry out pre-calculated measurements.
• Implement intelligent date management.

Publication and Collaborative Work

• Know the publishing and sharing solutions.
• Example of Powerview reports.
• SharePoint and/or Office 365.

Description

Inescapable standards in the exchange of textual data on the Web, XML and JSON have taken a major place in Web applications, information systems, data and application integration. For its part, XML, the basis of many other languages, is surrounded by a multitude of tools for the definition and manipulation of data. JSON, for its part, offers a simpler data format and integrates more easily with programming languages. This seminar offers you an exhaustive vision of the uses of XML and JSON within information systems.

Who is this training for ?

Training objectives

Read and understand XML and JSON documents
Model and define data in XML and JSON
Choose the tools adapted to the needs of your application.
Understand the place of XML and JSON in Web architectures

Training program

Concepts de base

• Document management: structure, content and presentation.
• Markup languages: SGML, HTML and CSS.
• Comparison with WYSIWYG languages.
• Web 2.0, XML and JSON.
• Asynchronous browser-server communication with AJAX.
• The rich client with HTML5, CSS3 and JavaScript technologies.
• Instead of XHTML 2.0?

Introduction to XML and JSON

• The XML data model: elements and attributes, well-formed and valid document.
• Serialized or tree-based representation, the Infoset XML logical model, XML parsing The XML galaxy: technical standards and business standards.
• XML and office automation: the Open Document standards from Open Office and OpenXML from Microsoft.
• EXI: compressed XML.
• The JSON data model: object, array and literal values.
• Integration with programming languages ​​(JavaScript, PHP.).
• Frameworks using JSON (jQuery, Angular.).
• JSON parsing.
• Differences with XML.
• XML and JSON development tools.

Defining XML data with DTD and XMLschema

• Document Type Definition (DTD) and document typing.
• Definition of elements, attributes, entities; simple and compound elements, parameter entities.
• XMLschema: simple and complex types, declaration of elements and attributes.
• XMLschema: Collection constructors, type inheritance, reuse of definitions.
• Namespaces xmlns: interest in integrating XML data.
• Best practices: DTD writing rules or XML schemas, version management.
• The main DTD development tools and XML schemas.

JSON data definition

• JSON Schema: basic concepts, validation keywords, hyper-media keywords.
• Meta-schemas to define JSON schemas and Hyper-Schema formats.
• Standard schemas: e.g.
• geographic coordinates, map, calendar, address.
• JSON schema validation libraries.

Navigating XML trees with Xpath, the XSL style language

• Addressing nodes in an XML tree: navigation and path expressions.
• Xpath terminology: nodes, expression syntax, navigation axes.
• Expressions XPath path: traversal of nodes, regular expressions, selection predicates, functions.
• Data transformation with XSLT: production rules, selection of nodes with XPath, production of results.
• Examples of XML-XML, XML-HTML transformation.
• XSLT processors. Integration into the n-tier architecture.
• Formatting documents with XSL/FO: objects , masks, layouts.
• XSL/FO processors. Integration with XSLT processors.

The XSL style language

• Data transformation with XSLT: production rules, selection of nodes with XPath, production of results.
• Examples of XML-XML, XML-HTML transformation.
• XSLT processors.
• Integration into the n-tier architecture.
• Formatting documents with XSL/FO: objects, masks, layouts.
• XSL/FO processors.
• Integration with XSLT processors.

Processing XML with SAX and DOM

• Event processing with the SAX API, example of use with Java objects, SAX parsers.
• Programmatic processing via the DOM API, using the SAX parser for translation from XML to object, DOM parsers.
• XML application development tools.
• XML/JSON conversion.

XML and JSON databases

• Document-oriented databases: XML or JSON as data model.
• Storage and indexing of documents, relational storage.
• Query languages ​​for XML: SQL/XML, XQuery, with XML/JSON support.
• Data integration: integrated views of heterogeneous data in XML, schema integration, query processing.
• The main XML data integration tools : EII (Enterprise Information Integrators).

Architecture SOA et Web Services

• Web Services: client, provider, service directory and application integration.
• Description of services with WSDL.
• Referencing in the UDDI directory.
• XML communication protocols: XML RPC and SOAP.
• Lightweight architectures with ReST.
• Choosing the right Web Services architecture: ReST/JSON versus XML/ SOAP.
• Quality of services: WS-Transaction, WS-Coordination, WS-Security.
• Integration into .NET and JEE application servers.
• Relationships between SOA and Web Services.
• Service composition: modeling of business processes and workflows.
• XML and WSDL at the heart of BPM.
• The BPEL standard.
• Evolutions of EAI solutions towards ESB, XML at the heart of SOA?

Description

Recent years have seen a strong increase in the popularity of XML, the W3C standard for writing structured documents. At the end of this training, the participant will have complete mastery of the syntax of the XML Schema language and the modeling rules allowed by this language.

Who is this training for ?

Training objectives

Training program

Reminders about XML and associated technologies

• Structure and components of an XML document.
• Well-formed document and valid document.
• Structured and semi-structured data.
• The different types of XML parsers and their role.
• The galaxy of XML technologies.
• Practical work Create and validate an XML document.

XML and document composition

• Objectives of structuring languages: DTD, XML Schema, Schematron and Relax NG.
• The main parts of a schema.
• EBNF syntax for DTD (Data Type Definition).
• Validation of documents.
• DTD with multiple roots.
• Practical work Writing a DTD and documents conforming to that -ci.
• Modular restructuring of the DTD.

Namespaces

• Description and use of namespaces.
• Combination of multiple vocabularies.
• Combination of languages: XHTML, Xforms and SVG.
• Study of the scope of a namespace.
• Practical work Writing a document using several namespaces.

XML Schema language

• The syntax of the language.
• Defining a vocabulary and a grammar.
• Testing the values ​​of elements and attributes.
• Organization of elements: sequence, choice, heap.
• Use of keys and uniqueness rules.
• Practical work Redefinition of a DTD with XML syntax -Schema.
• Code improvement.

XML modeling techniques

• Design patterns.
• Unique patterns applicable to different document types.
• Generic reusable patterns (list, grid, etc.
• ).
• Documents using multiple diagrams.
• Practical work Application of the models studied.

XML and object design

• Reminders on object-oriented concepts.
• Object concepts of the XML Schema language.
• Types, class, derivation, polymorphism.
• UML/XML representation.
• Inclusion of schemas.
• Practical work Composition of modular and reusable schemas.

Modeling best practices

• Composition and inheritance.
• Types of constructions: "Russian dolls", "Slices of salami" and "Venetian blinds".
• Design pattern catalogs.
• Extensible content patterns.
• Practical work Evaluation of composition methods and use of different languages.

Description

Known for its blogging platform, WordPress has become a full-fledged CMS for easily creating and managing websites. You will learn how to install, configure and administer WordPress. You will build a site and manage its content and design. You will finally discover the main extensions.

Who is this training for ?

Training objectives

Training program

Introduction

• What is a CMS, its features.
• Distinctions Blog/Site, Article/Page.
• The blogosphere, trackbacks.
• Demonstration Discovery of wordpress.
• com and wordpress-fr.
• net.
• Visit to a website blog, CMS and mixed type.

Internet and local environment

• The concept of client/server, languages, protocols.
• Quick basics of database: Mysql.
• Hosting, domain name.
• Wampserver.
• Practical work Installation of the local environment.
• Creation of the database.
• Analysis of the tree structure.

Installation locale de WordPress

• Installation (wp-config file preview).
• Database overview.
• The dashboard.
• Discovery : tools, menus and navigation.
• Practical work Downloading WordPress.
• Local installation.
• Discovery / Appropriation of the solution.
• Choice of site theme.

Content construction

• Manage categories, keywords, pages and subpages, articles, links, media.
• Configuration of the home page.
• Creation of menus.
• Practical work Design of the site tree.
• Creation of the taxonomy.
• Addition of content.
• Creation of the home page.
• Creation of menus.

Appearance of the site

• Templates.
• Add a template.
• Widgets.
• Practical work Choice of a template , widget management in the sidebar and in the footer.

The responsibility of the administrator

• Responsibility for content.
• Point on Internet law.
• 'Trolling', 'spamming'.
• Management of users and their level of rights.
• Practical work Creation of different types of users, management of subscriber registrations.

Site extensions and maintenance

• What is an extension? Find and install an extension.
• Opening Hello Dolly.
• SEO extension: ALL IN ONE SEO .
• Protection extensions: Akismet.
• Content extensions: Contact Form 7, WP DB Backup, Google Analytics, WPSuperCache.
• Maintenance and backup .
• Practical work Using extensions.
• Improving SEO and optimizing the cache.
• Creating a contacts page.

Description

This seminar provides you with solid, precise and concise knowledge in the field of networks. It presents the solutions deployed in different environments: corporate networks and data centers, access and transport networks. Particular emphasis is placed on the rapid advances made in the field of wireless networks, mobility and the Internet of Things. Finally, it highlights the concepts on which network administration and control are based.

Who is this training for ?

Training objectives

Understand network architecture Understand access and transport network technologies Specify corporate networks, networks for mobility and the Cloud Know the means of network management in terms of performance and security< /p>

Training program

Foundations of network architectures

• The basic principles of network architectures.
• Signal transmission and bandwidth.
• Routing, switching, addressing, naming, scanning.
• Services, applications and communication models.
• Quality of Service, control, management and service.
• Centralization of servers and data, data center, Cloud and virtualization .
• Operator networks, overlay networks and content distribution.
• Cellular and mobile networks.
• Architectures of tomorrow.

Business Networks

• Local network technologies. Architecture: capillary networks and core network.
• Cabling. Supports and topologies.
• Standardization and developments in networks premises.
• Principle of access technology: ISO 8802.3.
• The physical layers, MAC, and LLC The main protocols.
• Ethernet. switched.
• Virtual local networks: the principle of VLANs.
• Quality of service in Ethernet.
• Ethernet local networks for all environments. (SAN, LAN, WAN).
• Evolutions in enterprise networks.

Wireless networks

• Typologies: WPAN, WLAN, WMAN, WRAN.
• Wireless network technologies. IEEE 802.15 and WPAN. Bluetooth, ZigBee and WiGig.
• Wi-Fi and its variations from Wi-Fi 1 to Wi-Fi 7.
• Wi-Fi controllers.
• Wi-Fi virtualization.
• Wi-Fi security from WEP to WPA3.
• Mesh and ad-hoc networks: routing and direct modes.
• Hybrid networks.
• Satellite constellations.
• StarLink, Kuiper networks, etc.
• Upcoming announcements in this wireless field.

Internet architecture, operation and organization

• Founding principles: the datagram, interconnection. The TCP/IP protocol stack.
• Public and private addressing. NAT.
• IPv4, IPv6 protocol . ICMP. Transport: TCP, UDP.
• Non-connected mode and routing in IP.
• Principles of Quality of Service in IP.
• Applications IP: DNS, RTP, DHCP, SMTP, POP, SIP.
• IP network management. The SNMP approach.
• Mobility management in IP.
• Applications: from messaging to VoD Microsoft, Google, Netflix, Facebook.
• Future developments.

Network virtualization

• Network virtualization.
• Cloud Networking.
• Network function virtualization (NFV).
• Hypervision technologies, containerization , functions.
• The four levels of data center: embedded, Fog, MEC, Cloud.
• SDN (Software Defined Networking) technology.
• The centralization of the control plane and the functions of the controller.
• The programmability of equipment (data plane).
• The OpenFlow protocol and the evolution of SDN (Software Defined Network).
• SD-WAN, vCPE, vWi-Fi.
• The virtualization of tomorrow.

Interconnections and virtual private networks

• Repeaters, bridges, gateways.
• Switching versus routing. Intra and inter-domain IP routing.
• Switching of labels. MPLS architecture.
• VLAN switching (VXLAN, Q-in-Q, Mac-in-Mac).
• VPN and IPSec technology.
• The VPN-IP-IPsec and VPN-IP-MPLS environments.
• Information filtering.

Access networks

• The optical local loop: PON, FTTx, etc.
• The disappearance of twisted pair transmissions: ADSL, SDSL, VDSL.
• Cable operator solutions . Cable modems.
• The radio local loop.
• Access via satellite.

Mobile networks

• Typologies: WPAN, WLAN, WMAN, WRAN. Hot spot, handover, roaming.
• Architecture of 4G and 5G networks.
• LTE radio (4G) and NR (5G).
• The RAN (Radio Access Network) and the reasons for the revolution proposed by 5G.
• The core network and slicing.
• 5G applications: mission critical, Internet of Things, broadband in mobility.
• Management, security and control of 5G.
• Private 5G and products arriving on the market.
• Wi-Fi/5G convergence.
• Vehicular networks.
• The developments and future of mobile networks. mobile.

The Internet of Things

• RedCap (Reduced Capability) objects and high-speed objects.
• PAN or LAN networks for objects: Bluetooth, Halow, ZigBee, 6WPAN, etc.
• Private long-distance networks: LoRa, SigFox.
• Operator networks for objects.
• The use of virtualization: Fog and the Cloud.
• Platforms for the IoT.
• Sensor networks and the IoT (Industrial Internet of Things).
• IOT developments and forecasts .

Network security

• Attacks: viruses, Worms, DDOS. Solutions: firewall, authentication.
• Encryption, electronic signature...
• Directories for security. The LDAP model.
• The IPSEC model. Services, implementation.
• Secure elements.
• The security cloud.

Description

This seminar presents an overview of the most recent advances in the field of networks and telecommunications, emerging technologies and their integration into current environments. The different solutions will be explained from a technological and economic angle. This seminar also shows the current centralization of network architectures, the inexorable extension of mobile and Cloud-oriented architectures, and the joining of networks, storage and computing to form a new operational vision of the company.

Who is this training for ?

Training objectives

Develop a global vision of the evolution of network technologies
Understand Cloud networking
Understand mobile networks
Integrate network security issues

Training program

Network of today and tomorrow

• The essential functions of IP: addressing, routing (BGP, RIP, OSPF).
• Problems and solutions.
• Internet protocols: IPv4, IPv6, UDP, TCP, etc.
• VLANs and their extensions.
• VPNs and today's network security.
• The problem of energy management in networks.
• The state of play, the challenges and approaches.
• The principle of network virtualization.
• The transition from hardware networks to software networks.
• The integration of calculation, storage, networks: a new vision of corporate IT architecture.

Evolution of routing technologies in networks

• Routing versus switching.
• Switching: very high speed, labeling and signaling.
• Overlays, content distribution and P2P.
• Carrier grade networks.
• Traffic engineering and optimization of network throughput.
• Control techniques.
• Automation of management and control .
• Operation and support.

Network technologies and their evolution

• ATM, the myth of the universal network.
• Ethernet for everything! From 10 Mbit/s to 400 Gbit/s.
• The different types of Ethernet switching.
• MPLS and the Internet Telecom generation.
• Label switching.
• Origins and motivations.
• Generalization G -MPLS.
• VLAN and its many extensions: Q-in-Q, Mac-in-Mac, PBB, etc.
• The new generation of protocols: TRILL and LISP.

Le Cloud networking

• Network cloudification and SDN (Software Defined Networking).
• The standardized architecture of SDN by the ONF (Open Network Foundation).
• The layers of the ONF architecture: application, control, infrastructure.
• The interfaces: north, south, east and west.
• The protocols of the southern interface: OpenFlow, I2RS, OpFlex, etc.
• Controllers: Open DayLight (ODL), Open Contrail, ONOS, etc.
• NFV (Network Function Virtualization).
• L 'orchestration and chaining.
• The open source architecture of the future: OPNFV.

Wireless networks

• WPANs.
• New generation, IEEE 802 standards.
• 15 and WiGig.
• WLANs.
• The Wi-Fi environment with IEEE 802.
• 11a/b/g/n.
• The new generations of Wi-Fi: 802.
• 11ac/ad/af/ah/ax.
• Handovers, quality of service and security.
• Low and high level access controllers.
• The Wi-Fi Passpoint telecom generation.
• The impact of SDN and OpenFlow on the Wi-Fi environment.

Mobile networks

• The generations of mobile networks.
• The increase in speed.
• The integration of Wi-Fi and mobile networks.
• 4G and 5G: the rise of mobile networks.
• Mobility: handover, multi-technology access, multi-access, etc.
• Mobile IP and its derivatives.
• New technologies: Software-defined Radio, network coding, cognitive radio, etc.
• The massive arrival of things, the Internet of Things and Fog Networking.
• Sensors, RFID, NFC, how to connect them.
• Ad hoc and mesh networks.
• The Participatory Internet.
• The new generations D2D, D2D2D, autonomous and optimized.
• Drone networks.

Security

• Is the Internet security model still viable? Authentication and IEEE 802.
• 1x.
• Encryption and electronic signature.
• Classification of flows for security purposes.
• The new generation of firewalls.
• Solutions based on secure elements.
• The problems in mobile payment.
• SDN security.
• The Security Cloud.

Future prospects

• Does centralization have a chance of establishing itself? Very high wireless density (stadium, large assembly, etc.
• ).
• Distributed SDN.
• The “green” and the solutions envisaged to reduce consumption.
• The integration of storage, calculation, network: towards a new globalized architecture.
• Open source, network intelligence and automation.
• Conclusions.

Description

This seminar offers a complete state of the art of the emerging field of network virtualization and the impacts on the digital transition and Cloud Networking. After an introduction presenting the market and the changes in virtualization in the Cloud, the seminar offers an in-depth study of SDN (Software Defined Network) software networks as well as the current NFV (Network Function Virtualization) standardization. It shows a presentation of the OpenFlow protocol as well as existing solutions on the market and their deployment.

Who is this training for ?

Training objectives

Define the fundamental principles of network virtualization
Understand and evaluate the main aspects of software networks
Identify the problem and the inherent technical solutions
Discover and implement existing solutions
Understand the economic and innovation opportunities brought by the SDN

Training program

Virtualization and networks

• The market and virtualization needs.
• The transition from the internalized information system model to outsourced.
• The impact of broadband technologies on network virtualization (Optical Fiber, High-speed Cellular Networks).
• From supercomputers to data centers.
• Academic and industrial research projects precursors of SDN.
• Virtualization: concept, models and principles.
• Hypervisors (Xen, VMware/vSphere, OpenVZ, Linux VServer, Hyper-V, KVM).
• The different solutions of Cloud (SaaS, PaaS, IaaS).
• Network integration in the Cloud: Neutron in OpenStack.
• Virtualized equipment.
• Characterization of Quality of Service (QoS), the mechanisms which guarantee it.
• Examples of virtualization of network functions (Firewalls, Switch, Router, PC.).

Architecture and its standardization

• Standardization organizations.
• Standardization in progress with NFV (Network Functions Virtualization).
• ONF (Open Network Foundation) architecture.
• North, south, east and west interfaces.
• Cloud architectures (Central Cloud, Cloudlet).
• Uses (Infrastructure, Service, Mobile.).
• Constraints for hosting sensitive data and regulation.

Techniques and applications of SDN (Software Defined Networking)

• SDN network architectures.
• Transmission plane-control decoupling.
• Abstraction layers.
• Physical controllers and virtual.
• SDN in local networks.
• LAN controllers, applications.
• SDN players: Open Networking Foundation, IETF, operators .
• Control of the infrastructure (centralized or distributed).
• Automation of network management.
• The coexistence of virtualized and traditional networks .
• The migration of virtual networks.
• The virtualization of security (virtual firewalls), what is possible to achieve.
• The management of access control (Authentication, identity management).
• High Availability, load balancing (Load Balancing).
• Energy consumption management , how can we reduce this consumption?

OpenFlow networks

• The controller-transfer node coupling.
• OpenFlow functionalities and frames.
• OpenFlow switches, Open vSwitch.
• The controllers compatible with OpenFlow, NOX, FlowVisor.
• Open Source developments, OpenDaylight, OpenContrail.

Protocol levels

• The frame and packet level.
• Advantages and Disadvantages.
• Interconnection solutions for data centers.
• Compatibility with Ethernet .
• Level 2 routing.
• QoS: MPLS/GMPLS.
• Overlays: NaaS.
• Technologies levels 3: NVGRE, VXLAN.
• VXLAN (Virtual Extensible LAN) encapsulation protocols.
• Trends: STT, NVGRE, SPB.

Wireless network virtualization

• Virtualization in mobile networks: HLR, VLR, virtual antennas.
• The coexistence of virtualized and non-virtualized mobile networks, Cloud-RAN.
• Virtualization of the IMS (IP multimedia Subsystem).
• Passpoint virtual access points.
• Migration of virtual access points.

New network paradigms

• The limits and disadvantages of the current architecture.
• SDN and the support of new network paradigms.
• SDN in the Internet of Things.
• The TRILL (TRansparent Interconnection of Lots of Links) protocol.
• The LISP (Locator/Identifier Separation Protocol) protocol.
• The ICN (Information Centric) model Network).

SDN equipment manufacturers, new trends

• Standard products from OEMs.
• ACI (Application Centric Infrastructure) from CISCO.
• NSX from VMware, FlexNetwork from HP.
• Other proposals: Brocade, Juniper, Alcatel-Lucent/Nokia.
• Performance: hardware accelerators.
• Trends among operators, first deployments: Google, Orange.
• The maturity of SDN solutions.
• The positioning of Cloud Networking.
• The convergence of networks (Mobile and Cloud).
• The impact of virtualization on applications and services.
• Deployment forecasts.
• The chances of success of new generations of protocols.
• Market trends.

Description

This seminar offers an overview of IP telephony solutions. It presents the founding concepts and purposes. It describes the essentials of the underlying protocols and addresses migration, performance and security issues. The different possible solutions are analyzed and illustrated using real case studies.

Who is this training for ?

Training objectives

Know the issues and challenges of ToIP Understand the H323 and SIP protocols Prepare the migration to ToIP Manage the QoS and security of ToIP networks

Training program

Network and telecom reminders

• The PSTN: the Switched Telephone Network.
• The business telephone service.
• Its architecture.
• Its active elements (PABX , Terminals).
• Available services.
• Its constraints and limitations.
• Internet architecture, TCP/IP networks.
• The enterprise data network.
• Its architecture.

IP telephony

• Definition and concepts.
• The vocabulary of ToIP.
• Business networks and their developments: Voice and Data, convergence towards a single network.
• Why migrate to ToIP? How to integrate ToIP into the company's information system? How to interoperate with traditional telephone networks? The user functionalities provided by ToIP .
• The market and its actors.

The essential protocols (H323, SIP...)

• Role and interest of each protocol.
• H323 presentation and architecture.
• Principles and definitions.
• H323 components: gatekeeper, MCU , gateway.
• Communication H323: RAS, H225, H245.
• Examples of enterprise architectures.
• SIP overview and architecture.
• Principles and definitions.
• SIP components: proxy, registrar, redirection, location.
• SIP communication: registration, location, call, mobility.
• Examples of enterprise architectures.
• Other VoIP protocols.
• MGCP, MEGACO, H248.
• The IAX protocol, the Open Source protocol of Asterisk.

Migrate to IP telephony

• The keys to choosing ToIP.
• The motivations of companies for switching to ToIP.
• The cost: the pluses (communications, maintenance ), the least (equipment, skills).
• New services: improving employee productivity (VisioConf, Mobility, etc.).
• The scalability of the network and of its applications.
• The image of the company.
• Business scenarios and market solutions.
• Several solutions, for different companies.
• The PABX-PABX interconnection.
• Migration to the IP PABX: examples of manufacturer solutions, its advantages and constraints.
• IP type solutions Centrex: examples of operator solutions, its advantages and constraints.
• Peer-to-peer: the Skype and Wengo model.
• Satisfaction and maturity of the solutions.
• Managing a ToIP project.
• The different stages.
• Needs analysis and network audit.
• Comparison of available solutions, adaptation of the solution to the company, migration.
• The keys to success.
• The obstacles.
• TPE practical work , SMEs and Large Accounts.
• Functionalities, cost analysis, availability, maintenance.

Integration and administration

• Manufacturer administration tools.
• QoS measurement probes.
• Integration with user databases: LDAP, SSO.
• Use and update of network equipment: DHCP, TFTP, DNS.
• Mobile telephone terminals (VoIP over WiFi, DECT, dual-mode terminals).
• The links: xDSL, Ethernet, radio links, sizing.

Performance and QoS of ToIP networks

• Why do data networks not provide the reliability required for voice transport? The benchmark for reliability: RTC.
• Strengths and weaknesses of networks of data in terms of quality of service.
• QoS concepts.
• Delay, jitter, packet loss.
• The impact of the QoS of an IP network on ToIP.
• Voice transport.
• Voice digitization: use of codecs.
• To compensate for the unreliability of IP networks, use of specific protocols: RTP and RTCP.
• Summary of the flows involved in ToIP.
• Signalling (call routing).
• The media (voice, video).
• Providing performance to IP networks.
• Reinforcing bandwidth.
• Management tools of QoS for IP networks (802.
• 1P/Q, RSVP, DiffServ, MPLS.
• ).
• Quality benchmarks in VoIP : E-model, PESQ, PAMS, PSQM.

Security

• Problems of switching to ToIP solutions.
• What should we protect ourselves from, from whom, why can we be attacked? Known threats.
• Confidentiality: protect media streams and signaling type data.
• Integrity: control and prevent data modifications.
• Availability and denial of service.
• Identity theft.
• Fraud.
• Spam.
• Regulation: legal security and obstacles to technological development.
• The problem of emergency services.

The future

• Operator developments: fixed/mobile convergence and abandonment of the RTC model for VoIP.
• Convergence technologies: WiMax, MPLS.
• The new multimedia services and uses.
• IMS, IP Multimedia Subsystem, the multimedia network of tomorrow.

Description

This training presents the principles of business telecommunications and associated vocabulary. It describes the standards used in telephony, the architectural principles, the equipment, services and applications available, how to structure and organize a business telephony network.

Who is this training for ?

Training objectives

Understand the vocabulary and principles of business telecommunications.
Understand the standards used in telephony.
Identify new architectures and equipment for business telecommunications.
Discover telephony services and applications.
Discover the developments towards telephony over IP (ToIP).
Understand the principles of mobility over IP.

Training program

Telephone networks of fixed operators

• From voice to telephony.
• Signal processing (analog and digital).
• History of PSTN, ISDN telephone networks.
• Organization of operator networks.
• Digital operator access (MIC).
• D signaling (Q931), SS7.
• Advanced services and intelligent network.
• Evolution of Telecoms.

Business telephony: from PABX to IP Centrex

• Architecture and components.
• Call handling.
• Routing/switching. Evolution of enterprise network architecture, convergence voice/data.
• Evolution towards telephony over IP (ToIP).
• PBX interconnection (RPIS).

Les Call Centers

• Architecture and components.
• The stages of processing a customer call.
• Distribution and queue management.
• CTI and CSTA standards.

Signaling

• Role and objectives. Types of signaling. Standards and convergence towards IP.
• Multimedia protocols H323, SIP, RTP, MGCP. Multimedia codecs (G7xx, AMR, H263, MPEG 4).
• Stream architecture and dynamics.

Telephony services and applications

• Basic services (double call, multiline).
• Reception services (pre-answer, grouping...).
• Voice messaging and unified messaging .
• Speech synthesis and “text to speech” technology.
• Automatic switchboard and interactive voice server.
• Management applications.

IP telephony

• Needs of data networks and telephone networks.
• New services.
• Business scenarios.

Wireless and mobile telephony

• GSM, EDGE and UMTS mobile networks.
• Mobility over IP (WiFi / 802.11x, Wimax).
• Fixed-mobile convergence (UMA) ).

Advanced communications services

• Personal Information Management.
• Real-time voice/video services via the Web.
• New services (presence, instant messaging, video telephony, etc.).
• IMS (IP Multimedia Subsystem) development prospects.
• New uses and change management.

Description

This training presents an overview of cellular networks and their competitors. You will see methods of access and data transfer, the structure of mobile networks, wireless and the transition to mobile Internet. So much knowledge necessary to decide on a mobile network policy.

Who is this training for ?

Training objectives

Training program

General

• Introduction.
• History: mobile service, radio transmission.
• Fixed networks vs mobile networks.
• Frequencies and radio spectrum.
• Propagation and directionality.
• Cells: sizes, obstacles, performance.
• The four generations of mobile networks.
• Analogue networks : radio-mobiles (1 G).

Basis of cellular systems

• Mobile networks: waves and propagation.
• TDMA, CDMA and FDMA access methods.
• The solution of the future: OFDMA.
• Radio duplexing methods.
• Random access methods: Aloha, CSMA, CSMA/CD, CSMA/CA.
• Methods for estimating radio quality 'cellular communication.
• Speed ​​and range settings.
• Compatibility with the Internet and the IP standard.

General structure of mobile networks

• Radio link.
• GSM, GPRS, EDGE networks.
• 3G, 3G+ networks.
• The transition to 4G ( LTE).
• License allocation methods.
• Frequency allocation methods (cellular patterns, sectorization.
• ).
• The evolution of mobile services.
• Mobility mechanisms: roaming, handovers, roaming, nomadism.
• Session management mechanism.
• Security mechanisms and protocols.
• 4G systems: functionalities (cognitive radio, spectrum aggregation.
• ) and performance.

Wireless networks and the shift to mobility

• IEEE cellular networks.
• Wireless personal networks.
• Wi-Fi networks.
• Wi-Fi architectures and planning .
• Security in Wi-Fi.
• Application: ToIP.
• QoS in Wi-Fi.
• Networks Wimax.
• Wimax applications: BLR and bakhauling.
• Fixed Wimax vs mobile Wimax.
• Sustainability of Wimax in the face of LTE.
• Horizontal and vertical handovers.

The evolution towards mobile Internet

• IP mobility.
• Ad hoc and mesh networks.

Description

This seminar presents the techniques that have introduced mobility into our daily lives: GSM, GPRS, and EDGE. It details the GSM standard and its evolution towards packet mode and broadband. It also examines the challenges posed by new applications running on mobile networks.

Who is this training for ?

Training objectives

The objective of thisMobile Networks trainingis to understand these developments and to detail the underlying technologies through a complete overview of mobile networks

Training program

The cellular concept

• Analog/digital transmission.
• Propagation.
• Cellular planning.
• Duplexing and multiplexing techniques.

The GSM system

• The architecture of GSM.
• Its growth throughout the world.
• Its advantages and disadvantages.
• The different elements making up GSM: MS, BTS, BSC, MSC, HLR, VLR, etc.
• The interfaces connecting these elements together.
• Detailed study of the Um interface, i.e. the radio interface.
• Definition of the physical channel in GSM.
• Its different rates.
• The maximum capacity of the access network in GSM.
• The messages.
• The protocols existing between the terminal and the network to establish a communication.
• Study of intercellular transfer (handover) and call establishment.
• Authentication and encryption.
• What are the American systems? IS136 and IS95.
• How are they different from GSM? ? Overview of the innovations brought by the IS95: soft handoff and discontinuous transmission.

The GPRS system

• GSM and packet mode.
• What type of traffic in packet mode is GPRS suitable for? Traffic study www.
• L 'GPRS architecture.
• The elements of packet mode and the gateway to the Internet: GGSN and GGSN.
• Example of GPRS routing.
• Allocation radio resources by GPRS.
• Static and dynamic allocations.
• GPRS multi-frame.
• Classes of service.
• The logical channels of GPRS.
• Cohabitation with GSM.
• Terminal management: active and idle.

The EDGE system

• Broadband.
• How can we improve GSM speed? 8-PSK modulation.
• EDGE speeds.
• Adaptation of the link.

Description

After an evolution in our society with the use of GSM, the world of telecommunications wanted to turn definitively towards broadband. This course will provide you with the knowledge necessary for a good understanding of UMTS networks after having reviewed GSM/GPRS/EDGE networks.

Who is this training for ?

Training objectives

Training program

Cellular architecture

• Concepts and reminders.
• The four generations of mobile networks.
• Mobile radio, GSM, UMTS, LTE.
• Methods of 'data access and transfer.
• General structure of a mobile network.

GSM/GPRS/EDGE networks

• Reminder: principles and concepts maintained by 3G.
• GSM architecture.
• The elements making up GSM.
• Messages and GSM protocols.
• GPRS architecture and components.
• EDGE.
• High speed.

And CDMA

• Presentation of CDMA (Code Division Multiple Access).
• Transmission coding.
• Orthogonality between resources and the difficulties encountered in maintaining it.
• Orthogonal codes and pseudo-random sequences.
• Synchronization of CDMA communication channels.
• Allocation of codes to users in a cell and on sending information in CDMA mode.

The 3rd generation

• Introduction to third generation universal networks.
• UMTS and IMT2000.
• Global competition in the third generation.
• System and services proposed by UMTS.
• The architecture of UMTS.
• Variable bit rates.
• Different multiplexing modes on the radio interface.
• The core network: CN.
• The Uu radio interface.
• The FDD/W-CDMA and TDD/TD-CDMA modes.
• A comparison between the two modes.
• W-CDMA.
• The physical, logical channels and the mapping with physical channels.
• The method of allocating codes to terminals.
• HDR ​​(High Data Service).
• The cdma2000 packet service, an efficient interconnection with the Internet and the IP protocol

Illustration: understanding CDMA

• Power control: open loop, closed loop.
• How to generate orthogonal codes? Illustrate the problem of synchronization and loss of orthogonality.
• Pseudo-random sequences and desynchronization correction.
• See a complete example of the CDMA transmission chain (coding and scrambling).

Description

This training will allow you to navigate the evolution of technologies towards 4G, pre-4G solutions, its technical solutions, its economic future, 4G services and its inclusion in "full IP".

Who is this training for ?

Training objectives

Training program

Next generation architecture

• Introduction to 4G technologies.
• 4G OFDMA and SOFDMA techniques.
• Advantages and disadvantages compared to 3G and CDMA.
• The architecture of 4G networks.
• Which architecture for which application in 4G? All-IP: the advantages and disadvantages.
• Convergence fixed mobile: IMS.

Next generation architecture

• Introduction to 4G technologies.
• 4G OFDMA and SOFDMA techniques.
• Advantages and disadvantages compared to 3G and CDMA.
• The architecture of 4G networks.
• Which architecture for which application in 4G? All-IP: the advantages and disadvantages.
• Convergence fixed mobile: IMS.

Pre-4G networks

• Fixed and mobile WiMAX networks.
• WDSL and the performance to expect from it.
• Standards for future generations of IEEE such as 4G.
• IEEE 802.
• 22 and regional networks for interactive television.
• New generations of Wi-Fi and their impact on 4G.

4G mobile networks

• The fourth generation (4G), HSOPA and LTE.
• The 4G revolutions.
• Very high speeds: more than 100 Mbit/s in crest.
• 4G with LTE (Long Term Evolution) and UMB (Ultra Mobile Broadband).
• WWI (World Wireless Initiative).
• The first 4G operators.
• 4G terminals.
• LSTI tests (LTE/SAE Trial Initiative).
• 4G services.
• Audio video services.
• P2P services and more generally T2T.
• Web services and security.

Convergence and integration in the Internet

• Fixed mobile convergence.
• IMS (IP Multimedia Subsystem): IP-Telecom convergence.
• The architecture of IMS.
• The TISPAN working group.
• The mobile IP solution: advantages and disadvantages.
• The IPv4 and IPv6 versions.
• Cellular IP and micromobility.
• Comparison with the mobility of cellular networks.
• Which solution for the fourth generation: Home Agent and Foreign Agent or HLR/VLR? The optimization of the road; smooth handovers.

Ad hoc networks and MANET for 4G

• Ad hoc network architectures.
• Optimization of spectrum use.
• The impact of the IP world on ad hoc networks.
• The standardized OLSR and AODV protocols.

Perspectives et conclusion

• The place of DTT (digital terrestrial television) in 4G.
• 4G networks and ?Full IP.
• The new autonomous architectures for control of 4G.
• The virtualization of 4G equipment.
• Developments such as LTE-Advanced.
• Exercise: Calculating the throughput of a network WiMAX.

Description

This seminar presents VoIP over LTE for which IMS is mandatory. You will develop your knowledge of the characteristics of 4G and IMS networks, the concepts for establishing VoLTE service with the maintenance of telephone communication during a handover to 2G/3G networks and taxation mechanisms.

Who is this training for ?

Training objectives

Study the evolution of mobile networks Understand the solutions proposed in the LTE standard to offer multimedia services (voice, presence, etc.)
Understand the operation of the IMS network and SIP signaling for the deployment of VoLTE Differentiate between VoLTE services from OTT solutions Analyze the concepts of taxation

Training program

2G and 3G cellular networks

• Presentation of the 2G network architecture.
• GSM: separation of the radio core and the network core.
• Description of the evolution from GSM to GPRS.
• Evolution of the network with the arrival of 3G: study of the UTRAN radio core.
• Evolution of the network core: from R.
• 99 towards NGN .
• The entities of the 2G and 3G network.
• Role and functionality.
• Radio resource management procedure.
• Services voice and data transmission of 2G and 3G networks.
• The circuit and packet switched network.
• Study of a call: Mobile Originating Call and Mobile Terminating Call.
• Attachment to the Data network.
• Notions of PDP Context.

The LTE network

• EPS network architecture: LTE - SAE.
• Description of entities: eNB, MME, SGW, PGW, PCRF, HSS.
• X2, S1 network interfaces -U, S1-MME, S5/S8, S6, S11, Gx.
• Signaling in the control plane and the user plane.
• Protocols: RRC, S1-AP ,
• Description of the physical layer: Modulation, Multiplexing, PRB.
• Notion of bearer, QoS parameters.
• Default bearer, dedicated bearer.
• The PCC: QoS and taxation.

SIP: presentation and architecture

• Principles and definition.
• SIP architecture and description of functional entities: Proxy.
• Registrar.
• Redirection - Location.
• SIP protocol: signaling and voice flow mechanisms.
• SIP messages: description of requests and responses.
• RTP protocol: voice transport.
• Presentation of codecs: impact on the MoS.
• SIP addressing mechanisms (URI, IP, E164).
• Methods.
• Method details: INFO, OPTION, MESSAGE.
• SIP and mobiles.
• GSM, GPRS.
• 3GPP.
• Example of SIP communication: study of call FLows (recording, call.).

L'architecture IMS

• Presentation of the IMS.
• The protocols used.
• IMS server (IP Multimedia Subsystem): P-CSCF, I-CSCF, S-CSCF.
• HSS, PCRF, MGCF, MGW/SGW equipment.
• AAA in IMS: study of the Diameter protocol.
• Client authentication.
• Billing architecture (Online and Offline).
• Signaling in the IMS: the SIP/SDP protocol.
• Registration and service management procedures : Call Flow study.
• IMS services and application servers

Radio functionality for voice

• Voice Bearer Management: QoS, QCI, ARP, GBR, non-GBR.
• Admission policy.
• Preemption of eNb.
• Scheduling strategy: dynamic, semi-persistent.
• DRX mode VAD (Voice Activity Detection) options and comfort noise generation.
• TTI Bundling features.
• Compression of IP headers: RoHC, principles and performances.
• Management of Handovers.
• Practical study: limitation of the number of simultaneous calls according to the number of PRBs.

Voice over 4G solutions

• CSFB technological solutions.
• MSC / MME interconnection.
• Registration on the circuit-switched network and on the IMS network: concept of double attachment.
• VLR bypass: TAI/LAI.
• SG and SV interface.
• SR-VCC (Single Radio Voice Call Continuity) function.
• SRVCC: session transfer in the core network and call transfer on the radio layer.
• Reception/Sending an SMS on the 4G network.
• Roaming and interconnection.
• Taxation and QoS.

Voice over LTE

• Attachment procedure.
• Creation of the Default bearer.
• Registration procedure to the IMS network: study of SIP signaling and 4G SIG.
• Private/Public IMS addressing.
• Negotiation of codecs and availability of radio resources.
• Setting up a SIP call/session: creation of the dedicated bearer.
• Telephone services provided by the IMS server.
• Call flow on user registration.
• Interconnection between the LTE network/ EPC and IMS? role of P-CSCF.
• Study of SIP requests: NOTIFY/SUBSCRIBE.
• RCS and OTT services: Joyn, Skype.
• SRVCC function: impact on registration and session establishment, PS-CS handover, session maintenance.
• ATCF/ATGW entity and SCC AS server.
• Evolution of the LTE and IMS architecture: e-SRVCC, v-SRVCC, r-SRVCC.
• Case study Call FLow: SMSoSG and Mobile Originated Call (MOC), Mobile Terminate Call (MTC) and roaming.

Voice over WiFI: WiFi Calling

• Call over WiFI.
• Extension from LTE network to WiFI: ePDG gateway, T-ADS (Terminating Access Domain Selection).
• Authentication over WiFI network .
• Call continuity.
• Handover.
• Evolution of Vi-WiFI.

Description

The world of wireless networks is rapidly being enriched with new norms and standards. These networks allow company equipment such as voice, data and images to be connected together. They are also the basis of operators’ “hot spots”. IEEE 802.11 networks (Wi-Fi and all variations), Bluetooth, UWB, Zigbee, IEEE 802.16, WiMAX, WRAN, etc., will be studied in detail in this seminar as well as the applications that can be associated with them.

Who is this training for ?

Training objectives

Understand the challenges of the world of wireless networks.
Know the technologies and developments in wireless/Wi-Fi networks.
Understand the different Wi-Fi networks and all their variations.
Learn the new standards and the new standards.

Training program

Principles of wireless networks

• Introduction to wireless networks.
• WPAN, WLAN, WMAN, WRAN.
• Expected characteristics and performances.
• Handovers and the integration of solutions.
• The integration of wireless networks in the company.
• Required speeds.
• Environment. home, office and business automation.
• The “hotspots” of operators.
• The advantages of Wi-Fi technologies.
• The difficult problems posed by Wi-Fi for operators.
• Handovers.
• The problem of mobility.
• Integration with mobiles.

Bluetooth, ZigBee and the Internet of Things

• Technologies for the Internet of Things.
• IEEE 802.15 standards and technologies, ZigBee, Bluetooth, etc. Support from manufacturers.
• Technology IEEE 802.15.1 and Bluetooth.
• IEEE 802.15.4 and ZigBee products.
• Personal networking technologies.

Wi-Fi IEEE 802.11

• Wi-Fi and the new nomenclature: from Wi-Fi 1 to Wi-Fi 7.
• The reasons for the success of Wi-Fi technology. The particularities.
• MAC layer: CSMA/CA. Frequency bands.
• Ethernet integration.
• The technique of accessing physical media.
• Quality of service and IEEE 802.11e.
• Telephone speech and streams.
• Wi-Fi switches and controllers.
• Wi-Fi network engineering and management.
• IEEE 802.11ac/802.11n standards.
• Constraints. Cost. Configuration.

Mesh networks and ad hoc networks

• The participatory Internet.
• Definition of a mesh network and an ad hoc network.
• Routing in mesh networks. Routing protocols: proactive (OLSR, DSDV) and reactive (AODV, DSR).
• Security and QoS in ad hoc networks.

New generations of wireless networks

• WiGig1 and WiGig2.
• Cognitive radio and White-Fi Wi-Fi.
• The generation of WRAN regional wireless networks.
• The new Wi-Fi 5 and 6 generations (802.11ac and ax).

Protocols and applications

• The smart city.
• Vehicular networks: Wi-Fi IEEE 802.11p.
• The IP environment. Slow start problems.
• MIMO technologies and increased throughput. Massive MIMO.
• The use of beamforming and directionality.
• Security protocols: WEP, WPA1 , WPA2 and WPA3.
• Pirate access points.
• Applications: speech, video, production, P2P...

Mobility in wireless networks

• Mobile IP and interdomain mobility management.
• Cellular networks: GSM, GPRS, EDGE.
• 3G (UMTS) and 3G+ (HSDPA) networks and HSUPA).
• The OFDMA access method and 4G.
• 5G and its introduction into the enterprise in competition with Wi-Fi.
• LTE-M, NB-IoT, LTE-V, and new applications.

Comparison with 4G and 5G networks

• LTE-U and 5G NR-U. 5G on the local network.
• Techniques associated with Wi-Fi: LAA and eLAA.
• LBT (Listen Before Talk) and the industrial standard: MulteFire.
• Wi-Fi-LTE carrier aggregations.
• Femtocells and metrocells.
• The use of new frequencies, particularly millimeter waves.

Conclusion and future

• The upcoming standards: Wi-Fi 7.
• Will there be competition between Wi-Fi and 5G?
• The impact of mixed Wi-Fi – LTE mesh networks.
• The role of new Fog datacenters.
• Towards 100 Gbit/s in Wi-Fi

Description

This course will provide you with complete and concise knowledge on Quality of Service (QoS): how to provide a service that meets response time and bandwidth requirements? It shows the interaction of QoS with the most used protocols in the world of computer networks.

Who is this training for ?

Training objectives

Training program

Concepts de base

• The operation of the network.
• The characterization of IP Quality of Service (QoS).
• The mechanisms which guarantee it.
• Transport protocols.
• Implementation of QoS.

QoS and the IP protocol

• The DiffServ model.
• The classification of the service.
• The information to be stored in the IP packet.
• The TOS field (Type Of Service).
• Differentiated treatment.
• Control and marking of network equipment.
• The IntServ model.
• Comment achieve QoS without touching the IP protocol? Differentiated billing by the receiver.
• Gateway redundancy.
• HSRP and VRRP protocols.
• Equipment reconfiguration.
• The Graceful Restart mechanism.
• The principle of restarting the control card.
• Case study Configuration examples.

QoS and MPLS

• Diffserv support by MPLS.
• Control and regulate traffic distribution.
• Implement Traffic Engineering.
• RSVP protocols -TE and OSPF-TE.
• The joint implementation of QoS and TE, Diffserv-Aware TE.
• The guarantee of rerouting in less than 50 ms.
• The Fast ReRoute mechanism.
• Implementation of Fast ReRoute.
• Graceful Restart and MPLS.
• Case study Configuration examples.

La QoS and Ethernet

• Priority management and mapping with DiffServ.
• The Subnetwork Bandwidth Manager (SBM) protocol.
• How to reserve resources with SBM? The Spanning Tree and QoS.
• Reconfigure the network with STP and RSTP protocols.
• Exercise: Configuration examples.

Description

This training will teach you how to install and administer Windows 10, the new Microsoft operating system for client workstations. Thanks to numerous practical exercises, you will learn how to configure and optimize the system in order to obtain the best performance. You will see how to perform common administration tasks, share and synchronize data between users and applications, and implement Windows 10 technologies to secure network connections and data for different sedentary or nomadic users.

Who is this training for ?

Training objectives

Know the main new features of the new Windows 10 operating system Install, configure and configure a computer with Windows 10 Customize the working environment: adding components to MMC consoles, its user space Perform common administrative tasks with Windows 10 Install and uninstall programs with Windows

Training program

Overview and installation of Windows 10

• Positioning of Windows 10 in the Microsoft offer.
• The different versions.
• Hardware prerequisites.
• Types and methods of installation, upgrade to Windows 10.
• Setting up a dual boot.
• Updating to Windows 10 from a previous version.
• License management and new authentication process.
• Range of supported processors.
• Recommendations and post-installation settings.
• Booting from 'a USB source, file sharing or WDS (Windows Deployment Services).
• Practical work Installation of Windows 10.

Windows 10 deployment

• Solutions offered by Microsoft (ADK, MDT, WDS).
• Capturing a Windows 10 image.
• Preparing and creating WIM images.
• Customizing a WIM image (adding drivers or software).
• Installing Windows in a VHDx (creating, deploying, booting, mounting.
• ).
• Boot options (WIM/PE and WIM/PE).
• Automate deployment methods.
• Native support for ISO and VHDx files under Windows 10.
• Migration of user profiles.
• Practical work Preparation and creation of WIM images, installation of Windows 10 in a VHDx.

Hardware and software configuration

• Device management (update, uninstallation, signing.
• ).
• Device management in USB 3.
• 0.
• Checking hardware compatibility.
• Setting up software restriction policies.
• Configuring web browser security.
• Hands-on Installation and configuration of device drivers.

Working environment

• The new features of the Windows 10 interface.
• The new Start menu, the Internet browser.
• Virtual desktops.
• Convergence mobile interfaces for tablets and PCs.
• Visual passwords (by image), by PIN code.
• Improve desktop performance.
• hidden shortcuts.
• The task manager (simple and detailed views) and its heat map.
• The registry.
• Practical work Take control of the user environment.
• Personalization of the workstation.

Setting up network connectivity

• Configuring TCP/IP network settings.
• Support name resolution for TCP/IP.
• Configuring network settings.
• Configuring the wired or wireless connection.
• Setting up the firewall.
• Advanced firewall configuration.
• Remote administration.
• Introduction to PowerShell.
• Hands-on Network configuration.
• IPv4 and IPv6 configuration.

Configure access to resources

• Configuring Windows 10 resource sharing.
• Data recovery and user profile, user data migration (USMT).
• Setting access permissions to shared resources.
• Setting up the home group (HomeGroup).
• Setting up a file encryption strategy (EFS).
• Setting file access permissions.
• Configuring User Access Control (UAC).
• Configuring authentication and authorizations (rights, smart cards, certificates .
• ).
• Setting up BranchCache (shared caching of remote files).
• Practical work Sharing data between several machines , setting up Live account in Windows 10.

Optimization for mobile computing

• Setting up BitLocker (hard drives) and Bitlocker To Go (USB).
• Administering Bitlocker recovery keys.
• Introducing DirectAccess.
• Optimization of mobility functions (power and cache of file shares).
• Configuration of remote connections (VPN, NAP, Remote Desktop.
• ).
• The online download store “Windows Store”.
• Practical work Using the Live account in Windows 10.

Monitoring and maintenance

• Setting up the Windows 10 update strategy (Windows Update).
• Disk space management (dynamic disks, partitions.
• ).
• Recovery options in Windows 10.
• Partition maintenance (defrag, extend, mount.
• ).
• Contribution dynamic RAID (Stores Space).
• System monitoring (events, counters, alerts.
• ).
• Configuring performance options (process priorities , memory.
• ).
• Practical work Using system monitoring tools.

Backup and Restore

• Using system restore points.
• Setting up a backup and recovery strategy.
• Configuring instant restore options.
• Practical work Using system restore points.

Security management

• Windows 8 security overview.
• Setting the local security policy.
• Securing data with EFS and BitLocker.
• Configuring application restrictions, user account control (UAC and Live account).
• Firewall settings: profiles, standard mode and advanced mode.
• Security settings of Internet Explorer 10.
• Configuring Windows Defender.
• Specific settings for laptops.
• Practical work Apply a policy (gpedit.
• msc).
• EFS encryption.

Description

This course will show you how to implement the different deployment techniques for Windows 10 workstations, with a view to efficiency and productivity. You'll see the new tools offered and learn how to create, customize and distribute images that meet business needs.

Who is this training for ?

Training objectives

Implement the different deployment techniques for Windows 10 workstations Install and configure ADK (Windows Assessment and Deployment Kit) Install and customize Windows with WinPE (Windows PE) Create and customize Windows 10 WIM images Implement a Lite Touch scenario with MDT

Training program

Deployment tools

• Presentation of the different tools (ADK, MDT, etc.
• ).
• The technologies (WIM format, etc.
• ) used for Windows 10 deployment.
• Generate the reference computer.

User State Migration Tool (USMT)

• Preparing the environment for migration.
• Using ScanState.
• Using Windows Easy Transfer (migwiz).
• Work practices Migrate a profile from Windows to Windows.

Create custom Windows 10 images

• Customizing a template image using the WADK.
• Deployment Image Servicing and Management.
• Driver and package management.
• Install and configure ADK.
• Deploying Windows 10 with the new tools.
• Create an image with ImageX.
• Customize a WIM image.
• Deploy Windows 10 with ImageX.
• Creating a WIM image from a template system.
• Deployment using Boot VHD.
• Converting a WIM image to a VHD image.
• Practical work Creating and customizing Windows 10 WIM images.

Windows PE customizations

• Creating WinPE boot media.
• Testing WinPE.
• Integrating specific drivers with drvload.
• Adding packages to WinPE with PEimg.
• Hands-on Create a WinPE bootable CD.
• Customize WinPE.
• Add scripts to WinPE.

Windows Deployment Services (WDS)

• Installing WDS and using images with WDS.
• Implementing Multicast.
• Targeting drivers corresponding to client hardware.
• Practical work Installation and configuration of a WDS deployment solution.

Microsoft Deployment Toolkit 2013 (MDT)

• MDT 2013 features.
• Setting up an LTI deployment.
• Creating a task sequence.
• Creating of a deployment image.
• Scripts.
• Lite Touch and Zero Touch deployment with MDT.
• Practical work rnImplementation of 'a Lite Touch scenario with MDT 2013.'}

Activation management

• Selecting the activation template.
• Implementing Active Directory-based activation.
• Assign Multiple Activation Keys (MAK ).
• Deploy Key Management Services (KMS).
• License Activation Tools.
• Request Activation Status .
• Take inventory of the environment with VAMT.

Description

This training offers a methodology and practical techniques to resolve the various problems that may be encountered in the use and administration of Windows 10: system, hardware, network, security, applications.

Who is this training for ?

Training objectives

Learn how to troubleshoot Windows 10 Use built-in maintenance tools and third-party tools Troubleshoot system, hardware, network, security, or application issues Configure automatic maintenance Recover information from clients and computers

Training program

Problem solving methodology

• Presentation of a method.
• Identification of resolution areas.
• Tips for improving system performance.
• Practical work rnCollect information remotely.

Troubleshooting System Problems

• Back up, restore system.
• BCDEDIT Startup Repair Tools.
• Troubleshooting startup problems with Windows RE.
• Create a restore point, a system repair disk.
• Create a system image.
• Creating, implementing a recovery drive.
• Tools basic built-in troubleshooting, troubleshooting.
• Hands-on Retrieve system information and define a plan for troubleshooting.
• Clean Boot.
• Speed ​​up startup and shutdown, using Windows troubleshooting tools.

Troubleshooting Hardware Issues

• Device management (updating, uninstalling, signing.
• ).
• Working with virtual hard disks.
• Install, configure the device drivers.
• USB 3 devices, hardware, force installation.
• Practical work Recovery of customer information and implementation of a plan 'action.

Network and security troubleshooting

• Troubleshooting sign-in issues.
• Configure User Account Controls (UAC).
• Setting up Windows Defender, Edge browser.
• Practical work Recovery of information from clients, computers.
• Resolving a problem.
• Security checks.

Application-related troubleshooting

• Install a virtual machine.
• Startup options and settings: what's new.
• Windows and Web applications.
• Startup history report problems.
• Troubleshoot an application that won't install.
• Practical work Installing the Hyper V Client.
• Identifying a problem application and implementation of an action plan.

Optimisation et maintenance

• Configure automatic maintenance.
• System refresh, maintenance tools.
• Study performance via monitoring tools.
• Save , restore files.
• Practical work Use of integrated maintenance tools and third-party tools.

Description

This training will teach you how to optimize the performance of Windows 10, Microsoft's new operating system and will allow you to master the techniques and tools intended to ensure a good level of security.

Who is this training for ?

Training objectives

Know the main security features of Windows 10 Manage and move encrypted files Manage rights (ACL) of user accounts Limit the installation of non-compliant applications with AppLocker Master the Windows 10 firewall and its advanced functions

Training program

Security fundamentals

• Physical, access and data security.
• Updates and vulnerability management with WSUS 4.
• Network access security.
• Firewall and proxy.
• Practical work Overview of Windows 10 security features.

Security policies and models

• Administrative templates.
• User environment settings.
• Install and configure applications.
• Management of Windows Store Apps.
• Internet browser configuration settings.
• Configuring AppLocker application restrictions.
• Hands-on Limit the installation of non-compliant applications using AppLocker.

Protection techniques

• Code signing for Kernel Mode drivers.
• Configuring Windows Defender.
• Hands-on Manage, move encrypted files.

Securing workstations

• Authentication and authorization in Windows 10.
• Implementing GPOs.
• Securing data with EFS and BitLocker.
• Configuring security control user account (UAC).
• Overview of Device Guard, Credential Guard.
• Practical work Manage rights (ACL) of user accounts, modify UACs on different profiles.

Protecting network connections

• Security in a Windows domain context.
• The Windows 10 firewall and its advanced functions.
• Network Access Protection (NAP).
• Administer PCs remotely with DirectAccess.
• Discover Windows to go.
• Practical work Configure the firewall.
• Join a domain, isolate workstations.
• Implementing NAP and DirectAccess.

Backups and restore points

• System protection.
• Manage and automate backups.
• Shadow copies and Volume Shadow Copies.
• Practical work rnBack up, reinstall, recover Windows 10.

Analysis tools

• The performance and stability analyzer.
• Error reporting.
• Diagnose memory.
• The deployment kit and Windows Assessment.
• Tools: Windows 10 Performance Toolkit (WPT).
• Battery life and power consumption.
• Practical work Manipulate analysis tools.
• Carry out a centralized audit.

Description

Who is this training for ?

Training objectives

Training program

Description

This training in which practical work plays a central role, will present you with the different tools, techniques and methods for configuring your systems for preventing and managing incidents involving data loss. The training covers all versions of Windows.

Who is this training for ?

Training objectives

Identify the different tools to secure data in a Windows environment.
Create a startup key Back up the registry.
Implement a backup strategy with market standards.
Recover Fatxx, NTFS files after accidental formatting Install an antivirus.

Training program

Analysis of risks incurred and existing solutions

• Costs linked to loss and security of data.
• What tools to secure data?

Data storage

• Drives, controllers: IDE, PATA, SATA, E-IDE, SCSI and Ultra-SCSI, Ultra2Wide-SCSI.
• Hard drives: logical, physical structure, formatting.
• BIOS boot sequence (MBR, UEFI).
• Startup: requested files.
• Step mode options.
• Practical work Low-level formatting.
• Partitioning a HD.
• Modifying partitions.
• Optimizing the size and occupancy of Clusters and partition size.
• Conversion from FAT to NTFS.

Hard drive recovery

• RAID systems, troubleshooting.
• Recovery after accidental formatting.
• Practical work Complete implementation of a backup strategy (design and achieved with market standards).
• Recovery of files under FATxx, NTFS.
• Recovery after accidental formatting.

Hardware settings

• Inputs/outputs, IRQ, DMA.
• RAM addresses, ROM.
• Slot number.
• Plug and play.
• Parameter visualization tools.
• Driver management.
• Search for the latest drivers, WDM, WHQL.
• Return to the previous version.
• Practical workrnInstallation of software to view the hardware without dismantling it.
• Optimization of the configuration.
• Analysis of the 'architecture, bottlenecks.'}

Boot media, troubleshooting tools

• How to create a bootable CD or disk/USB key? (With its diagnostic tools).
• Microsoft tools, WAIK.
• Practical work rnCreating a USB key.

System repair

• Image creation and customization with Ghost, DriveImage.
• The SID.
• Registry database backup.
• Optimize with the correct keys of the registry.
• Practical work Creation of restore point and use.
• Preparation of reference station.
• Restoration of the image on his computer.
• Backup, editing of registry bases.

Security

• The inverter.
• Types of viruses.
• Propagation vectors.
• Installation and update of antivirus.
• Securing the BIOS.
• Protecting the boot sector.
• Presentation of the Firewall.
• The right tools.
• Practical work Implementation of an antivirus policy.

Description

The Windows 10 operating system has many features and particularities that require specific knowledge. This very practical training will provide you with all the skills to effectively provide user support.

Who is this training for ?

Training objectives

Learn how to troubleshoot Windows 10 Use the correct commands and troubleshooting tools Adapt a workstation to the user's needs Add, configure, delete a user's account Install, uninstall and commission hardware and software

Training program

The user environment

• Manage PC mode, tablet mode, thumbnails, applications.
• Add, configure, delete a user's account.
• Associate a password to a user.
• Change the application associated by default with a file type.
• The registry, user profiles.
• The Edge browser.
• Practical work Changing user settings.

Startup and hardware management

• ReadyBoost and SuperFetch.
• Troubleshooting drivers, ACPI, APM.
• Basic troubleshooting tools: ERD, Windows diagnostics, backup.
• Troubleshooting CD, advanced tools: knowledge base, MBSA etc.
• Advanced boot mode: system restore, recovery.
• UEFI support.
• Practical work Troubleshooting, creating MMC, system restore, previous version, creating a backup, creating and using a WinRE and WinPE CD.

The file system and local security

• Troubleshooting quotas and EFS encryption.
• File access issues.
• Auditing.
• Bitlocker, setting up, key recovery.
• Local security policy.
• Policy templates.
• Counters, logs, and resource monitor.
• Jobs practices Creating and converting a volume, testing inheritance rules, testing a security strategy.
• Setting up counters to test disks, memory and CPU.

The file system and local security

• Troubleshooting quotas and EFS encryption.
• File access issues.
• Auditing.
• Bitlocker, setting up, key recovery.
• Local security policy.
• Policy templates.
• Counters, logs, and resource monitor.
• Jobs practices Creating and converting a volume, testing inheritance rules, testing a security strategy.
• Setting up counters to test disks, memory and CPU.

Network troubleshooting

• Network center and sharing tools.
• Setting up different network profiles.
• Usable protocols.
• Troubleshooting IPv4 problems /v6.
• Troubleshooting DNS, DHCP issues.
• Internet connectivity.
• Troubling firewall issues.
• Remote access and VPN.
• Practical workrnConfiguration and troubleshooting of the firewall, use of troubleshooting commands, analysis of network traffic.
• Setting up and testing files outside connection.
• Setting up a firewall rule.

Problems with system installation, software management

• View system information.
• Task Manager.
• Software Compatibility Assistant.
• Practical work Using the Hardware Assessment application and File Transfer Wizard.

The user environment

• Manage tiles, applications.
• Add, configure, delete a user's account.
• Associate a password with a user.
• Change the application associated by default with a file type.
• The registry, user profiles.
• Practical work Modifying the settings of the user.

The user environment

• Manage tiles, applications.
• Add, configure, delete a user's account.
• Associate a password with a user.
• Change the application associated by default with a file type.
• The registry, user profiles.
• Practical work Modifying the settings of the user.

Startup and hardware management

• System architecture.
• Troubleshooting drivers, ACPI, APM.
• Basic troubleshooting tools: ERD, Windows diagnostics, backup.
• WinRE, WinPE troubleshooting CD.
• Advanced tools: knowledge base, MBSA etc.
• Advanced boot mode: system restore, system image recovery.
• Boot settings.
• UEFI support.
• Practical work Troubleshooting, creating MMC, system restore, previous version, creating a backup, creation and use of a WinRE and WinPE CD.

Description

Windows Server 2016 offers new features for better security management and increased operating reliability. This internship will allow you to discover the new environment, learn how to implement it and evaluate its behavior.

Who is this training for ?

Training objectives

• Install, configure and configure a server with Windows Server 2016
  
• Perform administration tasks via the new interfaces and PowerShell
  
• Implement architectural security
  
• Monitor resources with GUI tools and PowerShell
  

Training program

Installation de Windows 2016

• Positioning of the different versions of 2016 (Gui, Core, Nano).
• Panorama of the new features (Windows defender, Windows container).
• The new features of the Windows 2016 server interface (notification center, started menu).
• Installation in CoreServer mode.
• Installation in NanoServer mode, dedicated Wim.
• Installation of roles and features with the dashboard.
• Roles in local or remote session.
• Practical work Install NanoServer mode.
• Installation of roles in local or remote session .

Local and remote administration

• Administer all servers via the server manager in graphical mode.
• Adding packages and managing roles.
• Administration of roles and managed features by NanoServeur.
• Configuring the network, the firewall (Nano Server Recovery console).
• Performing administration tasks with CorePowerShell.
• The remote installation of roles.
• Conversion of a graphics server into a Core server.
• Practical work Implement server group management.
• Remotely install roles.
• Manage the server with PowerShell.
• Converting a graphics server to a Core server.

Infrastructure and networks

• DHCP, DHCP FailOver, DNS and DNSSecure.
• IPv4 and IPv6 servers and protocols.
• New Direct Access (VNP) features.
• The IP address manager (IPAM).
• Creating zones and DNS records with PowerShell.
• Bandwidth optimization with NIC Teaming network cards).
• BranchCache mode: in distributed mode, in hosted mode.
• Practical work Install a DHCP Failover.
• Create zones and DNS records with PowerShell.

Disks, shares and file system

• The new ReFS (Resilient File System) file system.
• File system availability.
• Unified remote management for file services and storage pool.
• Configure Storage Spaces in Windows Server 2016.
• Dynamic Access Control (DAC) Overview.
• The data governance (Dynamic Access Control): configuration and planning.
• Dynamic disk space.
• Windows Defender malware protection.
• File security and files.
• The Biloquer system, securing partitions with Bitlocker, the TPM.
• Practical work Implementation of dynamic access control (DAC) and ReFS.
• Disk troubleshooting.

Active Directory

• Installation prerequisites.
• Installation of Active Directory on physical and virtual server.
• New object management interfaces.
• The Active Directory Administration Management Center (ADAC).
• Advanced auditing functions.
• Object management, creation of groups, users and Organization Units.
• Management of the Active Directory recycle bin.
• Creation of objects with PowerShell and the graphical interface, automation of administration with PowerShell.
• Local accounts and groups, user profiles.
• Practical work Configure the Active Directory.
• Creation of groups, users and Data Units Organization.
• Managing objects with the new interface.
• Using queries on the AD.

Troubleshooting and Optimization

• The new server management monitors.
• Windows 2016 Server startup methods.
• Recovery tools.
• The system backups and restores.
• PowerShell scripts to manage and troubleshoot the server.
• Optimization of access on networks and BranchCache mode.
• Practical work Use BCDEDIT, recovery tools and PowerShell scripts to manage and troubleshoot the server.

Virtualisation

• The basic concepts of virtualization.
• How Windows 2016 Server works with the hypervisor.
• Windows and Hyper-V Container.
• The Docker Framework and Windows Server containers.
• Hyper-V in Hyper-V.
• The creation of virtual machines (VMs), switches and other hardware components.
• Managing VMs and shadow copies.
• The VHDX format.
• Live moving a VM without a cluster (Live Storage Migration).
• Interaction of PowerShell and Hyper-V.
• Practical work Creation of shadow copies, virtual machine, installation of Windows Server 2016 on Hyper-V.
• Using Live Storage Migration.

Description

This course will allow you to master the Active Directory environment under Windows Server 2016. You will learn how to install and configure an Active Directory directory and perform all administration tasks via graphical interfaces and PowerShell.

Who is this training for ?

Training objectives

Install and configure an Active Directory under Windows Server 2016 Deploy domain controllers Perform common administration tasks via interfaces and PowerShell Deploy GPOs to administer workstations and servers Deploy dynamic access control to fine-tune resource permissions Back up and restore an Active Directory

Training program

L'architecture de l'Active Directory

• Active Directory roles and services.
• What's new in AD domain services 2016.
• AD services and Cloud orientation.

L'installation de l'Active Directory

• Directory deployment.
• The DNS system and Active Directory.
• Integrated and secure DNS zones.
• DNS records linked to the AD.
• Practical work Installation of the AD.
• Configuring the DNS.
• Record management.

Domain controller deployment

• Remote deployment and PowerShell.
• Domain controller cloning.
• Child domain implementation.
• The deployment of read-only DC (RODC).
• Practical work Deployment of RODC, remote DC.

Object management

• Management interfaces.
• Object management in PowerShell.
• Administered service accounts.
• Privileged access management (PAM).
• Silos and authentication strategies.
• Practical work Creation and modification of AD objects.
• Creation of account accounts service.
• Implementing authentication strategies.

Group policies

• The operating principle.
• The central store.
• WMI filtering.
• Inheritance, blocking and filtering.
• Practical work Creation of the central store.
• Creation of GPOs to secure stations and servers.

Dynamic access control

• Dynamic access control overview.
• Principles of claims.
• Principles of rules, centralized access policies.
• The FSRM resource manager, authorizations.
• Practical work Implementation of DAC to specify access to resources.

Sites, services and approval relationships

• The roles of an AD site.
• Management of sites and replications.
• Approval relationships: overview and configuration.
• Practical work Creation of sites and AD replications.
• Implementation of trust relationships.

Maintenance and troubleshooting of services

• Backup and restoration of services.
• AD database maintenance procedures.
• Replication troubleshooting.
• Role management FSMO.
• Practical work Maintenance, backup of the AD.
• Implementation of monitoring tools.

Description

This course will allow you to understand the different preventive and curative maintenance techniques in an Active Directory 2016 environment. You will learn how to manage Active Directory structure changes, rename domain controllers, resolve network problems and replications.

Who is this training for ?

Training objectives

Diagnose and resolve Active Directory 2016 structural issues
Diagnose and resolve DFS replication issues
Restructure and migrate Active Directory domains and objects
Define an Active Directory recovery plan

Training program

AD Architecture and Security

• Reminder on the architecture and new features of AD 2016.
• AD and nano servers.
• Privileged access management (PAM).
• Encrypting DCs.
• Practical work Secure AD administration.
• Encrypting DCs.
• Recovery encryption key.

Troubleshooting AD-related network issues

• DNS records linked to AD.
• DNS zone management and delegation.
• Securing zones.
• Cleaning the DNS zones integrated into the AD.
• DNS troubleshooting utilities.
• Practical work DNS operation test.
• Configure cleaning areas.
• Troubleshoot DC removal.

Troubleshooting AD Objects

• Management of ACLs on objects.
• The AD recycle bin, restore objects without the recycle bin.
• Isolate stale objects in PowerShell.
• Diagnose service account issues.
• Lab Restore objects.
• Using PowerShell to resolve issues.
• Troubleshoot managed service accounts.

Troubleshooting Domains

• Backup and restoration of the AD.
• Optimization and troubleshooting of the global catalog.
• Management of operation masters.
• Problems with AD sites, domain trust relationships and forest.
• Practical work Back up and restore the AD.
• Resolve problems with sites, trust relationships.

Troubleshooting DFS Replications Issues

• DFS Replications and DC Replications.
• DFS Sysvol Root Issues and DFS Limitations.
• DFS Deployment, Optimization, and Troubleshooting.
• Practical work Resolve sysvol replication and DFS problems linked to migrations.

Domain reconstruction and restructuring

• Renaming domain DCs.
• Domain restructuring with ADMT.
• Problems related to migrations.
• Define a plan of forest reconstruction.
• Practical work Renaming DCs.
• Restructuring, migrating objects with ADMT.
• Building a forest restoration plan .

DC Hardware Troubleshooting and Performance

• The BPA tool, MSDART.
• The AD data collector, the performance counters.
• Practical work The performance monitor to analyze the DC.
• Using MSDART.

Description

This course will teach you how to manage group policies under Windows Server 2016. You will be able to administer your servers and workstations by controlling registry keys, system security, software management, scripts, policy safety and environmental auditing.

Who is this training for ?

Training objectives

Understand how group policies work Perform administration tasks with GPOs Configure Group Policy preferences Deploy software using Group Policy Implement security by GPO

Training program

How group policies work

• Differences between local and domain Active Directory policies.
• Administrative models.
• Object bindings.
• Starter GPOs .
• Filtering the deployment of an object.
• Practical work Creating and linking group policy objects.
• Filtering deploying an object.

How group policies work

• Differences between local and domain Active Directory policies.
• Administrative models.
• Object bindings.
• Starter GPOs .
• Filtering the deployment of an object.
• Practical work Creating and linking group policy objects.
• Filtering deploying an object.

How group policies work

• The role of group policies.
• How GPOs work.
• Inheritance and object bindings.
• The GPO deployment filtering.
• Callback loops.
• Practical work Creating and linking group policy objects.
• Filtering the deployment of an object.

Manage GPOs with GPMC

• GPO Starter.
• Delegation on GPOs.
• Updating GPOs, controlling GPO descents.
• Show and modify the state of GPO replications in the domain.
• Practical work Creation and use of Starter.
• Searching and filtering parameters in GPOs.

Administrative templates and filtering

• The central store.
• ADMX and ADML templates.
• ADMX custom templates.
• Create advanced filtering with WMI filters .
• Hands-on Create the central store.
• Add administrative templates.
• Create WMI filters.

Configure preference settings

• Principle of preference parameters.
• Implementation of preference parameters.
• Targeting parameters with the Targeting Editor.
• Scheduling tasks.
• Practical work Configure IE configuration preferences settings, network drives, configure scheduled tasks.

General Policies

• Printer deployment.
• Script deployment.
• Manage tablets via GPOs.
• Examples of use of general policies.
• Practical work Create GPOs for advanced administration of stations and tablets.