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

​

• Essential knowledge

Discover Excel, complete a table

 To know: The discovery of the spreadsheet
 Opening a workbook
 General information on the environment
 Moving around in a workbook
 Namely: Input aids
 Data entry
 Namely: Selection, copying, moving
 Selecting and deleting cells
 Undoing and redoing an action
 Column width/row height
 Namely: Saving files
 Saving a workbook
 Editing cell content
 Creating a new workbook

​

Make your first calculations

 Entering a calculation formula
 Sum and other simple calculations
 Calculation of a percentage
 Copy to adjacent cells

​

Present a minimum of your data

 Simple number formats
 Application of a theme
 Character enhancement
 Font and font size
 Alignment of cell contents
 Cell color
 Cell border

​

Print, layout your workbooks

 Layout
 Preview and print
 Page break
 Print area
 To know: The header and the footer
 Header and Footer

​

Become more efficient

 Using Excel Help
 Spell check
 Search, replace
 Display Zoom
 Insert/delete rows, columns and cells
 Moving cells
 Copy to non-adjacent cells
 Quick copy of cell formatting
 Merge Cells
 Cell content orientation
 Cell Styles
 Data sorting

​

Manage the sheets and display of your data

 Sheet name, tab color
 Inserting, deleting and backgrounding sheets
 Moving, copying and hiding a sheet
 Freeze column/row on screen, window split
 Repeated column/row titles in print
 Hiding sheet elements
 Grouping of data in the form of a plan

• 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

​

​