Description

Successful candidates for the Microsoft Excel 2016 exam have approximately 150 hours of instruction and hands-on experience with the product. They will know and demonstrate the correct application of the principle features of Excel 2016. Candidates will create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

MOS 2016 certification exams introduce a new performance-based format for improved testing of a candidate’s knowledge, skills and abilities using the MOS 2016 programs: • MOS 2016 exam task instructions generally do not include the command name as in previous versions. For example, function names are avoided, and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects. • The MOS 2016 exam format incorporates multiple projects.

À qui s’adresse cette formation ?

Pour qui ?

Toute personne ayant à créer et communiquer des fichiers PDF. Contributeur de sites Web. Gestionnaire des systèmes d’information, archiviste, documentaliste.

Prérequis

Les objectifs de la certification Exel

Comprendre les différents usages du format PDF.
Convertir, optimiser et diffuser vos documents.
Organiser et protéger vos documents.
Signer et suivre vos documents.
Travailler sur vos appareils mobiles.

Programme de la certification Exel

Create and Manage Worksheets and Workbooks

Create Worksheets and Workbooks

Create a workbook

Import data from a delimited text file

Add a worksheet to an existing workbook

Copy and move a worksheet

Navigate in Worksheets and Workbooks

Search for data within a workbook

Navigate to a named cell, range, or workbook element

Insert and remove hyperlinks

Format Worksheets and Workbooks

Change worksheet tab color

Rename a worksheet

Change worksheet order

Modify page setup

Insert and delete columns or rows

Change workbook themes

Adjust row height and column width

Insert headers and footers

Customize Options and Views for Worksheets and Workbooks

Hide or unhide worksheets

Hide or unhide columns and rows

Customize the Quick Access toolbar

Change workbook views

Change window views

Modify document properties

Change magnification by using zoom tools

Display formulas

MOS Excel 2016

Create and Manage Worksheets and Workbooks

Configure Worksheets and Workbooks for Distribution

Set a print area

Save workbooks in alternative file formats

Print all or part of a workbook

Set print scaling

Display repeating row and column titles on multipage worksheets

Inspect a workbook for hidden properties or personal information

Inspect a workbook for accessibility issues

Inspect a workbook for compatibility issues

Manage Data Cells and Ranges

Insert Data in Cells and Ranges

Replace data

Cut, copy, or paste data

Paste data by using special paste options

Fill cells by using Auto Fill

Insert and delete cells

Format Cells and Ranges

Merge cells

Modify cell alignment and indentation

Format cells by using Format Painter

Wrap text within cells

Apply number formats

Apply cell formats

Apply cell styles

Summarize and Organize Data

Insert sparklines

Outline data

Insert subtotals

Apply conditional formatting

Create Tables

Create and Manage Tables

Create an Excel table from a cell range

Convert a table to a cell range

Add or remove table rows and columns

Manage Table Styles and Options

Apply styles to tables

Configure table style options

Insert total rows

Filter and Sort a Table

Filter records

Sort data by multiple columns

Change sort order

Remove duplicate records

Perform Operations with Formulas and Functions

Summarize Data by using Functions

Insert references

Perform calculations by using the SUM function

Perform calculations by using MIN and MAX functions

Perform calculations by using the COUNT function

Perform calculations by using the AVERAGE function

Perform Operations with Formulas and Functions

Perform Conditional Operations by using Functions

 Perform logical operations by using the IF function

 Perform logical operations by using the SUMIF function

 Perform logical operations by using the AVERAGEIF function

 Perform statistical operations by using the COUNTIF function

Format and Modify Text by using Functions

Format text by using RIGHT, LEFT, and MID functions

Format text by using UPPER, LOWER, and PROPER functions

Format text by using the CONCATENATE function

Create Charts and Objects

Create Charts

Create a new chart

Add additional data series

Switch between rows and columns in source data

Analyze data by using Quick Analysis

Format Charts

Resize charts

Add and modify chart elements

Apply chart layouts and styles

Move charts to a chart sheet

Insert and Format Objects

Insert text boxes and shapes

Insert images

Modify object properties

Add alternative text to objects for accessibility