Certifying training eligible for the CPF ​

​

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

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

INTRODUCTION TO THE MICROCOMPUTER

• Hardware architecture: screen, keyboard, mouse,

• The motherboard

•   Microprocessor and memories

•   Peripherals, storage systems.

•   Software architecture: operating system, applications.

Discovering Windows

• Office,

• Types of objects,

• Taskbar,

• Using the mouse,

• Handling windows.

• Control Panel

•   Mouse,

•   Keyboard,

•   Display,

•   Date and hour,

•   Regional settings.

• Manage folders

• Using Explorer,

• Create a folder,

•   Name a folder

• move a folder,

•   Delete a folder.

•   Notion of networks

• File management

• save a file,

•   Copy a file,

• move a file,

•   delete a file,

• Recover a file from the recycle bin,

• Permanently delete a file

• Renaming a file,

• Search for a file.

Word processing:  write a document

• Discover the work screen,

• Create a new document,

•   Enter, modify or delete a text,

•   Creating a Simple Table

•   Design a table and enter text in it,

•   Resize a table

•   Insert, move or delete a row or column

•   Define formatting and dressing.

•   Format a document: choice of font, style, paragraph options, etc.,

•   Insert bulleted lists or numbers,

• Define the layout options: margins, document orientation (portrait or landscape), page numbering, borders, etc.,

•   Use the automatic corrector,

• Discover the "print preview" mode.

Presentation of the EXCEL screen

• The tools needed to create a table,

• concept of cells,

• Presentation of a table,

• Enter data,

• Select data,

• The operators,

• The main formats (number, currency, date/time).

• The formulas,

• Format cells, numbers, text, titles,

• Data formatting (type of font, size, alignment, color, etc.)

• Table formatting (height, width, color, border, etc.)

• Apply a table style

• Relative and absolute references,

• Application exercises

​

SIMPLE FUNCTIONS

• Sum, average, etc.

• Functions such as sorts, totals, and subtotals

• Use filters,

• Application exercises

• The help tool for choosing a graphic

• Creating a chart from data,

• Modify the chart type: histogram, line, sector,

• Application exercises

• Multi-sheet and multi-workbook management,

• Insert move copy one or more sheets,

• Build summary tables,

• Printing of a table, partially or in part,

• Title, paginate,

• Application exercises

• The PowerPoint environment,

•   The slides