Certifying training eligible for the CPF ​

​

Access to unlimited interactive E-learning modules over a period of 3 months.

The training can also be provided in blended learning (combination of online and face-to-face sequences).

​

• Intermediate knowledge

Upgrade to more complex tables

 Displaying multiple rows in one cell
 Absolute reference in a formula
 Copy of values, copy with link or transpose
 Namely: Entering calculation functions
 System date and date format
 Single Condition
 Custom size
 Conditional Formatting
 Conditional formatting management
 Name of a range of cells
 Validation criterion
 Range of cells in a function

​

Present your figures on graphs

 Namely: Graphics
 Creating and moving a chart
 Chart management
 Selecting elements of a chart
 Adding and removing items
 Formatting chart elements
 Changing the text elements of the chart
 Legend and Plot Area
 Graphic printing and layout

​

Improve the presentation of your graphics

 Changing data labels
 Data series and axes of a chart
 Series management
 Chart type options
 Management of chart templates
 Creating a 2D Map type chart
 Creating sparkline charts
 Sparkline chart management

​

Decorate your tables

 Creation of graphic objects
 Selection and deletion of objects
 Copying and moving objects
 Sizing of a graphic object
 Editing a text box
 Editing a drawing
 Formatting drawing objects
 Inserting an image
 Image management
 Object rotation and alignment
 Layering and grouping of objects

​

Leverage your data list tables

 Namely: Instant filling
 Calculation of subtotals
 Creation and management of a data table
 Presentation and sorting of data in a data table
 Adding calculation in a data table
 Auto Filter
 Custom filters
 Empty values and duplicates
 Namely: The criteria area
 Using a criteria area
 Filter and copy rows by criteria area
 Statistics with criteria area

​

Improve the presentation of your graphics

 Namely: Pivot tables and charts
 Creation of a pivot table
 Editing and adding calculation in a pivot table
 Changing the source of a pivot table
 Selecting, copying, moving and deleting in a pivot table
 Structure and printing of a pivot table
 Formatting a pivot table
 Pivot table filter
 Filter using segments
 Creating a pivot table based on multiple tables
 Adding fields or calculated items
 Data grouping
 Creating a PivotChart  

​

• Advanced knowledge

Gain in efficiency

 Data Conversion
 Creation of data series
 Custom views: Views
 Annotation of a cell
 Error checking
 Evaluation of formulas
 Watch Window

​

Use advanced calculation functions

 Lookup table and search functions
 Text functions
 Calculation of hours
 Date calculations
 Conditions with AND, OR, NOT
 Nested conditions
 Conditional functions
 Matrix formula
 Calculations during copies
 Consolidation
 Financial functions
 Double entry table

​

Discover unexpected features

 Target value
 Solver
 Scenario management
 Hyperlink
 Namely: Styles and templates
 Creating and customizing a theme
 Creation and use of a model
 Namely: Import, export and interoperability with Excel
 Editing and deleting a template
 Excel data distribution: PDF, XPS, email and web page
 Converting Excel files
 Data import
 Updating and managing imported data
 Workbook Properties

​

Share securely

 Protection of a workbook
 Cell protection
 Sharing a workbook
 Track changes to a workbook
 Workbook merging
 Finalizing a workbook
 Digital signature
 Creation of a form
 Protection and use of a form

​

To know even more

 Macro command
 Version and recovery of a file
 Namely: The customization of the ribbon
 To know: The good practices of the spreadsheet
 Namely: Collaborating on a workbook

​

​

​